R_InsurPlcyCvPcgCvrgRptdValTP

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_InsurPlcyCvPcgCvrgRptdValTP.
-- 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_InsurPlcyCvPcgCvrgRptdValTP AS
SELECT
  ReportedValue.InsurPlcyUUID AS InsurPlcyUUID,
  ReportedValue.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  ReportedValue.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  ReportedValue.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  ReportedValue.InsurPlcyRptdValID AS InsurPlcyRptdValID,
  ReportedValue.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  ReportedValue.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  ReportedValue.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  ReportedValue.InsurPlcyRptdValIsCancld AS InsurPlcyRptdValIsCancld,
  ReportedValue.InsurPlcyRptdValTemplateID AS InsurPlcyRptdValTemplateID,
  ReportedValue.InsurPlcyRptdValCat AS InsurPlcyRptdValCat,
  ReportedValue.InsurPlcyRptdSettlmtStartDate AS InsurPlcyRptdSettlmtStartDate,
  ReportedValue.InsurPlcyRptdSettlmtEndDate AS InsurPlcyRptdSettlmtEndDate,
  ReportedValue.InsurPlcyRptdValDueDteKey AS InsurPlcyRptdValDueDteKey,
  ReportedValue.InsurPlcyPnltyEndorsementMode AS InsurPlcyPnltyEndorsementMode,
  ReportedValue.InsurPlcyPnltyFctrPercent AS InsurPlcyPnltyFctrPercent,
  ReportedValue.InsurPlcyIsPnltyEndorsement AS InsurPlcyIsPnltyEndorsement,
  ReportedValue.InsurPlcyFiscalYearHandling AS InsurPlcyFiscalYearHandling,
  ReportedValue.InsurPlcyRptdValSts AS InsurPlcyRptdValSts,
  ReportedValue.InsurPlcyRptgCyc AS InsurPlcyRptgCyc,
  ReportedValue.InsurPlcyNotifPerdNumberOfDays AS InsurPlcyNotifPerdNumberOfDays,
  ReportedValue.InsurPlcyRptdValTmeRef AS InsurPlcyRptdValTmeRef,
  ReportedValue.InsurPlcyMonetaryRptdValAmt AS InsurPlcyMonetaryRptdValAmt,
  ReportedValue.InsurPlcyAdvncPaytOfPremPct AS InsurPlcyAdvncPaytOfPremPct,
  ReportedValue.InsurPlcyRptdValSettlmtCyc AS InsurPlcyRptdValSettlmtCyc,
  ReportedValue.InsurPlcyRptdValSettlmtMode AS InsurPlcyRptdValSettlmtMode,
  ReportedValue.InsurPlcyRptdValSettlmtWvr AS InsurPlcyRptdValSettlmtWvr,
  ReportedValue.InsurPlcyRptdValCurrency AS InsurPlcyRptdValCurrency,
  ReportedValue.InsurPlcyRptdValQuantity AS InsurPlcyRptdValQuantity,
  ReportedValue.InsurPlcyRptdValQuantityUnit AS InsurPlcyRptdValQuantityUnit,
  ReportedValue.InsurPlcyRptdValCl AS InsurPlcyRptdValCl,
  ReportedValue.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  ReportedValue.LastChangeDateTime AS LastChangeDateTime,
  ReportedValue._Currency AS _Currency
FROM I_InsurPlcyReportedValBasic AS ReportedValue
LEFT OUTER JOIN E_InsurancePolicyReportedValue AS _Extension ON InsurPlcyRptdValID = _Extension.InsurPlcyRptdValID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr  -- association [1..1]
;