P_RequirementTrackingPurOrd

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_RequirementTrackingPurOrd.
-- 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.

CREATE VIEW P_RequirementTrackingPurOrd AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  concat(PurchaseOrder, concat('/', PurchaseOrderItem)) AS FormattedPurchaseOrderItem,
  RequirementTracking,
  Material,
  cast(OrderQuantity as vdm_po_orderquantity) AS OrderQuantity,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  cast(NetAmount as vdm_ponetamount) AS NetAmount,
  DocumentCurrency,
  I_PurchaseOrderItem._PurchaseOrder.Supplier AS Supplier,
  MaterialGroup,
  PurchaseOrderItemText AS PurchasingText,
  I_PurchaseOrderItem._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  I_PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  Plant,
  AccountAssignmentCategory,
  CompanyCode,
  StorageLocation,
  _PurchasingCategoryMatlGrp._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGrp._PurchasingCategory.PurgCatName AS PurgCatName,
  I_PurchaseOrderItem._PurchaseOrder._PurchaseOrderType.PurchasingDocumentType AS PurchasingDocumentType,
  I_PurchaseOrderItem._PurchaseOrder._PurchaseOrderType.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchaseOrder._PurchaseOrderType._Text[1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  PurchaseOrderItemCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language ].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  I_PurchaseOrderItem._PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  I_PurchaseOrderItem._PurchaseOrder.CreatedByUser AS CreatedByUser,
  I_PurchaseOrderItem._PurchaseOrder._CreatedByUser.UserDescription AS UserDescription,
  NetPriceAmount,
  cast(_POItemNextDeliveryCalc.ScheduleLineOpenQuantity as vdm_openpurchaseorderquantity) AS OpenPurchaseOrderQuantity,
  cast(NetPriceQuantity as vdm_netpricequantity) AS NetPriceQuantity,
  I_PurchaseOrderItem._PurchaseOrder.CreationDate AS CreationDate
FROM I_PurchaseOrderItem
LEFT OUTER JOIN P_PurReqTrkAggrGRInv AS _PurReqTrkAggrGRInv ON _PurReqTrkAggrGRInv.PurchaseOrder = PurchaseOrder AND _PurReqTrkAggrGRInv.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGrp ON MaterialGroup = _PurchasingCategoryMatlGrp.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN R_POItemNextDeliveryCalc AS _POItemNextDeliveryCalc ON PurchaseOrder = _POItemNextDeliveryCalc.PurchaseOrder AND PurchaseOrderItem = _POItemNextDeliveryCalc.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccAssignValHelp ON _AccAssignValHelp.AccountAssignmentCategory = AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_ProcmtBlockedSupplier AS _ProcmtBlockedSupplier ON _ProcmtBlockedSupplier.PurchasingIsBlockedForSupplier = 'X'  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON purchasingorganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON purchasinggroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
;