P_DGR_Appl_FillContrPlntMat

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

CREATE VIEW P_DGR_Appl_FillContrPlntMat 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.ApplicationUUID AS ApplicationUUID,
  Appl.ApplicationVersion AS ApplicationVersion,
  Appl.TradingContractNumber AS TradingContractNumber,
  Appl.TradingContractItem AS TradingContractItem,
  Appl.DailyGrainReportDisplayUnit AS DailyGrainReportDisplayUnit,
  Appl.DailyGrainReportType AS DailyGrainReportType,
  Appl.DailyGrainReportDate AS DailyGrainReportDate,
  Appl.SettlementUnitUUID AS SettlementUnitUUID,
  Appl.ContractNumber AS ContractNumber,
  Appl.ContractItem AS ContractItem,
  Appl.ContractCommodityItem AS ContractCommodityItem,
  Appl.SettlementStatus AS SettlementStatus,
  Appl.SettlementStatusObject AS SettlementStatusObject,
  Appl.ContractQtyCancellationUUID AS ContractQtyCancellationUUID,
  Appl.SettlementType AS SettlementType,
  Appl.SettlmtDoc AS SettlmtDoc,
  Appl.SettlmtDocYear AS SettlmtDocYear,
  Appl.StatusCode AS StatusCode,
  Appl.SttlInvoicePaymentDateTime AS SttlInvoicePaymentDateTime,
  Appl.ApplicationDocumentType AS ApplicationDocumentType,
  Appl.LoadDataCaptureApplInstruction AS LoadDataCaptureApplInstruction,
  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.ApplItemSettlementDateTime AS ApplItemSettlementDateTime,
  Appl.ApplItemSettlementDate AS ApplItemSettlementDate,
  Appl.EndOfDayTimestamp AS EndOfDayTimestamp,
  Appl.PreviousEndOfDayTimestamp AS PreviousEndOfDayTimestamp,
  Appl.BegingingBookBalancetTimestamp AS BegingingBookBalancetTimestamp,
  Appl.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  Appl.ApplicationId AS ApplicationId,
  Appl.ActionDateTime AS ActionDateTime,
  Appl.ContractStatus AS ContractStatus,
  Appl.ContractType AS ContractType,
  Appl.ContractIsConfirmationRelevant AS ContractIsConfirmationRelevant,
  wbhi.ContractPlant AS ContractPlant,
  wbhi.ContractMaterial AS ContractMaterial
FROM P_DGR_Appl_LatestContrStatus
LEFT OUTER JOIN I_ACMContrItmData AS wbhi ON /* join condition not captured in parsed metadata */
;