MATDOC

-- ============================================================
-- Table  : MATDOC Material Document (S/4HANA)
-- Purpose: Column-selected read of MATDOC — auto-generated from field metadata
-- Grain  : One row per KEY1 + KEY2 + KEY3 + KEY4 + KEY5 + KEY6
-- 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
  m.MANDT     AS "Client",
  m.KEY1      AS "Split GUID Part 1",
  m.KEY2      AS "Split GUID Part 2",
  m.KEY3      AS "Split GUID Part 3",
  m.KEY4      AS "Split GUID Part 4",
  m.KEY5      AS "Split GUID Part 5",
  m.KEY6      AS "Split GUID Part 6",
  m.MBLNR     AS "Number of Material Document",
  m.MJAHR     AS "Material Document Year",
  m.ZEILE     AS "Item in Material Document",
  m.LINE_ID   AS "Unique Line ID",
  m.PARENT_ID AS "Parent Line ID",
  m.BWART     AS "Movement Type",
  m.MATNR     AS "Material Number",
  m.WERKS     AS "Plant",
  m.LGORT     AS "Storage Location",
  m.CHARG     AS "Batch Number",
  m.MENGE     AS "Quantity",
  m.SHKZG     AS "Debit/Credit Indicator",
  m.BUDAT     AS "Posting Date in the Document",
  m.BLDAT     AS "Document Date in Document",
  m.SOBKZ     AS "Special Stock Indicator"
FROM <catalog>.<schema>.matdoc m
WHERE
  m.MANDT = '<MANDT>'
ORDER BY m.KEY1;