C_SuplrInvcItQty

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_SuplrInvcItQty.
-- 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: CSUPLRINVCITQTY

CREATE VIEW C_SuplrInvcItQty AS
SELECT
  iv_items.belnr AS SupplierInvoice,
  iv_items.gjahr AS SupplierInvoiceYear,
  iv_items.buzei AS SupplierInvoiceItem,
  iv_items.ebeln AS PurchaseOrder,
  iv_items.ebelp AS PurchaseOrderItem,
  iv_items.matnr AS Material,
  0 AS SuplrInvcItemQtyToBaseQtyNmrtr,
  0 AS SuplrInvcItmQtyToBaseQtyDnmntr,
  iv_items.bstme AS SuplrInvcItemQuantityUnit,
  SuplrInvcUnitT006A,
  iv_items.meins AS BaseUnit,
  BaseUnitT006A,
  iv_head.waers AS SupplierInvoiceCurrency,
  iv_items.menge AS SupplierInvoiceItemQuantity,
  iv_items.menge AS SuplrInvcItmQuantityInBaseUnit,
  iv_items.wrbtr AS ItemAmountOfSupplierInvoice,
  iv_items.shkzg AS shkzg,
  iv_items.meins AS meins
FROM rseg AS iv_items
LEFT OUTER JOIN view_iv_head_p AS iv_head ON SupplierInvoice = iv_head.belnr AND SupplierInvoiceYear = iv_head.gjahr  -- association [1..1]
LEFT OUTER JOIN view_PO_items_p AS purchase_order_item ON PurchaseOrder = purchase_order_item.ebeln AND PurchaseOrderItem = purchase_order_item.ebelp  -- association [0..1]
LEFT OUTER JOIN t006a AS SuplrInvcUnitT006A ON SuplrInvcItemQuantityUnit = SuplrInvcUnitT006A.msehi  -- association [0..*]
LEFT OUTER JOIN t006a AS BaseUnitT006A ON BaseUnit = BaseUnitT006A.msehi  -- association [0..*]
;