SAP Reference
MI04
Create S/4HANA status: ActiveEnter Inventory Count with Document
Notes
Mapped here to MARD/MCHB/MARA — the stock the count is taken against. The physical-inventory document itself (header IKPF, item ISEG) is not in this catalog.
Boilerplate SQL
Databricks SQLStarting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.
Query parameters
6 parameters not filled: <catalog>, <schema>, <MANDT>, <MATNR>, <WERKS>, <LGORT>
-- ============================================================
-- T-Code : MI04 Enter Inventory Count with Document
-- Purpose: Enter Inventory Count with Document — auto-generated boilerplate from tcode-table-map
-- Grain : One row per MARD joined to MARD, MCHB, MARA
-- Tables : MARD, MARD, MCHB, MARA
-- Notes : Auto-generated skeleton. Add MAKT/T001W/LFA1/KNA1 enrichment joins as needed for the business question. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
m.MANDT AS "Client",
m.MATNR AS "Material Number",
m.WERKS AS "Plant",
m.LGORT AS "Storage Location",
mc.CHARG AS "Batch Number"
FROM <catalog>.<schema>.mard m
LEFT JOIN <catalog>.<schema>.mard m
ON m.MANDT = m.MANDT
AND m.MATNR = m.MATNR
AND m.WERKS = m.WERKS
AND m.LGORT = m.LGORT
LEFT JOIN <catalog>.<schema>.mchb mc
ON mc.MANDT = m.MANDT
AND mc.MATNR = m.MATNR
AND mc.WERKS = m.WERKS
AND mc.LGORT = m.LGORT
LEFT JOIN <catalog>.<schema>.mara ma
ON ma.MANDT = m.MANDT
AND ma.MATNR = m.MATNR
WHERE
m.MANDT = '<MANDT>'
AND m.MATNR = '<MATNR>'
AND m.WERKS = '<WERKS>'
AND m.LGORT = '<LGORT>'
ORDER BY m.MATNR;