P_DGR_Sttl_Final_Data

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 P_DGR_Sttl_Final_Data.
-- 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.
-- SQL view name: PDGRSTLFINALDATA

CREATE VIEW P_DGR_Sttl_Final_Data AS
SELECT
  Sttl.SettlementUnitUUID AS SettlementUnitUUID,
  Sttl.ApplicationUUID AS ApplicationUUID,
  Sttl.ApplicationVersion AS ApplicationVersion,
  Sttl.ContractNumber AS ContractNumber,
  Sttl.ContractItem AS ContractItem,
  Sttl.ContractCommodityItem AS ContractCommodityItem,
  Sttl.SettlementCreatedOnDateTime AS SettlementCreatedOnDateTime,
  Sttl.SettlementCreatedOnDate AS SettlementCreatedOnDate,
  Sttl.SettlementStatus AS SettlementStatus,
  Sttl.SettlementStatusObject AS SettlementStatusObject,
  Sttl.ContractQtyCancellationUUID AS ContractQtyCancellationUUID,
  Sttl.SettlementType AS SettlementType,
  Sttl.SettlmtDoc AS SettlmtDoc,
  Sttl.SettlmtDocYear AS SettlmtDocYear,
  Sttl.StatusCode AS StatusCode,
  FirstPaymentDate.SttlInvoicePaymentDateTime AS SttlInvoicePaymentDateTime
FROM P_DGR_Sttl_PrepareData AS Sttl
LEFT OUTER JOIN P_DGR_Sttl_First_Payment_Date AS FirstPaymentDate ON /* join condition not captured in parsed metadata */
;