MKPF

-- ============================================================
-- Table  : MKPF Header: Material Document
-- Purpose: Column-selected read of MKPF — auto-generated from field metadata
-- Grain  : One row per MBLNR + MJAHR
-- 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
  h.MANDT  AS "Client",
  h.MBLNR  AS "Number of Material Document",
  h.MJAHR  AS "Material Document Year",
  h.VGART  AS "Transaction/Event Type",
  h.BLART  AS "Document Type",
  h.BLAUM  AS "Document Type of Revaluation Document",
  h.BLDAT  AS "Document Date in Document",
  h.BUDAT  AS "Posting Date in the Document",
  h.CPUDT  AS "Day On Which Accounting Document Was Entered",
  h.CPUTM  AS "Time of Entry",
  h.AEDAT  AS "Date of Last Change",
  h.USNAM  AS "User Name",
  h.TCODE2 AS "Transaction Code",
  h.XBLNR  AS "Reference Document Number",
  h.BKTXT  AS "Document Header Text",
  h.XABLN  AS "Goods Receipt/Issue Slip Number",
  h.LFSNR  AS "Delivery Note Number",
  h.FRBNR  AS "Number of Bill of Lading at Time of Goods Receipt"
FROM <catalog>.<schema>.mkpf h
WHERE
  h.MANDT = '<MANDT>'
ORDER BY h.MBLNR;