I_InsurApplContrCoverage

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_InsurApplContrCoverage.
-- 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_InsurApplContrCoverage AS
SELECT
  Coverage.InsurPlcyUUID AS InsurPlcyUUID,
  Coverage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Coverage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Coverage.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  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 P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyCoverageBasic AS Coverage ON /* join condition not captured in parsed metadata */
INNER JOIN I_InsurApplContract AS InsurApplContractTmpl ON /* join condition not captured in parsed metadata */
INNER JOIN R_InsurApplicationPremium AS RegularPremium 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_InsurApplContrCvrgLimit AS _InsurApplContrCvrgLimit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgClause AS _InsurApplContrCvrgClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgDeductible AS _InsurApplContrCvrgDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgInsrdObj AS _InsurApplContrCvrgInsrdObj ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgSurcharge AS _InsurApplContrCvrgSurcharge ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgSubCvrg AS _InsurApplContrCvrgSubCvrg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgTypeRgnlCl AS _InsurApplContrCvrgTypeRgnlCl ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_InsurApplContrCvrgPremComprn AS _InsurApplContrCvrgPremComprn ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_InsurApplContrCvrgBonusMalus AS _InsurApplContrCvrgBonusMalus ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurApplContrCvrgBnfcy AS _InsurApplContrCvrgBeneficiary ON /* condition not available in parsed metadata */  -- association [0..*]
;