I_InsuranceObject

DDL: I_INSURANCEOBJECT Type: view_entity BASIC

Insurance Object

I_InsuranceObject (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Services

I_InsuranceObject is a Basic CDS View that provides data about "Insurance Object" in SAP S/4HANA. It reads from 1 data source (dimaiob) and exposes 12 fields with key field InsuranceObject. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessFinancial Services
Application ComponentFS-CD
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageFinancial Services for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
dimaiob dimaiob from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsuranceObjectCategory _InsuranceObjectCategory $projection.InsuranceObjectCategory_2 = _InsuranceObjectCategory.InsuranceObjectCategory_2
[0..1] I_InsurObjCanclnReason _InsurObjCanclnReason $projection.InsuranceObjectCanclnReason = _InsurObjCanclnReason.InsuranceObjectCanclnReason

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Insurance Object view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.representativeKey InsuranceObject view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InsuranceObject insobject Identification of an Insurance Object
InsuranceObjectCategory_2 insobjecttyp External Insurance Object Category
InsuranceObjectName insobez IO: Name of an Insurance Object
InsuranceObjectExtReference insobjectext Insurance Object Number in External System
InsuranceObjectLeadingObject objref Reference to Leading Objects
CreatedByUser ernam IO: Technical User That Creted Insurance Object
CreationDate erdat Record Created On
LastChangedByUser aenam Technical User That Used IO
LastChangeDate aedat Last Changed On
InsuranceObjectCanclnReason cncreason Cancellation Reason for Insurance Object
_InsuranceObjectCategory _InsuranceObjectCategory
_InsurObjCanclnReason _InsurObjCanclnReason

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_InsuranceObject.
-- 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_InsuranceObject AS
SELECT
  insobject AS InsuranceObject,
  insobjecttyp AS InsuranceObjectCategory_2,
  insobez AS InsuranceObjectName,
  insobjectext AS InsuranceObjectExtReference,
  objref AS InsuranceObjectLeadingObject,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  cncreason AS InsuranceObjectCanclnReason
FROM dimaiob
LEFT OUTER JOIN I_InsuranceObjectCategory AS _InsuranceObjectCategory ON InsuranceObjectCategory_2 = _InsuranceObjectCategory.InsuranceObjectCategory_2  -- association [1..1]
LEFT OUTER JOIN I_InsurObjCanclnReason AS _InsurObjCanclnReason ON InsuranceObjectCanclnReason = _InsurObjCanclnReason.InsuranceObjectCanclnReason  -- association [0..1]
;