1. Home
  2. Resources
  3. SAP Tables
  4. MWZMSEG - ZMSEG:Interface for Posting of Value

SAP Table MWZMSEG

ZMSEG:Interface for Posting of Value

MWZMSEG (ZMSEG:Interface for Posting of Value) 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 MWZMSEG to other SAP tables.

MWZMSEG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
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
LINE_ID Unique identification of document line MB_LINE_ID NUMC 6 0
PARENT_ID Identifier of immediately superior line MB_PARENT_ID NUMC 6 0
LINE_DEPTH Hierarchy level of line in document MB_LINE_DEPTH NUMC 2 0
MAA_URZEI Original Line for Account Assignment Item in Material Doc. MAA_URZEI NUMC 4 0
BWART Movement Type (Inventory Management) BWART CHAR 3 0
XAUTO Item automatically created MB_XAUTO CHAR 1 0
NULL No automatically created item
X General automatically created item
S Component of a structured material
U Component of a structured material in stock transfer
L Standard tied 'empties' material
M Tied 'empties' in transfer (stocks on a material basis)
W Tied 'empties' in transfer (stocks on a value basis)
F Tied 'empties' (full product managed on a value basis)
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
INSMK Stock Type MB_INSMK CHAR 1 0
X Quality inspection
S Blocked
2 Quality inspection
3 Blocked
NULL Unrestricted-use
F Unrestricted-use
ZUSCH Batch status key DZUSCH CHAR 1 0
ZUSTD Batch in Restricted-Use Stock DZUSTD CHAR 1 0
X Yes
NULL No
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
KUNNR Account Number of Customer EKUNN CHAR 10 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PLPLA Distribution of Differences PLPLA CHAR 10 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS CUKY 5 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
BNBTR Delivery costs in local currency BNBTR CURR 13 2
BUALT Amount posted in alternative price control BUALT CURR 13 2
SHKUM Debit/credit indicator in revaluation SHKUM CHAR 1 0
H Credit
S Debit
DMBUM Revaluation amount on back-posting to a previous period DMBUM CURR 13 2
BWTAR Valuation Type BWTAR_D CHAR 10 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME UNIT 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BBPRM UNIT 3 0
EBELN Purchase Order Number BSTNR CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
LFBJA Fiscal Year of a Reference Document LFBJA NUMC 4 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
SJAHR Material Document Year MJAHR NUMC 4 0
SMBLN Number of Material Document MBLNR CHAR 10 0
SMBLP Item in Material Document MBLPO NUMC 4 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
SGTXT Item Text SGTXT CHAR 50 0
EQUNR Equipment Number EQUNR CHAR 18 0
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
ABLAD Unloading Point ABLAD CHAR 25 0
GSBER Business Area GSBER CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
PARBU Clearing company code PARBU CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
AUFNR Order Number AUFNR CHAR 12 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
XSKST Indicator: Statistical posting to cost center XSKST CHAR 1 0
X Yes
NULL No
XSAUF Indicator: Posting to order is statistical XSAUF CHAR 1 0
X Yes
NULL No
XSPRO Indicator: Posting to project is statistical XSPRO CHAR 1 0
X Yes
NULL No
XSERG Indicator: Posting to prof.analysis is statistical XSERG CHAR 1 0
X Yes
NULL No
GJAHR Fiscal Year GJAHR NUMC 4 0
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1 0
X Yes
NULL No
XRUEJ Indicator: post to previous year XRUEJ CHAR 1 0
X Yes
NULL No
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BELUM Accounting Document Number BELNR_D CHAR 10 0
BUZUM Number of Line Item Within Accounting Document BUZEI NUMC 3 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
PBAMG Quantity MENGE_D QUAN 13 3
KZSTR Transaction/event is relevant to statistics KZSTR CHAR 1 0
NULL Not relevant
2 Document evaluations and standard analyses (update)
3 Standard analyses only (update)
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
UMZST Status of Transfer Batch UMZST CHAR 1 0
UMZUS Status key of transfer batch UMZUS CHAR 1 0
UMBAR Valuation Type of Transfer Batch UMBAR CHAR 10 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
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
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KZZUG Receipt Indicator KZZUG CHAR 1 0
NULL Normal receipt
X Stock transport order
L Tied empties
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
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
BWLVS Movement Type for Warehouse Management BWLVS NUMC 3 0
TBNUM Transfer Requirement Number TBNUM NUMC 10 0
TBPOS Transfer Requirement Item TBPOS NUMC 4 0
XBLVS Indicator: posting in warehouse management system XBLVS CHAR 1 0
X Yes
NULL No
VSCHN Ind: interim storage posting for source stor.type and bin T333_VSCHN CHAR 1 0
X Yes
NULL No
NSCHN Ind.: interim storage posting for dest.stor.type and bin T333_NSCHN CHAR 1 0
X Yes
NULL No
DYPLA Indicator: dynamic storage bin DYPLA CHAR 1 0
X Yes
NULL No
UBNUM Posting Change Number UBNUM NUMC 10 0
TBPRI Transfer Priority TBPRI CHAR 1 0
TANUM Transfer Order Number TANUM NUMC 10 0
WEANZ Number of GR/GI Slips to Be Printed WEANZ NUMC 3 0
GRUND Reason for Movement MB_GRBEW NUMC 4 0
EVERS Shipping Instructions EVERS CHAR 2 0
EVERE Compliance with Shipping Instructions EVERE CHAR 2 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 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
APLZL Internal counter CIM_COUNT NUMC 8 0
AUFPS Order Item Number CO_POSNR NUMC 4 0
VPTNR Partner account number JV_PART CHAR 10 0
FIPOS Commitment Item FIPOS CHAR 14 0
SAKTO G/L Account Number SAKNR CHAR 10 0
BSTMG Goods receipt quantity in order unit MB_BSTMG QUAN 13 3
BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
XWSBR Reversal of GR allowed for GR-based IV despite invoice XWSBR CHAR 1 0
X Yes
NULL No
EMLIF Vendor to be supplied/who is to receive delivery EMLIF CHAR 10 0
EXBWR Externally Entered Posting Amount in Local Currency EXBWR CURR 13 2
VKWRT Value at Sales Prices Including Value-Added Tax VKWRT CURR 13 2
AKTNR Promotion WAKTION CHAR 10 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13 2
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
RSART Record type RSART CHAR 1 0
GEBER Fund BP_GEBER CHAR 10 0
FISTL Funds Center FISTL CHAR 16 0
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
UMMAB Receiving/Issuing Material UMMAT CHAR 18 0
BUSTM Posting string for quantities BUSTM CHAR 4 0
BUSTW Posting string for values BUSTW CHAR 4 0
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
LBKUM Total Valuated Stock LBKUM QUAN 13 3
SALK3 Value of Total Valuated Stock SALK3 CURR 13 2
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
FKBER Functional Area FKBER CHAR 16 0
DABRBZ Reference Date for Settlement DABRBEZ DATS 8 0
VKWRA Value at sales prices excluding value-added tax VKWRA CURR 13 2
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
XBEAU Purchase order created at time of goods receipt XBEAU CHAR 1 0
X Yes
NULL No
LSMNG Quantity in Unit of Measure from Delivery Note LSMNG QUAN 13 3
LSMEH Unit of Measure From Delivery Note LSMEH UNIT 3 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
QINSPST Status of Goods Receipt Inspection QINSPST CHAR 1 0
1 Inspection active (insp. lot created)
2 QM system certified in QINF (no insp. lot)
3 QM system certified for the vendor/manuf. (no insp. lot)
4 Indicator 'No inspection' active in QINF (no insp. lot)
5 Source insp. instead of GR insp. active in QINF (NoInspLot)
6 Insp. lot already created from previous document
7 Inspection lot is created at inbound delivery
8 Inspection Lot for External Inspection Can Be Created
URZEI Original line in material document URZEI NUMC 4 0
J_1BEXBASE Alternate base amount in document currency J_1BEXBASE CURR 13 2
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
J_1AGIRUPD Goods issue revaluation performed J_1AGIRUPD CHAR 1 0
0 Goods issue revaluation not relevant
1 Goods issue revaluation relevant, but not yet performed
2 Goods issue revaluation relevant and already performed
VKMWS Tax on sales/purchases code MWSKZ CHAR 2 0
HSDAT Date of Manufacture HSDAT DATS 8 0
BERKZ Material Staging Indicator for Production Supply BERKZ CHAR 1 0
0 Not relevant for WM
1 Pick list item
2 Crate part
3 Rel.ord.part
4 Manual staging
MAT_KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 0
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
MAT_PSPNR Valuated Sales Order Stock WBS Element MAT_PSPNR NUMC 8 0
XWOFF Calculation of val. open XWOFF CHAR 1 0
X Yes
NULL No
BEMOT Accounting Indicator BEMOT CHAR 2 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0

MWZMSEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MWZMSEG ZZREGION SYST MANDT ZREG User Defined Regions MANDT
MWZMSEG ZZREGION MWZMSEG ZZREGION ZREG User Defined Regions ZZREGION
MWZMSEG ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
MWZMSEG ZZSPREG MWZMSEG ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
MWZMSEG ZZSTATE MWZMSEG ZZSTATE T005S Taxes: Region (Province) Key BLAND
MWZMSEG ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
MWZMSEG ZZSTATE * T005S Taxes: Region (Province) Key LAND1
MWZMSEG ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
MWZMSEG ZZUSERFLD1 MWZMSEG ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1