OIA12I - Movement Based Netting document item

Movement Based Netting document item information is stored in SAP table OIA12I.
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 OIA12I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUKRS	Company Code	X	BUKRS	CHAR	8
NETNUM	Exchange - netting document number	X	OIA_NETNUM	CHAR	20
ITMNO	Exchange - netting document item number	X	OIA_ITNO	NUMC	10
BUDAT	Posting Date in the Document		BUDAT	DATS	16
SELKZ	Selection flag		SELKZ	CHAR	2
OIEXGNUM	Exchange agreement number		OIA_EXGNUM	CHAR	20
ITCAT	Exchange - netting document item type		OIA_ITCAT	CHAR	2
MBLNR	Number of Material Document		MBLNR	CHAR	20
MJAHR	Material Document Year		MJAHR	NUMC	8
MATNR	Material Number		MATNR	CHAR	80
WERKS	Plant		WERKS_D	CHAR	8
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
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
BUZEI	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
DMBTR	Amount in local currency		OIA_DMBTR1	CURR	7
WRBTR	Amount in document currency		OIA_WRBTR1	CURR	7
WAERS	Currency Key		WAERS	CUKY	10
SHKZG	Debit/Credit Indicator		SHKZG	CHAR	2
CLRNO	Doc. number of the netting document clearing the item/cycle		OIA_CLRNO	CHAR	20
OIBASPROD	Base product number		OIA_SBMAT	CHAR	80
BOMCON	Indicator: BOM continuation item		OIA_BOMCON	CHAR	2
OICLRDCYC	Item already cleared in all cycles under process (X/ )		OIA_CLRCYC	CHAR	2
OIMATREF	Material group reference for exchange balance reporting		OIA_MATREF	CHAR	40
.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
.INCLUDE				OID_EX	0
OID_EXTBOL	External bill of lading		OID_EXTBOL	CHAR	32
OID_MISCDL	Miscellaneous delivery number		OID_MISCDL	CHAR	32
OIAOBAL	Opening exchange balance		OIA_OBAL	QUAN	8
BASEPMEINS	Base Unit of Measure		MEINS	UNIT	6
MENGE	Movement quantity		OIA_QUAN	QUAN	7
MEINS	Base Unit of Measure		MEINS	UNIT	6
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16