OIAQB - Exchange Movements Index

Exchange Movements Index information is stored in SAP table OIAQB.
It is part of development package OIA in software component IS-OIL-DS-EXG. This development package consists of objects that can be grouped under "EXG Exchanges".

Fields for table OIAQB

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