- Home
- Resources
- SAP Tables
- MACK5 - Material Master Structure for Costing
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.
Source: MACK5 (Material Master Structure for Costing)
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 |
Possible values
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 |
Possible values
|
KZKFG |
Configurable Material |
KZKFG |
|
CHAR |
|
1 |
0 |
Possible values
|
HKMAT |
Material-related origin |
HKMAT |
|
CHAR |
|
1 |
0 |
Possible values
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 |
|