P_DGR_Appl_FillSettlementData

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_Appl_FillSettlementData.
-- 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: PDGRAPPLSTTLDATA
-- Parameters: P_DisplayUnitOfMeasure : cds_dgr_display_uom, P_DailyGrainReportType : cds_dgr_report_type, P_DailyGrainReportDate : cds_dgr_date

CREATE VIEW P_DGR_Appl_FillSettlementData AS
SELECT
  Appl.ApplicationDocument AS ApplicationDocument,
  Appl.ApplicationDocumentItem AS ApplicationDocumentItem,
  Appl.Side AS Side,
  Appl.SubItem AS SubItem,
  Appl.ApplicationItemCategory AS ApplicationItemCategory,
  Appl.ItemGuid AS ItemGuid,
  Appl.RootItem AS RootItem,
  Appl.ParentItem AS ParentItem,
  Appl.ApplicationStatusObject AS ApplicationStatusObject,
  Appl.StorageStartDate AS StorageStartDate,
  Appl.StorageEndDate AS StorageEndDate,
  Appl.WarehouseReceiptType AS WarehouseReceiptType,
  Appl.WarehouseReceiptNo AS WarehouseReceiptNo,
  Appl.WarehouseStartDate AS WarehouseStartDate,
  Appl.WarehouseEndDate AS WarehouseEndDate,
  Appl.ObligationType AS ObligationType,
  Appl.Plant AS Plant,
  Appl.StorageLocation AS StorageLocation,
  Appl.MaterialGroup AS MaterialGroup,
  Appl.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  Appl.LoadDataObjectUUID AS LoadDataObjectUUID,
  Appl.LoadDataObjectType AS LoadDataObjectType,
  Appl.Material AS Material,
  Appl.PostingDate AS PostingDate,
  Appl.Vendor AS Vendor,
  Appl.CommodityQuantityInBaseUnit AS CommodityQuantityInBaseUnit,
  Appl.CommodityBaseUnit AS CommodityBaseUnit,
  Appl.CompanyCode AS CompanyCode,
  Appl.ApplItemChangedOnDateTime AS ApplItemChangedOnDateTime,
  Appl.ApplItemChangedOnDate AS ApplItemChangedOnDate,
  Appl.ApplicationDocumentType AS ApplicationDocumentType,
  Appl.LoadDataCaptureApplInstruction AS LoadDataCaptureApplInstruction,
  Appl.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  Appl.ApplicationUUID AS ApplicationUUID,
  Appl.ApplicationVersion AS ApplicationVersion,
  Appl.TradingContractNumber AS TradingContractNumber,
  Appl.TradingContractItem AS TradingContractItem,
  Appl.EndOfDayTimestamp AS EndOfDayTimestamp,
  Appl.PreviousEndOfDayTimestamp AS PreviousEndOfDayTimestamp,
  Appl.BegingingBookBalancetTimestamp AS BegingingBookBalancetTimestamp,
  Appl.ApplItemCreatedOnDateTime AS ApplItemCreatedOnDateTime,
  Appl.ApplItemCreatedOnDate AS ApplItemCreatedOnDate,
  Appl.ApplItemCancelledDateTime AS ApplItemCancelledDateTime,
  Appl.ApplItemCancelledDate AS ApplItemCancelledDate,
  Appl.ApplItemAppliedDateTime AS ApplItemAppliedDateTime,
  Appl.ApplItemAppliedDate AS ApplItemAppliedDate,
  Appl.DailyGrainReportDisplayUnit AS DailyGrainReportDisplayUnit,
  Appl.DailyGrainReportType AS DailyGrainReportType,
  Appl.DailyGrainReportDate AS DailyGrainReportDate,
  Sttl.SettlementUnitUUID AS SettlementUnitUUID,
  Sttl.ContractNumber AS ContractNumber,
  Sttl.ContractItem AS ContractItem,
  Sttl.ContractCommodityItem AS ContractCommodityItem,
  Sttl.SettlementCreatedOnDateTime AS ApplItemSettlementDateTime,
  Sttl.SettlementCreatedOnDate AS ApplItemSettlementDate,
  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,
  Sttl.SttlInvoicePaymentDateTime AS SttlInvoicePaymentDateTime
FROM P_DGR_Appl_FilterOnAppliedDate
LEFT OUTER JOIN P_DGR_Sttl_Final_Data AS Sttl ON /* join condition not captured in parsed metadata */
;