I_InsurPlcyContrCvrgObjDcbl

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_InsurPlcyContrCvrgObjDcbl.
-- 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_InsurPlcyContrCvrgObjDcbl AS
SELECT
  Deductible.InsurPlcyUUID AS InsurPlcyUUID,
  Deductible.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Deductible.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Deductible.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Deductible.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  Deductible.InsurPlcySubCvrgID AS InsurPlcySubCvrgID,
  Deductible.InsurPlcyDeductibleID AS InsurPlcyDeductibleID,
  Deductible.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Deductible.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Deductible.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Deductible.InsurPlcyDeductibleCategory AS InsurPlcyDeductibleCategory,
  Deductible.InsurPlcyDeductibleAmount AS InsurPlcyDeductibleAmount,
  Deductible.InsurPlcyDeductibleStartDate AS InsurPlcyDeductibleStartDate,
  Deductible.InsurPlcyDeductibleEndDate AS InsurPlcyDeductibleEndDate,
  Deductible.InsurPlcyDeductibleTemplate AS InsurPlcyDeductibleTemplate,
  Deductible.InsurPlcyDeductibleCurrency AS InsurPlcyDeductibleCurrency,
  Deductible.InsurPlcyDeductibleAmountUnit AS InsurPlcyDeductibleAmountUnit,
  Deductible.InsurPlcyDeductibleValue AS InsurPlcyDeductibleValue,
  Deductible.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyDeductibleBasic AS Deductible
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyDeductibleCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyDeductibleTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurPlcyDcblAmountUnitLink AS _InsurPlcyDcblAmountUnit ON InsurPlcyDeductibleAmountUnit = _InsurPlcyDcblAmountUnit.InsurPlcyDeductibleAmountUnit AND InsurPlcyDeductibleTemplate = _InsurPlcyDcblAmountUnit.InsurPlcyDeductibleTemplate  -- association [0..1]
LEFT OUTER JOIN I_InsurPlcyDcblCategoryLink AS _InsurPlcyDeductibleCategory ON InsurPlcyDeductibleCategory = _InsurPlcyDeductibleCategory.InsurPlcyDeductibleCategory AND InsurPlcyDeductibleTemplate = _InsurPlcyDeductibleCategory.InsurPlcyDeductibleTemplate  -- association [0..1]
;