P_InsurOpenApplSubCoverage

DDL: P_INSUROPENAPPLSUBCOVERAGE Type: view_entity COMPOSITE

P_InsurOpenApplSubCoverage is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (P_InsuranceOpenApplicationJrnl, P_InsuranceOpenApplicationJrnl, I_InsurPlcySubCoverageBasic, I_InsurPlcySubCoverageBasic) and exposes 17 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyJrnlNmbr, InsurPlcyInsurContr, InsurPlcyCoveragePackageID.

4 data source(s) 17 fields

Data Sources (4)

SourceAliasJoin Type
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner
I_InsurPlcySubCoverageBasic SubCoverage from
I_InsurPlcySubCoverageBasic SubCoverage union

Annotations (4)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsuranceOpenApplicationJrnl InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcySubCoverageBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPlcySubCoverageBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcySubCoverageBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcySubCoverageBasic InsurPlcyCoverageID
KEY InsurPlcySubCvrgID I_InsurPlcySubCoverageBasic InsurPlcySubCvrgID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcySubCoverageBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPlcySubCoverageBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcySubCoverageBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcySubCoverageBasic InsurPlcyCoverageID
KEY InsurPlcySubCvrgID I_InsurPlcySubCoverageBasic InsurPlcySubCvrgID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyUUID P_InsuranceOpenApplicationJrnl InsurPlcyUUID 
@VDM : {
   viewType: #COMPOSITE,
   private: true
}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_InsurOpenApplSubCoverage
  as select from I_InsurPlcySubCoverageBasic    as SubCoverage
    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  =  SubCoverage.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            =  SubCoverage.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= SubCoverage.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  SubCoverage.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key SubCoverage.InsurPlcyJrnlNmbr,
  key SubCoverage.InsurPlcyInsurContr,
  key SubCoverage.InsurPlcyCoveragePackageID,
  key SubCoverage.InsurPlcyCoverageID,
  key SubCoverage.InsurPlcySubCvrgID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
}

union

select from  I_InsurPlcySubCoverageBasic    as SubCoverage
  inner join P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              =  SubCoverage.InsurPlcyUUID
                                                            and OpenApplJrnl.InsurPlcyInsurContr            =  SubCoverage.InsurPlcyInsurContr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= SubCoverage.InsurPlcyJrnlNmbr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  SubCoverage.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key SubCoverage.InsurPlcyJrnlNmbr,
  key SubCoverage.InsurPlcyInsurContr,
  key SubCoverage.InsurPlcyCoveragePackageID,
  key SubCoverage.InsurPlcyCoverageID,
  key SubCoverage.InsurPlcySubCvrgID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
}

Learn More