R_InsurPlcyCvPcgCvrgCvrgOptnTP

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 R_InsurPlcyCvPcgCvrgCvrgOptnTP.
-- 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 R_InsurPlcyCvPcgCvrgCvrgOptnTP AS
SELECT
  CoverageOption.InsurPlcyUUID AS InsurPlcyUUID,
  CoverageOption.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  CoverageOption.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  CoverageOption.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  CoverageOption.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  CoverageOption.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  CoverageOption.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  CoverageOption.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  CoverageOption.InsurPlcyCvrgOptionIsCancelled AS InsurPlcyCvrgOptionIsCancelled,
  CoverageOption.InsurPlcyLineOfBusiness AS InsurPlcyLineOfBusiness,
  CoverageOption.InsurPlcyCvrgOptionStartDate AS InsurPlcyCvrgOptionStartDate,
  CoverageOption.InsurPlcyCvrgOptionEndDate AS InsurPlcyCvrgOptionEndDate,
  CoverageOption.InsurPlcyCvrgOptionCvrgNmbr AS InsurPlcyCvrgOptionCvrgNmbr,
  CoverageOption.InsurPlcyCvrgOptnCvrgOptnNmbr AS InsurPlcyCvrgOptnCvrgOptnNmbr,
  CoverageOption.InsurPlcyCvrgOptionProdMgrID AS InsurPlcyCvrgOptionProdMgrID,
  CoverageOption.InsurPlcyCvrgOptionCurrency AS InsurPlcyCvrgOptionCurrency,
  CoverageOption.InsurPlcyCvrgOptionGnrtnDate AS InsurPlcyCvrgOptionGnrtnDate,
  CoverageOption.InsurPlcyCvrgOptnGnrtnDetnDte AS InsurPlcyCvrgOptnGnrtnDetnDte,
  CoverageOption.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  CoverageOption.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyCoverageOption AS CoverageOption
LEFT OUTER JOIN E_InsurPolicyCoverageOption AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyCvPcgCvrgOptnPremTP AS _Premium ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyLifeCvPcgCvrgOptnTP AS _LifeCoverageOption ON /* condition not available in parsed metadata */  -- association [0..1]
;