I_INSURINSRBLOBJECTBASIC

CDS View

Insurable Object

I_INSURINSRBLOBJECTBASIC is a CDS View in S/4HANA. Insurable Object. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_InsurInsurableObject view_entity from COMPOSITE Insurable Object
I_InsurInsurableObjectBldng view_entity from COMPOSITE Insurable Object Building

Fields (33)

KeyField CDS FieldsUsed in Views
KEY InsurInsrblObj InsurInsrblObj 2
KEY InsurInsrblObjJrnlNmbr InsurInsrblObjJrnlNmbr 2
KEY InsurInsrblObjUUID InsurInsrblObjUUID 2
InsurInsrblObjBldngCategory InsurInsrblObjBldngCategory 1
InsurInsrblObjBldngType InsurInsrblObjBldngType 1
InsurInsrblObjCancldRsn InsurInsrblObjCancldRsn 1
InsurInsrblObjCanclnDte InsurInsrblObjCanclnDte 1
InsurInsrblObjCategory InsurInsrblObjCategory 1
InsurInsrblObjConstructYear InsurInsrblObjConstructYear 1
InsurInsrblObjCubicSpaceQty InsurInsrblObjCubicSpaceQty 1
InsurInsrblObjCubicSpaceUnit InsurInsrblObjCubicSpaceUnit 1
InsurInsrblObjEffctvDte InsurInsrblObjEffctvDte 1
InsurInsrblObjExtObjNmbr InsurInsrblObjExtObjNmbr 1
InsurInsrblObjGlazingQty InsurInsrblObjGlazingQty 1
InsurInsrblObjGlazingUnit InsurInsrblObjGlazingUnit 1
InsurInsrblObjIsBuildUpArea InsurInsrblObjIsBuildUpArea 1
InsurInsrblObjIsCancld InsurInsrblObjIsCancld 1
InsurInsrblObjIsOccupiedBldng InsurInsrblObjIsOccupiedBldng 1
InsurInsrblObjIsPrefabHouse InsurInsrblObjIsPrefabHouse 1
InsurInsrblObjIsTmpCvrg InsurInsrblObjIsTmpCvrg 1
InsurInsrblObjName InsurInsrblObjName 1
InsurInsrblObjNmbrOfFloors InsurInsrblObjNmbrOfFloors 1
InsurInsrblObjNmbrOfLiving InsurInsrblObjNmbrOfLiving 1
InsurInsrblObjOuterWallType InsurInsrblObjOuterWallType 1
InsurInsrblObjPartner InsurInsrblObjPartner 1
InsurInsrblObjPartPrpty InsurInsrblObjPartPrpty 1
InsurInsrblObjPropertyAreaQty InsurInsrblObjPropertyAreaQty 1
InsurInsrblObjPropertyAreaUnit InsurInsrblObjPropertyAreaUnit 1
InsurInsrblObjRoofing InsurInsrblObjRoofing 1
InsurInsrblObjSubCategory InsurInsrblObjSubCategory 1
InsurInsrblObjUsableSpaceQty InsurInsrblObjUsableSpaceQty 1
InsurInsrblObjUsableSpaceUnit InsurInsrblObjUsableSpaceUnit 1
InsurInsrblObjYearOfCleanup InsurInsrblObjYearOfCleanup 1
@EndUserText.label        : 'Insurable Object'
@VDM                      : {
  viewType                : #BASIC,
  lifecycle.contract.type : #PUBLIC_LOCAL_API }

@AccessControl            : {
  authorizationCheck      : #PRIVILEGED_ONLY,
  personalData.blocking   : #('TRANSACTIONAL_DATA')}

@ObjectModel              : {
    representativeKey     : 'InsurInsrblObjUUID',
    semanticKey           : [ 'InsurInsrblObj' ],
    usageType             : {
    dataClass             : #TRANSACTIONAL,
    serviceQuality        : #A,
    sizeCategory          : #XL },
    supportedCapabilities : [ #CDS_MODELING_DATA_SOURCE ] }

@Metadata.allowExtensions : true
@Analytics                : {
    technicalName         : 'IInsrblObjBasic'}

define view entity I_InsurInsrblObjectBasic
  as select from /pm0/abdoinsobj as InsurableObject
{
  key cast( insobj_gd    as /pm0/vdm_policy_uuid  preserving type ) as InsurInsrblObjUUID,
  key cast( journalno_id as /pm0/abj_journalno_id preserving type ) as InsurInsrblObjJrnlNmbr,
      effectivity_dt                                                as InsurInsrblObjEffctvDte,
      insobj_tt                                                     as InsurInsrblObjName,
      objcat_cd                                                     as InsurInsrblObjCategory,
      objtyp_cd                                                     as InsurInsrblObjSubCategory,
      insobjnr_tt                                                   as InsurInsrblObj,
      extobjnr_tt                                                   as InsurInsrblObjExtObjNmbr,
      status_id                                                     as InsurInsrblObjStatus,
      cancel_tt                                                     as InsurInsrblObjCancldRsn,
      cancel_dt                                                     as InsurInsrblObjCanclnDte,
      cancel_fg                                                     as InsurInsrblObjIsCancld,
      prefabrihouse_fg                                              as InsurInsrblObjIsPrefabHouse,
      intcovconf_fg                                                 as InsurInsrblObjIsTmpCvrg,
      outerwall_cd                                                  as InsurInsrblObjOuterWallType,
      roofing_cd                                                    as InsurInsrblObjRoofing,
      @Semantics.quantity.unitOfMeasure: 'InsurInsrblObjCubicSpaceUnit'
      cast( cubicvolume_vl  as abap.quan( 5, 0 ) )                  as InsurInsrblObjCubicSpaceQty,
      cubicvolume_ut                                                as InsurInsrblObjCubicSpaceUnit,
      yearconstruct_dt                                              as InsurInsrblObjConstructYear,
      @Semantics.quantity.unitOfMeasure: 'InsurInsrblObjGlazingUnit'
      cast( glazedareabui_vl as abap.quan( 6, 0 ) )                 as InsurInsrblObjGlazingQty,
      glazedareabui_ut                                              as InsurInsrblObjGlazingUnit,
      locbuiltarea_fg                                               as InsurInsrblObjIsBuildUpArea,
      @Semantics.quantity.unitOfMeasure: 'InsurInsrblObjPropertyAreaUnit'
      cast( propertyarea_vl as abap.quan( 8, 0 ) )                  as InsurInsrblObjPropertyAreaQty,
      propertyarea_ut                                               as InsurInsrblObjPropertyAreaUnit,
      partn_id                                                      as InsurInsrblObjPartner,
      partneract_id                                                 as InsurInsrblObjPartPrpty,
      buildingtype_cd                                               as InsurInsrblObjBldngCategory,
      bldkind_id                                                    as InsurInsrblObjBldngType,
      numberfloors_am                                               as InsurInsrblObjNmbrOfFloors,
      nrresidunits_am                                               as InsurInsrblObjNmbrOfLiving,
      buildinhabit_fg                                               as InsurInsrblObjIsOccupiedBldng,
      yearrestore_dt                                                as InsurInsrblObjYearOfCleanup,
      @Semantics.quantity.unitOfMeasure: 'InsurInsrblObjUsableSpaceUnit'
      cast( activearea_vl as abap.quan( 8, 0 ) )                    as InsurInsrblObjUsableSpaceQty,
      activearea_ut                                                 as InsurInsrblObjUsableSpaceUnit

}
where
  InsurableObject.status_id = '0'