I_InsurOpenApplCoverage

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_InsurOpenApplCoverage.
-- 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_InsurOpenApplCoverage AS
SELECT
  OpenApplJrnl.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  cast( OpenApplJrnl.InsuranceApplication as /pm0/vdm_applicationnr_tt preserving type ) AS InsuranceApplication,
  Coverage.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Coverage.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Coverage.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  cast( OpenApplJrnl.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,
  OpenApplJrnl.InsurPlcyUUID AS InsurPlcyUUID,
  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 I_InsurOpenApplContract AS InsurApplContractTmpl ON /* join condition not captured in parsed metadata */
INNER JOIN R_InsurOpenApplicationPremium 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_InsOpApCvrgSurchrgDiscount AS _InsurOpenApplCvrgSurchrgDisc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurOpenApplCoverageLimit AS _InsurOpenApplCvrgLimit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurOpenApplCoverageClause AS _InsurOpenApplCvrgClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurOpenApplCvrgDeductible AS _InsurOpenApplCvrgDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurOpenApplInsuredObject AS _InsurOpenApplInsuredObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurOpenApplSubCoverage AS _InsurOpenApplSubCoverage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsOpApCvrgTypeRegionalCl AS _InsurOpenApplTypeRgnlCl ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsOpApCvrgPremComparison AS _InsurOpenApplCvrgPremComprn ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_InsOpApCoverageBonusMalus AS _InsurOpenApplCvrgBonusMalus ON /* condition not available in parsed metadata */  -- association [0..*]
;