R_InsurApplicationPremium

DDL: R_INSURAPPLICATIONPREMIUM Type: view_entity COMPOSITE
24 Fields 2 Data Sources 3 Associations

Premium in Insurance Application

R_InsurApplicationPremium is a Composite CDS View that provides data about "Premium in Insurance Application" in SAP S/4HANA. It reads from 2 data sources (P_InsurPolicyJournalKeys, I_InsurancePolicyPremiumBasic) and exposes 24 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurancePolicyPremium. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_InsurPolicyJournalKeys PlcyJrnl from
I_InsurancePolicyPremiumBasic Premium inner

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 Premium in Insurance Application 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 (24)

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
KEY InsurPlcyContrDataDetnJrnlNmbr
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_InsurApplicationPremium.
-- 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_InsurApplicationPremium AS
SELECT
  Premium.InsurPlcyUUID AS InsurPlcyUUID,
  Premium.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Premium.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Premium.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Premium.InsurancePolicyPremium AS InsurancePolicyPremium,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  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 P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurancePolicyPremiumBasic AS Premium ON /* join condition not captured in parsed metadata */
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