P_InsurOpenApplContract

DDL: P_INSUROPENAPPLCONTRACT Type: view_entity COMPOSITE

P_InsurOpenApplContract is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_InsuranceContractBasic, I_InsuranceContractBasic, P_InsuranceOpenApplicationJrnl, P_InsuranceOpenApplicationJrnl) and exposes 13 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyInsurContr, InsurPlcyContrDataDetnJrnlNmbr, InsuranceApplication.

4 data source(s) 13 fields

Data Sources (4)

SourceAliasJoin Type
I_InsuranceContractBasic Contract from
I_InsuranceContractBasic Contract 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 (13)

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

// Get data for appl GUID and policy GUID


define view entity P_InsurOpenApplContract
  as select from I_InsuranceContractBasic       as Contract

    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  = Contract.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            = Contract.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Contract.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr < Contract.InsurPlcyJrnlEndNmbr

{

  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Contract.InsurPlcyInsurContr,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID,
      Contract.InsurPlcyJrnlNmbr,
      OpenApplJrnl.InsuranceApplicationStatus

}

union

select from  I_InsuranceContractBasic       as Contract

  inner join P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              = Contract.InsurPlcyUUID
                                                            and OpenApplJrnl.InsurPlcyInsurContr            = Contract.InsurPlcyInsurContr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Contract.InsurPlcyJrnlNmbr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr < Contract.InsurPlcyJrnlEndNmbr

{

  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Contract.InsurPlcyInsurContr,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID,
      Contract.InsurPlcyJrnlNmbr,
      OpenApplJrnl.InsuranceApplicationStatus

}

Learn More