I_INSURINSRBLOBJECTBASIC
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurInsurableObject | view_entity | from | COMPOSITE | Insurable Object |
| I_InsurInsurableObjectBldng | view_entity | from | COMPOSITE | Insurable Object Building |
Fields (33)
| Key | Field | CDS Fields | Used 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'