SAP Table MACK5

Material Master Structure for Costing

MACK5 (Material Master Structure for Costing) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MACK5 to other SAP tables.

MACK5 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price VERPR CURR 11 2
STPRS Standard price STPRS CURR 11 2
PEINH Price Unit PEINH DEC 5 0
BKLAS Valuation Class BKLAS CHAR 4 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
ZKPRS Future price DZKPRS CURR 11 2
ZKDAT Date as of which the price is valid DZKDAT DATS 8 0
BWPRS Valuation price based on tax law: level 1 BWPRS CURR 11 2
BWPRH Valuation price based on commercial law: level 1 BWPRH CURR 11 2
BWPS1 Valuation price based on tax law: level 2 BWPS1 CURR 11 2
BWPH1 Valuation price based on commercial law: level 2 BWPH1 CURR 11 2
VJBWS Valuation price based on tax law: level 3 VJBWS CURR 11 2
VJBWH Valuation price based on commercial law: level 3 VJBWH CURR 11 2
ZPLPR Future planned price DZPLPR CURR 11 2
ZPLP1 Future Planned Price 1 DZPLP1 CURR 11 2
ZPLP2 Future Planned Price 2 DZPLP2 CURR 11 2
ZPLP3 Future Planned Price 3 DZPLP3 CURR 11 2
ZPLD1 Date from Which Future Planned Price 1 Is Valid DZPLD1 DATS 8 0
ZPLD2 Date from Which Future Planned Price 2 Is Valid DZPLD2 DATS 8 0
ZPLD3 Date from Which Future Planned Price 3 Is Valid DZPLD3 DATS 8 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
KALN1 Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
VMSTP Standard price in the previous period VMSTP CURR 11 2
VMPEI Price unit of previous period VMPEI DEC 5 0
MTART Material Type MTART CHAR 4 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1 0
X Yes
NULL No
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
BWPEI Price unit for valuation prices based on tax/commercial law BWPEI DEC 5 0