SAP Table MCBESTADD2

Characteristics for Updating in Inventory Controlling

MCBESTADD2 (Characteristics for Updating in Inventory Controlling) 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 MCBESTADD2 to other SAP tables.

Source: MCBESTADD2 (Characteristics for Updating in Inventory Controlling)

MCBESTADD2 table fields

Field Data element Checktable Datatype Length Decimals
WAERS Local Currency HWAER TCURC CUKY 5 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
MTART Material Type MTART T134 CHAR 4 0
MATKL Material Group MATKL T023 CHAR 9 0
DISMM MRP Type DISMM T438A CHAR 2 0
GSBER Business Area GSBER TGSB CHAR 4 0
SPART Division SPART TSPA CHAR 2 0
BKLAS Valuation Class BKLAS T025 CHAR 4 0
SAKTO G/L Account Number SAKNR CHAR 10 0
PRDHA Product hierarchy PRODH_D T179 CHAR 18 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
SUPKZ Statistics update indicator (post in/post out) SUPKZ CHAR 1 0
1 Old status: charge off (negative posting)
2 New status: record
3 Standard item in a return (SD only)
0 Returns item in standard order (SD only)
LBKUM_VZ +/- sign for delta posting LBKUM LBKUM_VZ CHAR 1 0
SALK3_VZ +/- sign for delta posting SALK3 SALK3_VZ CHAR 1 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
SYDAT System Date SYDATUM DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
EKLAS Valuation Class for Sales Order Stock EKLAS CHAR 4 0
QKLAS Valuation Class for Project Stock QKLAS CHAR 4 0
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No

MCBESTADD2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCBESTADD2 BKLAS MCBEST MANDT T025 Valuation Classes MANDT
MCBESTADD2 BKLAS MCBESTADD2 BKLAS T025 Valuation Classes BKLAS
MCBESTADD2 BUKRS MCBEST MANDT T001 Company Codes MANDT
MCBESTADD2 BUKRS MCBESTADD2 BUKRS T001 Company Codes BUKRS
MCBESTADD2 DISMM MCBEST MANDT T438A MRP Type MANDT
MCBESTADD2 DISMM MCBESTADD2 DISMM T438A MRP Type DISMM
MCBESTADD2 DISPO MCBEST MANST T024D MRP controllers MANDT
MCBESTADD2 DISPO MCBEST WERKS T024D MRP controllers WERKS
MCBESTADD2 DISPO MCBESTADD2 DISPO T024D MRP controllers DISPO
MCBESTADD2 GSBER MCBESTADD2 GSBER TGSB Business Areas GSBER
MCBESTADD2 GSBER MCMCBEST DT MANDT TGSB Business Areas MANDT
MCBESTADD2 KOKRS MCBEST MANDT TKA01 Controlling Areas MANDT
MCBESTADD2 KOKRS MCBESTADD2 KOKRS TKA01 Controlling Areas KOKRS
MCBESTADD2 MATKL MCBEST MANDT T023 Material Groups MANDT
MCBESTADD2 MATKL MCBESTADD2 MATKL T023 Material Groups MATKL
MCBESTADD2 MEINS MCBEST MANDT T006 Units of Measurement MANDT
MCBESTADD2 MEINS MCBESTADD2 MEINS T006 Units of Measurement MSEHI
MCBESTADD2 MTART MCBESTADD2 MTART T134 Material Types MTART
MCBESTADD2 MTART MCBEST MANDT T134 Material Types MANDT
MCBESTADD2 PRCTR MCBEST MANDT CEPC Profit Center Master Data Table MANDT
MCBESTADD2 PRCTR MCBESTADD2 PRCTR CEPC Profit Center Master Data Table PRCTR
MCBESTADD2 PRCTR MCBESTADD2 BUDAT CEPC Profit Center Master Data Table DATBI
MCBESTADD2 PRCTR MCBESTADD2 KOKRS CEPC Profit Center Master Data Table KOKRS
MCBESTADD2 PRDHA MCBESTADD2 PRDHA T179 Materials: Product Hierarchies PRODH
MCBESTADD2 PRDHA MCBEST MANDT T179 Materials: Product Hierarchies MANDT
MCBESTADD2 SPART MCBESTADD2 SPART TSPA Organizational Unit: Sales Divisions SPART
MCBESTADD2 SPART MCBEST MANDT TSPA Organizational Unit: Sales Divisions MANDT
MCBESTADD2 WAERS MCBESTADD2 WAERS TCURC Currency Codes WAERS
MCBESTADD2 WAERS MCBEST MANDT TCURC Currency Codes MANDT