I_InsurancePolicyCoverage

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 I_InsurancePolicyCoverage.
-- 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 I_InsurancePolicyCoverage AS
SELECT
  Coverage.InsurPlcyUUID AS InsurPlcyUUID,
  Coverage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Coverage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Coverage.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Coverage.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Coverage.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Coverage.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Coverage.InsurPlcyInsuranceCoverage AS InsurPlcyInsuranceCoverage,
  Coverage.InsurPlcyElementaryProdTmpl AS InsurPlcyElementaryProdTmpl,
  Coverage.InsurPlcyCoverageStartDateTime AS InsurPlcyCoverageStartDateTime,
  Coverage.InsurPlcyCoverageEndDateTime AS InsurPlcyCoverageEndDateTime,
  Coverage.InsurPlcyCvrgPremExmpReason AS InsurPlcyCvrgPremExmpReason,
  Coverage.InsurPlcyCvrgLifeCycleStatus AS InsurPlcyCvrgLifeCycleStatus,
  Coverage.InsurContrCanclnRsn AS InsurContrCanclnRsn,
  Coverage.InsurPlcyCvrgCanclnDateTime AS InsurPlcyCvrgCanclnDateTime,
  Coverage.InsurPlcyCoverageSuspension AS InsurPlcyCoverageSuspension,
  Coverage.InsurPlcyCvrgSuspnStrtDateTime AS InsurPlcyCvrgSuspnStrtDateTime,
  Coverage.InsurPlcyCvrgSuspnEndDateTime AS InsurPlcyCvrgSuspnEndDateTime,
  Coverage.InsurPlcyCvrgInsuredSumAmount AS InsurPlcyCvrgInsuredSumAmount,
  Coverage.InsurPlcyCvrgInsrdSumCalcMeth AS InsurPlcyCvrgInsrdSumCalcMeth,
  Coverage.InsurPlcyCvrgInsuredSumPercent AS InsurPlcyCvrgInsuredSumPercent,
  Coverage.InsurPlcyCoverageCurrency AS InsurPlcyCoverageCurrency,
  Coverage.InsurPlcyBonusRestorerType AS InsurPlcyBonusRestorerType,
  Coverage.InsurPlcyVehDeregistrationDate AS InsurPlcyVehDeregistrationDate,
  Coverage.InsurPlcyBonusMalusIsNotCeded AS InsurPlcyBonusMalusIsNotCeded,
  Coverage.InsurPlcyInsurEndMsgSendDate AS InsurPlcyInsurEndMsgSendDate,
  Coverage.InsurPlcySubcoverageVariant AS InsurPlcySubcoverageVariant,
  Coverage.InsurPlcyVehInsurCoverEndDate AS InsurPlcyVehInsurCoverEndDate,
  Coverage.InsurPlcyNrOfVehClaimsRestored AS InsurPlcyNrOfVehClaimsRestored,
  Coverage.InsurPlcyCrteInsurEndMessage AS InsurPlcyCrteInsurEndMessage,
  Coverage.InsurPlcyDiscProtIsActive AS InsurPlcyDiscProtIsActive,
  Coverage.LastChangeDateTime AS LastChangeDateTime,
  RegularPremium.InsurancePolicyPremium AS InsurancePolicyPremium,
  RegularPremium.InsurPlcyJrnlNmbr AS InsurPlcyPremiumJournalNumber,
  RegularPremium.InsurPlcyJrnlEndNmbr AS InsurPlcyPremJournalEndNumber,
  RegularPremium.InsurPerdPremBfrTaxPaytAmt AS InsurPerdPremBfrTaxPaytAmt,
  RegularPremium.InsurPerdPremAftTaxPaytAmt AS InsurPerdPremAftTaxPaytAmt,
  RegularPremium.InsurPremType AS InsurPremType,
  RegularPremium.InsurPlcyCvrgIsPremiumExempt AS InsurPlcyCvrgIsPremiumExempt,
  RegularPremium.InsurPlcyCvrgPremExmpEndDate AS InsurPlcyCvrgPremExmpEndDate,
  RegularPremium.InsurPlcyPremiumCurrency AS InsurPlcyPremiumCurrency,
  RegularPremium.InsurPlcyTotAnnPremAmt AS InsurPlcyTotAnnPremAmt,
  RegularPremium.InsurPlcyPerdPremBfrTxPaytAmt AS InsurPlcyPerdPremBfrTxPaytAmt,
  RegularPremium.InsurPlcyPremiumTemplate AS InsurPlcyPremiumTemplate
FROM I_InsurPlcyCoverageBasic AS Coverage
INNER JOIN R_InsurancePolicyPremium AS RegularPremium ON /* join condition not captured in parsed metadata */
INNER JOIN I_InsuranceContract AS InsuranceContractTmpl ON /* join condition not captured in parsed metadata */
INNER JOIN I_InsurPlcyRegPremConfig AS PremiumConfig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _PremiumCurrency ON InsurPlcyPremiumCurrency = _PremiumCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CoverageCurrency ON InsurPlcyCoverageCurrency = _CoverageCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurContrCanclnReason AS _InsurContrCanclnReason ON InsurContrCanclnRsn = _InsurContrCanclnReason.InsurContrCanclnRsn  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCvrgLifeCycSts AS _InsurPlcyCvrgLifeCycSts ON InsurPlcyCvrgLifeCycleStatus = _InsurPlcyCvrgLifeCycSts.InsurPlcyCvrgLifeCycleStatus  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCvrgInsrdSumCalc AS _InsurPlcyCvrgInsrdSumCalc ON InsurPlcyCvrgInsrdSumCalcMeth = _InsurPlcyCvrgInsrdSumCalc.InsurPlcyCvrgInsrdSumCalcMeth  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCvrgSuspension AS _InsurPlcyCvrgSuspension ON InsurPlcyCoverageSuspension = _InsurPlcyCvrgSuspension.InsurPlcyCoverageSuspension  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyElementaryProdTmpl = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurPlcyCvrgPremExmpRsnLink AS _InsurPlcyCvrgPremExmpRsn ON InsurPlcyCvrgPremExmpReason = _InsurPlcyCvrgPremExmpRsn.InsurPlcyCvrgPremExmpReason AND InsurPlcyElementaryProdTmpl = _InsurPlcyCvrgPremExmpRsn.InsurancePolicyCoverageControl  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCvrgSurchrgDiscount AS _InsurPlcyCvrgSurchrgDiscount ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyCvrgLimit AS _InsurancePolicyCvrgLimit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyCvrgClause AS _InsurancePolicyCvrgClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPolicyCvrgDeductible AS _InsurPolicyCvrgDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyInsuredObject AS _InsurancePolicyInsuredObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcySubCoverage AS _InsurPlcySubCoverage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCvrgTypeRegionalCl AS _InsurPlcyCvrgTypeRegionalCl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCvrgPremComparison AS _InsurPlcyCvrgPremComparison ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurCvrgPlannedProcessing AS _InsurCvrgPlndProcessing ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyCoverageBonusMalus AS _InsurPlcyCoverageBonusMalus ON /* condition not available in parsed metadata */  -- association [0..*]
;