SAP Table MACK4

Material Master View: Costing

MACK4 (Material Master View: 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 MACK4 to other SAP tables.

MACK4 table fields

Field Data element Checktable Datatype Length Decimals
LVORM Deletion flag for all material data of a valuation type LVOBA CHAR 1 0
X Yes
NULL No
KALN1 Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
BWVA1 Valuation Variant for Future Standard Cost Estimate CK_BWVA1 CHAR 3 0
BWVA2 Valuation Variant for Current Standard Cost Estimate CK_BWVA2 CHAR 3 0
KALKZ Indicator: standard cost estimate for future period KAXKZ CHAR 1 0
X Yes
NULL No
KALKL Indicator: Standard cost estimate for the period KALKZ CHAR 1 0
X Yes
NULL No
KALKV Indicator: standard cost estimate for previous period KALKV CHAR 1 0
X Yes
NULL No
VERS1 Costing Version of Future Standard Cost Estimate CK_TVERS1 NUMC 2 0
VERS2 Costing Version of Current Standard Cost Estimate CK_TVERS2 NUMC 2 0
PPRDZ Period of Future Standard Cost Estimate CK_PPRDZ NUMC 3 0
PPRDL Period of Current Standard Cost Estimate CK_PPRDL NUMC 3 0
PDATZ Fiscal Year of Future Standard Cost Estimate CK_PDATZ NUMC 4 0
PDATL Fiscal Year of Current Standard Cost Estimate CK_PDATL NUMC 4 0
ZPLPR Future planned price DZPLPR CURR 11 2
FPLPX Fixed Portion of Future Planned Price CK_ZPLPX CURR 11 2
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1 0
X Yes
NULL No
KOSGR Costing Overhead Group CK_KOSGR TCK14 CHAR 10 0
PEINH Price Unit PEINH DEC 5 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
PPRDV Period of Previous Standard Cost Estimate CK_PPRDV NUMC 3 0
PDATV Fiscal Year of Previous Standard Cost Estimate CK_PDATV NUMC 4 0
BWVA3 Valuation Variant for Previous Standard Cost Estimate CK_BWVA3 CHAR 3 0
VERS3 Costing Version of Previous Standard Cost Estimate CK_TVERS3 NUMC 2 0
LPLPR Current Planned Price CK_LPLPR CURR 11 2
LPLPX Fixed Portion of Current Planned Price CK_LPLPX CURR 11 2
BWTTY Valuation Category BWTTY_D CHAR 1 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
VJPEI Price unit of previous year VJPEI DEC 5 0
FBWST Valuation Strategy for Future Planned Price, Special Stock CK_ZBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
LBWST Val. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
VBWST Valuation Strategy for Previous Plan Price, Special Stock CK_VBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
XBEWM Valuation based on the batch-specific unit of measure XBEWW CHAR 1 0
X Yes
NULL No
VPLPR Previous planned price VPLPR CURR 11 2
VPLPX Fixed Portion of Previous Planned Price CK_VPLPX CURR 11 2
LFMON Current period (posting period) LFMON NUMC 2 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
/CWM/XCWMAT Material Is Activated for Catch Weight /CWM/XCWMAT CHAR 1 0
X Yes
NULL No
/CWM/VALUM Valuation Unit of Measure /CWM/VALUM UNIT 3 0

MACK4 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MACK4 KOSGR SYST MANDT TCK14 Overhead Groups MANDT
MACK4 KOSGR RM03M BWKEY TCK14 Overhead Groups BWKEY
MACK4 KOSGR MACK4 KOSGR TCK14 Overhead Groups KOSGR