I_InsurOpenApplCoveragePackage

DDL: I_INSUROPENAPPLCOVERAGEPACKAGE Type: view_entity COMPOSITE
20 Fields 1 Data Sources 6 Associations

Coverage Package in InsurOpenAppl

I_InsurOpenApplCoveragePackage is a Composite CDS View that provides data about "Coverage Package in InsurOpenAppl" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCvrgPackageBasic) and exposes 20 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyContrDataDetnJrnlNmbr. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCvrgPackageBasic CoveragePackage from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyCvrgPackageTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[1..1] I_InsurContrCanclnReason _InsurContrCanclnReason $projection.InsurPlcyCvrgPckgCanclnReason = _InsurContrCanclnReason.InsurContrCanclnRsn
[1..*] I_InsurOpenApplCoverage _InsurOpenApplCoverage
[0..*] I_InsurOpenApplCvrgPckgClause _InsurOpenApplCvrgPckgClause
[0..*] I_InsOpApCvrgPckgInsrdObject _InsurOpenApplCvrgPckgInsrdObj
[0..*] I_InsOpApCvrgPckgSurchrgDisc _InsOpApCvrgPckgSurchrgDisc

Annotations (11)

NameValueLevelField
EndUserText.label Coverage Package in InsurOpenAppl 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 IOACvrgPckg view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID OpenApplJrnl InsurPlcyApplUUID Policy UUID
KEY InsuranceApplication
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.
InsurPlcyUUID OpenApplJrnl InsurPlcyUUID Policy UUID
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
_InsurOpenApplContract _InsurOpenApplContract
_InsurOpenApplCoverage _InsurOpenApplCoverage
_InsurOpenApplCvrgPckgClause _InsurOpenApplCvrgPckgClause
_InsurOpenApplCvrgPckgInsrdObj _InsurOpenApplCvrgPckgInsrdObj
_InsOpApCvrgPckgSurchrgDisc _InsOpApCvrgPckgSurchrgDisc
_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_InsurOpenApplCoveragePackage.
-- 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_InsurOpenApplCoveragePackage AS
SELECT
  OpenApplJrnl.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  cast( OpenApplJrnl.InsuranceApplication as /pm0/vdm_applicationnr_tt preserving type ) AS InsuranceApplication,
  CoveragePackage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  CoveragePackage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  CoveragePackage.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  CoveragePackage.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  OpenApplJrnl.InsurPlcyUUID AS InsurPlcyUUID,
  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_InsurOpenApplCoverage AS _InsurOpenApplCoverage ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurOpenApplCvrgPckgClause AS _InsurOpenApplCvrgPckgClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsOpApCvrgPckgInsrdObject AS _InsurOpenApplCvrgPckgInsrdObj ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsOpApCvrgPckgSurchrgDisc AS _InsOpApCvrgPckgSurchrgDisc ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More