VBAP

-- ============================================================
-- Table  : VBAP Sales Document: Item Data
-- Purpose: Column-selected read of VBAP — auto-generated from field metadata
-- Grain  : One row per VBELN + POSNR
-- Notes  : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  l.MANDT  AS "Client",
  l.VBELN  AS "Sales Document",
  l.POSNR  AS "Sales Document Item",
  l.MATNR  AS "Material Number",
  l.MATWA  AS "Material Entered",
  l.PMATN  AS "Pricing Reference Material",
  l.CHARG  AS "Batch Number",
  l.MATKL  AS "Material Group",
  l.ARKTX  AS "Short Text for Sales Order Item",
  l.PSTYV  AS "Sales Document Item Category",
  l.POSAR  AS "Item Type",
  l.LFREL  AS "Item Is Relevant for Delivery",
  l.FKREL  AS "Relevant for Billing",
  l.UEPOS  AS "Higher-Level Item in BOM Structures",
  l.GRPOS  AS "Alternative for Item",
  l.ABGRU  AS "Reason for Rejection of Quotations and Sales Orders",
  l.NETWR  AS "Net Value of the Order Item in Document Currency",
  l.WAERK  AS "SD Document Currency",
  l.NETPR  AS "Net Price",
  l.KPEIN  AS "Condition Price Unit",
  l.KMEIN  AS "Condition Unit",
  l.KWMENG AS "Cumulative Order Quantity in Sales Units",
  l.VRKME  AS "Sales Unit",
  l.UMVKZ  AS "Numerator (factor) for Conversion of Sales Qty into SKU",
  l.UMVKN  AS "Denominator (divisor) for Conversion of Sales Qty into SKU",
  l.MEINS  AS "Base Unit of Measure",
  l.NTGEW  AS "Net Weight of the Item",
  l.BRGEW  AS "Gross Weight of the Item",
  l.GEWEI  AS "Weight Unit",
  l.VOLUM  AS "Volume of the Item",
  l.VOLEH  AS "Volume Unit",
  l.SPART  AS "Division",
  l.WERKS  AS "Plant (Own or External)",
  l.LGORT  AS "Storage Location",
  l.VSTEL  AS "Shipping Point/Receiving Point",
  l.ROUTE  AS "Route",
  l.STKEY  AS "Bill of Material Origin",
  l.STDAT  AS "BOM Date",
  l.STLNR  AS "Bill of Material",
  l.OBJNR  AS "Object Number at Item Level"
  -- … plus 12 more columns — full list in the Fields section above
FROM <catalog>.<schema>.vbap l
WHERE
  l.MANDT = '<MANDT>'
ORDER BY l.VBELN;