C_InApprovalPurchaseOrderItem

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 C_InApprovalPurchaseOrderItem.
-- 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: CINAPPO
-- Parameters: P_DisplayCurrency : displaycurrency

CREATE VIEW C_InApprovalPurchaseOrderItem AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  MaterialGroup,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  CompanyCode,
  Plant,
  Material,
  _Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  OrderQuantity,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder._Supplier.SupplierName AS SupplierName,
  PurchaseOrderQuantityUnit,
  cast(:P_DisplayCurrency as displaycurrency) AS DisplayCurrency
FROM I_PurchaseOrderItem
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup  -- association [0..*]
;