R_InsurOpenApplicationPremium

DDL: R_INSUROPENAPPLICATIONPREMIUM Type: view_entity COMPOSITE
25 Fields 1 Data Sources 3 Associations

Premium in Insur Open Application

R_InsurOpenApplicationPremium is a Composite CDS View that provides data about "Premium in Insur Open Application" in SAP S/4HANA. It reads from 1 data source (I_InsurancePolicyPremiumBasic) and exposes 25 fields with key fields InsurPlcyApplUUID, 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 Premium in Insur Open 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 #XL view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID OpenApplJrnl InsurPlcyApplUUID 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.
InsurPlcyUUID I_InsurancePolicyPremiumBasic InsurPlcyUUID Policy UUID
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_InsurOpenApplicationPremium.
-- 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_InsurOpenApplicationPremium AS
SELECT
  OpenApplJrnl.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Premium.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Premium.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Premium.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Premium.InsurancePolicyPremium AS InsurancePolicyPremium,
  cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  Premium.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Premium.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Premium.InsurPlcyUUID AS InsurPlcyUUID,
  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