1. Home
  2. Resources
  3. SAP Tables
  4. IMSEG - MMIM: Input Structure for General FM to Post Goods Movement

SAP Table IMSEG

MMIM: Input Structure for General FM to Post Goods Movement

IMSEG (MMIM: Input Structure for General FM to Post Goods Movement) 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 IMSEG to other SAP tables.

IMSEG table fields

Field Data element Checktable Datatype Length Decimals
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
CALLED_BY Clear identification of caller of MB_CREATE_GOODS_MOVEMENT CALLED_BY CHAR 20 0
BEAKZ Line already processed BEAKZ CHAR 1 0
X Yes
NULL No
XNIBU Checkbox XFELD CHAR 1 0
X Yes
NULL No
BWART Movement Type (Inventory Management) BWART CHAR 3 0
RECVSYSTEM Receiving logical system RECVSYSTEM CHAR 10 0
XRERE Reservation reading is mandatory XRERE CHAR 1 0
X Yes
NULL No
XMEVO Propose quantities XMEVO CHAR 1 0
X Yes
NULL No
XWAIT Checkbox XFELD CHAR 1 0
X Yes
NULL No
XNOEQ Checkbox XFELD CHAR 1 0
X Yes
NULL No
XDELIV Create Delivery (Shipping) XDELIV CHAR 1 0
X Yes
NULL No
XNOCON Quantity conversion not necessary XNOCON CHAR 1 0
X Yes
NULL No
XMENGE Quantity not converted for product units XMENGE_PAR CHAR 1 0
X Yes
NULL No
XSTOB Reverse posting indicator XSTOR CHAR 1 0
X Yes
NULL No
XSTOR Reverse posting indicator XSTOR CHAR 1 0
X Yes
NULL No
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)
XWOFF Calculation of val. open XWOFF CHAR 1 0
X Yes
NULL No
XLBTYPE Subcontracting item (PO item or component) MIGO_LBITEM CHAR 1 0
X Yes
NULL No
XZEROQUANTITY Allow Posting of Goods Movement Despite Zero Quantity XZEROQUANTITY CHAR 1 0
X Yes
NULL No
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
SOBKZ Special Stock Indicator SOBKZ 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
KUNNR Account Number of Customer EKUNN KNA1 CHAR 10 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
ERFMG Quantity in Unit of Entry MB_ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG_INPUT QUAN 13 3
BPRME Quantity in Purchase Order Price Unit MB_BPRME T006 UNIT 3 0
EBELN Purchase Order Number BSTNR EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
MIGO_ELIKZ "Delivery Completed" Indicator MIGO_ELIKZ NUMC 1 0
1 Set automatically
2 Set
3 Do not set
SGTXT Item Text SGTXT CHAR 50 0
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
ABLAD Unloading Point ABLAD CHAR 25 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RSART Record type RSART CHAR 1 0
KZEAR Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
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 Batch Trfr Pstg MIGO_UMCHA MCHA CHAR 10 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
ERFMG_ABD Quantity in Unit of Entry for Amount-Based Distribution ERFMG_ABD FLTP 16 16
BPMNG_ABD Qty in Order Price Unit for Amount-Based Distribution BPMNG_ABD FLTP 16 16
BSTMG_ABD Quantity in Order Unit for Amount-Based Distribution BSTMG_ABD FLTP 16 16
XHISTMA Update Multiple Account Assignment EKBE_MA, EKBZ_MA XHISTMA CHAR 1 0
MULKO Indicator: Multiple account assignment MULKO CHAR 1 0
X Yes
NULL No
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
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
KONTO G/L Account Number SAKNR 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 Posting Batch MIGO_UMBAR T149D CHAR 10 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
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
CLASS Class number KLASSE_D CHAR 18 0
UMCLA Class number KLASSE_D CHAR 18 0
XCLAS Checkbox XFELD CHAR 1 0
X Yes
NULL No
UMXCL Checkbox XFELD CHAR 1 0
X Yes
NULL No
OBJNR Object number J_OBJNR CHAR 22 0
BSTMG Goods receipt quantity in order unit MB_BSTMG QUAN 13 3
BSSKZ Special movement indicator for warehouse management LVS_BSSKZ CHAR 1 0
GEBEH Lot Container QGEBEH UNIT 3 0
ANZGEB QM - No. of Containers QANZGEB QUAN 6 3
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
HSDAT Date of Manufacture HSDAT DATS 8 0
LICHA Vendor Batch Number LICHN CHAR 15 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
TXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
VLIEF_AVIS Delivery VBELN_VL CHAR 10 0
VBELP_AVIS Delivery Item POSNR_VL NUMC 6 0
VBELN Delivery VBELN_VL CHAR 10 0
POSNR Delivery Item POSNR_VL NUMC 6 0
ETENS Sequential Number of Vendor Confirmation ETENS NUMC 4 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
GLOBAL_COUNTER Unique number for one line MIGO_GLOBAL_COUNTER NUMC 6 0
LSMNG Quantity in Unit of Measure from Delivery Note LSMNG QUAN 13 3
LSMEH Unit of Measure From Delivery Note LSMEH UNIT 3 0
UPTYP Subitem Category, Purchasing Document UPTYP CHAR 1 0
ANZSN Number of Serial Numbers/Pieces of Equipment to be Created ANZSER INT4 10 0
XSAUT Create serial number automatically XSAUT CHAR 1 0
X Yes
NULL No
REVLV Revision Level REVLV CHAR 2 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
UMCUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
KOSTL Cost Center KOSTL CHAR 10 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 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
NPLNR Network Number for Account Assignment NPLNR AUFK CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
FIPOS Commitment Item FIPOS CHAR 14 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
GEBER Fund BP_GEBER CHAR 10 0
FISTL Funds Center FISTL CHAR 16 0
FKBER Functional Area FKBER CHAR 16 0
LSTAR Activity Type LSTAR CHAR 6 0
PRZNR Business Process CO_PRZNR CHAR 12 0
KSTRG Cost Object KSTRG CHAR 12 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
AUFPS Order Item Number CO_POSNR NUMC 4 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL General counter for order CO_APLZL NUMC 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
EAN11_BME International Article Number (EAN/UPC) in Order Unit EAN11_BME CHAR 18 0
EAN11_KON International Article Number (EAN/UPC) Check EAN11_KON CHAR 18 0
EANME Base Unit of Measure MEINS UNIT 3 0
WEANZ Number of GR/GI Slips to Be Printed WEANZ NUMC 3 0
WEANZX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
R_MBLNR Number of Material Document MBLNR CHAR 10 0
R_MJAHR Material Document Year MJAHR NUMC 4 0
DUMMY3 Checkbox XFELD CHAR 1 0
X Yes
NULL No
BATCH_TYPE Type of Batch BATCH_TYPE CHAR 1 0
NULL Batch
1 WIP Batch
/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/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
WTY_IND Warranty indicator WTYSC_WTY_INDICATOR CHAR 1 0
X TRUE
NULL FALSE
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
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
VPTNR Partner account number JV_PART KNA1 CHAR 10 0
RSHKZ Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BDMNG Requirement Quantity BDMNG QUAN 13 3
ENMNG Quantity Withdrawn ENMNG QUAN 13 3
QPLOS Inspection Lot Number QPLOS QALS NUMC 12 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
QM_ZUSTD Batch status with status changed in QM (internal) QM_ZUSTD CHAR 1 0
QM_UMZST Status of receiv. batch when status changed in QM (intern.) QM_UMZST CHAR 1 0
BWLVS Movement Type for Warehouse Management BWLVS NUMC 3 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
BDTER Requirement Date for the Component BDTER DATS 8 0
TBBEL Material doc. no. of transfer requirement to be cancelled LVS_TBBEL CHAR 10 0
TBBPO Material doc. item of transf.reqmnt item to be cancelled LVS_TBBPO NUMC 4 0
TBBJR Material doc. year of transfer requirement to be cancelled LVS_TBBJR NUMC 4 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
QPLOA Inspection Lot on Which the Usage Decision is Based QPLOA NUMC 12 0
TBPKZ Indicator: No Transfer Requirement Created LVS_TBFKZ CHAR 1 0
X Yes
NULL No
TAFKZ Indicator: do not cal up automatic TO creation LVS_TAFKZ CHAR 1 0
X Yes
NULL No
KZEAR_OLD Final Issue for This Reservation KZEAR CHAR 1 0
X Yes
NULL No
UMLGT Storage type for stock transfer UMLGT CHAR 3 0
UMLGP Storage bin for stock transfer UMLGP CHAR 10 0
MHDAT SLED/Best-Before Date or Date of Production TMHHD DATS 8 0
EXIDV External Handling Unit Identification EXIDV CHAR 20 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
PRVBE Production Supply Area PRVBE CHAR 10 0
KZECH Determination of batch entry in the production/process order KZECH CHAR 1 0
NULL Batch in goods issue; no confirmation required
1 Manual batch determination required upon release of order
2 Batch not required in prod./process order; confirmation reqd
3 Automatic batch determination upon release of order
REFIX Field defined as in SY-TABIX TABIX_D INT4 10 0
ILINR IDoc line item number ILINR NUMC 6 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH UNIT 3 0
ANZL1 Number of Storage Units to be Placed Into Storage LVS_ANZLE DEC 3 0
ANZL2 Number of Storage Units to be Placed Into Storage LVS_ANZLE DEC 3 0
LMEN1 Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMEN QUAN 13 3
LMEN2 Quantity per Storage Unit to be Placed into Stock in Alt.UoM LVS_LEMEN QUAN 13 3
LETY1 Storage Unit Type LVS_LETYP CHAR 3 0
LETY2 Storage Unit Type LVS_LETYP CHAR 3 0
KZKUB Indicator: Do not create posting change notice LVS_KZKUB CHAR 1 0
X Yes
NULL No
UBTYP Storage type for transfer posting UBTYP CHAR 3 0
UBLGP Storage bin for transfer posting UBPLA CHAR 10 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MBLPO Item in Material Document MBLPO NUMC 4 0
MJAHR Material Document Year MJAHR NUMC 4 0
URZEI Original line in material document URZEI NUMC 4 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
KDAUF_SD Sales Order Number KDAUF CHAR 10 0
KDPOS_SD Item Number in Sales Order KDPOS NUMC 6 0
BRGEW Gross weight BRGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI UNIT 3 0
WM_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
WENUM Goods Receipt Number LVS_WENUM CHAR 10 0
KANBA Kanban Indicator KBNKZ CHAR 1 0
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
LFBJA_INTERNAL Fiscal Year of a Reference Document LFBJA NUMC 4 0
LFBNR_INTERNAL Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS_INTERNAL Item of a Reference Document LFPOS NUMC 4 0
UPVOR Subitems Exist UPVOR CHAR 1 0
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
PABNUM JIT Call Number PABNUM CHAR 10 0
PABPOS JIT call item PABPOS NUMC 4 0
PKKEY Identification Number PKKEY NUMC 10 0
PARBU Clearing company code PARBU CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
EXBWR Externally Entered Posting Amount in Local Currency EXBWR CURR 13 2
EXVKW Externally Entered Sales Value in Local Currency EXVKW CURR 13 2
LLIEF Supplying Vendor LLIEF CHAR 10 0
J_1BEXBASE Alternate base amount in document currency J_1BEXBASE CURR 13 2
WEMPFX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
ABLADX Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
OBJTYPE Change indicator OCM_OBJ_TYPE CHAR 1 0
+ Object created
- Object is to be deleted
C Object changed
M Object reassigned
NULL Normal object
0 Zero Object
SPE_GTS_STOCK_TY GTS Stock Type /SPE/GTS_STOCK_TYPE CHAR 1 0
NULL Normal Stock
1 Temporary Storage Relevant
2 Scrapping Relevant
SPE_UM_GTS_ST_TY GTS Stock Type /SPE/GTS_STOCK_TYPE CHAR 1 0
NULL Normal Stock
1 Temporary Storage Relevant
2 Scrapping Relevant
/CWM/SMBLU Original line in material document URZEI NUMC 4 0
/CWM/NOTOLCHECK Checkbox XFELD CHAR 1 0
X Yes
NULL No
/CWM/BDMNG Requirement Quantity BDMNG QUAN 13 3
/CWM/ENMNG Quantity Withdrawn ENMNG QUAN 13 3
DISUB_OWNER Owner of stock OWNER_D CHAR 10 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OILFKNUM Delivery note reference for fee doc. conditions OIA_LFKNUM CHAR 10 0
OILFPOS Reference delivery note item OIA_LFPOS NUMC 6 0
OIMATREF Material group reference for exchange balance reporting OIA_MATREF CHAR 20 0
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
OIBOMHEAD BoM header material number OIA_BOMHM CHAR 18 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIA_ZEILE Item in Material Document MBLPO NUMC 4 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
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
OIB_ZEILE Item in Material Document MBLPO NUMC 4 0
OIB_ZEILE_CHECK Item in Material Document MBLPO NUMC 4 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
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIFULTAX Excise duty tax value at the full rate OIH_FULTAX CURR 13 2
OITXVAL0 Excise duty tax value 0 OIH_TXVAL0 CURR 13 2
OITXVAL1 Excise duty tax value 1 OIH_TXVAL1 CURR 13 2
OITXVAL2 Excise duty tax value 2 OIH_TXVAL2 CURR 13 2
OITXVAL3 Excise duty tax value 3 OIH_TXVAL3 CURR 13 2
OITXVAL4 Excise duty tax value 4 OIH_TXVAL4 CURR 13 2
OITXVAL5 Excise duty tax value 5 OIH_TXVAL5 CURR 13 2
OITXVAL6 Excise duty tax value 6 OIH_TXVAL6 CURR 13 2
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OITAXCON Excise duty tax from pricing conditions OIH_TAXCON CURR 13 2
OITAXVAL Excise duty value in material inventory account OIH_TAXVAL CURR 13 2
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5 2
0 Range of permissible values for Mineral Oil Content %
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
OIFUTTX Future tax value OIH_FUTTX CURR 13 2
OIFUTDT Future tax date OIH_FUTDT DATS 8 0
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13 3
OIFUTTX2 Future tax value 2 OIH_FUTTX2 CURR 13 2
OIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8 0
OIEDOK Excise duty validation indicator OIH_EDOK CHAR 1 0
X Yes
NULL No
OIEDBAL Excise duty balancing is required (indicator) OIH_EDBAL CHAR 1 0
X Yes
NULL No
OIEDBALM Excise duty balancing method indicator OIH_EDBALM CHAR 1 0
0 Transport & Distribution (TD) is not Active
1 Loading with Vehicle's Status
2 Loading with Customer's Status
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
OIEDOK_GI Excise Duty Validation Indicator for Material (STO) OIH_EDOK_GI CHAR 1 0
X Yes
NULL No
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 OIH5 CHAR 2 0
OITAXGRP_GI Excise Duty Group OIH_TAXGRP OIH2 CHAR 2 0
OIINEX_GI Code for Internal or External Excise Duty Rate Determination OIH_INEX_GI OIH16 CHAR 2 0
OITAXFROM_GI Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO_GI Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0

IMSEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IMSEG AUFNR SY MANDT AUFK Order master data MANDT
IMSEG AUFNR IMSEG AUFNR AUFK Order master data AUFNR
IMSEG BEMOT SYST MANDT TBMOT Accounting indicators MANDT
IMSEG BEMOT IMSEG BEMOT TBMOT Accounting indicators BEMOT
IMSEG BPRME SY MANDT T006 Units of Measurement MANDT
IMSEG BPRME IMSEG BPRME T006 Units of Measurement MSEHI
IMSEG BWTAR SY MANDT T149D Global Valuation Types MANDT
IMSEG BWTAR IMSEG BWTAR T149D Global Valuation Types BWTAR
IMSEG CHARG SY MANDT MCHA Batches MANDT
IMSEG CHARG IMSEG MATNR MCHA Batches MATNR
IMSEG CHARG IMSEG WERKS MCHA Batches WERKS
IMSEG CHARG IMSEG CHARG MCHA Batches CHARG
IMSEG EBELN SY MANDT EKKO Purchasing Document Header MANDT
IMSEG EBELN IMSEG EBELN EKKO Purchasing Document Header EBELN
IMSEG EBELP IMSEG EBELN EKPO Purchasing Document Item EBELN
IMSEG EBELP IMSEG EBELP EKPO Purchasing Document Item EBELP
IMSEG EBELP SY MANDT EKPO Purchasing Document Item MANDT
IMSEG ERFME SY MANDT T006 Units of Measurement MANDT
IMSEG ERFME IMSEG ERFME T006 Units of Measurement MSEHI
IMSEG EVERE SY MANDT T027C Codes for Compliance with Shipping Instructions MANDT
IMSEG EVERE IMSEG EVERS T027C Codes for Compliance with Shipping Instructions EVERS
IMSEG EVERE IMSEG EVERE T027C Codes for Compliance with Shipping Instructions EVERE
IMSEG EVERS SY MANDT T027A Shipping Instructions, Purchasing MANDT
IMSEG EVERS IMSEG EVERS T027A Shipping Instructions, Purchasing EVERS
IMSEG GRUND SY MANDT T157D Reason for Movement MANDT
IMSEG GRUND IMSEG BWART T157D Reason for Movement BWART
IMSEG GRUND IMSEG GRUND T157D Reason for Movement GRUND
IMSEG KDAUF SY MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
IMSEG KDAUF IMSEG KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
IMSEG KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
IMSEG KUNNR IMSEG KUNNR KNA1 General Data in Customer Master KUNNR
IMSEG LGNUM SY MANDT T300 WM Warehouse Numbers MANDT
IMSEG LGNUM IMSEG LGNUM T300 WM Warehouse Numbers LGNUM
IMSEG LGORT SY MANDT T001L Storage Locations MANDT
IMSEG LGORT IMSEG WERKS T001L Storage Locations WERKS
IMSEG LGORT IMSEG LGORT T001L Storage Locations LGORT
IMSEG LGPLA SY MANDT LAGP Storage bins MANDT
IMSEG LGPLA IMSEG LGNUM LAGP Storage bins LGNUM
IMSEG LGPLA IMSEG LGTYP LAGP Storage bins LGTYP
IMSEG LGPLA IMSEG LGPLA LAGP Storage bins LGPLA
IMSEG LGTYP SY MANDT T301 WM Storage Types MANDT
IMSEG LGTYP IMSEG LGNUM T301 WM Storage Types LGNUM
IMSEG LGTYP IMSEG LGTYP T301 WM Storage Types LGTYP
IMSEG MATNR SY MANDT MARA General Material Data MANDT
IMSEG MATNR IMSEG MATNR MARA General Material Data MATNR
IMSEG MWSKZ SY MANDT T007A Tax Keys MANDT
IMSEG MWSKZ IMSEG KALSM T007A Tax Keys KALSM
IMSEG MWSKZ IMSEG MWSKZ T007A Tax Keys MWSKZ
IMSEG NPLNR SY MANDT AUFK Order master data MANDT
IMSEG NPLNR IMSEG NPLNR AUFK Order master data AUFNR
IMSEG OIC_DCITYC IMSEG OIC_DCITYC T005G City CITYC
IMSEG OIC_DCITYC SYST MANDT T005G City MANDT
IMSEG OIC_DCITYC IMSEG OIC_DLAND1 T005G City LAND1
IMSEG OIC_DCITYC IMSEG OIC_DREGIO T005G City REGIO
IMSEG OIC_DCOUNC SYST MANDT T005E County MANDT
IMSEG OIC_DCOUNC IMSEG OIC_DLAND1 T005E County LAND1
IMSEG OIC_DCOUNC IMSEG OIC_DREGIO T005E County REGIO
IMSEG OIC_DCOUNC IMSEG OIC_DCOUNC T005E County COUNC
IMSEG OIC_DLAND1 SYST MANDT T005 Countries MANDT
IMSEG OIC_DLAND1 IMSEG OIC_DLAND1 T005 Countries LAND1
IMSEG OIC_DREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
IMSEG OIC_DREGIO IMSEG OIC_DLAND1 T005S Taxes: Region (Province) Key LAND1
IMSEG OIC_DREGIO IMSEG OIC_DREGIO T005S Taxes: Region (Province) Key BLAND
IMSEG OIC_LIFNR IMSEG OIC_LIFNR LFA1 Vendor Master (General Section) LIFNR
IMSEG OIC_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
IMSEG OIC_MOT SYST MANDT TVTR Routes: Modes of Transport MANDT
IMSEG OIC_MOT IMSEG OIC_MOT TVTR Routes: Modes of Transport VKTRA
IMSEG OIC_OCITYC SYST MANDT T005G City MANDT
IMSEG OIC_OCITYC IMSEG OIC_OLAND1 T005G City LAND1
IMSEG OIC_OCITYC IMSEG OIC_OREGIO T005G City REGIO
IMSEG OIC_OCITYC IMSEG OIC_OCITYC T005G City CITYC
IMSEG OIC_OCOUNC IMSEG OIC_OLAND1 T005E County LAND1
IMSEG OIC_OCOUNC IMSEG OIC_OREGIO T005E County REGIO
IMSEG OIC_OCOUNC IMSEG OIC_OCOUNC T005E County COUNC
IMSEG OIC_OCOUNC SYST MANDT T005E County MANDT
IMSEG OIC_OLAND1 SYST MANDT T005 Countries MANDT
IMSEG OIC_OLAND1 IMSEG OIC_OLAND1 T005 Countries LAND1
IMSEG OIC_OREGIO IMSEG OIC_OREGIO T005S Taxes: Region (Province) Key BLAND
IMSEG OIC_OREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
IMSEG OIC_OREGIO IMSEG OIC_OLAND1 T005S Taxes: Region (Province) Key LAND1
IMSEG OIHANTYP_GI SYST MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
IMSEG OIHANTYP_GI IMSEG OIHANTYP_GI OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
IMSEG OIH_LCFOL MSEG MANDT OIHL License Master Data MANDT
IMSEG OIH_LCFOL IMSEG OIH_LCFOL OIHL License Master Data LICIN
IMSEG OIH_LCFOL IMSEG OIH_LICTP OIHL License Master Data LICTP
IMSEG OIH_LCFOL_GI SYST MANDT OIHL License Master Data MANDT
IMSEG OIH_LCFOL_GI IMSEG OIH_LCFOL_GI OIHL License Master Data LICIN
IMSEG OIH_LCFOL_GI IMSEG OIH_LICTP_GI OIHL License Master Data LICTP
IMSEG OIH_LICIN MSEG MANDT OIHL License Master Data MANDT
IMSEG OIH_LICIN IMSEG OIH_LICIN OIHL License Master Data LICIN
IMSEG OIH_LICIN * OIHL License Master Data LICTP
IMSEG OIH_LICIN_GI SYST MANDT OIHL License Master Data MANDT
IMSEG OIH_LICIN_GI IMSEG OIH_LICIN_GI OIHL License Master Data LICIN
IMSEG OIH_LICIN_GI * OIHL License Master Data LICTP
IMSEG OIH_LICTP MSEG MANDT OIH20 License types MANDT
IMSEG OIH_LICTP IMSEG OIH_LICTP OIH20 License types LICTP
IMSEG OIH_LICTP_GI SYST MANDT OIH20 License types MANDT
IMSEG OIH_LICTP_GI IMSEG OIH_LICTP_GI OIH20 License types LICTP
IMSEG OIINEX_GI SYST MANDT OIH16 Internal/external price conditions MANDT
IMSEG OIINEX_GI IMSEG OIINEX_GI OIH16 Internal/external price conditions INEX
IMSEG OITAXGRP_GI IMSEG OITAXGRP_GI OIH2 Excise duty tax group (IS-Oil TDP standard/core object) TAXGRP
IMSEG OITAXGRP_GI SYST MANDT OIH2 Excise duty tax group (IS-Oil TDP standard/core object) MANDT
IMSEG OIUMBAR SY MANDT T149D Global Valuation Types MANDT
IMSEG OIUMBAR IMSEG OIUMBAR T149D Global Valuation Types BWTAR
IMSEG PS_PSP_PNR SY MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
IMSEG PS_PSP_PNR IMSEG PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
IMSEG QPLOS SY MANDT QALS Inspection lot record MANDANT
IMSEG QPLOS IMSEG QPLOS QALS Inspection lot record PRUEFLOS
IMSEG SOBKZ SY MANDT T148 Special Stock Indicator MANDT
IMSEG SOBKZ IMSEG SOBKZ T148 Special Stock Indicator SOBKZ
IMSEG TXJCD SY MANDT TTXJ Check Table for Tax Jurisdiction MANDT
IMSEG TXJCD IMSEG KALSM TTXJ Check Table for Tax Jurisdiction KALSM
IMSEG TXJCD IMSEG TXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
IMSEG UMBAR SY MANDT T149D Global Valuation Types MANDT
IMSEG UMBAR IMSEG UMBAR T149D Global Valuation Types BWTAR
IMSEG UMCHA IMSEG UMMAT MCHA Batches MATNR
IMSEG UMCHA IMSEG UMWRK MCHA Batches WERKS
IMSEG UMCHA IMSEG UMCHA MCHA Batches CHARG
IMSEG UMCHA SY MANDT MCHA Batches MANDT
IMSEG UMLGO SY MANDT T001L Storage Locations MANDT
IMSEG UMLGO IMSEG UMWRK T001L Storage Locations WERKS
IMSEG UMLGO IMSEG UMLGO T001L Storage Locations LGORT
IMSEG UMMAT SY MANDT MARA General Material Data MANDT
IMSEG UMMAT IMSEG UMMAT MARA General Material Data MATNR
IMSEG UMWRK SY MANDT T001W Plants/Branches MANDT
IMSEG UMWRK IMSEG UMWRK T001W Plants/Branches WERKS
IMSEG VPTNR IMSEG VPTNR KNA1 General Data in Customer Master KUNNR
IMSEG VPTNR SY MANDT KNA1 General Data in Customer Master MANDT
IMSEG WAERS SY MANDT TCURC Currency Codes MANDT
IMSEG WAERS IMSEG WAERS TCURC Currency Codes WAERS
IMSEG WERKS IMSEG WERKS T001W Plants/Branches WERKS
IMSEG WERKS SY MANDT T001W Plants/Branches MANDT
IMSEG ZZREGION SYST MANDT ZREG User Defined Regions MANDT
IMSEG ZZREGION IMSEG ZZREGION ZREG User Defined Regions ZZREGION
IMSEG ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
IMSEG ZZSPREG IMSEG ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
IMSEG ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
IMSEG ZZSTATE * T005S Taxes: Region (Province) Key LAND1
IMSEG ZZSTATE IMSEG ZZSTATE T005S Taxes: Region (Province) Key BLAND
IMSEG ZZUSERFLD1 IMSEG ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
IMSEG ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT