SAP ABAP Table OIAQA (Exchange Statement Print Requests)

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	OIAQA	Table Relationship Diagram
Short Description	Exchange Statement Print Requests

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	T000
2	PREQNO	☑	OIA_PREQNO	OIA_PREQNO	CHAR	10	0	Exchange statement print request document number
3	NETDOC	☐	OIA_NETDOC	XFELD	CHAR	1	0	Movement-based netting document
4	PREQTYP	☐	OIA_PREQTY	FKART	CHAR	4	0	Exchange statement print request document type	TVFK
5	EXGPTR	☐	OIA_EXGPTR	LIFNR	CHAR	10	0	Exchange partner (vendor number)	LFA1
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	WAERS	☐	OIA_DWAERS	WAERS	CUKY	5	0	Currency for exchange statement	TCURC
10	VEXGNUM	☐	OIA_VEXNUM	OIA_EXGNUM	CHAR	10	0	From exchange agreement number	OIA01
11	BEXGNUM	☐	OIA_BEXNUM	OIA_EXGNUM	CHAR	10	0	To exchange agreement number	OIA01
12	VEXGTYP	☐	OIA_VEXTYP	OIA_EXGTYP	CHAR	4	0	From exchange type	TOIA2
13	BEXGTYP	☐	OIA_BEXTYP	OIA_EXGTYP	CHAR	4	0	To exchange type	TOIA2
14	VMATREF	☐	OIA_VMATRF	OIA_MATREF	CHAR	20	0	From mat. group reference for exchange balance reporting
15	BMATREF	☐	OIA_BMATRF	OIA_MATREF	CHAR	20	0	To - mat. group reference for exchange balance reporting
16	VMATNR	☐	OIA_VMATNR	MATNR	CHAR	18	0	From material number	MARA
17	BMATNR	☐	OIA_BMATNR	MATNR	CHAR	18	0	To material number	MARA
18	VOIBASPROD	☐	OIA_VSBMAT	MATNR	CHAR	18	0	From base product number	*
19	BOIBASPROD	☐	OIA_BSBMAT	MATNR	CHAR	18	0	To base product number	*
20	VWERKS	☐	OIA_VWERKS	WERKS	CHAR	4	0	From plant	T001W
21	BWERKS	☐	OIA_BWERKS	WERKS	CHAR	4	0	To plant	T001W
22	VSPMON	☐	OIA_VSPMON	RSCALMONTH	NUMC	6	0	From period to analyze - month
23	BSPMON	☐	OIA_BSPMON	RSCALMONTH	NUMC	6	0	To period to analyze - month
24	VSPTAG	☐	OIA_VSPTAG	DATUM	DATS	8	0	From period to analyze -daytime reference
25	BSPTAG	☐	OIA_BSPTAG	DATUM	DATS	8	0	To period to analyze - day
26	VSPWOC	☐	OIA_VSPWOC	MCPERIOD	NUMC	6	0	From period to analyze - week
27	BSPWOC	☐	OIA_BSPWOC	MCPERIOD	NUMC	6	0	To period to analyze - week
28	VSPBUP	☐	OIA_VSPBUP	MCPERIOD	NUMC	6	0	From period to analyze - posting period
29	BSPBUP	☐	OIA_BSPBUP	MCPERIOD	NUMC	6	0	To period to analyze - posting period
30	DOCSTAT	☐	OIA_DOCSTA	OIA_DOCSTA	CHAR	1	0	Exchange - netting document status
31	NJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
32	MAPPE	☐	MAPPE	MAPPE	CHAR	12	0	Session name
33	BICNT	☐	OIA_BICNT	OIA_BICNT	DEC	6	0	Counter created batch inputs per netting document
34	NETBAL	☐	OIA_NETBAL	WERT7	CURR	13	2	Net balance check TOTAL
35	.INCLUDE	☐				0	0	Date, time and name of creation and change in txn-data
36	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
37	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
38	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
39	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
40	AETIM	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
41	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
42	.INCLUDE	☐				0	0	Invoice cycle included indicator active 1-n (grouped)
43	OIINVCYC1	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
44	OIINVCYC2	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
45	OIINVCYC3	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
46	OIINVCYC4	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
47	OIINVCYC5	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
48	OIINVCYC6	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
49	OIINVCYC7	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
50	OIINVCYC8	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
51	OIINVCYC9	☐	OIA_INCYCI	KREUZ	CHAR	1	0	Invoice cycle included indicator active (X/ )
52	OIINCLIA	☐	OIA_INCLIA	KREUZ	CHAR	1	0	LIA included indicator (X/ )
53	OIINCPFA	☐	OIA_INCPFA	KREUZ	CHAR	1	0	PFA included indicator (X/ )
54	DISPME	☐	OIA_OUTMEI	MEINS	UNIT	3	0	Output unit of measure (for exchange and netting statement)	T006
55	OIAMWOFI	☐	OIA_MWOFI	OI0_SELKZ	CHAR	1	0	Movements without financials indicator
56	OIABALAN	☐	OIA_BALAN	OI0_SELKZ	CHAR	1	0	Include balances indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIAQA	BEXGNUM	OIA01	EXGNUM	KEY	1	CN
2	OIAQA	BEXGTYP	TOIA2	EXGTYP	KEY	1	CN
3	OIAQA	BMATNR	MARA	MATNR	REF	1	CN
4	OIAQA	BWERKS	T001W	WERKS	KEY	1	CN
5	OIAQA	DISPME	T006	MSEHI
6	OIAQA	EXGPTR	LFA1	LIFNR	KEY	1	CN
7	OIAQA	MANDT	T000	MANDT	KEY	1	CN
8	OIAQA	PREQTYP	TVFK	FKART	KEY	1	CN
9	OIAQA	SPART	TSPA	SPART	REF	1	CN
10	OIAQA	VEXGNUM	OIA01	EXGNUM	KEY	1	CN
11	OIAQA	VEXGTYP	TOIA2	EXGTYP	KEY	1	CN
12	OIAQA	VKORG	TVKO	VKORG	REF	1	CN
13	OIAQA	VMATNR	MARA	MATNR	REF	1	CN
14	OIAQA	VTWEG	TVTW	VTWEG	REF	1	CN
15	OIAQA	VWERKS	T001W	WERKS	KEY	1	CN
16	OIAQA	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20050520
SAP Release Created in