SAP ABAP Table OIASGG (Exchange Issues View for Exchange Statement)

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	INTTAB	Structure
Structure	OIASGG	Table Relationship Diagram
Short Description	Exchange Issues View for Exchange Statement

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	TYPETOTAL	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
2	BALANCE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
3	LOCTOTAL	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
4	BASPRTOTAL	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
5	.INCLUDE	☐				0	0	LIA Document: Item Data
6	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	UPENUM	☐	OIA_UPENUM	OIA_UPENUM	CHAR	10	0	Document number for logical inventory adjustment	OIA08H
8	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
9	SEGNUM	☐	OIA_SEGNUM	OIA_SEGNUM	NUMC	5	0	Document item no. for logical inventory adjustment
10	ITEM_TYPE	☐	OIA_UPEITM	OIA_UPEITM	CHAR	1	0	LIA item type
11	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
12	EXGTYP	☐	OIA_EXGTYP	OIA_EXGTYP	CHAR	4	0	Exchange type	TOIA2
13	EXGNUM	☐	OIA_EXGNUM	OIA_EXGNUM	CHAR	10	0	Exchange agreement number	*
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
16	MEINS	☐	OIA_TMEINS	MEINS	UNIT	3	0	LIA transaction unit of measure	T006
17	MENGE	☐	OIA_MENGE	OIA_MENGE	QUAN	13	3	Quantity in transaction UOM
18	SKMEINS	☐	OIA_SKMNS	MEINS	UNIT	3	0	Stockkeeping unit of measure	T006
19	SKMENGE	☐	OIA_SKMNG	MENGE	QUAN	13	3	Quantity in stockkeeping UoM
20	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
21	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
22	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
23	PYMT	☐	OIA_PYMT	OIA_PYMT	CURR	13	2	Payment amount for LIA
24	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
25	ZLSPR	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
26	CVIND	☐	OIA_CVIND	OIA_CVIND	CHAR	1	0	Customer / vendor posting indicator
27	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
28	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
29	TAXCD	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
30	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
31	NEGADJ	☐	OIA_NEGADJ	OIA_NEGADJ	CHAR	1	0	Negative adjustment indicator for LIA
32	SUBPROD	☐	OIA_SUBPRD	MATNR	CHAR	18	0	Sub-product number	MARA
33	OICYCLE	☐	OIA_INVCYC	OIA_INVCYC	NUMC	1	0	Invoice cycle	TOIA10
34	OID_EXTBOL	☐	OID_EXTBOL	OID_EXTBOL	CHAR	16	0	External bill of lading
35	LIA_DMBTR	☐	OIA_LIA_DMBTR	WERT7	CURR	13	2	LIA quantity adjustment value in local currency
36	MATPST	☐	OIA_MATPST	OIA_MATPST	CHAR	1	0	Posting rules for material
37	KTOSL	☐	OIA_KTOSL	OIA_KTOSL	CHAR	3	0	Fee accounting process key	TOIAH
38	.INCLUDE	☐				0	0	Customer Data for OIASGG (LIAs view) for Exchange Statmnt.
39	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
40	STEXT	☐	OIA_MESS18	CHAR18	CHAR	18	0	Message data element

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIASGG	BUKRS	T001	BUKRS	REF	C	CN
2	OIASGG	EKORG	T024E	EKORG	REF	1	CN
3	OIASGG	EXGTYP	TOIA2	EXGTYP
4	OIASGG	KTOSL	TOIAH	KTOSL
5	OIASGG	MANDT	T000	MANDT	KEY	1	CN
6	OIASGG	MATNR	MARA	MATNR	REF	C	CN
7	OIASGG	MEINS	T006	MSEHI	REF	C	CN
8	OIASGG	OICYCLE	TOIA10	OIINVCYC
9	OIASGG	SKMEINS	T006	MSEHI	KEY	1	CN
10	OIASGG	SUBPROD	MARA	MATNR		1	CN
11	OIASGG	TAXCD	T007A	MWSKZ
12	OIASGG	UPENUM	OIA08H	UPENUM
13	OIASGG	VKORG	TVKO	VKORG	REF	1	CN
14	OIASGG	WAERS	TCURC	WAERS	REF	1	CN
15	OIASGG	WERKS	T001W	WERKS	REF	1	CN
16	OIASGG	ZLSPR	T008	ZAHLS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in