I_InsurOpenApplDeductible

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_InsurOpenApplDeductible.
-- 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_InsurOpenApplDeductible AS
SELECT
  OpenApplJrnl.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  cast( OpenApplJrnl.InsuranceApplication as /pm0/vdm_applicationnr_tt preserving type ) AS InsuranceApplication,
  Deductible.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Deductible.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Deductible.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Deductible.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  Deductible.InsurPlcySubCvrgID AS InsurPlcySubCvrgID,
  Deductible.InsurPlcyDeductibleID AS InsurPlcyDeductibleID,
  cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  Deductible.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Deductible.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Deductible.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  OpenApplJrnl.InsurPlcyUUID AS InsurPlcyUUID,
  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]
;