P_InsurOpenApplClause

DDL: P_INSUROPENAPPLCLAUSE Type: view_entity COMPOSITE Package: VDM_PM_PLCY_OPEN_APPL_BASIC

Insurance Open Application Clause

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

4 data source(s) 21 fields

Data Sources (4)

SourceAliasJoin Type
I_InsurPlcyClauseBasic Clause from
I_InsurPlcyClauseBasic Clause union
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner
P_InsuranceOpenApplicationJrnl OpenApplJrnl inner

Annotations (4)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsuranceOpenApplicationJrnl InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyClauseBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPlcyClauseBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyClauseBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyClauseBasic InsurPlcyCoverageID
KEY InsurPlcySubCvrgID I_InsurPlcyClauseBasic InsurPlcySubCvrgID
KEY InsurPlcyInsuredObjectID I_InsurPlcyClauseBasic InsurPlcyInsuredObjectID
KEY InsurPlcyClauseID I_InsurPlcyClauseBasic InsurPlcyClauseID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyApplUUID
KEY InsuranceApplication P_InsuranceOpenApplicationJrnl InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyClauseBasic InsurPlcyJrnlNmbr
KEY InsurPlcyInsurContr I_InsurPlcyClauseBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyClauseBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyClauseBasic InsurPlcyCoverageID
KEY InsurPlcySubCvrgID I_InsurPlcyClauseBasic InsurPlcySubCvrgID
KEY InsurPlcyInsuredObjectID I_InsurPlcyClauseBasic InsurPlcyInsuredObjectID
KEY InsurPlcyClauseID I_InsurPlcyClauseBasic InsurPlcyClauseID
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsuranceOpenApplicationJrnl InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyUUID P_InsuranceOpenApplicationJrnl InsurPlcyUUID 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM:{ viewType: #COMPOSITE,
       private: true
}
define view entity P_InsurOpenApplClause
  as select from I_InsurPlcyClauseBasic         as Clause

    inner join   P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  =  Clause.InsurPlcyUUID
                                                                and OpenApplJrnl.InsurPlcyInsurContr            =  Clause.InsurPlcyInsurContr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Clause.InsurPlcyJrnlNmbr
                                                                and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Clause.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Clause.InsurPlcyJrnlNmbr,
  key Clause.InsurPlcyInsurContr,
  key Clause.InsurPlcyCoveragePackageID,
  key Clause.InsurPlcyCoverageID,
  key Clause.InsurPlcySubCvrgID,
  key Clause.InsurPlcyInsuredObjectID,
  key Clause.InsurPlcyClauseID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID

}

union

select from  I_InsurPlcyClauseBasic         as Clause
  inner join P_InsuranceOpenApplicationJrnl as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              =  Clause.InsurPlcyUUID
                                                            and OpenApplJrnl.InsurPlcyInsurContr            =  Clause.InsurPlcyInsurContr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Clause.InsurPlcyJrnlNmbr
                                                            and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Clause.InsurPlcyJrnlEndNmbr
{
  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Clause.InsurPlcyJrnlNmbr,
  key Clause.InsurPlcyInsurContr,
  key Clause.InsurPlcyCoveragePackageID,
  key Clause.InsurPlcyCoverageID,
  key Clause.InsurPlcySubCvrgID,
  key Clause.InsurPlcyInsuredObjectID,
  key Clause.InsurPlcyClauseID,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID

}

Learn More