P_InsurOpenApplNamedDriver

DDL: P_INSUROPENAPPLNAMEDDRIVER Type: view_entity COMPOSITE Package: VDM_PMA_PLCY_OPEN_APPL_BASIC

Insur Open Application Named Driver

P_InsurOpenApplNamedDriver is a Composite CDS View that provides data about "Insur Open Application Named Driver" in SAP S/4HANA. It reads from 4 data sources (I_InsurPlcyNamedDriverBasic, I_InsurPlcyNamedDriverBasic, P_InsuranceOpenApplicationJrnl, P_InsuranceOpenApplicationJrnl) and exposes 19 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyJrnlNmbr, InsurPlcyCoveragePackageID, InsurPlcyInsurContr. Part of development package VDM_PMA_PLCY_OPEN_APPL_BASIC.

4 data source(s) 19 fields

Data Sources (4)

SourceAliasJoin Type
I_InsurPlcyNamedDriverBasic NamedDriver from
I_InsurPlcyNamedDriverBasic NamedDriver union
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner

Annotations (4)

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsuranceOpenApplicationJrnl InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyNamedDriverBasic InsurPlcyJrnlNmbr
KEY InsurPlcyCoveragePackageID I_InsurPlcyNamedDriverBasic InsurPlcyCoveragePackageID
KEY InsurPlcyInsurContr I_InsurPlcyNamedDriverBasic InsurPlcyInsurContr
KEY InsurPlcyCoverageID I_InsurPlcyNamedDriverBasic InsurPlcyCoverageID
KEY InsurPlcyInsuredObjectID I_InsurPlcyNamedDriverBasic InsurPlcyInsuredObjectID
KEY InsurPlcyInsrdVehNmdDrvrID I_InsurPlcyNamedDriverBasic InsurPlcyInsrdVehNmdDrvrID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyNamedDriverBasic InsurPlcyJrnlNmbr
KEY InsurPlcyCoveragePackageID I_InsurPlcyNamedDriverBasic InsurPlcyCoveragePackageID
KEY InsurPlcyInsurContr I_InsurPlcyNamedDriverBasic InsurPlcyInsurContr
KEY InsurPlcyCoverageID I_InsurPlcyNamedDriverBasic InsurPlcyCoverageID
KEY InsurPlcyInsuredObjectID I_InsurPlcyNamedDriverBasic InsurPlcyInsuredObjectID
KEY InsurPlcyInsrdVehNmdDrvrID I_InsurPlcyNamedDriverBasic InsurPlcyInsrdVehNmdDrvrID
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_InsurOpenApplNamedDriver
  as select from I_InsurPlcyNamedDriverBasic    as NamedDriver
    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  =  NamedDriver.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            =  NamedDriver.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= NamedDriver.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  NamedDriver.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key NamedDriver.InsurPlcyJrnlNmbr,
  key NamedDriver.InsurPlcyCoveragePackageID,
  key NamedDriver.InsurPlcyInsurContr,
  key NamedDriver.InsurPlcyCoverageID,
  key NamedDriver.InsurPlcyInsuredObjectID,
  key NamedDriver.InsurPlcyInsrdVehNmdDrvrID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
  
}     
   
union

select from I_InsurPlcyNamedDriverBasic    as NamedDriver
    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              =  NamedDriver.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            =  NamedDriver.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= NamedDriver.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  NamedDriver.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key NamedDriver.InsurPlcyJrnlNmbr,
  key NamedDriver.InsurPlcyCoveragePackageID,
  key NamedDriver.InsurPlcyInsurContr,
  key NamedDriver.InsurPlcyCoverageID,
  key NamedDriver.InsurPlcyInsuredObjectID,
  key NamedDriver.InsurPlcyInsrdVehNmdDrvrID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
  
}

Learn More