SAP ABAP Table OIA02 (Exchange item data - sales side)

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	OIA02	Table Relationship Diagram
Short Description	Exchange item data - sales side

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	EXGNUM	☑	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	OIA01
3	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
4	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
5	REORG	☐	OIA_REORG	DATUM	DATS	8	0	Reorganization date
6	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	TEXT	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
9	.INCLUDE	☐				0	0	Date, time and name of creation and change in txn-data
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AETIM	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIA02	AUART	TVAK	AUART	KEY	1	CN
2	OIA02	EXGNUM	OIA01	EXGNUM	KEY		CN
3	OIA02	MANDT	T000	MANDT	KEY	1	CN
4	OIA02	VBELN	VBUK	VBELN	KEY	1	CN
5	OIA02	VKORG	TVKO	VKORG	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in