P_InsurOpenApplClaimComparison

DDL: P_INSUROPENAPPLCLAIMCOMPARISON Type: view_entity COMPOSITE Package: VDM_PMA_PLCY_OPEN_APPL_BASIC

Insurance Open Application Claim Comparison

P_InsurOpenApplClaimComparison is a Composite CDS View that provides data about "Insurance Open Application Claim Comparison" in SAP S/4HANA. It reads from 4 data sources (I_InsurPlcyClaimComparisonBsc, I_InsurPlcyClaimComparisonBsc, P_InsuranceOpenApplicationJrnl, P_InsuranceOpenApplicationJrnl) and exposes 21 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyJrnlNmbr, InsurPlcyCoveragePackageID, InsurPlcyInsurContr. Part of development package VDM_PMA_PLCY_OPEN_APPL_BASIC.

4 data source(s) 21 fields

Data Sources (4)

SourceAliasJoin Type
I_InsurPlcyClaimComparisonBsc ClaimComparison from
I_InsurPlcyClaimComparisonBsc ClaimComparison 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 (21)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsuranceOpenApplicationJrnl InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyClaimComparisonBsc InsurPlcyJrnlNmbr
KEY InsurPlcyCoveragePackageID I_InsurPlcyClaimComparisonBsc InsurPlcyCoveragePackageID
KEY InsurPlcyInsurContr I_InsurPlcyClaimComparisonBsc InsurPlcyInsurContr
KEY InsurPlcyCoverageID I_InsurPlcyClaimComparisonBsc InsurPlcyCoverageID
KEY InsurPlcyBonusMalusID I_InsurPlcyClaimComparisonBsc InsurPlcyBonusMalusID
KEY InsurPlcyClaimComparisonID I_InsurPlcyClaimComparisonBsc InsurPlcyClaimComparisonID
KEY InsurPlcyBnMlClaimSurrenderID I_InsurPlcyClaimComparisonBsc InsurPlcyBnMlClaimSurrenderID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyClaimComparisonBsc InsurPlcyJrnlNmbr
KEY InsurPlcyCoveragePackageID I_InsurPlcyClaimComparisonBsc InsurPlcyCoveragePackageID
KEY InsurPlcyInsurContr I_InsurPlcyClaimComparisonBsc InsurPlcyInsurContr
KEY InsurPlcyCoverageID I_InsurPlcyClaimComparisonBsc InsurPlcyCoverageID
KEY InsurPlcyBonusMalusID I_InsurPlcyClaimComparisonBsc InsurPlcyBonusMalusID
KEY InsurPlcyClaimComparisonID I_InsurPlcyClaimComparisonBsc InsurPlcyClaimComparisonID
KEY InsurPlcyBnMlClaimSurrenderID I_InsurPlcyClaimComparisonBsc InsurPlcyBnMlClaimSurrenderID
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_InsurOpenApplClaimComparison
  as select from I_InsurPlcyClaimComparisonBsc  as ClaimComparison
    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  =  ClaimComparison.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            =  ClaimComparison.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= ClaimComparison.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  ClaimComparison.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key ClaimComparison.InsurPlcyJrnlNmbr,
  key ClaimComparison.InsurPlcyCoveragePackageID,
  key ClaimComparison.InsurPlcyInsurContr,
  key ClaimComparison.InsurPlcyCoverageID,
  key ClaimComparison.InsurPlcyBonusMalusID,
  key ClaimComparison.InsurPlcyClaimComparisonID,
  key ClaimComparison.InsurPlcyBnMlClaimSurrenderID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
  
}     
   
union

select from I_InsurPlcyClaimComparisonBsc       as ClaimComparison
    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              =  ClaimComparison.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            =  ClaimComparison.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= ClaimComparison.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  ClaimComparison.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key ClaimComparison.InsurPlcyJrnlNmbr,
  key ClaimComparison.InsurPlcyCoveragePackageID,
  key ClaimComparison.InsurPlcyInsurContr,
  key ClaimComparison.InsurPlcyCoverageID,
  key ClaimComparison.InsurPlcyBonusMalusID,
  key ClaimComparison.InsurPlcyClaimComparisonID,
  key ClaimComparison.InsurPlcyBnMlClaimSurrenderID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID
  
}

Learn More