P_DGR_Appl_PrepareData

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

CREATE VIEW P_DGR_Appl_PrepareData AS
SELECT
  Appl.ApplicationDocument AS ApplicationDocument,
  ApplicationDocumentItem,
  Appl.Side AS Side,
  Appl.SubItem AS SubItem,
  Appl.ItemCategory AS ItemCat,
  Appl.ApplicationItemCategory AS ApplicationItemCategory,
  Appl.ApplicationItemUUID AS ItemGuid,
  Appl.RootItem AS RootItem,
  cast(right(Appl.ParentItem, 6) as abap.char(6)) 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.Supplier AS Vendor,
  Appl.LDCApplInstructionValue AS LoadDataCaptureApplInstruction,
  Appl.CommodityQuantityInBaseUnit AS CommodityQuantityInBaseUnit,
  Appl.CommodityUnit AS CommodityBaseUnit,
  Appl.CompanyCode AS CompanyCode,
  Appl.ApplItemCreatedOnDateTime AS ApplItemCreatedOnDateTime,
  Appl.ApplItemChangedOnDateTime AS ApplItemChangedOnDateTime,
  Appl.ApplicationItemCreatedOnDate AS ApplItemCreatedOnDate,
  Appl.ApplicationItemChangedOnDate AS ApplItemChangedOnDate,
  Status.StatusTmstp AS ApplItemCancelledDateTime,
  Status.StatusDate AS ApplItemCancelledDate,
  Appl.ApplicationItemCreatedOnDate AS CreatedOn,
  Appl.ApplicationItemChangedOnDate AS ChangedOn,
  Appl.ApplicationItemCreatedOnDate AS ApplicationItemCreatedOnDate,
  Appl.ApplicationItemChangedOnDate AS ApplicationItemChangedOnDate,
  Appl.PurApplDocValidityStartDate AS PADValidityStartDate,
  Appl.ApplicationDocType AS ApplicationDocumentType,
  $parameters.P_DailyGrainReportType AS DailyGrainReportType,
  $parameters.P_DailyGrainReportDate AS DailyGrainReportDate
FROM I_ACMApplDocData AS Appl
LEFT OUTER JOIN P_DGR_Appl_DstctCancldAppl AS Status ON /* join condition not captured in parsed metadata */
;