R_InsurancePolicyPremiumTP

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_InsurancePolicyPremiumTP.
-- 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_InsurancePolicyPremiumTP AS
SELECT
  _Premium.InsurPlcyUUID AS InsurPlcyUUID,
  _Premium.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  _Premium.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  _Premium.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  _Premium.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  _Premium.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  _Premium.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  _Premium.InsurancePolicyPremium AS InsurancePolicyPremium,
  cast('00000' as /pm0/abd_benefit_id ) AS InsurPlcyBenefitID,
  cast('00000' as /pm0/abd_bnfcalc_id ) AS InsurPlcyBnftDetnID,
  _Premium.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  _Premium.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  _Premium.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  _Premium.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  _Premium.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  _Premium.InsurPlcyCoverageOptionID AS InsurPlcyCvrgOptnIDForEdit,
  _Premium.InsurPlcyInsuredObjectID AS InsurPlcyInsrdObjIDForEdit,
  _Premium.InsurancePolicyPremium AS InsurancePolicyPremiumForEdit,
  _Premium.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  _Premium.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  _Premium.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  _Premium.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  _Premium.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  _Premium.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  _Premium.InsurPlcyPremIsCanceled AS InsurPlcyPremIsCanceled,
  _Premium.InsurPlcyPremIntCrrtdAmount AS InsurPlcyPremIntCrrtdAmount,
  _Premium.InsurPlcyPremLineOfBusiness AS InsurPlcyPremLineOfBusiness,
  _Premium.InsurPremSpecPaytRcrrcFrqcy AS InsurPremSpecPaytRcrrcFrqcy,
  _Premium.InsurPerdPremBfrTaxPaytAmt AS InsurPerdPremBfrTaxPaytAmt,
  _Premium.InsurPerdPremAftTaxPaytAmt AS InsurPerdPremAftTaxPaytAmt,
  _Premium.InsurPremType AS InsurPremType,
  _Premium.InsurPlcyPremTrifPerUnitSumAmt AS InsurPlcyPremTrifPerUnitSumAmt,
  _Premium.InsurPlcyPremTotTrifPremAmount AS InsurPlcyPremTotTrifPremAmount,
  _Premium.InsurPlcyPremDvdndClrgAmount AS InsurPlcyPremDvdndClrgAmount,
  _Premium.InsPlcyPremPrptnlDvdndClrgAmt AS InsPlcyPremPrptnlDvdndClrgAmt,
  _Premium.InsurPlcyPremGrssPremBfrTxAmt AS InsurPlcyPremGrssPremBfrTxAmt,
  _Premium.InsurPlcyPremTrifPremPrptnlAmt AS InsurPlcyPremTrifPremPrptnlAmt,
  _Premium.InsurPlcyPremTotDiscountAmount AS InsurPlcyPremTotDiscountAmount,
  _Premium.InsurPlcyPremEntirePaytTotAmt AS InsurPlcyPremEntirePaytTotAmt,
  _Premium.InsurPlcyPremStartDate AS InsurPlcyPremStartDate,
  _Premium.InsurPlcyPremDiscAmount AS InsurPlcyPremDiscAmount,
  _Premium.InsurPlcyPremPaytPeriodEndDate AS InsurPlcyPremPaytPeriodEndDate,
  _Premium.InsurPlcyPremRndngCrrtnAmount AS InsurPlcyPremRndngCrrtnAmount,
  _Premium.InsPlcyPremInstlmntSuplmntAmt AS InsPlcyPremInstlmntSuplmntAmt,
  _Premium.InsPlcyPremMedlRskSurchrgAmt AS InsPlcyPremMedlRskSurchrgAmt,
  _Premium.InsurPlcyPremOthRskSurchrgAmt AS InsurPlcyPremOthRskSurchrgAmt,
  _Premium.InsurPlcyPremSftySurchrgAmount AS InsurPlcyPremSftySurchrgAmount,
  _Premium.InsurPlcyPremUnitCostAmount AS InsurPlcyPremUnitCostAmount,
  _Premium.InsurPlcyCvrgIsPremiumExempt AS InsurPlcyCvrgIsPremiumExempt,
  _Premium.InsurPlcyCvrgPremExmpEndDate AS InsurPlcyCvrgPremExmpEndDate,
  _Premium.InsurPlcyPremBfrTaxEnteredAmt AS InsurPlcyPremBfrTaxEnteredAmt,
  _Premium.InsurPlcyPremSumInsuredRate AS InsurPlcyPremSumInsuredRate,
  _Premium.InsurPlcyPremiumCurrency AS InsurPlcyPremiumCurrency,
  _Premium.InsurPlcyPremRateUntForMnlRatg AS InsurPlcyPremRateUntForMnlRatg,
  _Premium.InsurPlcyPremIsManualRating AS InsurPlcyPremIsManualRating,
  _Premium.InsurPlcyPremTrifPremAmount AS InsurPlcyPremTrifPremAmount,
  _Premium.InsurPlcyTotAnnPremAmt AS InsurPlcyTotAnnPremAmt,
  _Premium.InsurPlcyPerdPremBfrTxPaytAmt AS InsurPlcyPerdPremBfrTxPaytAmt,
  _Premium.InsurPlcyPremAnnGrssPremAmount AS InsurPlcyPremAnnGrssPremAmount,
  _Premium.InsurPlcyPremNetYrlyPremAmount AS InsurPlcyPremNetYrlyPremAmount,
  _Premium.InsurPlcyPremCumltvTaxChrgsAmt AS InsurPlcyPremCumltvTaxChrgsAmt,
  _Premium.InsurPlcyPremFinalAgeVal AS InsurPlcyPremFinalAgeVal,
  _Premium.InsurPlcyPremInitPremAmount AS InsurPlcyPremInitPremAmount,
  _Premium.InsurPlcyPremYrlyPremAmount AS InsurPlcyPremYrlyPremAmount,
  _Premium.InsurPlcyPremDiffDvdndClrgAmt AS InsurPlcyPremDiffDvdndClrgAmt,
  _Premium.InsurPlcyPremDiffGrssPremAmt AS InsurPlcyPremDiffGrssPremAmt,
  _Premium.InsurPlcyPremIntPaymentMethod AS InsurPlcyPremIntPaymentMethod,
  _Premium.InsurPlcyPremToBeTaxedAmount AS InsurPlcyPremToBeTaxedAmount,
  _Premium.InsurPlcyPremSuDscYearlyAmount AS InsurPlcyPremSuDscYearlyAmount,
  _Premium.InsurPlcyPremSuDscTotAmount AS InsurPlcyPremSuDscTotAmount,
  _Premium.InsurPlcyPremRatePrvsnlRptdPct AS InsurPlcyPremRatePrvsnlRptdPct,
  _Premium.InsPlcyPremAftTaxPrvsnlRptdAmt AS InsPlcyPremAftTaxPrvsnlRptdAmt,
  _Premium.InsurPlcyPremMappgInfo AS InsurPlcyPremMappgInfo,
  _Premium.InsurPlcyPremCollectionType AS InsurPlcyPremCollectionType,
  _Premium.InsurPlcyPremWvrAnnulmentRsn AS InsurPlcyPremWvrAnnulmentRsn,
  _Premium.InsurPlcyPremNonMedlSuDscAmt AS InsurPlcyPremNonMedlSuDscAmt,
  _Premium.InsurPlcyPremPaytFrqcyStrtDate AS InsurPlcyPremPaytFrqcyStrtDate,
  _Premium.InsurPlcyMainDueDayMonth AS InsurPlcyMainDueDayMonth,
  _Premium.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _Premium.LastChangeDateTime AS LastChangeDateTime,
  _Premium.InsurPlcyPremiumTemplate AS InsurPlcyPremiumTemplate,
  _Premium._Currency AS _Currency
FROM I_InsurPlcyPremiumVersion AS _Premium
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN E_InsurancePolicyPremium AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurancePolicyPremium = _Extension.InsurancePolicyPremium AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyAddlPaytPayerTP_2 AS _AdditionalPremiumPayer ON InsurPlcyUUIDForEdit = _AdditionalPremiumPayer.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _AdditionalPremiumPayer.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _AdditionalPremiumPayer.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _AdditionalPremiumPayer.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _AdditionalPremiumPayer.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _AdditionalPremiumPayer.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _AdditionalPremiumPayer.InsurPlcyInsuredObjectID AND InsurancePolicyPremiumForEdit = _AdditionalPremiumPayer.InsurancePolicyPremium  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyLifePremiumTP AS _LifePremium ON InsurPlcyUUIDForEdit = _LifePremium.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _LifePremium.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _LifePremium.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _LifePremium.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _LifePremium.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _LifePremium.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsrdObjIDForEdit = _LifePremium.InsurPlcyInsrdObjIDForEdit AND InsurancePolicyPremiumForEdit = _LifePremium.InsurancePolicyPremiumForEdit  -- association [0..1]
LEFT OUTER JOIN R_InsurancePolicyPremiumTaxTP AS _PremiumTax ON InsurPlcyUUIDForEdit = _PremiumTax.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _PremiumTax.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _PremiumTax.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _PremiumTax.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _PremiumTax.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _PremiumTax.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _PremiumTax.InsurPlcyInsuredObjectID AND InsurancePolicyPremiumForEdit = _PremiumTax.InsurancePolicyPremium  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyFundAssignmentTP_2 AS _FundAssignment ON InsurPlcyUUIDForEdit = _FundAssignment.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _FundAssignment.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _FundAssignment.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _FundAssignment.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _FundAssignment.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _FundAssignment.InsurPlcyCoverageOptionID AND InsurPlcyInsrdObjIDForEdit = _FundAssignment.InsurPlcyInsuredObjectID AND InsurancePolicyPremiumForEdit = _FundAssignment.InsurancePolicyPremium AND InsurPlcyBenefitID = _FundAssignment.InsurPlcyBenefitID AND InsurPlcyBnftDetnID = _FundAssignment.InsurPlcyBnftDetnID  -- association [0..*]
;