Follow us on LinkedIn for your next SAP project

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 Possible values
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
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
ZUSCH
Batch status key
DZUSCH
CHAR
1 0
ZUSTD
Batch in Restricted-Use Stock
DZUSTD
CHAR
1 0
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
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
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
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
XSAUF
Indicator: Posting to order is statistical
XSAUF
CHAR
1 0
XSPRO
Indicator: Posting to project is statistical
XSPRO
CHAR
1 0
XSERG
Indicator: Posting to prof.analysis is statistical
XSERG
CHAR
1 0
GJAHR
Fiscal Year
GJAHR
NUMC
4 0
XRUEM
Allow Posting to Previous Period (Backposting)
XRUEM
CHAR
1 0
XRUEJ
Indicator: post to previous year
XRUEJ
CHAR
1 0
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
PBAMG
Quantity
MENGE_D
QUAN
13 3
KZSTR
Transaction/event is relevant to statistics
KZSTR
CHAR
1 0
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
KZVBR
Consumption Posting
KZVBR
CHAR
1 0
KZZUG
Receipt Indicator
KZZUG
CHAR
1 0
WEUNB
Goods Receipt, Non-Valuated
WEUNB
CHAR
1 0
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
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
VSCHN
Ind: interim storage posting for source stor.type and bin
T333_VSCHN
CHAR
1 0
NSCHN
Ind.: interim storage posting for dest.stor.type and bin
T333_NSCHN
CHAR
1 0
DYPLA
Indicator: dynamic storage bin
DYPLA
CHAR
1 0
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
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
WERTU
Value Update in Material Master Record
WERTU
CHAR
1 0
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
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
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
QINSPST
Status of Goods Receipt Inspection
QINSPST
CHAR
1 0
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
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
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
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
GRANT_NBR
Grant
GM_GRANT_NBR
CHAR
20 0
ZUSTD_T156M
Stock Type Modification (Read from Table T156M)
BAMOK_MSEG
CHAR
1 0
SPE_GTS_STOCK_TY
GTS Stock Type
/SPE/GTS_STOCK_TYPE
CHAR
1 0
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
/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
/CWM/UMTY2TQ
Type of Parallel Unit of Measure
/CWM/TY2TQ
CHAR
1 0
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
OIMATIE
Material internal / external posting indicator
OIA_MATIE
CHAR
1 0
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
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
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
OIPRIOP
Price options for gain calculation
OIH_PRIOP
CHAR
1 0
OITRIND
Transfer sign for plant-to-plant transfers
OIH_TRIND
CHAR
1 0
OIGHNDL
Gain handling
OIH_GHNDL
CHAR
1 0
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
OIBBSWQTY
Additional Oil and Gas Quantity
OIB_ADQNT
FLTP
16 16
OIASTBW
Reversal movement type
XSTBW
CHAR
1 0
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
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
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
OIINVREC
Indicator whether ED pricing is external (not used?)
OIH_INVREC
CHAR
1 0
OIOILCON
Oil content in a material as a percentage
OIH_OILCON
DEC
5 2
OIOILCON2
Oil content of a material as a percentage (2)
OIH_OILCN2
DEC
5 2
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
OIEDBALM_GI
Excise Duty Balancing Method Indicator for Mat. (STO)
OIH_EDBALM_GI
CHAR
1 0
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 BWART T156
Movement Type
BWART
MSEG BWART MSEG MANDT T156
Movement Type
MANDT
MSEG BWLVS MSEG LGNUM T333
WM Movement Types
LGNUM
MSEG BWLVS MSEG BWLVS T333
WM Movement Types
BWLVS
MSEG BWLVS MSEG MANDT T333
WM Movement Types
MANDT
MSEG BWTAR MSEG BWTAR T149D
Global Valuation Types
BWTAR
MSEG BWTAR MSEG MANDT T149D
Global Valuation Types
MANDT
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 MANDT T006
Units of Measurement
MANDT
MSEG ERFME MSEG ERFME T006
Units of Measurement
MSEHI
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 MANDT T027A
Shipping Instructions, Purchasing
MANDT
MSEG EVERS MSEG EVERS T027A
Shipping Instructions, Purchasing
EVERS
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 MANDT TGSB
Business Areas
MANDT
MSEG GSBER MSEG GSBER TGSB
Business Areas
GSBER
MSEG KDAUF MSEG MANDT VBUK
Sales Document: Header Status and Administrative Data
MANDT
MSEG KDAUF MSEG KDAUF VBUK
Sales Document: Header Status and Administrative Data
VBELN
MSEG KOKRS MSEG KOKRS TKA01
Controlling Areas
KOKRS
MSEG KOKRS MSEG MANDT TKA01
Controlling Areas
MANDT
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 LGNUM T300
WM Warehouse Numbers
LGNUM
MSEG LGNUM MSEG MANDT T300
WM Warehouse Numbers
MANDT
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 MEINS T006
Units of Measurement
MSEHI
MSEG MEINS MSEG MANDT T006
Units of Measurement
MANDT
MSEG MWSKZ MSEG MANDT T007A
Tax Keys
MANDT
MSEG MWSKZ DM07M KALSM T007A
Tax Keys
KALSM
MSEG MWSKZ MSEG MWSKZ T007A
Tax Keys
MWSKZ
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 MSEG OIC_MOT TVTR
Routes: Modes of Transport
VKTRA
MSEG OIC_MOT SYST MANDT TVTR
Routes: Modes of Transport
MANDT
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 SY MANDT T149D
Global Valuation Types
MANDT
MSEG OIUMBAR MSEG OIUMBAR T149D
Global Valuation Types
BWTAR
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 MANDT T148
Special Stock Indicator
MANDT
MSEG SOBKZ MSEG SOBKZ T148
Special Stock Indicator
SOBKZ
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 MSEG ZZREGION ZREG
User Defined Regions
ZZREGION
MSEG ZZREGION SYST MANDT ZREG
User Defined Regions
MANDT
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