I_InsurPlcyCoveragePackage

DDL: I_INSURPLCYCOVERAGEPACKAGE Type: view_entity COMPOSITE Package: VDM_PM_PLCY_COMMON
18 Fields 1 Data Sources 7 Associations

Coverage Package in Insurance Policy

I_InsurPlcyCoveragePackage is a Composite CDS View that provides data about "Coverage Package in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCvrgPackageBasic) and exposes 18 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID. It has 7 associations to related views. Part of development package VDM_PM_PLCY_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCvrgPackageBasic CoveragePackage from

Associations (7)

CardinalityTargetAliasCondition
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyCvrgPackageTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[1..1] I_InsurContrCanclnReason _InsurContrCanclnReason $projection.InsurPlcyCvrgPckgCanclnReason = _InsurContrCanclnReason.InsurContrCanclnRsn
[1..*] I_InsurancePolicyCoverage _InsurancePolicyCoverage
[0..*] I_InsurPlcyCvrgPckgClause _InsurPlcyCvrgPckgClause
[0..*] I_InsurPlcyCvrgPckgInsrdObject _InsurPlcyCvrgPckgInsrdObject
[0..*] I_InsurPlcyCvrgPckgSurchrgDisc _InsurPlcyCvrgPckgSurchrgDisc
[0..*] I_InsurPlcyCvrgPckgPlndProcg _InsurPlcyCvrgPckgPlndProcg

Annotations (11)

NameValueLevelField
EndUserText.label Coverage Package in Insurance Policy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyCoveragePackageID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IPPlcyCvrgPckg view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyCvrgPackageBasic InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyCvrgPackageBasic InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyCvrgPackageBasic InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyJrnlNmbr I_InsurPlcyCvrgPackageBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyCvrgPackageBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyCvrgPackageTemplate I_InsurPlcyCvrgPackageBasic InsurPlcyCvrgPackageTemplate Prod.Engine ID
InsurPlcyProductPackageID I_InsurPlcyCvrgPackageBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyCvrgPckgCanclnReason I_InsurPlcyCvrgPackageBasic InsurPlcyCvrgPckgCanclnReason Reversal Reason
InsurPlcyCvrgPckgCanclnDteTime I_InsurPlcyCvrgPackageBasic InsurPlcyCvrgPckgCanclnDteTime Cov. Package Reversal Date/Time
LastChangeDateTime I_InsurPlcyCvrgPackageBasic LastChangeDateTime Timestamp
_InsuranceContract _InsuranceContract
_InsurancePolicyCoverage _InsurancePolicyCoverage
_InsurPlcyCvrgPckgClause _InsurPlcyCvrgPckgClause
_InsurPlcyCvrgPckgInsrdObject _InsurPlcyCvrgPckgInsrdObject
_InsurPlcyCvrgPckgSurchrgDisc _InsurPlcyCvrgPckgSurchrgDisc
_InsurPlcyCvrgPckgPlndProcg _InsurPlcyCvrgPckgPlndProcg
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurContrCanclnReason _InsurContrCanclnReason

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_InsurPlcyCoveragePackage.
-- 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_InsurPlcyCoveragePackage AS
SELECT
  CoveragePackage.InsurPlcyUUID AS InsurPlcyUUID,
  CoveragePackage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  CoveragePackage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  CoveragePackage.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  CoveragePackage.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  CoveragePackage.InsurPlcyCvrgPackageTemplate AS InsurPlcyCvrgPackageTemplate,
  CoveragePackage.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  CoveragePackage.InsurPlcyCvrgPckgCanclnReason AS InsurPlcyCvrgPckgCanclnReason,
  CoveragePackage.InsurPlcyCvrgPckgCanclnDteTime AS InsurPlcyCvrgPckgCanclnDteTime,
  CoveragePackage.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyCvrgPackageBasic AS CoveragePackage
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyCvrgPackageTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurContrCanclnReason AS _InsurContrCanclnReason ON InsurPlcyCvrgPckgCanclnReason = _InsurContrCanclnReason.InsurContrCanclnRsn  -- association [1..1]
LEFT OUTER JOIN I_InsurancePolicyCoverage AS _InsurancePolicyCoverage ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurPlcyCvrgPckgClause AS _InsurPlcyCvrgPckgClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCvrgPckgInsrdObject AS _InsurPlcyCvrgPckgInsrdObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCvrgPckgSurchrgDisc AS _InsurPlcyCvrgPckgSurchrgDisc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCvrgPckgPlndProcg AS _InsurPlcyCvrgPckgPlndProcg ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More