I_InsurApplCoveragePackage

DDL: I_INSURAPPLCOVERAGEPACKAGE Type: view_entity COMPOSITE
18 Fields 2 Data Sources 6 Associations

Coverage Package in Insurance Appl

I_InsurApplCoveragePackage is a Composite CDS View that provides data about "Coverage Package in Insurance Appl" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyCvrgPackageBasic, P_InsurPolicyJournalKeys) and exposes 18 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyContrDataDetnJrnlNmbr. It has 6 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyCvrgPackageBasic CoveragePackage inner
P_InsurPolicyJournalKeys PlcyJrnl from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyCvrgPackageTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[1..1] I_InsurContrCanclnReason _InsurContrCanclnReason $projection.InsurPlcyCvrgPckgCanclnReason = _InsurContrCanclnReason.InsurContrCanclnRsn
[1..*] I_InsurApplCoverage _InsurApplCoverage
[0..*] I_InsurApplCvrgPckgClause _InsurApplCvrgPckgClause
[0..*] I_InsurApplCvrgPckgInsrdObject _InsurApplCvrgPckgInsrdObject
[0..*] I_InsurApplCvrgPckgSurchrgDisc _InsurApplCvrgPckgSurchrgDisc

Annotations (11)

NameValueLevelField
EndUserText.label Coverage Package in Insurance Appl 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 #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IACvrgPckg 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
KEY InsurPlcyContrDataDetnJrnlNmbr
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
_InsurApplContract _InsurApplContract
_InsurApplCoverage _InsurApplCoverage
_InsurApplCvrgPckgClause _InsurApplCvrgPckgClause
_InsurApplCvrgPckgInsrdObject _InsurApplCvrgPckgInsrdObject
_InsurApplCvrgPckgSurchrgDisc _InsurApplCvrgPckgSurchrgDisc
_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_InsurApplCoveragePackage.
-- 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_InsurApplCoveragePackage AS
SELECT
  CoveragePackage.InsurPlcyUUID AS InsurPlcyUUID,
  CoveragePackage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  CoveragePackage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  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 P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyCvrgPackageBasic AS CoveragePackage ON /* join condition not captured in parsed metadata */
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_InsurApplCoverage AS _InsurApplCoverage ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurApplCvrgPckgClause AS _InsurApplCvrgPckgClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplCvrgPckgInsrdObject AS _InsurApplCvrgPckgInsrdObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplCvrgPckgSurchrgDisc AS _InsurApplCvrgPckgSurchrgDisc ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More