P_GRItm

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_GRItm.
-- 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: PGRITM

CREATE VIEW P_GRItm AS
SELECT
  PurchasingHistoryDocument AS MaterialDocument,
  PurchasingHistoryDocumentItem AS MaterialDocumentItem,
  PurchasingHistoryDocumentYear AS MaterialDocumentYear,
  concat(concat(concat(concat(PurchasingHistoryDocument, '/'), PurchasingHistoryDocumentItem), '/' ), PurchasingHistoryDocumentYear) AS FormattedPurDoc,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  _PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  Plant,
  case GoodsMovementType when '101' then cast('22' as abap.char(2)) AS char2endasStatus,
  Material,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  '' AS CostCenter,
  '' AS SalesOrder,
  '' AS WBSElementExternalID,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder._PurchaseOrderType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  GoodsMovementType,
  DocumentDate,
  PostingDate,
  ReferenceDocument,
  DocumentReferenceID,
  Quantity,
  DebitCreditCode,
  PurchaseOrderItem,
  PurchaseOrder,
  CreatedByUser,
  PurchasingHistoryDocumentType,
  PurchasingHistoryCategory,
  '' AS SupplyingPlant,
  cast ('00000000' as mm_a_delivery_date) AS DeliveryDate,
  PurchasingHistoryDocument AS PurchasingDocument,
  '' AS AccountAssignmentCategory,
  '_' AS PurchasingDocumentItemCategory
FROM I_PurchaseOrderHistoryBasic
LEFT OUTER JOIN I_MaterialDocumentRecord AS _MatDocRec ON MaterialDocument = _MatDocRec.MaterialDocument AND MaterialDocumentItem = _MatDocRec.MaterialDocumentItem AND MaterialDocumentYear = _MatDocRec.MaterialDocumentYear AND _MatDocRec.MaterialDocumentRecordType = 'MDOC' AND _MatDocRec.IsAutomaticallyCreated <> 'X'  -- association [1..1]
;