I_InsuranceContract

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_InsuranceContract.
-- 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_InsuranceContract AS
SELECT
  Contract.InsurPlcyUUID AS InsurPlcyUUID,
  Contract.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Contract.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Contract.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Contract.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Contract.InsuranceContract AS InsuranceContract,
  Contract.InsurPlcyProductTemplate AS InsurPlcyProductTemplate,
  Contract.InsurPlcyLineOfBusiness AS InsurPlcyLineOfBusiness,
  Contract.InsurPlcyContractStartDateTime AS InsurPlcyContractStartDateTime,
  Contract.InsurPlcyContractEndDateTime AS InsurPlcyContractEndDateTime,
  Contract.InsrrIDByInsrr AS InsrrIDByInsrr,
  Contract.InsurContrLifeCycSts AS InsurContrLifeCycSts,
  Contract.InsurContrTrifVar AS InsurContrTrifVar,
  Contract.InsurCollDisbmtInsurObj AS InsurCollDisbmtInsurObj,
  Contract.InsurContrRnwlType AS InsurContrRnwlType,
  Contract.InsurContrCanclnRsn AS InsurContrCanclnRsn,
  Contract.InsurPlcyContrCanclnDateTime AS InsurPlcyContrCanclnDateTime,
  Contract.InsurApplRjcnRsn AS InsurApplRjcnRsn,
  Contract.InsurApplLifeCycSts AS InsurApplLifeCycSts,
  Contract.InsurPlcyContrStartIsDayOfRegn AS InsurPlcyContrStartIsDayOfRegn,
  Contract.InsurPlcyDiscountProtection AS InsurPlcyDiscountProtection,
  Contract.LastChangeDateTime AS LastChangeDateTime,
  Contract.InsurPlcyCountry AS InsurPlcyCountry,
  RegularPremium.InsurancePolicyPremium AS InsurancePolicyPremium,
  RegularPremium.InsurPlcyJrnlNmbr AS InsurPlcyPremiumJournalNumber,
  RegularPremium.InsurPlcyJrnlEndNmbr AS InsurPlcyPremJournalEndNumber,
  RegularPremium.InsurPremSpecPaytRcrrcFrqcy AS InsurPremSpecPaytRcrrcFrqcy,
  RegularPremium.InsurPerdPremBfrTaxPaytAmt AS InsurPerdPremBfrTaxPaytAmt,
  RegularPremium.InsurPerdPremAftTaxPaytAmt AS InsurPerdPremAftTaxPaytAmt,
  RegularPremium.InsurPremType AS InsurPremType,
  RegularPremium.InsurPlcyCvrgIsPremiumExempt AS InsurContrIsPremExempt,
  RegularPremium.InsurPlcyCvrgPremExmpEndDate AS InsurContrPremExmpEndDte,
  RegularPremium.InsurPlcyPremiumCurrency AS InsurPlcyPremiumCurrency,
  RegularPremium.InsurPlcyTotAnnPremAmt AS InsurPlcyTotAnnPremAmt,
  RegularPremium.InsurPlcyPerdPremBfrTxPaytAmt AS InsurPlcyPerdPremBfrTxPaytAmt,
  RegularPremium.InsurPlcyMainDueDayMonth AS InsurPlcyMainDueDayMonth,
  RegularPremium.InsurPlcyPremiumTemplate AS InsurPlcyPremiumTemplate
FROM I_InsuranceContractBasic AS Contract
INNER JOIN R_InsurancePolicyPremium 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 _Currency ON InsurPlcyPremiumCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyInsurer AS _InsurPlcyInsurer ON InsrrIDByInsrr = _InsurPlcyInsurer.InsrrIDByInsrr  -- association [1..1]
LEFT OUTER JOIN I_InsurContrCanclnReason AS _InsurContrCanclnReason ON InsurContrCanclnRsn = _InsurContrCanclnReason.InsurContrCanclnRsn  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyLineOfBusiness AS _InsurPlcyLineOfBusiness ON InsurPlcyLineOfBusiness = _InsurPlcyLineOfBusiness.InsurPlcyLineOfBusiness  -- association [1..1]
LEFT OUTER JOIN I_InsurContrLifeCycleStatus AS _InsurContrLifeCycleStatus ON InsurContrLifeCycSts = _InsurContrLifeCycleStatus.InsurContrLifeCycSts  -- association [1..1]
LEFT OUTER JOIN I_InsurContractRenewalTypeLink AS _InsurContractRenewalType ON InsurContrRnwlType = _InsurContractRenewalType.InsurContrRnwlType AND InsurPlcyProductTemplate = _InsurContractRenewalType.InsurPlcyProductTemplate  -- association [0..1]
LEFT OUTER JOIN I_InsurContrTariffVariantLink AS _InsurContractTariffVariant ON InsurContrTrifVar = _InsurContractTariffVariant.InsurContrTrifVar AND InsurPlcyProductTemplate = _InsurContractTariffVariant.InsurPlcyProductTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyDiscProtectionLink AS _InsurPlcyDiscProtection ON InsurPlcyDiscountProtection = _InsurPlcyDiscProtection.InsurPlcyDiscountProtection AND InsurPlcyProductTemplate = _InsurPlcyDiscProtection.InsurPlcyProductTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyProductTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurPremPaytRcrrcFrqcy AS _InsurPremPaytRcrrcFrqcy ON InsurPremSpecPaytRcrrcFrqcy = _InsurPremPaytRcrrcFrqcy.InsurPremSpecPaytRcrrcFrqcy  -- association [1..1]
LEFT OUTER JOIN I_InsurApplLifeCycleStatus AS _InsurApplLifeCycleStatus ON InsurApplLifeCycSts = _InsurApplLifeCycleStatus.InsurApplLifeCycSts  -- association [1..1]
LEFT OUTER JOIN I_InsurApplRejectionReason AS _InsurApplRejectionReason ON InsurApplRjcnRsn = _InsurApplRejectionReason.InsurApplRjcnRsn  -- association [1..1]
LEFT OUTER JOIN I_InsurPolicyProductTemplate AS _InsurPolicyProductTemplate ON InsurPlcyProductTemplate = _InsurPolicyProductTemplate.InsurPlcyTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCoveragePackage AS _InsurPlcyCoveragePackage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyContrCoverage AS _InsurancePolicyContrCoverage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyContrLimit AS _InsurancePolicyContrLimit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyContrClause AS _InsurancePolicyContrClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyContrSurchrgDisc AS _InsurPlcyContrSurchrgDisc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurancePolicyPremPayer AS _InsurancePolicyPremPayer ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurPolicyContrDeductible AS _InsurPolicyContrDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyContrInsuredObject AS _InsurPlcyContrInsuredObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurContrPlannedProcessing AS _InsurContrPlndProcg ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyContractBonusMalus AS _InsurPlcyContractBonusMalus ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurPlcyContractBeneficiary AS _InsurPlcyContractBeneficiary ON /* condition not available in parsed metadata */  -- association [0..*]
;