I_INSURPLCYINSUREDBLDNGBASIC
Insured Building in Insurance Policy
I_INSURPLCYINSUREDBLDNGBASIC is a CDS View in S/4HANA. Insured Building in Insurance Policy. It contains 33 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsOpApContrCvrgInsrdBldng | view_entity | from | COMPOSITE | Cvrg InsOb Bldng of Contr in InsOpenAppl |
| I_InsOpApContrInsrdObjBuilding | view_entity | from | COMPOSITE | InsOb Building of Contract in InsOpAppl |
| I_InsOpApCvrgPckgCvrgBuilding | view_entity | from | COMPOSITE | InsOb Bldng of Cvrg under CvPcg in OpAp |
| I_InsOpApCvrgPckgInsrdBldng | view_entity | from | COMPOSITE | InsOb Bldng of Cvrg Pckg in InsOpenAppl |
| I_InsurApplContrCvrgInsrdBldng | view_entity | inner | COMPOSITE | Cvrg InsOb Bldng of Contr in Insur Appl |
| I_InsurApplContrInsrdObjBldng | view_entity | inner | COMPOSITE | InsOb Building of Contract in Insur Appl |
| I_InsurApplCvrgPckgCvrgBldng | view_entity | inner | COMPOSITE | InsOb Bldng of Cvrg of CvPcg in Appl |
| I_InsurApplCvrgPckgInsrdBldng | view_entity | inner | COMPOSITE | InsOb Bldng of Cvrg Pckg in Insur Appl |
| I_InsurPlcyContrCvrgInsrdBldng | view_entity | from | COMPOSITE | Cvrg InsOb Bldng of Contr in Insur Plcy |
| I_InsurPlcyContrInsuredBldng | view_entity | from | COMPOSITE | InsOb Building of Contract in Insur Plcy |
| I_InsurPlcyCvrgPckgCvrgBldng | view_entity | from | COMPOSITE | InsOb Bldng of Cvrg of CvPcg in Plcy |
| I_InsurPlcyCvrgPckgInsrdBldng | view_entity | from | COMPOSITE | InsOb Bldng of Cvrg Pckg in Insur Plcy |
| P_InsurOpenApplInsuredBuilding | view_entity | from | COMPOSITE | |
| P_InsurOpenApplInsuredBuilding | view_entity | union | COMPOSITE |
Fields (33)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyCoverageID | InsurPlcyCoverageID | 9 |
| KEY | InsurPlcyCoveragePackageID | InsurPlcyCoveragePackageID | 9 |
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 9 |
| KEY | InsurPlcyInsuredObjectID | InsurPlcyInsuredObjectID | 9 |
| KEY | InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 8 |
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 9 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 4 |
| InsurInsrblObjBldngCategory | InsurInsrblObjBldngCategory | 8 | |
| InsurInsrblObjBldngType | InsurInsrblObjBldngType | 8 | |
| InsurInsrblObjConstructYear | InsurInsrblObjConstructYear | 8 | |
| InsurInsrblObjCubicSpaceQty | InsurInsrblObjCubicSpaceQty | 8 | |
| InsurInsrblObjCubicSpaceUnit | InsurInsrblObjCubicSpaceUnit | 8 | |
| InsurInsrblObjGlazingQty | InsurInsrblObjGlazingQty | 8 | |
| InsurInsrblObjGlazingUnit | InsurInsrblObjGlazingUnit | 8 | |
| InsurInsrblObjIsBuildUpArea | InsurInsrblObjIsBuildUpArea | 8 | |
| InsurInsrblObjIsOccupiedBldng | InsurInsrblObjIsOccupiedBldng | 8 | |
| InsurInsrblObjIsPrefabHouse | InsurInsrblObjIsPrefabHouse | 8 | |
| InsurInsrblObjIsTmpCvrg | InsurInsrblObjIsTmpCvrg | 8 | |
| InsurInsrblObjJrnlNmbr | InsurInsrblObjJrnlNmbr | 8 | |
| InsurInsrblObjNmbrOfFloors | InsurInsrblObjNmbrOfFloors | 8 | |
| InsurInsrblObjNmbrOfLiving | InsurInsrblObjNmbrOfLiving | 8 | |
| InsurInsrblObjOuterWallType | InsurInsrblObjOuterWallType | 8 | |
| InsurInsrblObjPartner | InsurInsrblObjPartner | 8 | |
| InsurInsrblObjPartPrpty | InsurInsrblObjPartPrpty | 8 | |
| InsurInsrblObjPropertyAreaQty | InsurInsrblObjPropertyAreaQty | 8 | |
| InsurInsrblObjPropertyAreaUnit | InsurInsrblObjPropertyAreaUnit | 8 | |
| InsurInsrblObjRoofing | InsurInsrblObjRoofing | 8 | |
| InsurInsrblObjUsableSpaceQty | InsurInsrblObjUsableSpaceQty | 8 | |
| InsurInsrblObjUsableSpaceUnit | InsurInsrblObjUsableSpaceUnit | 8 | |
| InsurInsrblObjYearOfCleanup | InsurInsrblObjYearOfCleanup | 8 | |
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | 8 | |
| InsurPlcyInsrdObjectTemplate | InsurPlcyInsrdObjectTemplate | 8 | |
| LastChangeDateTime | LastChangeDateTime | 8 |
@EndUserText.label : 'Insured Building in Insurance Policy'
@VDM : {
viewType : #BASIC,
lifecycle.contract.type : #SAP_INTERNAL_API }
@AccessControl : {
authorizationCheck : #PRIVILEGED_ONLY,
personalData.blocking : #('TRANSACTIONAL_DATA') }
@ObjectModel : {
representativeKey : 'InsurPlcyInsuredObjectID',
semanticKey : [ 'InsurPlcyInsuredObjectID' ],
usageType : {
dataClass : #TRANSACTIONAL,
serviceQuality : #A,
sizeCategory : #XL },
supportedCapabilities : [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ] }
@Metadata.allowExtensions : true
@Analytics : { technicalName: 'IPInsrdBldngBsc' }
define view entity I_InsurPlcyInsuredBldngBasic
as select from /pm0/abdasubjct as Subject
association [1..1] to I_InsurInsrblObjectBasic as _InsurInsrblObjectBasic on $projection.InsurPlcyInsrdObjUnqID = _InsurInsrblObjectBasic.InsurInsrblObj
and $projection.InsurInsrblObjJrnlNmbr = _InsurInsrblObjectBasic.InsurInsrblObjJrnlNmbr
association [1..1] to I_Currency as _Currency on $projection.InsurPlcyInsrdVehCurrency = _Currency.Currency
{
key cast( Subject.policy_id as /pm0/vdm_policy_uuid preserving type ) as InsurPlcyUUID,
key Subject.policyproduct_id as InsurPlcyInsurContr,
key Subject.covpac_id as InsurPlcyCoveragePackageID,
key Subject.coverage_id as InsurPlcyCoverageID,
key Subject.subject_id as InsurPlcyInsuredObjectID,
key cast( Subject.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
key Subject.journalendno_id as InsurPlcyJrnlEndNmbr,
@Consumption.hidden: true
Subject.ppdpac_id as InsurPlcyProductPackageID,
Subject.pm_id as InsurPlcyInsrdObjectTemplate,
Subject.objcat_cd as InsurPlcyInsuredObjectCategory,
Subject.objtyp_cd as InsurPlcyInsrdObjSubCategory,
Subject.insobjnr_tt as InsurPlcyInsrdObjUnqID,
@Consumption.hidden: true
Subject.bo_cd as InsurPlcyBusinessObject,
_InsurInsrblObjectBasic.InsurInsrblObjIsPrefabHouse as InsurInsrblObjIsPrefabHouse,
_InsurInsrblObjectBasic.InsurInsrblObjIsTmpCvrg as InsurInsrblObjIsTmpCvrg,
_InsurInsrblObjectBasic.InsurInsrblObjOuterWallType as InsurInsrblObjOuterWallType,
_InsurInsrblObjectBasic.InsurInsrblObjRoofing as InsurInsrblObjRoofing,
_InsurInsrblObjectBasic.InsurInsrblObjCubicSpaceQty as InsurInsrblObjCubicSpaceQty,
_InsurInsrblObjectBasic.InsurInsrblObjCubicSpaceUnit as InsurInsrblObjCubicSpaceUnit,
_InsurInsrblObjectBasic.InsurInsrblObjConstructYear as InsurInsrblObjConstructYear,
_InsurInsrblObjectBasic.InsurInsrblObjGlazingQty as InsurInsrblObjGlazingQty,
_InsurInsrblObjectBasic.InsurInsrblObjGlazingUnit as InsurInsrblObjGlazingUnit,
_InsurInsrblObjectBasic.InsurInsrblObjIsBuildUpArea as InsurInsrblObjIsBuildUpArea,
_InsurInsrblObjectBasic.InsurInsrblObjPropertyAreaQty as InsurInsrblObjPropertyAreaQty,
_InsurInsrblObjectBasic.InsurInsrblObjPropertyAreaUnit as InsurInsrblObjPropertyAreaUnit,
_InsurInsrblObjectBasic.InsurInsrblObjPartner as InsurInsrblObjPartner,
_InsurInsrblObjectBasic.InsurInsrblObjPartPrpty as InsurInsrblObjPartPrpty,
_InsurInsrblObjectBasic.InsurInsrblObjBldngCategory as InsurInsrblObjBldngCategory,
_InsurInsrblObjectBasic.InsurInsrblObjBldngType as InsurInsrblObjBldngType,
_InsurInsrblObjectBasic.InsurInsrblObjNmbrOfFloors as InsurInsrblObjNmbrOfFloors,
_InsurInsrblObjectBasic.InsurInsrblObjNmbrOfLiving as InsurInsrblObjNmbrOfLiving,
_InsurInsrblObjectBasic.InsurInsrblObjIsOccupiedBldng as InsurInsrblObjIsOccupiedBldng,
_InsurInsrblObjectBasic.InsurInsrblObjYearOfCleanup as InsurInsrblObjYearOfCleanup,
_InsurInsrblObjectBasic.InsurInsrblObjUsableSpaceQty as InsurInsrblObjUsableSpaceQty,
_InsurInsrblObjectBasic.InsurInsrblObjUsableSpaceUnit as InsurInsrblObjUsableSpaceUnit,
@ObjectModel.foreignKey.association: '_Currency'
Subject.currency_id as InsurPlcyInsrdVehCurrency,
Subject.jourvbo_cd as InsurInsrblObjJrnlNmbr,
@Semantics.systemDateTime.lastChangedAt: true
Subject.change_ts as LastChangeDateTime,
@Consumption.hidden: true
_Currency,
_InsurInsrblObjectBasic
}
where
Subject.covcp_id = 0
and Subject.objcat_cd = '00002'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURINSRBLOBJECTBASIC",
"/PM0/ABDASUBJCT"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_INSURINSRBLOBJECTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/