SAP Table OIA01
Exchange header (IS-Oil EXG standard/core object)
OIA01 (Exchange header (IS-Oil EXG standard/core object)) 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 OIA01 to other SAP tables.
OIA01 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
EXGNUM
Exchange agreement number
|
OIA_EXGNUM |
CHAR
|
10 | 0 | ||||||||||||
|
EXGTYP
Exchange type
|
OIA_EXGTYP | TOIA2 |
CHAR
|
4 | 0 | |||||||||||
|
EXGPTR
Exchange partner (vendor number)
|
OIA_EXGPTR | LFA1 |
CHAR
|
10 | 0 | |||||||||||
|
PTRREF
Exchange partner reference code
|
OIA_PTRREF |
CHAR
|
20 | 0 | ||||||||||||
|
MATPST
Posting rules for material
|
OIA_MATPST |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FEEPST
Posting rules for fees
|
OIA_FEEPST |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
NETTNG
Netting indicator
|
OIA_NETTNG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ENTLU
Breakdown ind. for scheduling on contract/call-off level
|
OIA_ENTLU | TOIA3 |
CHAR
|
1 | 0 | |||||||||||
|
OWNCHK
Ownership check indicator
|
OIA_OWNCHK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
NUMKR
Number range for exchanges document
|
OIA_NUMKR |
CHAR
|
2 | 0 | ||||||||||||
|
FEECHK
Fee check indicator (apply minimum of one fee to exchange)
|
OIA_FEECHK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
OIA_IPMVAT
VAT on internally-posted material
|
OIA_IPMVAT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SPLIT
How to split quantity in quantity schedule
|
OIA_SPLIT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||
|
ERTIM
Time of creation
|
OI0_ERTIM |
TIMS
|
6 | 0 | ||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||
|
AETIM
Time of day the record was changed
|
OI0_AETIM |
TIMS
|
6 | 0 | ||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||
|
NETCYC
Netting cycle (FI blocking indicator)
|
OIA_NETCYC | T008 |
CHAR
|
1 | 0 | |||||||||||
|
OISBREL
Sub product/ base product relevence indicator
|
OIA_SBREL |
NUMC
|
3 | 0 | ||||||||||||
|
OICHSBP
Sub/base product user exit routine
|
OIA_CHSBP |
NUMC
|
3 | 0 | ||||||||||||
|
OIA_BASELO
Base location
|
OIA_BASELO |
CHAR
|
15 | 0 | ||||||||||||
|
EXGSTAT
Status of an exchange agreement
|
OIA_EXSTAT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
BEGDA
Starting date (exchange agreement)
|
OIA_EXBEGD |
DATS
|
8 | 0 | ||||||||||||
|
ENDDA
Closing date (exchange agreement)
|
OIA_EXENDD |
DATS
|
8 | 0 | ||||||||||||
|
REVDA
Review date (exchange agreement)
|
OIA_EXREVD |
DATS
|
8 | 0 | ||||||||||||
|
EVGTYPE
Evergreen type
|
OIA_EVTYPE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
NOTPER
Notice period for exchange agreement
|
OIA_NOTPER |
DEC
|
3 | 0 | ||||||||||||
OIA01 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| OIA01 | ENTLU | OIA01 | MANDT |
TOIA3
Exchange Breakdown indicator
|
MANDT |
| OIA01 | ENTLU | OIA01 | ENTLU |
TOIA3
Exchange Breakdown indicator
|
ENTLU |
| OIA01 | EXGPTR | OIA01 | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| OIA01 | EXGPTR | OIA01 | EXGPTR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| OIA01 | EXGTYP | OIA01 | EXGTYP |
TOIA2
Exchange types
|
EXGTYP |
| OIA01 | EXGTYP | OIA01 | MANDT |
TOIA2
Exchange types
|
MANDT |
| OIA01 | MANDT | OIA01 | MANDT |
T000
Clients
|
MANDT |
| OIA01 | NETCYC | OIA01 | MANDT |
T008
Blocking Reasons for Automatic Payment Transcations
|
MANDT |
| OIA01 | NETCYC | OIA01 | NETCYC |
T008
Blocking Reasons for Automatic Payment Transcations
|
ZAHLS |