MSEG

-- ============================================================
-- Table  : MSEG Document Segment: Material
-- Purpose: Column-selected read of MSEG — auto-generated from field metadata
-- Grain  : One row per MBLNR + MJAHR + ZEILE
-- 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.MBLNR    AS "Number of Material Document",
  l.MJAHR    AS "Material Document Year",
  l.ZEILE    AS "Item in Material Document",
  l.BWART    AS "Movement Type (Inventory Management)",
  l.MATNR    AS "Material Number",
  l.WERKS    AS "Plant",
  l.LGORT    AS "Storage Location",
  l.CHARG    AS "Batch Number",
  l.INSMK    AS "Stock Type",
  l.SOBKZ    AS "Special Stock Indicator",
  l.LIFNR    AS "Account Number of Vendor or Creditor",
  l.KUNNR    AS "Account Number of Customer or Debtor",
  l.KDAUF    AS "Sales Order Number of Valuated Sales Order Stock",
  l.KDPOS    AS "Sales Order Item",
  l.SHKZG    AS "Debit/Credit Indicator",
  l.WAERS    AS "Currency Key",
  l.DMBTR    AS "Amount in Local Currency",
  l.MENGE    AS "Quantity",
  l.MEINS    AS "Base Unit of Measure",
  l.ERFMG    AS "Quantity in Unit of Entry",
  l.ERFME    AS "Unit of Entry",
  l.EBELN    AS "Purchase Order Number",
  l.EBELP    AS "Item Number of Purchasing Document",
  l.RSNUM    AS "Number of Reservation/Dependent Requirements",
  l.RSPOS    AS "Item Number of Reservation/Dependent Requirements",
  l.AUFNR    AS "Order Number",
  l.KOSTL    AS "Cost Center",
  l.SAKTO    AS "G/L Account Number",
  l.GSBER    AS "Business Area",
  l.PRCTR    AS "Profit Center",
  l.BUKRS    AS "Company Code",
  l.VBELN_IM AS "Delivery",
  l.VBELP_IM AS "Delivery Item",
  l.LGNUM    AS "Warehouse Number/Complex",
  l.LGTYP    AS "Storage Type",
  l.LGPLA    AS "Storage Bin",
  l.BWTAR    AS "Valuation Type",
  l.GRUND    AS "Reason for Movement",
  l.EXBWR    AS "Externally Entered Posting Amount in Local Currency"
  -- … plus 19 more columns — full list in the Fields section above
FROM <catalog>.<schema>.mseg l
WHERE
  l.MANDT = '<MANDT>'
ORDER BY l.MBLNR;