VBRP

-- ============================================================
-- Table  : VBRP Billing Document: Item Data
-- Purpose: Column-selected read of VBRP — 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 "Billing Document",
  l.POSNR AS "Billing Item",
  l.FKIMG AS "Actual Invoiced Quantity",
  l.VRKME AS "Sales Unit",
  l.MEINS AS "Base Unit of Measure",
  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.NETWR AS "Net Value of the Billing Item in Document Currency",
  l.MATNR AS "Material Number",
  l.MATKL AS "Material Group",
  l.ARKTX AS "Short Text for Sales Order Item",
  l.PSTYV AS "Sales Document Item Category",
  l.WERKS AS "Plant",
  l.LGORT AS "Storage Location",
  l.CHARG AS "Batch Number",
  l.MWSBP AS "Tax Amount in Document Currency",
  l.PRCTR AS "Profit Center",
  l.VGBEL AS "Document Number of the Reference Document",
  l.VGPOS AS "Item Number of the Reference Item",
  l.VGTYP AS "SD Document Category of Preceding Document",
  l.AUBEL AS "Sales Document",
  l.AUPOS AS "Sales Document Item",
  l.PRODH AS "Product Hierarchy",
  l.MVGR1 AS "Material Group 1",
  l.MVGR2 AS "Material Group 2",
  l.MVGR3 AS "Material Group 3",
  l.WAVWR AS "Cost in Document Currency",
  l.CMPRE AS "Credit Price",
  l.KZWI1 AS "Subtotal 1 from Pricing Procedure for Condition",
  l.KZWI2 AS "Subtotal 2 from Pricing Procedure for Condition",
  l.KZWI3 AS "Subtotal 3 from Pricing Procedure for Condition",
  l.KZWI4 AS "Subtotal 4 from Pricing Procedure for Condition",
  l.KZWI5 AS "Subtotal 5 from Pricing Procedure for Condition",
  l.KZWI6 AS "Subtotal 6 from Pricing Procedure for Condition",
  l.SKTOF AS "Cash Discount Indicator",
  l.MWSKZ AS "Tax on Sales/Purchases Code",
  l.KURSK AS "Exchange Rate for Statistics",
  l.STCUR AS "Exchange Rate for Statistics (Exch. Rate at Time of Creation)"
FROM <catalog>.<schema>.vbrp l
WHERE
  l.MANDT = '<MANDT>'
ORDER BY l.VBELN;