SAP ABAP Table OIA08 (LIA Document: Item Data)

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	OIA08	Table Relationship Diagram
Short Description	LIA Document: Item Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in