I_InsurPlcyInsrdObjEntity
Insured Object in Insurance Policy
I_InsurPlcyInsrdObjEntity is a Composite CDS View that provides data about "Insured Object in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyInsrdObj0Basic) and exposes 105 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyCoverageOptionID. It has 6 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InsurPlcyInsrdObj0Basic | InsuredObject | from |
Associations (6)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_InsurPlcyInsrdObj1Basic | _InsuredObject1 | $projection.InsurPlcyUUID = _InsuredObject1.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _InsuredObject1.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _InsuredObject1.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _InsuredObject1.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _InsuredObject1.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _InsuredObject1.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _InsuredObject1.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _InsuredObject1.InsurPlcyJrnlEndNmbr |
| [1..1] | I_InsurPlcyInsrdObj2Basic | _InsuredObject2 | $projection.InsurPlcyUUID = _InsuredObject2.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _InsuredObject2.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _InsuredObject2.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _InsuredObject2.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _InsuredObject2.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _InsuredObject2.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _InsuredObject2.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _InsuredObject2.InsurPlcyJrnlEndNmbr |
| [1..1] | I_InsurPlcyInsrdObj3Basic | _InsuredObject3 | $projection.InsurPlcyUUID = _InsuredObject3.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _InsuredObject3.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _InsuredObject3.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _InsuredObject3.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _InsuredObject3.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _InsuredObject3.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _InsuredObject3.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _InsuredObject3.InsurPlcyJrnlEndNmbr |
| [1..1] | I_InsurPlcyInsrdObj4Basic | _InsuredObject4 | $projection.InsurPlcyUUID = _InsuredObject4.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _InsuredObject4.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _InsuredObject4.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _InsuredObject4.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _InsuredObject4.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _InsuredObject4.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _InsuredObject4.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _InsuredObject4.InsurPlcyJrnlEndNmbr |
| [1..1] | I_InsurPlcyInsrdObj5Basic | _InsuredObject5 | $projection.InsurPlcyUUID = _InsuredObject5.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _InsuredObject5.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _InsuredObject5.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _InsuredObject5.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _InsuredObject5.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _InsuredObject5.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _InsuredObject5.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _InsuredObject5.InsurPlcyJrnlEndNmbr |
| [1..1] | I_InsurPlcyInsrdObj6Basic | _InsuredObject6 | $projection.InsurPlcyUUID = _InsuredObject6.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _InsuredObject6.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _InsuredObject6.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _InsuredObject6.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _InsuredObject6.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _InsuredObject6.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _InsuredObject6.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _InsuredObject6.InsurPlcyJrnlEndNmbr |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Insured Object in Insurance Policy | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #XL | view |
Fields (105)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InsurPlcyUUID | InsurPlcyUUID | Policy UUID | |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | Contract Key | |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | Cov.Package ID | |
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | Coverage Key | |
| KEY | InsurPlcyCoverageOptionID | InsurPlcyCoverageOptionID | Cov. Option Key | |
| KEY | InsurPlcyInsuredObjectID | InsurPlcyInsuredObjectID | Ins. Obj. No. | |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | Journal Number | |
| KEY | InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | Term. Jour. No. | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | Prod. Pckg. Key | ||
| InsurPlcyInsrdObjectTemplate | InsurPlcyInsrdObjectTemplate | Object Module | ||
| InsurPlcyInsuredObjectCategory | InsurPlcyInsuredObjectCategory | Object Category | ||
| InsurPlcyInsrdObjSubCategory | InsurPlcyInsrdObjSubCategory | Object Type | ||
| InsurPlcyInsrdObjUnqID | InsurPlcyInsrdObjUnqID | Insurable Obj. | ||
| InsurInsrblObjJrnlNmbr | InsurInsrblObjJrnlNmbr | INSBO JournStat | ||
| InsurPlcyInsrdObjIsCancelled | InsurPlcyInsrdObjIsCancelled | Rev. Flag | ||
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | Process.Status | ||
| InsurPlcyInsuredPersonID | InsurPlcyInsuredPersonID | BusPartner | ||
| InsurPlcyInsrdObjEffctvDte | InsurPlcyInsrdObjEffctvDte | Effective Date | ||
| InsurPlcyInsrdObjAwardReason | InsurPlcyInsrdObjAwardReason | Assign. Reason | ||
| InsurPlcyInsrdObjIsUpdateNeed | InsurPlcyInsrdObjIsUpdateNeed | Oblig. Update | ||
| InsurPlcyInsrdObjTypeChannel | InsurPlcyInsrdObjTypeChannel | ObjTypeChStruc. | ||
| InsurPlcyInsrdObjCatChannel | InsurPlcyInsrdObjCatChannel | Obj. Cat. ChStr | ||
| InsurPlcyInsrdObjSuperChannel | InsurPlcyInsrdObjSuperChannel | ObjSuperChStruc | ||
| InsurPlcyInsrdObjCurrency | InsurPlcyInsrdObjCurrency | Currency | ||
| InsurPlcyInsrdObjDeclaration | InsurPlcyInsrdObjDeclaration | Declaration No. | ||
| InsurPlcyInsrdObjPositionSqnc | InsurPlcyInsrdObjPositionSqnc | Item No. | ||
| InsurPlcyInsrdObjIsNoPremRaise | InsurPlcyInsrdObjIsNoPremRaise | No Prem.Incr. | ||
| InsurPlcyInsrdObjIsLocChanged | InsurPlcyInsrdObjIsLocChanged | Location Change | ||
| InsurPlcyInsrdObjRiskGrpNumber | InsurPlcyInsrdObjRiskGrpNumber | Risk Group No. | ||
| InsurPlcyInsrdObjOccptnRdyDte | InsurPlcyInsrdObjOccptnRdyDte | Ready for Occ. | ||
| InsurPlcyInsrdObjIsInCnstrctn | InsurPlcyInsrdObjIsInCnstrctn | Building Str. | ||
| InsurPlcyInsrdObjStormZone | InsurPlcyInsrdObjStormZone | Storm Zone | ||
| InsurPlcyInsrdObjHazardClass | InsurPlcyInsrdObjHazardClass | Risk Class | ||
| InsurPlcyInsrdObjCnstrctnType | InsurPlcyInsrdObjCnstrctnType | Const.TypeCl | ||
| InsurPlcyInsrdObjUsblAreaQty | InsurPlcyInsrdObjUsblAreaQty | |||
| InsurPlcyInsrdObjCommlUsgePct | InsurPlcyInsrdObjCommlUsgePct | Comm. Usage (%) | ||
| InsurPlcyInsrdObjTariffZone | InsurPlcyInsrdObjTariffZone | Tariff Zone | ||
| InsurPlcyInsrdPersonBirthDate | InsurPlcyInsrdPersonBirthDate | Date of Birth | ||
| InsurPlcyInsrdPersonName | InsurPlcyInsrdPersonName | Name at Birth | ||
| InsurPlcyInsrdPersonStatus | InsurPlcyInsrdPersonStatus | IP/IO Status | ||
| InsurPlcyInsrdPersonAddr | InsurPlcyInsrdPersonAddr | Address | ||
| InsurPlcyInsrdPersonIsOwner | InsurPlcyInsrdPersonIsOwner | Owner in Assoc. | ||
| InsurPlcyInsrdPersonJob | InsurPlcyInsrdPersonJob | IP Occupation | ||
| InsurPlcyInsrdPersonIsSmoker | InsurPlcyInsrdPersonIsSmoker | Smoker | ||
| InsurPlcyInsrdPersonRskGrp | InsurPlcyInsrdPersonRskGrp | Risk Group | ||
| InsurPlcyInsrdPersonGender | InsurPlcyInsrdPersonGender | Gender | ||
| InsurPlcyInsrdPersnBeginValue | InsurPlcyInsrdPersnBeginValue | Age at Entry | ||
| InsurPlcyInsrdPersnFinalValue | InsurPlcyInsrdPersnFinalValue | Final Age | ||
| InsurPlcyInsrdPersnAgeGrp | InsurPlcyInsrdPersnAgeGrp | Age Group | ||
| InsurPlcyInsrdPersnRole | InsurPlcyInsrdPersnRole | Ins.Person Role | ||
| InsurPlcyInsrdPersnJobClass | InsurPlcyInsrdPersnJobClass | Occupatnl Class | ||
| InsurPlcyInsrdPersnProfession | InsurPlcyInsrdPersnProfession | IP Occup.Status | ||
| InsurPlcyInsrdObjNmbrOfAnimal | InsurPlcyInsrdObjNmbrOfAnimal | No. of Animals | ||
| InsurPlcyInsrdObjValueAmount | InsurPlcyInsrdObjValueAmount | Object Value | ||
| InsurPlcyInsrdObjLonValue | InsurPlcyInsrdObjLonValue | Add. Longitude | ||
| InsurPlcyInsrdObjLonMinsValue | InsurPlcyInsrdObjLonMinsValue | Long. in Mins | ||
| InsurPlcyInsrdObjLonSecsValue | InsurPlcyInsrdObjLonSecsValue | Long. in Secs | ||
| InsurPlcyInsrdObjLatitudeValue | InsurPlcyInsrdObjLatitudeValue | Lat.for Address | ||
| InsurPlcyInsrdObjLatMinsValue | InsurPlcyInsrdObjLatMinsValue | Lat. in Minutes | ||
| InsurPlcyInsrdObjLatSecsValue | InsurPlcyInsrdObjLatSecsValue | Lat. in Seconds | ||
| InsurPlcyPostCodeTxt | InsurPlcyPostCodeTxt | Postal Code | ||
| InsurPlcyInsrdObjStreetName | InsurPlcyInsrdObjStreetName | Street | ||
| InsurPlcyInsrdObjCountry | InsurPlcyInsrdObjCountry | Country/Reg. | ||
| InsurPlcyInsrdObjValueType | InsurPlcyInsrdObjValueType | Obj. Value Type | ||
| InsurPlcyInsrdObjDtmnYearValue | InsurPlcyInsrdObjDtmnYearValue | Value Det. (Yr) | ||
| InsurPlcyInsrdObjCityName | InsurPlcyInsrdObjCityName | City | ||
| InsurPlcyInsrdObjHouseNumber | InsurPlcyInsrdObjHouseNumber | House Number | ||
| InsurPlcyInsrdObjUsblAreaUnit | InsurPlcyInsrdObjUsblAreaUnit | Occup.Area Unit | ||
| LastChangeDateTime | LastChangeDateTime | Timestamp | ||
| InsurPlcyInsrdObj2LonValue | _InsuredObject3 | InsurPlcyInsrdObj2LonValue | Add. Longitude | |
| InsurPlcyInsrdObj2LonMinsValue | _InsuredObject3 | InsurPlcyInsrdObj2LonMinsValue | Long. in Mins | |
| InsurPlcyInsrdObj2LonSecsValue | _InsuredObject3 | InsurPlcyInsrdObj2LonSecsValue | Long. in Secs | |
| InsurPlcyInsrdObj2LatValue | _InsuredObject3 | InsurPlcyInsrdObj2LatValue | Lat.for Address | |
| InsurPlcyInsrdObj2LatMinsValue | _InsuredObject3 | InsurPlcyInsrdObj2LatMinsValue | Lat. in Minutes | |
| InsurPlcyInsrdObj2LatSecsValue | _InsuredObject3 | InsurPlcyInsrdObj2LatSecsValue | Lat. in Seconds | |
| InsurPlcyInsrdObj2StreetName | _InsuredObject3 | InsurPlcyInsrdObj2StreetName | Street | |
| InsurPlcyInsrdObjPostCodeTxt | _InsuredObject3 | InsurPlcyInsrdObjPostCodeTxt | Postal Code | |
| InsurPlcyInsrdObj2Country | _InsuredObject3 | InsurPlcyInsrdObj2Country | Country/Reg. | |
| InsurPlcyInsrdObj2CnstrctnType | _InsuredObject3 | InsurPlcyInsrdObj2CnstrctnType | Const.TypeCl | |
| InsurPlcyInsrdObj2CityName | _InsuredObject3 | InsurPlcyInsrdObj2CityName | City | |
| InsurPlcyInsrdObj2HouseNumber | _InsuredObject3 | InsurPlcyInsrdObj2HouseNumber | House Number | |
| InsurPlcyInsrdObjIsTmpCvrg | _InsuredObject3 | InsurPlcyInsrdObjIsTmpCvrg | Temporary | |
| InsurPlcyInsrdObjGlazingQty | _InsuredObject3 | InsurPlcyInsrdObjGlazingQty | ||
| InsurPlcyInsrdObjInteriorQty | _InsuredObject3 | InsurPlcyInsrdObjInteriorQty | ||
| InsurPlcyInsrdObjIsBuildUpArea | _InsuredObject3 | InsurPlcyInsrdObjIsBuildUpArea | Built-Up Area | |
| InsurPlcyInsrdObjOuterWallType | _InsuredObject3 | InsurPlcyInsrdObjOuterWallType | Ext.Wall Type | |
| InsurPlcyInsrdObjIsPrefabHouse | _InsuredObject3 | InsurPlcyInsrdObjIsPrefabHouse | Prefab. House | |
| InsurPlcyInsrdObjLivingAreaQty | _InsuredObject3 | InsurPlcyInsrdObjLivingAreaQty | ||
| InsurPlcyInsrdObjLivingAreaUnt | _InsuredObject3 | InsurPlcyInsrdObjLivingAreaUnt | Living Area UOM | |
| InsurPlcyInsrdObjRoofing | _InsuredObject3 | InsurPlcyInsrdObjRoofing | Roofing | |
| InsurPlcyInsrdObjGlazingUnit | _InsuredObject3 | InsurPlcyInsrdObjGlazingUnit | ExtGlaze Area UM | |
| InsurPlcyInsrdObjPrtnPrpty | _InsuredObject3 | InsurPlcyInsrdObjPrtnPrpty | Partner Prop. | |
| InsurPlcyInsrdObjPartner | _InsuredObject3 | InsurPlcyInsrdObjPartner | BusPartner | |
| InsurPlcyInsrdObjInteriorGlaze | _InsuredObject3 | InsurPlcyInsrdObjInteriorGlaze | IntGlaze Area UM | |
| InsurPlcyInsrdObj2HazardClass | _InsuredObject3 | InsurPlcyInsrdObj2HazardClass | Risk Class | |
| InsurPlcyInsrdObj2TariffZone | _InsuredObject3 | InsurPlcyInsrdObj2TariffZone | Tariff Zone | |
| InsurPlcyInsrdObjHasAlarm | _InsuredObject3 | InsurPlcyInsrdObjHasAlarm | Alarm System | |
| InsurPlcyInsrdObjBldngType | _InsuredObject3 | InsurPlcyInsrdObjBldngType | Building Type | |
| _Currency | _Currency | |||
| _InsuredObject1 | _InsuredObject1 | |||
| _InsuredObject2 | _InsuredObject2 | |||
| _InsuredObject3 | _InsuredObject3 | |||
| _InsuredObject4 | _InsuredObject4 | |||
| _InsuredObject5 | _InsuredObject5 | |||
| _InsuredObject6 | _InsuredObject6 |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_InsurPlcyInsrdObjEntity.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW I_InsurPlcyInsrdObjEntity AS
SELECT
InsurPlcyUUID,
InsurPlcyInsurContr,
InsurPlcyCoveragePackageID,
InsurPlcyCoverageID,
InsurPlcyCoverageOptionID,
InsurPlcyInsuredObjectID,
InsurPlcyJrnlNmbr,
InsurPlcyJrnlEndNmbr,
InsurPlcyProductPackageID,
InsurPlcyInsrdObjectTemplate,
InsurPlcyInsuredObjectCategory,
InsurPlcyInsrdObjSubCategory,
InsurPlcyInsrdObjUnqID,
InsurInsrblObjJrnlNmbr,
InsurPlcyInsrdObjIsCancelled,
InsurPlcyBusinessObject,
InsurPlcyInsuredPersonID,
InsurPlcyInsrdObjEffctvDte,
InsurPlcyInsrdObjAwardReason,
InsurPlcyInsrdObjIsUpdateNeed,
InsurPlcyInsrdObjTypeChannel,
InsurPlcyInsrdObjCatChannel,
InsurPlcyInsrdObjSuperChannel,
InsurPlcyInsrdObjCurrency,
InsurPlcyInsrdObjDeclaration,
InsurPlcyInsrdObjPositionSqnc,
InsurPlcyInsrdObjIsNoPremRaise,
InsurPlcyInsrdObjIsLocChanged,
InsurPlcyInsrdObjRiskGrpNumber,
InsurPlcyInsrdObjOccptnRdyDte,
InsurPlcyInsrdObjIsInCnstrctn,
InsurPlcyInsrdObjStormZone,
InsurPlcyInsrdObjHazardClass,
InsurPlcyInsrdObjCnstrctnType,
InsurPlcyInsrdObjUsblAreaQty,
InsurPlcyInsrdObjCommlUsgePct,
InsurPlcyInsrdObjTariffZone,
InsurPlcyInsrdPersonBirthDate,
InsurPlcyInsrdPersonName,
InsurPlcyInsrdPersonStatus,
InsurPlcyInsrdPersonAddr,
InsurPlcyInsrdPersonIsOwner,
InsurPlcyInsrdPersonJob,
InsurPlcyInsrdPersonIsSmoker,
InsurPlcyInsrdPersonRskGrp,
InsurPlcyInsrdPersonGender,
InsurPlcyInsrdPersnBeginValue,
InsurPlcyInsrdPersnFinalValue,
InsurPlcyInsrdPersnAgeGrp,
InsurPlcyInsrdPersnRole,
InsurPlcyInsrdPersnJobClass,
InsurPlcyInsrdPersnProfession,
InsurPlcyInsrdObjNmbrOfAnimal,
InsurPlcyInsrdObjValueAmount,
InsurPlcyInsrdObjLonValue,
InsurPlcyInsrdObjLonMinsValue,
InsurPlcyInsrdObjLonSecsValue,
InsurPlcyInsrdObjLatitudeValue,
InsurPlcyInsrdObjLatMinsValue,
InsurPlcyInsrdObjLatSecsValue,
InsurPlcyPostCodeTxt,
InsurPlcyInsrdObjStreetName,
InsurPlcyInsrdObjCountry,
InsurPlcyInsrdObjValueType,
InsurPlcyInsrdObjDtmnYearValue,
InsurPlcyInsrdObjCityName,
InsurPlcyInsrdObjHouseNumber,
InsurPlcyInsrdObjUsblAreaUnit,
LastChangeDateTime,
_InsuredObject3.InsurPlcyInsrdObj2LonValue AS InsurPlcyInsrdObj2LonValue,
_InsuredObject3.InsurPlcyInsrdObj2LonMinsValue AS InsurPlcyInsrdObj2LonMinsValue,
_InsuredObject3.InsurPlcyInsrdObj2LonSecsValue AS InsurPlcyInsrdObj2LonSecsValue,
_InsuredObject3.InsurPlcyInsrdObj2LatValue AS InsurPlcyInsrdObj2LatValue,
_InsuredObject3.InsurPlcyInsrdObj2LatMinsValue AS InsurPlcyInsrdObj2LatMinsValue,
_InsuredObject3.InsurPlcyInsrdObj2LatSecsValue AS InsurPlcyInsrdObj2LatSecsValue,
_InsuredObject3.InsurPlcyInsrdObj2StreetName AS InsurPlcyInsrdObj2StreetName,
_InsuredObject3.InsurPlcyInsrdObjPostCodeTxt AS InsurPlcyInsrdObjPostCodeTxt,
_InsuredObject3.InsurPlcyInsrdObj2Country AS InsurPlcyInsrdObj2Country,
_InsuredObject3.InsurPlcyInsrdObj2CnstrctnType AS InsurPlcyInsrdObj2CnstrctnType,
_InsuredObject3.InsurPlcyInsrdObj2CityName AS InsurPlcyInsrdObj2CityName,
_InsuredObject3.InsurPlcyInsrdObj2HouseNumber AS InsurPlcyInsrdObj2HouseNumber,
_InsuredObject3.InsurPlcyInsrdObjIsTmpCvrg AS InsurPlcyInsrdObjIsTmpCvrg,
_InsuredObject3.InsurPlcyInsrdObjGlazingQty AS InsurPlcyInsrdObjGlazingQty,
_InsuredObject3.InsurPlcyInsrdObjInteriorQty AS InsurPlcyInsrdObjInteriorQty,
_InsuredObject3.InsurPlcyInsrdObjIsBuildUpArea AS InsurPlcyInsrdObjIsBuildUpArea,
_InsuredObject3.InsurPlcyInsrdObjOuterWallType AS InsurPlcyInsrdObjOuterWallType,
_InsuredObject3.InsurPlcyInsrdObjIsPrefabHouse AS InsurPlcyInsrdObjIsPrefabHouse,
_InsuredObject3.InsurPlcyInsrdObjLivingAreaQty AS InsurPlcyInsrdObjLivingAreaQty,
_InsuredObject3.InsurPlcyInsrdObjLivingAreaUnt AS InsurPlcyInsrdObjLivingAreaUnt,
_InsuredObject3.InsurPlcyInsrdObjRoofing AS InsurPlcyInsrdObjRoofing,
_InsuredObject3.InsurPlcyInsrdObjGlazingUnit AS InsurPlcyInsrdObjGlazingUnit,
_InsuredObject3.InsurPlcyInsrdObjPrtnPrpty AS InsurPlcyInsrdObjPrtnPrpty,
_InsuredObject3.InsurPlcyInsrdObjPartner AS InsurPlcyInsrdObjPartner,
_InsuredObject3.InsurPlcyInsrdObjInteriorGlaze AS InsurPlcyInsrdObjInteriorGlaze,
_InsuredObject3.InsurPlcyInsrdObj2HazardClass AS InsurPlcyInsrdObj2HazardClass,
_InsuredObject3.InsurPlcyInsrdObj2TariffZone AS InsurPlcyInsrdObj2TariffZone,
_InsuredObject3.InsurPlcyInsrdObjHasAlarm AS InsurPlcyInsrdObjHasAlarm,
_InsuredObject3.InsurPlcyInsrdObjBldngType AS InsurPlcyInsrdObjBldngType
FROM I_InsurPlcyInsrdObj0Basic AS InsuredObject
LEFT OUTER JOIN I_InsurPlcyInsrdObj1Basic AS _InsuredObject1 ON InsurPlcyUUID = _InsuredObject1.InsurPlcyUUID AND InsurPlcyInsurContr = _InsuredObject1.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _InsuredObject1.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _InsuredObject1.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _InsuredObject1.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _InsuredObject1.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _InsuredObject1.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _InsuredObject1.InsurPlcyJrnlEndNmbr -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsrdObj2Basic AS _InsuredObject2 ON InsurPlcyUUID = _InsuredObject2.InsurPlcyUUID AND InsurPlcyInsurContr = _InsuredObject2.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _InsuredObject2.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _InsuredObject2.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _InsuredObject2.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _InsuredObject2.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _InsuredObject2.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _InsuredObject2.InsurPlcyJrnlEndNmbr -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsrdObj3Basic AS _InsuredObject3 ON InsurPlcyUUID = _InsuredObject3.InsurPlcyUUID AND InsurPlcyInsurContr = _InsuredObject3.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _InsuredObject3.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _InsuredObject3.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _InsuredObject3.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _InsuredObject3.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _InsuredObject3.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _InsuredObject3.InsurPlcyJrnlEndNmbr -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsrdObj4Basic AS _InsuredObject4 ON InsurPlcyUUID = _InsuredObject4.InsurPlcyUUID AND InsurPlcyInsurContr = _InsuredObject4.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _InsuredObject4.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _InsuredObject4.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _InsuredObject4.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _InsuredObject4.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _InsuredObject4.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _InsuredObject4.InsurPlcyJrnlEndNmbr -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsrdObj5Basic AS _InsuredObject5 ON InsurPlcyUUID = _InsuredObject5.InsurPlcyUUID AND InsurPlcyInsurContr = _InsuredObject5.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _InsuredObject5.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _InsuredObject5.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _InsuredObject5.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _InsuredObject5.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _InsuredObject5.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _InsuredObject5.InsurPlcyJrnlEndNmbr -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsrdObj6Basic AS _InsuredObject6 ON InsurPlcyUUID = _InsuredObject6.InsurPlcyUUID AND InsurPlcyInsurContr = _InsuredObject6.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _InsuredObject6.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _InsuredObject6.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _InsuredObject6.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _InsuredObject6.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _InsuredObject6.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _InsuredObject6.InsurPlcyJrnlEndNmbr -- association [1..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA