P_InsuranceOpenApplication

DDL: P_INSURANCEOPENAPPLICATION Type: view_entity COMPOSITE Package: VDM_PM_PLCY_OPEN_APPL_BASIC

Insurance Open Application

P_InsuranceOpenApplication is a Composite CDS View that provides data about "Insurance Open Application" in SAP S/4HANA. It reads from 4 data sources (P_InsOpApPlcyLvlDetnJrnlGrp, P_InsOpApPlcyLvlDetnJrnlGrp, I_InsurPlcyBasic, I_InsurPlcyBasic) and exposes 27 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyJrnlNmbr, InsurPlcyContrDataDetnJrnlNmbr, InsuranceApplication. Part of development package VDM_PM_PLCY_OPEN_APPL_BASIC.

4 data source(s) 27 fields

Data Sources (4)

SourceAliasJoin Type
P_InsOpApPlcyLvlDetnJrnlGrp OpenApplJrnl inner
P_InsOpApPlcyLvlDetnJrnlGrp OpenApplJrnl inner
I_InsurPlcyBasic Policy from
I_InsurPlcyBasic Policy union

Annotations (4)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyApplUUID
KEY InsuranceApplication P_InsOpApPlcyLvlDetnJrnlGrp InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyBasic InsurPlcyJrnlNmbr
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyUUID P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyUUID
InsuranceApplicationStatus P_InsOpApPlcyLvlDetnJrnlGrp InsuranceApplicationStatus
InsurPlcyBusProcType P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyBusProcType
InsurPlcyBusProcessNumerator P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyBusProcessNumerator
InsurApplRcptDte P_InsOpApPlcyLvlDetnJrnlGrp InsurApplRcptDte
InsurApplSgntrDte P_InsOpApPlcyLvlDetnJrnlGrp InsurApplSgntrDte
InsurPlcyBusProcEffectiveDate P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyBusProcEffectiveDate
InsurApplChgRsn P_InsOpApPlcyLvlDetnJrnlGrp InsurApplChgRsn
InsurApplChgRsnText P_InsOpApPlcyLvlDetnJrnlGrp InsurApplChgRsnText
InsurPlcyApplUUID
KEY InsuranceApplication P_InsOpApPlcyLvlDetnJrnlGrp InsuranceApplication
KEY InsurPlcyJrnlNmbr I_InsurPlcyBasic InsurPlcyJrnlNmbr
KEY InsurPlcyContrDataDetnJrnlNmbr P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyUUID P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyUUID
InsuranceApplicationStatus P_InsOpApPlcyLvlDetnJrnlGrp InsuranceApplicationStatus
InsurPlcyBusProcType P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyBusProcType
InsurPlcyBusProcessNumerator P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyBusProcessNumerator
InsurApplRcptDte P_InsOpApPlcyLvlDetnJrnlGrp InsurApplRcptDte
InsurApplSgntrDte P_InsOpApPlcyLvlDetnJrnlGrp InsurApplSgntrDte
InsurPlcyBusProcEffectiveDate P_InsOpApPlcyLvlDetnJrnlGrp InsurPlcyBusProcEffectiveDate
InsurApplChgRsn P_InsOpApPlcyLvlDetnJrnlGrp InsurApplChgRsn
InsurApplChgRsnText P_InsOpApPlcyLvlDetnJrnlGrp InsurApplChgRsnText
CreatedByUser P_InsOpApPlcyLvlDetnJrnlGrp CreatedByUser 
@VDM:           {   viewType:           #COMPOSITE,
                    private:            true}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

// Get data for appl GUID and policy GUID


define view entity P_InsuranceOpenApplication
  as select from I_InsurPlcyBasic            as Policy

    inner join   P_InsOpApPlcyLvlDetnJrnlGrp as OpenApplJrnl on  OpenApplJrnl.InsurPlcyApplUUID              =  Policy.InsurPlcyUUID
                                                             and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Policy.InsurPlcyJrnlNmbr
                                                             and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Policy.InsurPlcyJrnlEndNmbr

{

  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Policy.InsurPlcyJrnlNmbr,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID,
      OpenApplJrnl.InsuranceApplicationStatus,
      OpenApplJrnl.InsurPlcyBusProcType,
      OpenApplJrnl.InsurPlcyBusProcessNumerator,
      OpenApplJrnl.InsurApplRcptDte,
      OpenApplJrnl.InsurApplSgntrDte,
      OpenApplJrnl.InsurPlcyBusProcEffectiveDate,
      OpenApplJrnl.InsurApplChgRsn,
      OpenApplJrnl.InsurApplChgRsnText,
      OpenApplJrnl.CreatedByUser

}

union

select from  I_InsurPlcyBasic            as Policy

  inner join P_InsOpApPlcyLvlDetnJrnlGrp as OpenApplJrnl on  OpenApplJrnl.InsurPlcyUUID                  =  Policy.InsurPlcyUUID
                                                         and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr >= Policy.InsurPlcyJrnlNmbr
                                                         and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr <  Policy.InsurPlcyJrnlEndNmbr

{


  key OpenApplJrnl.InsurPlcyApplUUID,
  key OpenApplJrnl.InsuranceApplication,
  key Policy.InsurPlcyJrnlNmbr,
  key OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr,
      OpenApplJrnl.InsurPlcyUUID,
      OpenApplJrnl.InsuranceApplicationStatus,
      OpenApplJrnl.InsurPlcyBusProcType,
      OpenApplJrnl.InsurPlcyBusProcessNumerator,
      OpenApplJrnl.InsurApplRcptDte,
      OpenApplJrnl.InsurApplSgntrDte,
      OpenApplJrnl.InsurPlcyBusProcEffectiveDate,
      OpenApplJrnl.InsurApplChgRsn,
      OpenApplJrnl.InsurApplChgRsnText,
      OpenApplJrnl.CreatedByUser

}

Learn More