MARA

-- ============================================================
-- Table  : MARA General Material Data
-- Purpose: Column-selected read of MARA — auto-generated from field metadata
-- Grain  : One row per MATNR
-- 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.MATNR AS "Material Number",
  m.ERSDA AS "Created On",
  m.ERNAM AS "Name of Person who Created the Object",
  m.LAEDA AS "Date of Last Change",
  m.AENAM AS "Name of Person Who Changed Object",
  m.VPSTA AS "Maintenance Status of Complete Material",
  m.PSTAT AS "Maintenance status",
  m.LVORM AS "Flag Material for Deletion at Client Level",
  m.MTART AS "Material Type",
  m.MBRSH AS "Industry Sector",
  m.MATKL AS "Material Group",
  m.BISMT AS "Old Material Number",
  m.MEINS AS "Base Unit of Measure",
  m.BSTME AS "Purchase Order Unit of Measure",
  m.ZEINR AS "Document Number",
  m.ZEIAR AS "Document Type",
  m.ZEIVR AS "Document Version",
  m.ZEIFO AS "Page Format of Document",
  m.AESZN AS "Document Change Number (Without Document Management System)",
  m.BLATT AS "Page Number of Document",
  m.FERTH AS "Production/Inspection Memo",
  m.FORMT AS "Page Format of Production Memo",
  m.GROES AS "Size/Dimensions",
  m.WRKST AS "Basic Material",
  m.NORMT AS "Industry Standard Description",
  m.LABOR AS "Laboratory/Design Office",
  m.EKWSL AS "Purchasing Value Key",
  m.BRGEW AS "Gross Weight",
  m.NTGEW AS "Net Weight",
  m.GEWEI AS "Weight Unit",
  m.VOLUM AS "Volume",
  m.VOLEH AS "Volume Unit",
  m.BEHVO AS "Container Requirements",
  m.RAUBE AS "Storage Conditions",
  m.TEMPB AS "Temperature Conditions Indicator",
  m.DISST AS "Low-Level Code",
  m.TRAGR AS "Transportation Group",
  m.STOFF AS "Hazardous Material Number",
  m.SPART AS "Division"
  -- … plus 55 more columns — full list in the Fields section above
FROM <catalog>.<schema>.mara m
WHERE
  m.MANDT = '<MANDT>'
  -- AND m.MATNR = '<MATNR>'
ORDER BY m.MATNR;