I_InsurancePolicy

DDL: I_INSURANCEPOLICY Type: view_entity COMPOSITE
24 Fields 1 Data Sources 11 Associations

Insurance Policy

I_InsurancePolicy is a Composite CDS View that provides data about "Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyBasic) and exposes 24 fields with key field InsurPlcyUUID. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyBasic Policy from

Associations (11)

CardinalityTargetAliasCondition
[1..1] I_InsurPlcyDistrChnl _InsurPlcyDistrChnl $projection.InsurPlcyDistrChnl = _InsurPlcyDistrChnl.InsurPlcyDistrChnl
[1..1] I_InsurPlcyAcquisitionType _InsurPlcyAcqnType $projection.InsurPlcyAcqnType = _InsurPlcyAcqnType.InsurPlcyAcqnType
[1..1] I_InsurPlcyInsurer _InsurPlcyInsurer $projection.InsrrIDByInsrr = _InsurPlcyInsurer.InsrrIDByInsrr
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcySalesProductTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[1..1] I_InsurApplLifeCycleStatus _InsurApplLifeCycleStatus $projection.InsurApplLifeCycSts = _InsurApplLifeCycleStatus.InsurApplLifeCycSts
[1..*] I_InsurPlcyCashFlowHeader _InsurPlcyCashFlowHeader $projection.InsurancePolicy = _InsurPlcyCashFlowHeader.InsurancePolicy
[1..1] E_InsurancePolicy _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[1..*] I_InsurancePolicyPolicyHolder _InsurancePolicyholder
[1..*] I_InsuranceContract _InsuranceContract
[1..*] I_InsurPlcyContrJrnl _InsurPlcyContrJrnl
[0..*] I_InsurPolicyPlannedProcessing _InsurPlcyPlndProcg

Annotations (11)

NameValueLevelField
EndUserText.label Insurance Policy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey InsurPlcyUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IPPlcy view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyBasic InsurPlcyUUID Policy UUID
InsurPlcyJrnlNmbr I_InsurPlcyBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurancePolicy I_InsurPlcyBasic InsurancePolicy Policy Number
InsurPlcyAuthznSlsProductGroup I_InsurPlcyBasic InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
InsurPlcyStartDateTime I_InsurPlcyBasic InsurPlcyStartDateTime Policy Start
InsurApplLifeCycSts I_InsurPlcyBasic InsurApplLifeCycSts Policy Status
InsurPlcyDistrChnl I_InsurPlcyBasic InsurPlcyDistrChnl Distrib.Channel
InsrrIDByInsrr I_InsurPlcyBasic InsrrIDByInsrr Company ID
InsurPlcySalesProductTemplate I_InsurPlcyBasic InsurPlcySalesProductTemplate SlsProdTempl.ID
InsurPlcyAcqnType I_InsurPlcyBasic InsurPlcyAcqnType Acq. Type
PrdcssrInsurancePolicy I_InsurPlcyBasic PrdcssrInsurancePolicy Previous Policy
LastChangeDateTime I_InsurPlcyBasic LastChangeDateTime Timestamp
InsurPolicyCancellationStatus I_InsurPlcyBasic InsurPolicyCancellationStatus Policy Cancellation
_InsuranceContract _InsuranceContract
_InsurancePolicyholder _InsurancePolicyholder
_InsurPlcyCashFlowHeader _InsurPlcyCashFlowHeader
_InsurPlcyContrJrnl _InsurPlcyContrJrnl
_InsurPlcyPlndProcg _InsurPlcyPlndProcg
_InsurPlcyDistrChnl _InsurPlcyDistrChnl
_InsurPlcyAcqnType _InsurPlcyAcqnType
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurPlcyInsurer _InsurPlcyInsurer
_InsurApplLifeCycleStatus _InsurApplLifeCycleStatus

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_InsurancePolicy.
-- 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_InsurancePolicy AS
SELECT
  Policy.InsurPlcyUUID AS InsurPlcyUUID,
  Policy.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Policy.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Policy.InsurancePolicy AS InsurancePolicy,
  Policy.InsurPlcyAuthznSlsProductGroup AS InsurPlcyAuthznSlsProductGroup,
  Policy.InsurPlcyStartDateTime AS InsurPlcyStartDateTime,
  Policy.InsurApplLifeCycSts AS InsurApplLifeCycSts,
  Policy.InsurPlcyDistrChnl AS InsurPlcyDistrChnl,
  Policy.InsrrIDByInsrr AS InsrrIDByInsrr,
  Policy.InsurPlcySalesProductTemplate AS InsurPlcySalesProductTemplate,
  Policy.InsurPlcyAcqnType AS InsurPlcyAcqnType,
  Policy.PrdcssrInsurancePolicy AS PrdcssrInsurancePolicy,
  Policy.LastChangeDateTime AS LastChangeDateTime,
  Policy.InsurPolicyCancellationStatus AS InsurPolicyCancellationStatus
FROM I_InsurPlcyBasic AS Policy
LEFT OUTER JOIN I_InsurPlcyDistrChnl AS _InsurPlcyDistrChnl ON InsurPlcyDistrChnl = _InsurPlcyDistrChnl.InsurPlcyDistrChnl  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyAcquisitionType AS _InsurPlcyAcqnType ON InsurPlcyAcqnType = _InsurPlcyAcqnType.InsurPlcyAcqnType  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsurer AS _InsurPlcyInsurer ON InsrrIDByInsrr = _InsurPlcyInsurer.InsrrIDByInsrr  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcySalesProductTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurApplLifeCycleStatus AS _InsurApplLifeCycleStatus ON InsurApplLifeCycSts = _InsurApplLifeCycleStatus.InsurApplLifeCycSts  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCashFlowHeader AS _InsurPlcyCashFlowHeader ON InsurancePolicy = _InsurPlcyCashFlowHeader.InsurancePolicy  -- association [1..*]
LEFT OUTER JOIN E_InsurancePolicy AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN I_InsurancePolicyPolicyHolder AS _InsurancePolicyholder ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsuranceContract AS _InsuranceContract ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurPlcyContrJrnl AS _InsurPlcyContrJrnl ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurPolicyPlannedProcessing AS _InsurPlcyPlndProcg ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More