1. Home
  2. Resources
  3. SAP Tables
  4. MCMSEGADD2 - Material Document Fields (MCPF, MSEG)

SAP Table MCMSEGADD2

Material Document Fields (MCPF, MSEG)

MCMSEGADD2 (Material Document Fields (MCPF, MSEG)) 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 MCMSEGADD2 to other SAP tables.

MCMSEGADD2 table fields

Field Data element Checktable Datatype Length Decimals
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
MENGE Quantity MC_MENG QUAN 15 3
DMBTR Amount in local currency MC_DMBTR CURR 15 2
BNBTR Delivery costs in local currency MC_BNBTR CURR 15 2
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
ABLAD Unloading Point ABLAD CHAR 25 0
GSBER Business Area GSBER TGSB CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 ANLA CHAR 4 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
KZEAR Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
PALAN WMS Number of pallets PALAN DEC 11 0
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 0
LGTYP Storage Type LGTYP CHAR 3 0
LGPLA Storage Bin LGPLA CHAR 10 0
KSTRG Cost Object KSTRG CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
KZZUG Receipt Indicator KZZUG CHAR 1 0
NULL Normal receipt
X Stock transport order
L Tied empties
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
SYDAT System Date SYDATUM DATS 8 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
DMBUM Revaluation amount on back-posting to a previous period DMBUM CURR 13 2
SHKUM Debit/credit indicator in revaluation SHKUM CHAR 1 0
H Credit
S Debit
UMMAT Receiving/Issuing Material UMMAT CHAR 18 0
UMWRK Receiving/Issuing Plant UMWRK CHAR 4 0
UMLGO Receiving/Issuing Storage Location UMLGO CHAR 4 0
UMCHA Receiving/Issuing Batch UMCHA CHAR 10 0
VKWRT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13 2
AKTNR Promotion WAKTION CHAR 10 0
XINVB Generate physical inventory document for material doc. item XINVB CHAR 1 0
X Yes
NULL No
VGART Transaction/Event Type VGART CHAR 2 0
GRUND Reason for goods movment MB_GRUND NUMC 4 0
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
XSTOR Reversal, return delivery, or transfer posting KZSTO CHAR 1 0
NULL Neither return delivery nor reversal
1 Return deliv.(qty can be entered; no gener.of matchcode)
2 Reversal(qty cannot be entered; gener.of matchcode)
3 Transfer posting (qty can be entered; no gener.of matchcode)
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
UMMAB Receiving/Issuing Material UMMAT CHAR 18 0
VKMWS Tax on sales/purchases code MWSKZ CHAR 2 0
SGTXT Item Text SGTXT CHAR 50 0
APLZL Internal counter CIM_COUNT NUMC 8 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0

MCMSEGADD2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MCMSEGADD2 ANLN1 MCMSEG MANDT ANLH Main asset number MANDT
MCMSEGADD2 ANLN1 MCMSEG BUKRS ANLH Main asset number BUKRS
MCMSEGADD2 ANLN1 MCMSEGADD2 ANLN1 ANLH Main asset number ANLN1
MCMSEGADD2 ANLN2 MCMSEGADD2 ANLN1 ANLA Asset Master Record Segment ANLN1
MCMSEGADD2 ANLN2 MCMSEGADD2 ANLN2 ANLA Asset Master Record Segment ANLN2
MCMSEGADD2 ANLN2 MCMSEG MANDT ANLA Asset Master Record Segment MANDT
MCMSEGADD2 ANLN2 MCMSEG BUKRS ANLA Asset Master Record Segment BUKRS
MCMSEGADD2 AUFNR MCMSEG MANDT AUFK Order master data MANDT
MCMSEGADD2 AUFNR MCMSEGADD2 AUFNR AUFK Order master data AUFNR
MCMSEGADD2 BWART MCMSEG MANDT T156 Movement Type MANDT
MCMSEGADD2 BWART MCMSEGADD2 BWART T156 Movement Type BWART
MCMSEGADD2 GSBER MCMSEG MANDT TGSB Business Areas MANDT
MCMSEGADD2 GSBER MCMSEGADD2 GSBER TGSB Business Areas GSBER
MCMSEGADD2 KDAUF MCMSEG DT MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MCMSEGADD2 KDAUF MCMSEGADD2 KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
MCMSEGADD2 KOKRS MCMSEGADD2 KOKRS TKA01 Controlling Areas KOKRS
MCMSEGADD2 KOKRS MCMSEG MANDT TKA01 Controlling Areas MANDT
MCMSEGADD2 KOSTL MCMSEG BUDAT CSKS Cost Center Master Data DATBI
MCMSEGADD2 KOSTL MCMSEG MANDT CSKS Cost Center Master Data MANDT
MCMSEGADD2 KOSTL MCMSEGADD2 KOKRS CSKS Cost Center Master Data KOKRS
MCMSEGADD2 KOSTL MCMSEGADD2 KOSTL CSKS Cost Center Master Data KOSTL