I_InsurInsrblObjectBasic

DDL: I_INSURINSRBLOBJECTBASIC Type: view_entity BASIC
34 Fields 1 Data Sources

Insurable Object

I_InsurInsrblObjectBasic is a Basic CDS View that provides data about "Insurable Object" in SAP S/4HANA. It reads from 1 data source (/pm0/abdoinsobj) and exposes 34 fields with key fields InsurInsrblObjUUID, InsurInsrblObjJrnlNmbr.

Data Sources (1)

SourceAliasJoin Type
/pm0/abdoinsobj InsurableObject from

Annotations (10)

NameValueLevelField
EndUserText.label Insurable Object view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurInsrblObjUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view
Analytics.technicalName IInsrblObjBasic view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY InsurInsrblObjUUID Ins. Obj. GD
KEY InsurInsrblObjJrnlNmbr Journal Number
InsurInsrblObjEffctvDte effectivity_dt Effective Date
InsurInsrblObjName insobj_tt Ins. Obj. Name
InsurInsrblObjCategory objcat_cd Object Category
InsurInsrblObjSubCategory objtyp_cd Object Type
InsurInsrblObj insobjnr_tt Insurable Obj.
InsurInsrblObjExtObjNmbr extobjnr_tt Ext.Object No.
InsurInsrblObjStatus status_id Trans Doc Status
InsurInsrblObjCancldRsn cancel_tt Reversal Reason
InsurInsrblObjCanclnDte cancel_dt Reversal Date
InsurInsrblObjIsCancld cancel_fg Reversal
InsurInsrblObjIsPrefabHouse prefabrihouse_fg Prefab. House
InsurInsrblObjIsTmpCvrg intcovconf_fg Temporary
InsurInsrblObjOuterWallType outerwall_cd Ext.Wall Type
InsurInsrblObjRoofing roofing_cd Roofing
InsurInsrblObjCubicSpaceQty Cubic Space
InsurInsrblObjCubicSpaceUnit cubicvolume_ut CubicSpace Unit
InsurInsrblObjConstructYear yearconstruct_dt Constructn Year
InsurInsrblObjGlazingQty Exter.Glazing
InsurInsrblObjGlazingUnit glazedareabui_ut ExtGlaze Area UM
InsurInsrblObjIsBuildUpArea locbuiltarea_fg Built-Up Area
InsurInsrblObjPropertyAreaQty Property Size
InsurInsrblObjPropertyAreaUnit propertyarea_ut PropertyArea UM
InsurInsrblObjPartner partn_id BusPartner
InsurInsrblObjPartPrpty partneract_id Partner Prop.
InsurInsrblObjBldngCategory buildingtype_cd Building Cat.
InsurInsrblObjBldngType bldkind_id Building Type
InsurInsrblObjNmbrOfFloors numberfloors_am No. of Floors
InsurInsrblObjNmbrOfLiving nrresidunits_am No.Living Units
InsurInsrblObjIsOccupiedBldng buildinhabit_fg Occup. Building
InsurInsrblObjYearOfCleanup yearrestore_dt Year of Cleanup
InsurInsrblObjUsableSpaceQty Usable Space
InsurInsrblObjUsableSpaceUnit activearea_ut UsableSpace UM

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_InsurInsrblObjectBasic.
-- 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_InsurInsrblObjectBasic AS
SELECT
  cast( insobj_gd as /pm0/vdm_policy_uuid preserving type ) AS InsurInsrblObjUUID,
  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,
  cast( cubicvolume_vl as abap.quan( 5, 0 ) ) AS InsurInsrblObjCubicSpaceQty,
  cubicvolume_ut AS InsurInsrblObjCubicSpaceUnit,
  yearconstruct_dt AS InsurInsrblObjConstructYear,
  cast( glazedareabui_vl as abap.quan( 6, 0 ) ) AS InsurInsrblObjGlazingQty,
  glazedareabui_ut AS InsurInsrblObjGlazingUnit,
  locbuiltarea_fg AS InsurInsrblObjIsBuildUpArea,
  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,
  cast( activearea_vl as abap.quan( 8, 0 ) ) AS InsurInsrblObjUsableSpaceQty,
  activearea_ut AS InsurInsrblObjUsableSpaceUnit
FROM /pm0/abdoinsobj AS InsurableObject
;

Learn More