SAP Table MSEG

Document Segment: Material

MSEG (Document Segment: Material) 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 MSEG to other SAP tables.

Table MSEG contains all material document line items. A material document is created whenever a material movement occurs within the organisation. A material document contains a header and one or more line items. Header data is stored in table MKPF. Line items are stored in table MSEG. The link between MKPF and MSEG is made on fields MBLNR and MJAHR

MSEG 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 T156 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 MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHA 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 T148 CHAR 1 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
KUNNR Account Number of Customer EKUNN KNA1 CHAR 10 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
PLPLA Distribution of Differences PLPLA CHAR 10 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS TCURC 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 T149D CHAR 10 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BBPRM T006 UNIT 3 0
EBELN Purchase Order Number BSTNR EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO 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 TGSB CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
PARGB Trading partner's business area PARGB TGSB CHAR 4 0
PARBU Clearing company code PARBU T001 CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 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
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 T001 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 MARA CHAR 18 0
UMWRK Receiving/Issuing Plant UMWRK T001W CHAR 4 0
UMLGO Receiving/Issuing Storage Location UMLGO T001L CHAR 4 0
UMCHA Receiving/Issuing Batch UMCHA MCHA 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 T149D CHAR 10 0
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK T148 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 T300 CHAR 3 0
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA LAGP 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 T333 NUMC 3 0
TBNUM Transfer Requirement Number TBNUM LTBK 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 T157D NUMC 4 0
EVERS Shipping Instructions EVERS T027A CHAR 2 0
EVERE Compliance with Shipping Instructions EVERE T027C 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 AUFK 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 KNA1 CHAR 10 0
FIPOS Commitment Item FIPOS FMFPO CHAR 14 0
SAKTO G/L Account Number SAKNR SKA1 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 before the posting LBKUM_MSEG QUAN 13 3
SALK3 Value of total valuated stock before the posting SALK3_MSEG 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 T006 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 T007A CHAR 2 0
TXJCD Tax Jurisdiction TXJCD TTXJ 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 TBMOT CHAR 2 0
PRZNR Business Process CO_PRZNR CHAR 12 0
LLIEF Supplying Vendor LLIEF CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 0
XOBEW Vendor Stock Valuation Indicator XOBEW CHAR 1 0
X Yes
NULL No
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
ZUSTD_T156M Stock Type Modification (Read from Table T156M) BAMOK_MSEG CHAR 1 0
0 Restricted-Use Stock
1 Unrestricted-Use Stock
2 Stock in Quality Inspection
3 Blocked Stock
L Tied Empties
M Stock Transfer of 'Empties', on Mat. Basis After Val. Basis
W Stock Transfer of 'Empties', on Val. Basis After Mat. Basis
F Unrestricted-Use Stock (T156M-ZUSTD Read with ' ')
SPE_GTS_STOCK_TY GTS Stock Type /SPE/GTS_STOCK_TYPE CHAR 1 0
NULL Normal Stock
1 Temporary Storage Relevant
2 Scrapping Relevant
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
XMACC Multiple Account Assignment XMACC CHAR 1 0
VGART_MKPF Transaction/Event Type VGART CHAR 2 0
BUDAT_MKPF Posting Date in the Document BUDAT DATS 8 0
CPUDT_MKPF Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM_MKPF Time of Entry CPUTM TIMS 6 0
USNAM_MKPF User name USNAM CHAR 12 0
XBLNR_MKPF Reference Document Number XBLNR CHAR 16 0
TCODE2_MKPF Transaction Code TCODE CHAR 20 0
VBELN_IM Delivery VBELN_VL CHAR 10 0
VBELP_IM Delivery Item POSNR_VL NUMC 6 0
/BEV2/ED_KZ_VER Processing Status of Material Document for Excise Duties /BEV2/EDKZ_VER CHAR 1 0
NULL Not Yet Processed
0 Not Tax-Relevant
1 Partially Processed
2 Tax-Relevant
/BEV2/ED_USER User name USNAM CHAR 12 0
/BEV2/ED_AEDAT Changed On AEDAT DATS 8 0
/BEV2/ED_AETIM System Time SYUZEIT TIMS 6 0
/CWM/MENGE Quantity in Parallel Unit of Measure /CWM/MENGE QUAN 13 3
/CWM/MEINS Parallel Unit of Measure /CWM/MEINS UNIT 3 0
/CWM/ERFMG Quantity in Parallel Unit of Entry /CWM/ERFMG QUAN 13 3
/CWM/ERFME PUoM Entry Unit of Measure /CWM/ERFME UNIT 3 0
/CWM/BUSTW Posting string for values BUSTW CHAR 4 0
/CWM/SMBLU Original line in material document URZEI NUMC 4 0
/CWM/FI Dummy for B20 int1 (Local Everywhere) INT1 INT1 3 0
/CWM/TY2TQ Type of Parallel Unit of Measure /CWM/TY2TQ CHAR 1 0
A Parallel Unit of Measure and Valuation Unit of Measure
B Parallel Unit of Measure (BUoM is Valuation Unit of Measure)
C Alternative Parallel Unit of Measure
/CWM/UMTY2TQ Type of Parallel Unit of Measure /CWM/TY2TQ CHAR 1 0
A Parallel Unit of Measure and Valuation Unit of Measure
B Parallel Unit of Measure (BUoM is Valuation Unit of Measure)
C Alternative Parallel Unit of Measure
DISUB_OWNER Owner of stock OWNER_D CHAR 10 0
OINAVNW Non-deductible input tax NAVNW CURR 13 2
OICONDCOD Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 0
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD CHAR 2 0
OIKNUMV Number of the document condition KNUMV CHAR 10 0
OIEXGPTR Exchange partner (vendor number) OIA_EXGPTR CHAR 10 0
OIMATPST Posting rules for material OIA_MATPST CHAR 1 0
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
OIMATIE Material internal / external posting indicator OIA_MATIE CHAR 1 0
NULL Externally-posted material
X Internally-posted material
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIFEETOT Fee total OIA_FEETOT CURR 13 2
OIFEEPST Posting rules for fees OIA_FEEPST CHAR 1 0
1 External
2 Internal
OIFEEDT Fee pricing condition date OIA_FEEDT DATS 8 0
OIMATREF Material group reference for exchange balance reporting OIA_MATREF CHAR 20 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC T008 CHAR 1 0
OIJ1BNFFIM Control Flag for Nota Fiscal creation (Gain/Loss) OIH_J1B_NFFI CHAR 1 0
X Yes
NULL No
OITRKNR Tracking number OIH_TRKNR CHAR 10 0
OITRKJR Tracking number year OIH_TRKJR NUMC 4 0
OIEXTNR External tracking number OIH_EXTNR CHAR 18 0
OIITMNR Tracking number item line OIH_ITMNR NUMC 5 0
OIFTIND Final transfer indicator OIH_FTIND CHAR 1 0
X Final transfer indicator
OIPRIOP Price options for gain calculation OIH_PRIOP CHAR 1 0
1 G/L calculation based on the sending plant (from GI)
2 G/L calculation based on the receiving plant (current)
3 G/L calculation based on the sending plant (at time of GR)
4 G/L calculation based on condition record
OITRIND Transfer sign for plant-to-plant transfers OIH_TRIND CHAR 1 0
NULL SAP standard procedure
1 SAP standard procedure with tracking records for statistics
2 IS-OIL plant to plant transfers with tracking records
OIGHNDL Gain handling OIH_GHNDL CHAR 1 0
NULL Post transit gain only on final transfer
1 Post transit gain when GR > in-transit quantity
OIUMBAR Valuation type of issuing location for two-step transfer OIH_UMBAR T149D CHAR 10 0
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
OIBASVAL Base product value OIA_BASVAL CURR 13 2
OIGLERF Quantity in Unit of Entry ERFMG QUAN 13 3
OIGLSKU Quantity MENGE_D QUAN 13 3
OIGLBPR Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
OIGLBST Goods receipt quantity in order unit MB_BSTMG QUAN 13 3
OIGLCALC Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
OIBBSWQTY Additional Oil and Gas Quantity OIB_ADQNT FLTP 16 16
OIASTBW Reversal movement type XSTBW CHAR 1 0
X Yes
NULL No
OIVBELN Delivery VBELN_VL CHAR 10 0
OIPOSNR Delivery Item POSNR_VL NUMC 6 0
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) OID_PIPEV CHAR 1 0
X Yes
NULL No
OIC_LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
OIC_DCITYC Destination city code OIC_DCITYC T005G CHAR 4 0
OIC_DCOUNC Destination county code OIC_DCOUNC T005E CHAR 3 0
OIC_DREGIO Destination region OIC_DREGIO T005S CHAR 3 0
OIC_DLAND1 Destination country OIC_DLAND1 T005 CHAR 3 0
OIC_OCITYC Origin city code OIC_OCITYC T005G CHAR 4 0
OIC_OCOUNC Origin county code OIC_OCOUNC T005E CHAR 3 0
OIC_OREGIO Origin region OIC_OREGIO T005S CHAR 3 0
OIC_OLAND1 Origin country OIC_OLAND1 T005 CHAR 3 0
OIC_PORGIN Tax origin OIC_PORGIN CHAR 15 0
OIC_PDESTN Tax destination OIC_PDESTN CHAR 15 0
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP CHAR 16 0
OIC_PBATCH Pipeline operator´┐Żs external batch number OIC_PBATCH CHAR 16 0
OIC_MOT IS-OIL MAP external details mode of transport OIC_MOT TVTR CHAR 2 0
OIC_AORGIN Alternate origin OIC_AORGIN CHAR 15 0
OIC_ADESTN Alternate destination OIC_ADESTN CHAR 15 0
OIC_TRUCKN Truck number OIC_TRUCKN CHAR 10 0
OIA_BASELO Base location OIA_BASELO CHAR 15 0
OICERTF1 Excise tax external license number OIH_CERTF1 CHAR 15 0
OIDATFM1 Excise Duty License Valid from Date OIH_DATFM1 DATS 8 0
OIDATTO1 Valid to date for excise duty tax certificate OIH_DATTO1 DATS 8 0
OIH_LICTP License type OIH_LICTP OIH20 CHAR 4 0
OIH_LICIN Excise tax internal license number OIH_LICIN OIHL CHAR 10 0
OIH_LCFOL Follow-on license for quantity license OIH_LCFOL OIHL CHAR 10 0
OIH_FOLQTY Excise Tax Follow-On License Quantity OIH_FOLQTY QUAN 13 3
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OIBOMHEAD BoM header material number OIA_BOMHM CHAR 18 0
OIB_TIMESTAMP Tank dip time stamp OIB_TMSTM NUMC 14 0
OIB_GUID_OPEN GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
OIB_GUID_CLOSE GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
OIB_SOCNR SOC: Storage object characteristic segment number OII_SOCNR CHAR 20 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO OIH4 CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO OIH4 CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0
OITAXGRP Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIINVREC Indicator whether ED pricing is external (not used?) OIH_INVREC CHAR 1 0
X Yes
NULL No
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIFUTDT Future tax date OIH_FUTDT DATS 8 0
OIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8 0
OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQT UNIT 3 0
OITAXQT Excise duty tax quantity in STBME OIH_TAXQT QUAN 13 3
OIFUTQT Future tax quantity OIH_FUTQT QUAN 13 3
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13 3
OITAXGRP2 Excise Duty Group OIH_TAXGRP CHAR 2 0
OIEDBAL_GI Excise Duty Balancing is Required for Mat. (STO) OIH_EDBAL_GI CHAR 1 0
X Yes
NULL No
OIEDBALM_GI Excise Duty Balancing Method Indicator for Mat. (STO) OIH_EDBALM_GI CHAR 1 0
0 Transport & Distribution (TD) is not Active
1 Loading with Vehicle's Status
2 Loading with Customer's Status
OICERTF1_GI Excise Tax External License Number Used During GI (STO) OIH_CERTF1_GI CHAR 15 0
OIDATFM1_GI Excise Duty License Valid from Date for Mat. (STO) OIH_DATFM1_GI DATS 8 0
OIDATTO1_GI Valid To Date for Excise Duty Tax Certificate for Mat. (STO) OIH_DATTO1_GI DATS 8 0
OIH_LICTP_GI License Type to Material (STO) OIH_LICTP_GI OIH20 CHAR 4 0
OIH_LICIN_GI Excise Tax Internal License Number to Mat. (STO) OIH_LICIN_GI OIHL CHAR 10 0
OIH_LCFOL_GI Follow-On License for Quantity License to Mat. (STO) OIH_LCFOL_GI OIHL CHAR 10 0
OIH_FOLQTY_GI Excise Tax Follow-On License Quantity to Mat. (STO) OIH_FOLQTY_GI QUAN 13 3
OIHANTYP_GI Excise Duty Handling Type - Denotes Use of Material OIH_HANTYP_GI CHAR 2 0
OIO_VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
OIO_SPROC Supply Process OIO_SPROC CHAR 4 0

MSEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MSEG ANLN1 MSEG ANLN1 ANLH Main asset number ANLN1
MSEG ANLN1 MSEG MANDT ANLH Main asset number MANDT
MSEG ANLN1 MSEG PARBU ANLH Main asset number BUKRS
MSEG ANLN2 MSEG MANDT ANLA Asset Master Record Segment MANDT
MSEG ANLN2 MSEG PARBU ANLA Asset Master Record Segment BUKRS
MSEG ANLN2 MSEG ANLN1 ANLA Asset Master Record Segment ANLN1
MSEG ANLN2 MSEG ANLN2 ANLA Asset Master Record Segment ANLN2
MSEG AUFNR MSEG MANDT AUFK Order master data MANDT
MSEG AUFNR MSEG AUFNR AUFK Order master data AUFNR
MSEG BEMOT MSEG MANDT TBMOT Accounting indicators MANDT
MSEG BEMOT MSEG BEMOT TBMOT Accounting indicators BEMOT
MSEG BPRME MSEG MANDT T006 Units of Measurement MANDT
MSEG BPRME MSEG BPRME T006 Units of Measurement MSEHI
MSEG BUKRS MSEG MANDT T001 Company Codes MANDT
MSEG BUKRS MSEG BUKRS T001 Company Codes BUKRS
MSEG BWART MSEG MANDT T156 Movement Type MANDT
MSEG BWART MSEG BWART T156 Movement Type BWART
MSEG BWLVS MSEG MANDT T333 WM Movement Types MANDT
MSEG BWLVS MSEG LGNUM T333 WM Movement Types LGNUM
MSEG BWLVS MSEG BWLVS T333 WM Movement Types BWLVS
MSEG BWTAR MSEG MANDT T149D Global Valuation Types MANDT
MSEG BWTAR MSEG BWTAR T149D Global Valuation Types BWTAR
MSEG CHARG MSEG MANDT MCHA Batches MANDT
MSEG CHARG MSEG MATNR MCHA Batches MATNR
MSEG CHARG MSEG WERKS MCHA Batches WERKS
MSEG CHARG MSEG CHARG MCHA Batches CHARG
MSEG EBELN MSEG EBELN EKKO Purchasing Document Header EBELN
MSEG EBELN MSEG MANDT EKKO Purchasing Document Header MANDT
MSEG EBELP MSEG MANDT EKPO Purchasing Document Item MANDT
MSEG EBELP MSEG EBELN EKPO Purchasing Document Item EBELN
MSEG EBELP MSEG EBELP EKPO Purchasing Document Item EBELP
MSEG ERFME MSEG ERFME T006 Units of Measurement MSEHI
MSEG ERFME MSEG MANDT T006 Units of Measurement MANDT
MSEG EVERE MSEG MANDT T027C Codes for Compliance with Shipping Instructions MANDT
MSEG EVERE MSEG EVERS T027C Codes for Compliance with Shipping Instructions EVERS
MSEG EVERE MSEG EVERE T027C Codes for Compliance with Shipping Instructions EVERE
MSEG EVERS MSEG EVERS T027A Shipping Instructions, Purchasing EVERS
MSEG EVERS MSEG MANDT T027A Shipping Instructions, Purchasing MANDT
MSEG FIPOS MSEG FIPOS FMFPO FIFM: Commitment Item FIPOS
MSEG FIPOS MKPF BUDAT FMFPO FIFM: Commitment Item DATBIS
MSEG FIPOS MSEG MANDT FMFPO FIFM: Commitment Item MANDT
MSEG FIPOS T001 FIKRS FMFPO FIFM: Commitment Item FIKRS
MSEG GRUND MSEG MANDT T157D Reason for Movement MANDT
MSEG GRUND MSEG BWART T157D Reason for Movement BWART
MSEG GRUND MSEG GRUND T157D Reason for Movement GRUND
MSEG GSBER MSEG GSBER TGSB Business Areas GSBER
MSEG GSBER MSEG MANDT TGSB Business Areas MANDT
MSEG KDAUF MSEG KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
MSEG KDAUF MSEG MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MSEG KOKRS MSEG MANDT TKA01 Controlling Areas MANDT
MSEG KOKRS MSEG KOKRS TKA01 Controlling Areas KOKRS
MSEG KOSTL MSEG MANDT CSKS Cost Center Master Data MANDT
MSEG KOSTL MSEG KOKRS CSKS Cost Center Master Data KOKRS
MSEG KOSTL MSEG KOSTL CSKS Cost Center Master Data KOSTL
MSEG KOSTL MKPF BUDAT CSKS Cost Center Master Data DATBI
MSEG KUNNR MSEG MANDT KNA1 General Data in Customer Master MANDT
MSEG KUNNR MSEG KUNNR KNA1 General Data in Customer Master KUNNR
MSEG LGNUM MSEG MANDT T300 WM Warehouse Numbers MANDT
MSEG LGNUM MSEG LGNUM T300 WM Warehouse Numbers LGNUM
MSEG LGORT MSEG MANDT T001L Storage Locations MANDT
MSEG LGORT MSEG WERKS T001L Storage Locations WERKS
MSEG LGORT MSEG LGORT T001L Storage Locations LGORT
MSEG LGPLA MSEG MANDT LAGP Storage bins MANDT
MSEG LGPLA MSEG LGNUM LAGP Storage bins LGNUM
MSEG LGPLA MSEG LGTYP LAGP Storage bins LGTYP
MSEG LGPLA MSEG LGPLA LAGP Storage bins LGPLA
MSEG LGTYP MSEG MANDT T301 WM Storage Types MANDT
MSEG LGTYP MSEG LGNUM T301 WM Storage Types LGNUM
MSEG LGTYP MSEG LGTYP T301 WM Storage Types LGTYP
MSEG LIFNR MSEG MANDT LFA1 Vendor Master (General Section) MANDT
MSEG LIFNR MSEG LIFNR LFA1 Vendor Master (General Section) LIFNR
MSEG LSMEH MSEG MANDT T006 Units of Measurement MANDT
MSEG LSMEH MSEG LSMEH T006 Units of Measurement MSEHI
MSEG MATNR MSEG MANDT MARA General Material Data MANDT
MSEG MATNR MSEG MATNR MARA General Material Data MATNR
MSEG MEINS MSEG MANDT T006 Units of Measurement MANDT
MSEG MEINS MSEG MEINS T006 Units of Measurement MSEHI
MSEG MWSKZ DM07M KALSM T007A Tax Keys KALSM
MSEG MWSKZ MSEG MWSKZ T007A Tax Keys MWSKZ
MSEG MWSKZ MSEG MANDT T007A Tax Keys MANDT
MSEG NPLNR MSEG MANDT AUFK Order master data MANDT
MSEG NPLNR MSEG NPLNR AUFK Order master data AUFNR
MSEG OIC_DCITYC MSEG OIC_DCITYC T005G City CITYC
MSEG OIC_DCITYC SYST MANDT T005G City MANDT
MSEG OIC_DCITYC MSEG OIC_DLAND1 T005G City LAND1
MSEG OIC_DCITYC MSEG OIC_DREGIO T005G City REGIO
MSEG OIC_DCOUNC SYST MANDT T005E County MANDT
MSEG OIC_DCOUNC MSEG OIC_DLAND1 T005E County LAND1
MSEG OIC_DCOUNC MSEG OIC_DREGIO T005E County REGIO
MSEG OIC_DCOUNC MSEG OIC_DCOUNC T005E County COUNC
MSEG OIC_DLAND1 SYST MANDT T005 Countries MANDT
MSEG OIC_DLAND1 MSEG OIC_DLAND1 T005 Countries LAND1
MSEG OIC_DREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
MSEG OIC_DREGIO MSEG OIC_DLAND1 T005S Taxes: Region (Province) Key LAND1
MSEG OIC_DREGIO MSEG OIC_DREGIO T005S Taxes: Region (Province) Key BLAND
MSEG OIC_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
MSEG OIC_LIFNR MSEG OIC_LIFNR LFA1 Vendor Master (General Section) LIFNR
MSEG OIC_MOT SYST MANDT TVTR Routes: Modes of Transport MANDT
MSEG OIC_MOT MSEG OIC_MOT TVTR Routes: Modes of Transport VKTRA
MSEG OIC_OCITYC SYST MANDT T005G City MANDT
MSEG OIC_OCITYC MSEG OIC_OLAND1 T005G City LAND1
MSEG OIC_OCITYC MSEG OIC_OREGIO T005G City REGIO
MSEG OIC_OCITYC MSEG OIC_OCITYC T005G City CITYC
MSEG OIC_OCOUNC MSEG OIC_OREGIO T005E County REGIO
MSEG OIC_OCOUNC MSEG OIC_OCOUNC T005E County COUNC
MSEG OIC_OCOUNC SYST MANDT T005E County MANDT
MSEG OIC_OCOUNC MSEG OIC_OLAND1 T005E County LAND1
MSEG OIC_OLAND1 SYST MANDT T005 Countries MANDT
MSEG OIC_OLAND1 MSEG OIC_OLAND1 T005 Countries LAND1
MSEG OIC_OREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
MSEG OIC_OREGIO MSEG OIC_OLAND1 T005S Taxes: Region (Province) Key LAND1
MSEG OIC_OREGIO MSEG OIC_OREGIO T005S Taxes: Region (Province) Key BLAND
MSEG OIHANTYP MSEG MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
MSEG OIHANTYP MSEG OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
MSEG OIH_LCFOL MSEG OIH_LCFOL OIHL License Master Data LICIN
MSEG OIH_LCFOL MSEG OIH_LICTP OIHL License Master Data LICTP
MSEG OIH_LCFOL MSEG MANDT OIHL License Master Data MANDT
MSEG OIH_LCFOL_GI SYST MANDT OIHL License Master Data MANDT
MSEG OIH_LCFOL_GI MSEG OIH_LCFOL_GI OIHL License Master Data LICIN
MSEG OIH_LCFOL_GI MSEG OIH_LICTP_GI OIHL License Master Data LICTP
MSEG OIH_LICIN MSEG OIH_LICIN OIHL License Master Data LICIN
MSEG OIH_LICIN * OIHL License Master Data LICTP
MSEG OIH_LICIN MSEG MANDT OIHL License Master Data MANDT
MSEG OIH_LICIN_GI SYST MANDT OIHL License Master Data MANDT
MSEG OIH_LICIN_GI MSEG OIH_LICIN_GI OIHL License Master Data LICIN
MSEG OIH_LICIN_GI * OIHL License Master Data LICTP
MSEG OIH_LICTP MSEG OIH_LICTP OIH20 License types LICTP
MSEG OIH_LICTP MSEG MANDT OIH20 License types MANDT
MSEG OIH_LICTP_GI SYST MANDT OIH20 License types MANDT
MSEG OIH_LICTP_GI MSEG OIH_LICTP_GI OIH20 License types LICTP
MSEG OINETCYC MSEG MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
MSEG OINETCYC MSEG OINETCYC T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
MSEG OITAXFROM MSEG MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
MSEG OITAXFROM MSEG OITAXFROM OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
MSEG OITAXGRP MSEG MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
MSEG OITAXGRP MSEG OITAXGRP OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
MSEG OITAXTO MSEG MANDT OIH4 Excise duty tax status (IS-Oil TDP standard/core object) MANDT
MSEG OITAXTO MSEG OITAXTO OIH4 Excise duty tax status (IS-Oil TDP standard/core object) TAXKEY
MSEG OIUMBAR MSEG OIUMBAR T149D Global Valuation Types BWTAR
MSEG OIUMBAR SY MANDT T149D Global Valuation Types MANDT
MSEG PARBU MSEG MANDT T001 Company Codes MANDT
MSEG PARBU MSEG PARBU T001 Company Codes BUKRS
MSEG PARGB MSEG MANDT TGSB Business Areas MANDT
MSEG PARGB MSEG PARGB TGSB Business Areas GSBER
MSEG SAKTO MSEG MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
MSEG SAKTO T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
MSEG SAKTO MSEG SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
MSEG SOBKZ MSEG SOBKZ T148 Special Stock Indicator SOBKZ
MSEG SOBKZ MSEG MANDT T148 Special Stock Indicator MANDT
MSEG TBNUM MSEG TBNUM LTBK Transfer requirement header TBNUM
MSEG TBNUM MSEG MANDT LTBK Transfer requirement header MANDT
MSEG TBNUM MSEG LGNUM LTBK Transfer requirement header LGNUM
MSEG TXJCD MSEG MANDT TTXJ Check Table for Tax Jurisdiction MANDT
MSEG TXJCD DM07M KALSM TTXJ Check Table for Tax Jurisdiction KALSM
MSEG TXJCD MSEG TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
MSEG UMBAR MSEG MANDT T149D Global Valuation Types MANDT
MSEG UMBAR MSEG UMBAR T149D Global Valuation Types BWTAR
MSEG UMCHA MSEG UMMAT MCHA Batches MATNR
MSEG UMCHA MSEG UMWRK MCHA Batches WERKS
MSEG UMCHA MSEG UMCHA MCHA Batches CHARG
MSEG UMCHA MSEG MANDT MCHA Batches MANDT
MSEG UMLGO MSEG UMWRK T001L Storage Locations WERKS
MSEG UMLGO MSEG UMLGO T001L Storage Locations LGORT
MSEG UMLGO MSEG MANDT T001L Storage Locations MANDT
MSEG UMMAT MSEG MANDT MARA General Material Data MANDT
MSEG UMMAT MSEG UMMAT MARA General Material Data MATNR
MSEG UMSOK MSEG MANDT T148 Special Stock Indicator MANDT
MSEG UMSOK MSEG UMSOK T148 Special Stock Indicator SOBKZ
MSEG UMWRK MSEG MANDT T001W Plants/Branches MANDT
MSEG UMWRK MSEG UMWRK T001W Plants/Branches WERKS
MSEG VPTNR MSEG VPTNR KNA1 General Data in Customer Master KUNNR
MSEG VPTNR MSEG MANDT KNA1 General Data in Customer Master MANDT
MSEG WAERS MSEG MANDT TCURC Currency Codes MANDT
MSEG WAERS MSEG WAERS TCURC Currency Codes WAERS
MSEG WERKS MSEG WERKS T001W Plants/Branches WERKS
MSEG WERKS MSEG MANDT T001W Plants/Branches MANDT
MSEG ZZREGION SYST MANDT ZREG User Defined Regions MANDT
MSEG ZZREGION MSEG ZZREGION ZREG User Defined Regions ZZREGION
MSEG ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
MSEG ZZSPREG MSEG ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
MSEG ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
MSEG ZZSTATE * T005S Taxes: Region (Province) Key LAND1
MSEG ZZSTATE MSEG ZZSTATE T005S Taxes: Region (Province) Key BLAND
MSEG ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
MSEG ZZUSERFLD1 MSEG ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1