SAP table OIAQB (Exchange Movements Index)

SAP table OIAQB has 16 primary key fields being MANDT,OIEXGPTR,BUDAT,SPMON,SPTAG,SPWOC,SPBUP,OIEXGNUM,OIEXGTYP,OIMATREF,MATNR,OIBASPROD,WERKS,MBLNR,MJAHR,ZEILE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
OIEXGPTR Exchange partner (vendor number) CHAR 10 0 OIA_EXGPTR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
SPMON Period to analyze - month NUMC 6 0 SPMON
SPTAG Period to analyze - current date DATS 8 0 SPTAG
SPWOC Period to analyze - week NUMC 6 0 SPWOC
SPBUP Period to analyze - posting period NUMC 6 0 SPBUP
OIEXGNUM Exchange agreement number CHAR 10 0 OIA_EXGNUM
OIEXGTYP Exchange type CHAR 4 0 OIA_EXGTYP
OIMATREF Material group reference for exchange balance reporting CHAR 20 0 OIA_MATREF
MATNR Material Number CHAR 40 0 MATNR
OIBASPROD Base product number CHAR 40 0 OIA_SBMAT
WERKS Plant CHAR 4 0 WERKS_D
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item number NUMC 6 0 OIA_ITEM
ITEM_TYPE LIA item type CHAR 1 0 OIA_UPEITM
1 Book receipt
2 Book delivery
3 Negotiated payment
OINETCYC Netting cycle (FI blocking indicator) CHAR 1 0 OIA_NETCYC
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
OIASTBW Reversal movement type CHAR 1 0 XSTBW
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
OIVBELN Delivery CHAR 10 0 VBELN_VL
OIPOSNR Delivery Item NUMC 6 0 POSNR_VL
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
CLRNO Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) CHAR 1 0 OID_PIPEV
OIC_LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
OIC_DCITYC Destination city code CHAR 4 0 T005G OIC_DCITYC
OIC_DCOUNC Destination county code CHAR 3 0 T005E OIC_DCOUNC
OIC_DREGIO Destination region CHAR 3 0 T005S OIC_DREGIO
OIC_DLAND1 Destination country/Region CHAR 3 0 T005 OIC_DLAND1
OIC_OCITYC Origin city code CHAR 4 0 T005G OIC_OCITYC
OIC_OCOUNC Origin county code CHAR 3 0 T005E OIC_OCOUNC
OIC_OREGIO Origin region CHAR 3 0 T005S OIC_OREGIO
OIC_OLAND1 Origin Country/Region CHAR 3 0 T005 OIC_OLAND1
OIC_PORGIN Tax origin CHAR 15 0 OIC_PORGIN
OIC_PDESTN Tax destination CHAR 15 0 OIC_PDESTN
OIC_PTRIP Pipeline trip number (external) CHAR 16 0 OIC_PTRIP
OIC_PBATCH Pipeline operator´s external batch number CHAR 16 0 OIC_PBATCH
OIC_MOT IS-OIL MAP external details mode of transport CHAR 2 0 TVTR OIC_MOT
OIC_AORGIN Alternate origin CHAR 15 0 OIC_AORGIN
OIC_ADESTN Alternate destination CHAR 15 0 OIC_ADESTN
OIC_TRUCKN Truck number CHAR 10 0 OIC_TRUCKN
OIA_BASELO Base location CHAR 15 0 OIA_BASELO
CLRNO1 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO2 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO3 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO4 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO5 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO6 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO7 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO8 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
CLRNO9 Doc. number of the netting document clearing the item/cycle CHAR 10 0 OIA_CLRNO
PDUMMY Dummy function in length 1 CHAR 1 0 DUMMY
OID_EXTBOL External bill of lading CHAR 16 0 OID_EXTBOL
OID_MISCDL Miscellaneous delivery number CHAR 16 0 OID_MISCDL
NOCYC1 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC2 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC3 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC4 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC5 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC6 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC7 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC8 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
NOCYC9 Invoice cycle not used indicator CHAR 1 0 OIA_NOCYC
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

OIAQB foreign key relationships

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