SAP Table OIA08
LIA Document: Item Data
OIA08 (LIA Document: Item Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIA08 to other SAP tables.
OIA08 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| UPENUM | Document number for logical inventory adjustment | OIA_UPENUM | OIA08H | CHAR | 10 | 0 | ||||||||
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | 0 | |||||||||
| SEGNUM | Document item no. for logical inventory adjustment | OIA_SEGNUM | NUMC | 5 | 0 | |||||||||
| ITEM_TYPE | LIA item type | OIA_UPEITM | CHAR | 1 | 0 |
Possible values
|
||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| EXGTYP | Exchange type | OIA_EXGTYP | TOIA2 | CHAR | 4 | 0 | ||||||||
| EXGNUM | Exchange agreement number | OIA_EXGNUM | CHAR | 10 | 0 | |||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||
| MEINS | LIA transaction unit of measure | OIA_TMEINS | T006 | UNIT | 3 | 0 | ||||||||
| MENGE | Quantity in transaction UOM | OIA_MENGE | QUAN | 13 | 3 | |||||||||
| SKMEINS | Stockkeeping unit of measure | OIA_SKMNS | T006 | UNIT | 3 | 0 | ||||||||
| SKMENGE | Quantity in stockkeeping UoM | OIA_SKMNG | QUAN | 13 | 3 | |||||||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||
| PYMT | Payment amount for LIA | OIA_PYMT | CURR | 13 | 2 | |||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||
| ZLSPR | Block Key for Payment | DZAHLS | T008 | CHAR | 1 | 0 | ||||||||
| CVIND | Customer / vendor posting indicator | OIA_CVIND | CHAR | 1 | 0 |
Possible values
|
||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||
| TAXCD | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 | 0 | ||||||||
| SGTXT | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| NEGADJ | Negative adjustment indicator for LIA | OIA_NEGADJ | CHAR | 1 | 0 |
Possible values
|
||||||||
| SUBPROD | Sub-product number | OIA_SUBPRD | MARA | CHAR | 18 | 0 | ||||||||
| OICYCLE | Invoice cycle | OIA_INVCYC | TOIA10 | NUMC | 1 | 0 | ||||||||
| OID_EXTBOL | External bill of lading | OID_EXTBOL | CHAR | 16 | 0 | |||||||||
| LIA_DMBTR | LIA quantity adjustment value in local currency | OIA_LIA_DMBTR | CURR | 13 | 2 | |||||||||
| MATPST | Posting rules for material | OIA_MATPST | CHAR | 1 | 0 |
Possible values
|
||||||||
| KTOSL | Fee accounting process key | OIA_KTOSL | TOIAH | CHAR | 3 | 0 | ||||||||
OIA08 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIA08 | BUKRS | OIA08 | MANDT | T001 | Company Codes | MANDT |
| OIA08 | BUKRS | OIA08 | BUKRS | T001 | Company Codes | BUKRS |
| OIA08 | EKORG | OIA08 | MANDT | T024E | Purchasing Organizations | MANDT |
| OIA08 | EKORG | OIA08 | EKORG | T024E | Purchasing Organizations | EKORG |
| OIA08 | EXGTYP | OIA08 | EXGTYP | TOIA2 | Exchange types | EXGTYP |
| OIA08 | EXGTYP | OIA08 | MANDT | TOIA2 | Exchange types | MANDT |
| OIA08 | KTOSL | OIA08 | MANDT | TOIAH | Check Table for Fee Accounting Process Strings | MANDT |
| OIA08 | KTOSL | 'M' | TOIAH | Check Table for Fee Accounting Process Strings | APPIND | |
| OIA08 | KTOSL | OIA08 | KTOSL | TOIAH | Check Table for Fee Accounting Process Strings | KTOSL |
| OIA08 | MANDT | OIA08 | MANDT | T000 | Clients | MANDT |
| OIA08 | MATNR | OIA08 | MANDT | MARA | General Material Data | MANDT |
| OIA08 | MATNR | OIA08 | MATNR | MARA | General Material Data | MATNR |
| OIA08 | MEINS | OIA08 | MANDT | T006 | Units of Measurement | MANDT |
| OIA08 | MEINS | OIA08 | MEINS | T006 | Units of Measurement | MSEHI |
| OIA08 | OICYCLE | OIA08 | MANDT | TOIA10 | Invoicing Cycle Number (IS-Oil EXG standard/core object) | MANDT |
| OIA08 | OICYCLE | OIA08 | OICYCLE | TOIA10 | Invoicing Cycle Number (IS-Oil EXG standard/core object) | OIINVCYC |
| OIA08 | SKMEINS | OIA08 | MANDT | T006 | Units of Measurement | MANDT |
| OIA08 | SKMEINS | OIA08 | SKMEINS | T006 | Units of Measurement | MSEHI |
| OIA08 | SUBPROD | OIA08 | MANDT | MARA | General Material Data | MANDT |
| OIA08 | SUBPROD | OIA08 | SUBPROD | MARA | General Material Data | MATNR |
| OIA08 | TAXCD | OIA08 | TAXCD | T007A | Tax Keys | MWSKZ |
| OIA08 | TAXCD | SYST | MANDT | T007A | Tax Keys | MANDT |
| OIA08 | TAXCD | T005 | KALSM | T007A | Tax Keys | KALSM |
| OIA08 | UPENUM | OIA08 | MANDT | OIA08H | LIA Document: Header Data | MANDT |
| OIA08 | UPENUM | OIA08 | UPENUM | OIA08H | LIA Document: Header Data | UPENUM |
| OIA08 | UPENUM | OIA08 | MJAHR | OIA08H | LIA Document: Header Data | MJAHR |
| OIA08 | VKORG | OIA08 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| OIA08 | VKORG | OIA08 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| OIA08 | WAERS | OIA08 | MANDT | TCURC | Currency Codes | MANDT |
| OIA08 | WAERS | OIA08 | WAERS | TCURC | Currency Codes | WAERS |
| OIA08 | WERKS | OIA08 | MANDT | T001W | Plants/Branches | MANDT |
| OIA08 | WERKS | OIA08 | WERKS | T001W | Plants/Branches | WERKS |
| OIA08 | ZLSPR | OIA08 | MANDT | T008 | Blocking Reasons for Automatic Payment Transcations | MANDT |
| OIA08 | ZLSPR | OIA08 | ZLSPR | T008 | Blocking Reasons for Automatic Payment Transcations | ZAHLS |
