R_InsurancePolicyPremium

DDL: R_INSURANCEPOLICYPREMIUM Type: view_entity COMPOSITE
23 Fields 1 Data Sources 3 Associations

Contract Premium in Insurance Policy

R_InsurancePolicyPremium is a Composite CDS View that provides data about "Contract Premium in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurancePolicyPremiumBasic) and exposes 23 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurancePolicyPremium. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurancePolicyPremiumBasic Premium from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.InsurPlcyPremiumCurrency = _Currency.Currency
[1..1] I_InsurPremPaytRcrrcFrqcy _InsurPremPaytRcrrcFrqcy $projection.InsurPremSpecPaytRcrrcFrqcy = _InsurPremPaytRcrrcFrqcy.InsurPremSpecPaytRcrrcFrqcy
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyPremiumTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

Annotations (9)

NameValueLevelField
EndUserText.label Contract Premium in Insurance Policy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurancePolicyPremiumBasic InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurancePolicyPremiumBasic InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurancePolicyPremiumBasic InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurancePolicyPremiumBasic InsurPlcyCoverageID Coverage Key
KEY InsurancePolicyPremium I_InsurancePolicyPremiumBasic InsurancePolicyPremium Premium ID
InsurPlcyJrnlNmbr I_InsurancePolicyPremiumBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurancePolicyPremiumBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurancePolicyPremiumBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPremSpecPaytRcrrcFrqcy I_InsurancePolicyPremiumBasic InsurPremSpecPaytRcrrcFrqcy Payment Frequency
InsurPerdPremBfrTaxPaytAmt I_InsurancePolicyPremiumBasic InsurPerdPremBfrTaxPaytAmt Prem. Bef. Tax
InsurPerdPremAftTaxPaytAmt I_InsurancePolicyPremiumBasic InsurPerdPremAftTaxPaytAmt Prem. After Tax
InsurPremType I_InsurancePolicyPremiumBasic InsurPremType Premium Type
InsurPlcyCvrgIsPremiumExempt I_InsurancePolicyPremiumBasic InsurPlcyCvrgIsPremiumExempt Premium Exempt
InsurPlcyCvrgPremExmpEndDate I_InsurancePolicyPremiumBasic InsurPlcyCvrgPremExmpEndDate PremExmptEndDte
InsurPlcyPremiumCurrency I_InsurancePolicyPremiumBasic InsurPlcyPremiumCurrency Currency
InsurPlcyTotAnnPremAmt I_InsurancePolicyPremiumBasic InsurPlcyTotAnnPremAmt AnnPremAfterTax
InsurPlcyPerdPremBfrTxPaytAmt I_InsurancePolicyPremiumBasic InsurPlcyPerdPremBfrTxPaytAmt DelAPremBef.Tax
InsurPlcyMainDueDayMonth I_InsurancePolicyPremiumBasic InsurPlcyMainDueDayMonth Main Due Date
LastChangeDateTime I_InsurancePolicyPremiumBasic LastChangeDateTime Timestamp
InsurPlcyPremiumTemplate I_InsurancePolicyPremiumBasic InsurPlcyPremiumTemplate Premium Type
_Currency _Currency
_InsurPremPaytRcrrcFrqcy _InsurPremPaytRcrrcFrqcy
_InsurPlcyTemplateT _InsurPlcyTemplateT

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_InsurancePolicyPremium.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_InsurancePolicyPremium AS
SELECT
  Premium.InsurPlcyUUID AS InsurPlcyUUID,
  Premium.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Premium.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Premium.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Premium.InsurancePolicyPremium AS InsurancePolicyPremium,
  Premium.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Premium.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Premium.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Premium.InsurPremSpecPaytRcrrcFrqcy AS InsurPremSpecPaytRcrrcFrqcy,
  Premium.InsurPerdPremBfrTaxPaytAmt AS InsurPerdPremBfrTaxPaytAmt,
  Premium.InsurPerdPremAftTaxPaytAmt AS InsurPerdPremAftTaxPaytAmt,
  Premium.InsurPremType AS InsurPremType,
  Premium.InsurPlcyCvrgIsPremiumExempt AS InsurPlcyCvrgIsPremiumExempt,
  Premium.InsurPlcyCvrgPremExmpEndDate AS InsurPlcyCvrgPremExmpEndDate,
  Premium.InsurPlcyPremiumCurrency AS InsurPlcyPremiumCurrency,
  Premium.InsurPlcyTotAnnPremAmt AS InsurPlcyTotAnnPremAmt,
  Premium.InsurPlcyPerdPremBfrTxPaytAmt AS InsurPlcyPerdPremBfrTxPaytAmt,
  Premium.InsurPlcyMainDueDayMonth AS InsurPlcyMainDueDayMonth,
  Premium.LastChangeDateTime AS LastChangeDateTime,
  Premium.InsurPlcyPremiumTemplate AS InsurPlcyPremiumTemplate
FROM I_InsurancePolicyPremiumBasic AS Premium
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyPremiumCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPremPaytRcrrcFrqcy AS _InsurPremPaytRcrrcFrqcy ON InsurPremSpecPaytRcrrcFrqcy = _InsurPremPaytRcrrcFrqcy.InsurPremSpecPaytRcrrcFrqcy  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyPremiumTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
;

Learn More