P_InsurOpenApplBeneficiary

DDL: P_INSUROPENAPPLBENEFICIARY Type: view_entity COMPOSITE

Insurance Open Application Beneficiary

P_InsurOpenApplBeneficiary is a Composite CDS View that provides data about "Insurance Open Application Beneficiary" in SAP S/4HANA. It reads from 4 data sources (I_InsurPolicyBeneficiaryBasic, I_InsurPolicyBeneficiaryBasic, P_InsuranceOpenApplicationJrnl, P_InsuranceOpenApplicationJrnl) and exposes 17 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyJrnlNmbr, InsurPlcyInsurContr, InsurPlcyCoveragePackageID.

4 data source(s) 17 fields

Data Sources (4)

SourceAliasJoin Type
I_InsurPolicyBeneficiaryBasic Beneficiary from
I_InsurPolicyBeneficiaryBasic Beneficiary union
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner

Annotations (5)

NameValueLevelField
EndUserText.label Insurance Open Application Beneficiary view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsuranceOpenApplicationJrnl InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPolicyBeneficiaryBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPolicyBeneficiaryBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPolicyBeneficiaryBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPolicyBeneficiaryBasic InsurPlcyCoverageID
KEY InsurancePolicyBeneficiaryID I_InsurPolicyBeneficiaryBasic InsurancePolicyBeneficiaryID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPolicyBeneficiaryBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPolicyBeneficiaryBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPolicyBeneficiaryBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPolicyBeneficiaryBasic InsurPlcyCoverageID
KEY InsurancePolicyBeneficiaryID I_InsurPolicyBeneficiaryBasic InsurancePolicyBeneficiaryID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyUUID P_InsuranceOpenApplicationJrnl InsurPlcyUUID 
@EndUserText.label: 'Insurance Open Application Beneficiary'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM:{
viewType: #COMPOSITE,
private: true
}

define view entity P_InsurOpenApplBeneficiary
  as select from I_InsurPolicyBeneficiaryBasic  as Beneficiary

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

{

  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Beneficiary.InsurPlcyJrnlNmbr,
  key Beneficiary.InsurPlcyInsurContr,
  key Beneficiary.InsurPlcyCoveragePackageID,
  key Beneficiary.InsurPlcyCoverageID,
  key Beneficiary.InsurancePolicyBeneficiaryID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
}

union

select from  I_InsurPolicyBeneficiaryBasic  as Beneficiary

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

{

  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Beneficiary.InsurPlcyJrnlNmbr,
  key Beneficiary.InsurPlcyInsurContr,
  key Beneficiary.InsurPlcyCoveragePackageID,
  key Beneficiary.InsurPlcyCoverageID,
  key Beneficiary.InsurancePolicyBeneficiaryID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPOLICYBENEFICIARYBASIC",
"P_INSURANCEOPENAPPLICATIONJRNL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More