P_InsurOpenApplBonusMalusOwner

DDL: P_INSUROPENAPPLBONUSMALUSOWNER Type: view_entity COMPOSITE

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

4 data source(s) 19 fields

Data Sources (4)

SourceAliasJoin Type
I_InsurPolicyBnMlOwnerBasic BnMlOwner from
I_InsurPolicyBnMlOwnerBasic BnMlOwner 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_InsurPolicyBnMlOwnerBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPolicyBnMlOwnerBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPolicyBnMlOwnerBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPolicyBnMlOwnerBasic InsurPlcyCoverageID
KEY InsurPlcyBonusMalusID I_InsurPolicyBnMlOwnerBasic InsurPlcyBonusMalusID
KEY InsurPlcyBonusMalusOwnerID I_InsurPolicyBnMlOwnerBasic InsurPlcyBonusMalusOwnerID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPolicyBnMlOwnerBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPolicyBnMlOwnerBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPolicyBnMlOwnerBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPolicyBnMlOwnerBasic InsurPlcyCoverageID
KEY InsurPlcyBonusMalusID I_InsurPolicyBnMlOwnerBasic InsurPlcyBonusMalusID
KEY InsurPlcyBonusMalusOwnerID I_InsurPolicyBnMlOwnerBasic InsurPlcyBonusMalusOwnerID
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_InsurOpenApplBonusMalusOwner
  as select from I_InsurPolicyBnMlOwnerBasic      as BnMlOwner
    inner join     P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  =  BnMlOwner.InsurPlcyUUID
                                                                  and OpenApplJrnl.InsurPlcyInsurContr            =  BnMlOwner.InsurPlcyInsurContr
                                                                  and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= BnMlOwner.InsurPlcyJrnlNmbr
                                                                  and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  BnMlOwner.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key BnMlOwner.InsurPlcyJrnlNmbr,
  key BnMlOwner.InsurPlcyInsurContr,
  key BnMlOwner.InsurPlcyCoveragePackageID,
  key BnMlOwner.InsurPlcyCoverageID,
  key BnMlOwner.InsurPlcyBonusMalusID,
  key BnMlOwner.InsurPlcyBonusMalusOwnerID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID

}

union

select from  I_InsurPolicyBnMlOwnerBasic    as BnMlOwner
  inner join P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              =  BnMlOwner.InsurPlcyUUID
                                                            and OpenApplJrnl.InsurPlcyInsurContr            =  BnMlOwner.InsurPlcyInsurContr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= BnMlOwner.InsurPlcyJrnlNmbr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  BnMlOwner.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key BnMlOwner.InsurPlcyJrnlNmbr,
  key BnMlOwner.InsurPlcyInsurContr,
  key BnMlOwner.InsurPlcyCoveragePackageID,
  key BnMlOwner.InsurPlcyCoverageID,
  key BnMlOwner.InsurPlcyBonusMalusID,
  key BnMlOwner.InsurPlcyBonusMalusOwnerID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPOLICYBNMLOWNERBASIC",
"P_INSURANCEOPENAPPLICATIONJRNL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More