I_INSURPLCYINSUREDBLDNGBASIC

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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":""
}
}*/