LIPS

-- ============================================================
-- Table  : LIPS SD Document: Delivery Item Data
-- Purpose: Column-selected read of LIPS — 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 "Delivery",
  l.POSNR AS "Delivery Item",
  l.PSTYV AS "Delivery Item Category",
  l.ERNAM AS "Name of Person Who Created the Object",
  l.ERZET AS "Entry Time",
  l.ERDAT AS "Date on Which Record Was Created",
  l.MATNR AS "Material Number",
  l.MATWA AS "Material Entered",
  l.ARKTX AS "Short Text for Sales Order Item",
  l.MATKL AS "Material Group",
  l.WERKS AS "Plant",
  l.LGORT AS "Storage Location",
  l.CHARG AS "Batch Number",
  l.LFIMG AS "Actual Quantity Delivered (in Sales Units)",
  l.MEINS AS "Base Unit of Measure",
  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.NTGEW AS "Net Weight",
  l.BRGEW AS "Gross Weight",
  l.GEWEI AS "Weight Unit",
  l.VOLUM AS "Volume",
  l.VOLEH AS "Volume Unit",
  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 the Preceding Document",
  l.LGNUM AS "Warehouse Number/Complex",
  l.LGTYP AS "Storage Type",
  l.LGPLA AS "Storage Bin",
  l.BWART AS "Movement Type (Inventory Management)",
  l.PRCTR AS "Profit Center",
  l.KOSTL AS "Cost Center",
  l.AUFNR AS "Order Number",
  l.KDAUF AS "Sales Order Number for Valuated Stock",
  l.KDPOS AS "Item of a Sales Order for Valuated Stock",
  l.NETPR AS "Net Price",
  l.NETWR AS "Net Value of the Order Item in Document Currency",
  l.PRODH AS "Product Hierarchy",
  l.MVGR1 AS "Material Group 1"
  -- … plus 3 more columns — full list in the Fields section above
FROM <catalog>.<schema>.lips l
WHERE
  l.MANDT = '<MANDT>'
ORDER BY l.VBELN;