C_AgbuItemQty

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_AgbuItemQty.
-- 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: CAGBUITEMQTY

CREATE VIEW C_AgbuItemQty AS
SELECT
  agbu_items.wbeln AS AgencyBusinessDocument,
  agbu_items.posnr AS AgencyBusinessItem,
  agbu_items.matnr AS Material,
  agbu_items.umrez AS AgBuItemQtyToBaseQtyNmrtr,
  agbu_items.umren AS AgBuItemQtyToBaseQtyDnmntr,
  agbu_items.wfkme AS AgBuItemQuantityUnit,
  AgBuUnitT006A,
  agbu_items.meins AS BaseUnit,
  BaseUnitT006A,
  agbu_head.waerl AS AgencyBusinessDocumentCurrency,
  agbu_items.menge AS AgencyBusinessItemQuantity,
  agbu_items.menge AS AgBuItemQuantityInBaseUnit,
  agbu_items.netwr AS ItemNetAmountOfAgBuDoc,
  agbu_items.netwrd AS CustRelItemNetAmountofAgBuDoc,
  agbu_items.itemcat AS Itemcat,
  agbu_head.lftyp AS lftyp
FROM wbrp AS agbu_items
LEFT OUTER JOIN view_ab_head_p AS agbu_head ON AgencyBusinessDocument = agbu_head.wbeln  -- association [1..1]
LEFT OUTER JOIN t006a AS AgBuUnitT006A ON AgBuItemQuantityUnit = AgBuUnitT006A.msehi  -- association [0..*]
LEFT OUTER JOIN t006a AS BaseUnitT006A ON BaseUnit = BaseUnitT006A.msehi  -- association [0..*]
;