SAP ABAP Table OIAQB (Exchange Movements Index)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIA (Package) Exg exchanges

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIAQB	Table Relationship Diagram
Short Description	Exchange Movements Index

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	OIEXGPTR	☑	OIA_EXGPTR	LIFNR	CHAR	10	0	Exchange partner (vendor number)	*
3	BUDAT	☑	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	OIEXGNUM	☑	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
9	OIEXGTYP	☑	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	*
10	OIMATREF	☑	OIA_MATREF	OIA_MATREF	CHAR	20	0	Material group reference for exchange balance reporting
11	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
12	OIBASPROD	☑	OIA_SBMAT	MATNR	CHAR	18	0	Base product number	*
13	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	*
14	MBLNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
15	MJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
16	ZEILE	☑	OIA_ITEM	OIA_ITEM	NUMC	6	0	Item number
17	ITEM_TYPE	☐	OIA_UPEITM	OIA_UPEITM	CHAR	1	0	LIA item type
18	OINETCYC	☐	OIA_NETCYC	ZAHLS	CHAR	1	0	Netting cycle (FI blocking indicator)	*
19	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
20	OIASTBW	☐	XSTBW	XFELD	CHAR	1	0	Reversal transaction type
21	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
22	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
23	OIVBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
24	OIPOSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
25	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
26	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
27	CLRNO	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
28	.INCLUDE	☐				0	0	Origin, Destination, Trip and ex Batch No for Pipeline
29	OIPIPEVAL	☐	OID_PIPEV	X	CHAR	1	0	Validation indicator for pipeline fields (X=ON, blank=OFF)
30	OIC_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
31	.INCLUDE	☐				0	0	Destination/Origin: City,County,Region,Country + Tax
32	OIC_DCITYC	☐	OIC_DCITYC	CITYC	CHAR	4	0	Destination city code	T005G
33	OIC_DCOUNC	☐	OIC_DCOUNC	COUNC	CHAR	3	0	Destination county code	T005E
34	OIC_DREGIO	☐	OIC_DREGIO	REGIO	CHAR	3	0	Destination region	T005S
35	OIC_DLAND1	☐	OIC_DLAND1	LAND1	CHAR	3	0	Destination country	T005
36	OIC_OCITYC	☐	OIC_OCITYC	CITYC	CHAR	4	0	Origin city code	T005G
37	OIC_OCOUNC	☐	OIC_OCOUNC	COUNC	CHAR	3	0	Origin county code	T005E
38	OIC_OREGIO	☐	OIC_OREGIO	REGIO	CHAR	3	0	Origin region	T005S
39	OIC_OLAND1	☐	OIC_OLAND1	LAND1	CHAR	3	0	Origin country	T005
40	OIC_PORGIN	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
41	OIC_PDESTN	☐	OIC_PDESTN	OIC_PDESTN	CHAR	15	0	Tax destination
42	OIC_PTRIP	☐	OIC_PTRIP	OIC_PTRIP	CHAR	16	0	Pipeline trip number (external)
43	OIC_PBATCH	☐	OIC_PBATCH	OIC_PBATCH	CHAR	16	0	Pipeline operator´s external batch number
44	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
45	OIC_AORGIN	☐	OIC_AORGIN	OIC_PORGIN	CHAR	15	0	Alternate origin
46	OIC_ADESTN	☐	OIC_ADESTN	OIC_PDESTN	CHAR	15	0	Alternate destination
47	OIC_TRUCKN	☐	OIC_TRUCKN	OIC_TRUCKN	CHAR	10	0	Truck number
48	OIA_BASELO	☐	OIA_BASELO	OIA_BASELO	CHAR	15	0	Base location
49	CLRNO1	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
50	CLRNO2	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
51	CLRNO3	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
52	CLRNO4	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
53	CLRNO5	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
54	CLRNO6	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
55	CLRNO7	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
56	CLRNO8	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
57	CLRNO9	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
58	.INCLUDE	☐				0	0	Customer modifications to OIAQB
59	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
60	.INCLUDE	☐				0	0	External Bill of Lading and Misc. Deliv. No
61	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
62	OID_MISCDL	☐	OID_MISCDL	OID_MISCDL	CHAR	16	0	Miscellaneous delivery number
63	NOCYC1	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
64	NOCYC2	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
65	NOCYC3	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
66	NOCYC4	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
67	NOCYC5	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
68	NOCYC6	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
69	NOCYC7	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
70	NOCYC8	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator
71	NOCYC9	☐	OIA_NOCYC	OI0_SELKZ	CHAR	1	0	Invoice cycle not used indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIAQB	OIC_DCITYC	T005G	CITYC
2	OIAQB	OIC_DCOUNC	T005E	COUNC
3	OIAQB	OIC_DLAND1	T005	LAND1
4	OIAQB	OIC_DREGIO	T005S	BLAND
5	OIAQB	OIC_LIFNR	LFA1	LIFNR
6	OIAQB	OIC_MOT	TVTR	VKTRA
7	OIAQB	OIC_OCITYC	T005G	CITYC
8	OIAQB	OIC_OCOUNC	T005E	COUNC
9	OIAQB	OIC_OLAND1	T005	LAND1
10	OIAQB	OIC_OREGIO	T005S	BLAND

History

Last changed by/on	SAP	20110901
SAP Release Created in