OIA01 SAP (Exchange header (IS-Oil EXG standard/core object)) Table details
Dictionary Type: Table
Description: Exchange header (IS-Oil EXG standard/core object)
Description: Exchange header (IS-Oil EXG standard/core object)
Table field list including key, data, relationships and ABAP select examples
OIA01 is a standard SAP Table which is used to store Exchange header (IS-Oil EXG standard/core object) data and is available within R/3 SAP systems depending on the version and release level.
The OIA01 table consists of various fields, each holding specific information or linking keys about Exchange header (IS-Oil EXG standard/core object) data available in SAP. These include EXGNUM (Exchange agreement number), EXGTYP (Exchange type), EXGPTR (Exchange partner (vendor number)), PTRREF (Exchange partner reference code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIA01 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EXGNUM | Exchange agreement number | OIA_EXGNUM | CHAR | 10 | ALPHA | OIA_EXGNUM | OI1 | OIAE | |
EXGTYP | Exchange type | OIA_EXGTYP | CHAR | 4 | TOIA2 | OIA_EXGTYP | OI3 | ||
EXGPTR | Exchange partner (vendor number) | OIA_EXGPTR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KREDO |
PTRREF | Exchange partner reference code | OIA_PTRREF | CHAR | 20 | OIA_PTRREF | ||||
MATPST | Posting rules for material | OIA_MATPST | CHAR | 1 | OIA_MATPST | ||||
FEEPST | Posting rules for fees | OIA_FEEPST | CHAR | 1 | OIA_FEEPST | ||||
NETTNG | Netting indicator | OIA_NETTNG | CHAR | 1 | OIA_NETTNG | ||||
ENTLU | Breakdown ind. for scheduling on contract/call-off level | OIA_ENTLU | CHAR | 1 | TOIA3 | OIA_ENTLU | |||
OWNCHK | Ownership check indicator | OIA_OWNCHK | CHAR | 1 | OIA_OWNCHK | ||||
NUMKR | Number range for exchanges document | OIA_NUMKR | CHAR | 2 | NUMKR | ||||
FEECHK | Fee check indicator (apply minimum of one fee to exchange) | OIA_FEECHK | CHAR | 1 | OIA_FEECHK | ||||
OIA_IPMVAT | VAT on internally-posted material | OIA_IPMVAT | CHAR | 1 | OIA_IPMVAT | ||||
SPLIT | How to split quantity in quantity schedule | OIA_SPLIT | CHAR | 1 | OIA_SPLIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERTIM | Time of creation | OI0_ERTIM | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AETIM | Time of day the record was changed | OI0_AETIM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
NETCYC | Netting cycle (FI blocking indicator) | OIA_NETCYC | CHAR | 1 | T008 | ZAHLS | NTG | ||
OISBREL | Sub product/ base product relevence indicator | OIA_SBREL | NUMC | 3 | OIA_SBREL | ||||
OICHSBP | Sub/base product user exit routine | OIA_CHSBP | NUMC | 3 | Assigned to domain | GRPNO | |||
OIA_BASELO | Base location | OIA_BASELO | CHAR | 15 | OIA_BASELO | ||||
EXGSTAT | Status of an exchange agreement | OIA_EXSTAT | CHAR | 1 | OIA_EXSTAT | ||||
BEGDA | Starting date (exchange agreement) | OIA_EXBEGD | DATS | 8 | DATUM | ||||
ENDDA | Closing date (exchange agreement) | OIA_EXENDD | DATS | 8 | DATUM | ||||
REVDA | Review date (exchange agreement) | OIA_EXREVD | DATS | 8 | DATUM | ||||
EVGTYPE | Evergreen type | OIA_EVTYPE | CHAR | 1 | OIA_EVTYPE | ||||
NOTPER | Notice period for exchange agreement | OIA_NOTPER | DEC | 3 | OIA_DURAT |
Key field | Non-key field |
How do I retrieve data from SAP table OIA01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIA01 to SELECT all data from the tableDATA: WA_OIA01 TYPE OIA01.
SELECT SINGLE *
FROM OIA01
INTO CORRESPONDING FIELDS OF WA_OIA01
WHERE...
How to access SAP table OIA01
Within an ECC or HANA version of SAP you can also view further information about OIA01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects