P_InsurPlcyPremDevPremChg

DDL: P_INSURPLCYPREMDEVPREMCHG Type: view_entity COMPOSITE

P_InsurPlcyPremDevPremChg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_InsurancePolicyPremiumBasic) and exposes 5 fields with key fields InsurPlcyUUID, InsurPlcyChgEffctvDte.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurancePolicyPremiumBasic Premium from

Annotations (4)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID ContrJrnl InsurPlcyUUID
KEY InsurPlcyChgEffctvDte ContrJrnl InsurPlcyChgEffctvDte
InsurPlcyInsurContr I_InsurancePolicyPremiumBasic InsurPlcyInsurContr
InsurPlcyPremiumCurrency I_InsurancePolicyPremiumBasic InsurPlcyPremiumCurrency
InsurPlcyTotAnnPremAmt I_InsurancePolicyPremiumBasic InsurPlcyTotAnnPremAmt 
@VDM:           {   viewType:           #COMPOSITE,
                    private:            true}
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

// Get all relevant Premium change date - for the complete policy


define view entity P_InsurPlcyPremDevPremChg
  as select from            I_InsurancePolicyPremiumBasic as Premium

    left outer to many join I_InsurPlcyJournalEntryBasic   as ContrJrnl on  ContrJrnl.InsurPlcyUUID       = Premium.InsurPlcyUUID
                                                                        and ContrJrnl.InsurPlcyInsurContr = Premium.InsurPlcyInsurContr
                                                                        and ContrJrnl.InsurPlcyJrnlNmbr   = Premium.InsurPlcyJrnlNmbr

{

  key ContrJrnl.InsurPlcyUUID,
  key ContrJrnl.InsurPlcyChgEffctvDte,
      Premium.InsurPlcyInsurContr,
      Premium.InsurPlcyPremiumCurrency,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      Premium.InsurPlcyTotAnnPremAmt

}
where
      Premium.InsurPlcyCoveragePackageID = 0
  and Premium.InsurPlcyCoverageID        = 0
group by
  ContrJrnl.InsurPlcyUUID,
  ContrJrnl.InsurPlcyChgEffctvDte,
  Premium.InsurPlcyInsurContr,
  Premium.InsurPlcyPremiumCurrency,
  Premium.InsurPlcyTotAnnPremAmt
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCEPOLICYPREMIUMBASIC",
"I_INSURPLCYJOURNALENTRYBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More