SAP ABAP Table V_OIAQB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OIAQB	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	CLRNO1	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
29	CLRNO2	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
30	CLRNO3	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
31	CLRNO4	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
32	CLRNO5	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
33	CLRNO6	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
34	CLRNO7	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
35	CLRNO8	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle
36	CLRNO9	☐	OIA_CLRNO	OIA_PREQNO	CHAR	10	0	Doc. number of the netting document clearing the item/cycle

History

Last changed by/on	SAP	20110901
SAP Release Created in