R_InsurancePolicyCoverageTP_2

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_InsurancePolicyCoverageTP_2.
-- 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_InsurancePolicyCoverageTP_2 AS
SELECT *  -- field list not available in parsed metadata
FROM I_InsurPlcyBsCoverageVersion AS Coverage
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InsurancePolicyCoverage AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcySubcoverageTP_3 AS _Subcoverage ON InsurPlcyUUIDForEdit = _Subcoverage.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Subcoverage.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Subcoverage.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Subcoverage.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Subcoverage.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyAcctBalShtValTP AS _AccBalanceSheetValues ON InsurPlcyUUIDForEdit = _AccBalanceSheetValues.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _AccBalanceSheetValues.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _AccBalanceSheetValues.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _AccBalanceSheetValues.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _AccBalanceSheetValues.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _AccBalanceSheetValues.InsurPlcyCoverageOptionID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyAdjustmentTP AS _Adjustment ON InsurPlcyUUIDForEdit = _Adjustment.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Adjustment.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Adjustment.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Adjustment.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Adjustment.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Adjustment.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Adjustment.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyAssessmentBasisTP AS _AssessmentBasis ON InsurPlcyUUIDForEdit = _AssessmentBasis.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _AssessmentBasis.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _AssessmentBasis.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _AssessmentBasis.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _AssessmentBasis.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _AssessmentBasis.InsurPlcyCoverageOptionID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyBeneficiaryTP AS _Beneficiary ON InsurPlcyUUIDForEdit = _Beneficiary.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Beneficiary.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Beneficiary.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Beneficiary.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Beneficiary.InsurPlcyCoverageID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyBenefitTP AS _Benefit ON InsurPlcyUUIDForEdit = _Benefit.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Benefit.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Benefit.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Benefit.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Benefit.InsurPlcyCoverageIDForEdit AND InsurPlcyCoverageOptionID = _Benefit.InsurPlcyCvrgOptnIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyBnftDeterminationTP AS _BnftDetn ON InsurPlcyUUIDForEdit = _BnftDetn.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _BnftDetn.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _BnftDetn.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _BnftDetn.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _BnftDetn.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyChargeTP AS _Charge ON InsurPlcyUUIDForEdit = _Charge.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Charge.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Charge.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Charge.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Charge.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyChargePayerTP_2 AS _ChargePayer ON InsurPlcyUUIDForEdit = _ChargePayer.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ChargePayer.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ChargePayer.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ChargePayer.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ChargePayer.InsurPlcyCoverageID AND InsurPlcyChrgsChargeID = _ChargePayer.InsurPlcyChrgsChargeID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyClauseTP_3 AS _Clause ON InsurPlcyUUIDForEdit = _Clause.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Clause.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Clause.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Clause.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Clause.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Clause.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Clause.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Clause.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Clause.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyCreditorTP AS _Creditor ON InsurPlcyUUIDForEdit = _Creditor.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Creditor.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Creditor.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Creditor.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Creditor.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Creditor.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Creditor.InsurPlcyInsuredObjectID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyDateTP AS _Date ON InsurPlcyUUIDForEdit = _Date.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Date.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Date.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Date.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Date.InsurPlcyCoverageID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDeductibleTP_2 AS _Deductible ON InsurPlcyUUIDForEdit = _Deductible.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Deductible.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Deductible.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Deductible.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Deductible.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _Deductible.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Deductible.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Deductible.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Deductible.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyDistrPlnRelshpTP_3 AS _DistributionPlan ON InsurPlcyUUIDForEdit = _DistributionPlan.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _DistributionPlan.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _DistributionPlan.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _DistributionPlan.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _DistributionPlan.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyExtRefTP_2 AS _ExternalReference ON InsurPlcyUUIDForEdit = _ExternalReference.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ExternalReference.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ExternalReference.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ExternalReference.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ExternalReference.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _ExternalReference.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _ExternalReference.InsurPlcyInsuredObjectID  -- 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 InsurPlcyCoverageOptionID = _FundAssignment.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _FundAssignment.InsurPlcyInsuredObjectID AND InsurancePolicyPremium = _FundAssignment.InsurancePolicyPremium AND InsurPlcyBenefitID = _FundAssignment.InsurPlcyBenefitID AND InsurPlcyBnftDetnID = _FundAssignment.InsurPlcyBnftDetnID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyGuaranteeValueTP AS _GuaranteeValue ON InsurPlcyUUIDForEdit = _GuaranteeValue.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _GuaranteeValue.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _GuaranteeValue.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _GuaranteeValue.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _GuaranteeValue.InsurPlcyCoverageID  -- association [0..*]
LEFT OUTER JOIN R_InsurPolicyInsuredObjectTP_2 AS _InsuredObject ON InsurPlcyUUIDForEdit = _InsuredObject.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _InsuredObject.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _InsuredObject.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _InsuredObject.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _InsuredObject.InsurPlcyCoverageIDForEdit AND InsurPlcyCoverageOptionID = _InsuredObject.InsurPlcyCvrgOptnIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyLimitTP_2 AS _Limit ON InsurPlcyUUIDForEdit = _Limit.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Limit.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Limit.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Limit.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Limit.InsurPlcyCoverageID AND InsurPlcySubCvrgID = _Limit.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyManualCostPostingTP AS _ManualCostPosting ON InsurPlcyUUIDForEdit = _ManualCostPosting.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _ManualCostPosting.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _ManualCostPosting.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _ManualCostPosting.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _ManualCostPosting.InsurPlcyCoverageID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyMnlSettlmtAmountTP AS _ManualSettlementAmount ON InsurPlcyUUIDForEdit = _ManualSettlementAmount.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _ManualSettlementAmount.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _ManualSettlementAmount.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _ManualSettlementAmount.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _ManualSettlementAmount.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyModelCalculationTP AS _ModelCalculation ON InsurPlcyUUIDForEdit = _ModelCalculation.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _ModelCalculation.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _ModelCalculation.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _ModelCalculation.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _ModelCalculation.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyPremiumTP AS _Premium ON InsurPlcyUUIDForEdit = _Premium.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Premium.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Premium.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Premium.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Premium.InsurPlcyCoverageIDForEdit AND InsurPlcyCoverageOptionID = _Premium.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsuredObjectID = _Premium.InsurPlcyInsrdObjIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyReltdContractTP_2 AS _RelatedContract ON InsurPlcyUUIDForEdit = _RelatedContract.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _RelatedContract.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _RelatedContract.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _RelatedContract.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _RelatedContract.InsurPlcyCoverageIDForEdit AND InsurPlcyCoverageOptionID = _RelatedContract.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsuredObjectID = _RelatedContract.InsurPlcyInsrdObjIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyQuestionTP_2 AS _RiskAssessmentQuestion ON InsurPlcyUUIDForEdit = _RiskAssessmentQuestion.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _RiskAssessmentQuestion.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _RiskAssessmentQuestion.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _RiskAssessmentQuestion.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _RiskAssessmentQuestion.InsurPlcyCoverageIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcySurchrgDiscTP_2 AS _SurchargeDiscount ON InsurPlcyUUIDForEdit = _SurchargeDiscount.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _SurchargeDiscount.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _SurchargeDiscount.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _SurchargeDiscount.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _SurchargeDiscount.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _SurchargeDiscount.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _SurchargeDiscount.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _SurchargeDiscount.InsurPlcyUndrwrtgDcsnRiskID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyTaxJournalTP AS _TaxJournal ON InsurPlcyUUIDForEdit = _TaxJournal.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _TaxJournal.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _TaxJournal.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _TaxJournal.InsurPlcyCoveragePackageID  -- association [0..*]
;