1. Home
  2. Resources
  3. SAP Tables
  4. OIAQB - Exchange Movements Index

SAP Table OIAQB

Exchange Movements Index

OIAQB (Exchange Movements Index) 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 OIAQB to other SAP tables.

Source: OIAQB (Exchange Movements Index)

OIAQB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OIEXGPTR Exchange partner (vendor number) OIA_EXGPTR CHAR 10 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
SPMON Period to analyze - month SPMON NUMC 6 0
SPTAG Period to analyze - current date SPTAG DATS 8 0
SPWOC Period to analyze - week SPWOC NUMC 6 0
SPBUP Period to analyze - posting period SPBUP NUMC 6 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIMATREF Material group reference for exchange balance reporting OIA_MATREF CHAR 20 0
MATNR Material Number MATNR CHAR 18 0
OIBASPROD Base product number OIA_SBMAT CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item number OIA_ITEM NUMC 6 0
ITEM_TYPE LIA item type OIA_UPEITM CHAR 1 0
1 Book receipt
2 Book delivery
3 Negotiated payment
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
OIASTBW Reversal movement type XSTBW CHAR 1 0
X Yes
NULL No
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
OIVBELN Delivery VBELN_VL CHAR 10 0
OIPOSNR Delivery Item POSNR_VL NUMC 6 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
CLRNO Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 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
CLRNO1 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO2 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO3 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO4 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO5 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO6 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO7 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO8 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
CLRNO9 Doc. number of the netting document clearing the item/cycle OIA_CLRNO CHAR 10 0
PDUMMY Dummy function in length 1 DUMMY CHAR 1 0
OID_EXTBOL External bill of lading OID_EXTBOL CHAR 16 0
OID_MISCDL Miscellaneous delivery number OID_MISCDL CHAR 16 0
NOCYC1 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC2 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC3 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC4 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC5 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC6 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC7 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC8 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on
NOCYC9 Invoice cycle not used indicator OIA_NOCYC CHAR 1 0
NULL Entry not selected / not active / function switched off
X Entry selected / active / function switched on

OIAQB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIAQB OIC_DCITYC SYST MANDT T005G City MANDT
OIAQB OIC_DCITYC OIAQB OIC_DLAND1 T005G City LAND1
OIAQB OIC_DCITYC OIAQB OIC_DREGIO T005G City REGIO
OIAQB OIC_DCITYC OIAQB OIC_DCITYC T005G City CITYC
OIAQB OIC_DCOUNC OIAQB OIC_DCOUNC T005E County COUNC
OIAQB OIC_DCOUNC OIAQB OIC_DREGIO T005E County REGIO
OIAQB OIC_DCOUNC OIAQB OIC_DLAND1 T005E County LAND1
OIAQB OIC_DCOUNC SYST MANDT T005E County MANDT
OIAQB OIC_DLAND1 OIAQB OIC_DLAND1 T005 Countries LAND1
OIAQB OIC_DLAND1 SYST MANDT T005 Countries MANDT
OIAQB OIC_DREGIO OIAQB OIC_DLAND1 T005S Taxes: Region (Province) Key LAND1
OIAQB OIC_DREGIO OIAQB OIC_DREGIO T005S Taxes: Region (Province) Key BLAND
OIAQB OIC_DREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT
OIAQB OIC_LIFNR OIAQB OIC_LIFNR LFA1 Vendor Master (General Section) LIFNR
OIAQB OIC_LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
OIAQB OIC_MOT OIAQB OIC_MOT TVTR Routes: Modes of Transport VKTRA
OIAQB OIC_MOT SYST MANDT TVTR Routes: Modes of Transport MANDT
OIAQB OIC_OCITYC OIAQB OIC_OCITYC T005G City CITYC
OIAQB OIC_OCITYC OIAQB OIC_OREGIO T005G City REGIO
OIAQB OIC_OCITYC OIAQB OIC_OLAND1 T005G City LAND1
OIAQB OIC_OCITYC SYST MANDT T005G City MANDT
OIAQB OIC_OCOUNC SYST MANDT T005E County MANDT
OIAQB OIC_OCOUNC OIAQB OIC_OLAND1 T005E County LAND1
OIAQB OIC_OCOUNC OIAQB OIC_OREGIO T005E County REGIO
OIAQB OIC_OCOUNC OIAQB OIC_OCOUNC T005E County COUNC
OIAQB OIC_OLAND1 SYST MANDT T005 Countries MANDT
OIAQB OIC_OLAND1 OIAQB OIC_OLAND1 T005 Countries LAND1
OIAQB OIC_OREGIO OIAQB OIC_OREGIO T005S Taxes: Region (Province) Key BLAND
OIAQB OIC_OREGIO OIAQB OIC_OLAND1 T005S Taxes: Region (Province) Key LAND1
OIAQB OIC_OREGIO SYST MANDT T005S Taxes: Region (Province) Key MANDT