P_InsurPlcyPremDevContract

DDL: P_INSURPLCYPREMDEVCONTRACT Type: view_entity COMPOSITE

P_InsurPlcyPremDevContract is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_InsuranceContractBasic, I_InsurPlcyRegPremConfig, R_InsurApplicationPremium) and exposes 8 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_InsuranceContractBasic Contract inner
I_InsurPlcyRegPremConfig PremiumConfig inner
R_InsurApplicationPremium RegularPremium from

Annotations (4)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID R_InsurApplicationPremium InsurPlcyUUID
KEY InsurPlcyInsurContr R_InsurApplicationPremium InsurPlcyInsurContr
InsurPlcyJrnlNmbr R_InsurApplicationPremium InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr R_InsurApplicationPremium InsurPlcyJrnlEndNmbr
InsuranceContract I_InsuranceContractBasic InsuranceContract
InsurApplLifeCycSts I_InsuranceContractBasic InsurApplLifeCycSts
InsurPlcyPremiumCurrency R_InsurApplicationPremium InsurPlcyPremiumCurrency
InsurPlcyTotAnnPremAmt R_InsurApplicationPremium InsurPlcyTotAnnPremAmt 
@VDM:           {   viewType:           #COMPOSITE,
                    private:            true}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_InsurPlcyPremDevContract
  as select from R_InsurApplicationPremium as RegularPremium
    inner join   I_InsuranceContractBasic  as Contract      on  Contract.InsurPlcyUUID        =  RegularPremium.InsurPlcyUUID
                                                            and Contract.InsurPlcyInsurContr  =  RegularPremium.InsurPlcyInsurContr
                                                            and Contract.InsurPlcyJrnlNmbr    <= RegularPremium.InsurPlcyJrnlNmbr
                                                            and Contract.InsurPlcyJrnlEndNmbr >  RegularPremium.InsurPlcyJrnlNmbr

    inner join   I_InsurPlcyRegPremConfig  as PremiumConfig on  PremiumConfig.InsurPlcyProductTemplate = Contract.InsurPlcyProductTemplate
                                                            and PremiumConfig.InsurPremType            = RegularPremium.InsurPremType

{

  key RegularPremium.InsurPlcyUUID,
  key RegularPremium.InsurPlcyInsurContr,
      RegularPremium.InsurPlcyJrnlNmbr,
      RegularPremium.InsurPlcyJrnlEndNmbr,
      Contract.InsuranceContract,
      Contract.InsurApplLifeCycSts,

      RegularPremium.InsurPlcyPremiumCurrency,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      RegularPremium.InsurPlcyTotAnnPremAmt

}
where
      RegularPremium.InsurPlcyCoveragePackageID = 0
  and RegularPremium.InsurPlcyCoverageID        = 0

Learn More