SAP Table IOGMER

Database structure for goods movement errors - order header

IOGMER (Database structure for goods movement errors - order header) 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 IOGMER to other SAP tables.

IOGMER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
WEBLNR Number of a document from a goods movement with errors WEBLNR CHAR 10 0
WEBLPOS Internal counter CIM_COUNT NUMC 8 0
ERSDA Created On ERSDA DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
LAEDA Date of Last Change LAEDA DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 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 MCH1 CHAR 10 0
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS TCURC CUKY 5 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
ABLAD Unloading Point ABLAD CHAR 25 0
AUFNR Order Number AUFNR AUFK CHAR 12 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
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
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
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Internal counter CIM_COUNT NUMC 8 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
MSGID Application Area ARBGB T100A CHAR 20 0
MSGNO System Message Number MSGNO T100 CHAR 3 0
MSGTY Message Type MSGTY CHAR 1 0
S Message on next screen
I Information
A Cancel
E Error
W Warning
MSGV1 Message variable 01 MSGV1 CHAR 50 0
MSGV2 Message variable 02 MSGV2 CHAR 50 0
MSGV3 Message variable 03 MSGV3 CHAR 50 0
MSGV4 Message variable 04 MSGV4 CHAR 50 0
WABLNR Number of Material Document MBLNR CHAR 10 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
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
FEVOR Production Supervisor FEVOR T024F CHAR 3 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
FWDAT Date when the error first arose CO_FWDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
SMBLN Number of Material Document MBLNR CHAR 10 0
SMBLP Item in Material Document MBLPO NUMC 4 0
SJAHR Material Document Year MJAHR NUMC 4 0
RSART Record type RSART CHAR 1 0
MHDAT SLED/Best-Before Date or Date of Production TMHHD DATS 8 0
DNOTW Indicator: Dialog necessary DNOTW CHAR 1 0
X Yes
NULL No
MJAHR Material Document Year MJAHR NUMC 4 0
MBLPO Item in Material Document MBLPO NUMC 4 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
ERZET Entry time ERZET TIMS 6 0
FWZET Time when the error first arose CO_FWZET TIMS 6 0
PRVBE Production Supply Area PRVBE CHAR 10 0
PRTNR Confirmation number PRTNR NUMC 10 0
REFBLN Reference doc. number for linked entries in AFFW RU_WEBLNR CHAR 10 0
INACT Indicator: Planned confirmation RU_VRMKZ CHAR 1 0
X Yes
NULL No
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
PARBU Clearing company code PARBU CHAR 4 0
GRUND Reason for Movement MB_GRBEW NUMC 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
KUNNR Account Number of Customer EKUNN CHAR 10 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
LINE_ID Unique identification of document line MB_LINE_ID NUMC 6 0
BATCH_TYPE Type of Batch BATCH_TYPE CHAR 1 0
NULL Batch
1 WIP Batch
LICHA Vendor Batch Number LICHN CHAR 15 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
INDEX_NODE Field defined as in SY-TABIX TABIX_D INT4 10 0
MSGTEXT Error Text COWB_ERROR_TEXT CHAR 132 0
KZ_MARK Single-Character Indicator CHAR1 CHAR 1 0

IOGMER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IOGMER AUFNR IOGMER MANDT AUFK Order master data MANDT
IOGMER AUFNR IOGMER AUFNR AUFK Order master data AUFNR
IOGMER BEMOT IOGMER MANDT TBMOT Accounting indicators MANDT
IOGMER BEMOT IOGMER BEMOT TBMOT Accounting indicators BEMOT
IOGMER BWART IOGMER MANDT T156 Movement Type MANDT
IOGMER BWART IOGMER BWART T156 Movement Type BWART
IOGMER CHARG IOGMER CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
IOGMER CHARG IOGMER MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
IOGMER CHARG IOGMER MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
IOGMER DISPO IOGMER MANDT T024D MRP controllers MANDT
IOGMER DISPO IOGMER WERKS T024D MRP controllers WERKS
IOGMER DISPO IOGMER DISPO T024D MRP controllers DISPO
IOGMER ERFME IOGMER MANDT T006 Units of Measurement MANDT
IOGMER ERFME IOGMER ERFME T006 Units of Measurement MSEHI
IOGMER FEVOR IOGMER MANDT T024F Production scheduler MANDT
IOGMER FEVOR IOGMER WERKS T024F Production scheduler WERKS
IOGMER FEVOR IOGMER FEVOR T024F Production scheduler FEVOR
IOGMER KDAUF IOGMER KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
IOGMER KDAUF IOGMER MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
IOGMER LGNUM IOGMER MANDT T300 WM Warehouse Numbers MANDT
IOGMER LGNUM IOGMER LGNUM T300 WM Warehouse Numbers LGNUM
IOGMER LGORT IOGMER MANDT T001L Storage Locations MANDT
IOGMER LGORT IOGMER WERKS T001L Storage Locations WERKS
IOGMER LGORT IOGMER LGORT T001L Storage Locations LGORT
IOGMER LGPLA IOGMER MANDT LAGP Storage bins MANDT
IOGMER LGPLA IOGMER LGNUM LAGP Storage bins LGNUM
IOGMER LGPLA IOGMER LGTYP LAGP Storage bins LGTYP
IOGMER LGPLA IOGMER LGPLA LAGP Storage bins LGPLA
IOGMER LGTYP IOGMER MANDT T301 WM Storage Types MANDT
IOGMER LGTYP IOGMER LGNUM T301 WM Storage Types LGNUM
IOGMER LGTYP IOGMER LGTYP T301 WM Storage Types LGTYP
IOGMER LIFNR IOGMER LIFNR LFA1 Vendor Master (General Section) LIFNR
IOGMER LIFNR IOGMER MANDT LFA1 Vendor Master (General Section) MANDT
IOGMER MATNR IOGMER MANDT MARA General Material Data MANDT
IOGMER MATNR IOGMER MATNR MARA General Material Data MATNR
IOGMER MSGID IOGMER MSGID T100A Message IDs for T100 ARBGB
IOGMER MSGNO IOGMER MSGNO T100 Messages MSGNR
IOGMER MSGNO SYST LANGU T100 Messages SPRSL
IOGMER MSGNO IOGMER MSGID T100 Messages ARBGB
IOGMER SOBKZ IOGMER MANDT T148 Special Stock Indicator MANDT
IOGMER SOBKZ IOGMER SOBKZ T148 Special Stock Indicator SOBKZ
IOGMER WAERS IOGMER MANDT TCURC Currency Codes MANDT
IOGMER WAERS IOGMER WAERS TCURC Currency Codes WAERS
IOGMER WERKS IOGMER MANDT T001W Plants/Branches MANDT
IOGMER WERKS IOGMER WERKS T001W Plants/Branches WERKS