1. Home
  2. Resources
  3. SAP Tables
  4. OIA01 - Exchange header (IS-Oil EXG standard/core object)

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
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
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
FEEPST Posting rules for fees OIA_FEEPST CHAR 1 0
1 External
2 Internal
NETTNG Netting indicator OIA_NETTNG CHAR 1 0
X Netting active
NULL Netting not active
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
X Ownership checking
NULL No ownership checking
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
X Exchange fees applicable
NULL No exchange fees applicable
OIA_IPMVAT VAT on internally-posted material OIA_IPMVAT CHAR 1 0
NULL No VAT calculation
X VAT calculation with subtotal V of pricing procedure
SPLIT How to split quantity in quantity schedule OIA_SPLIT CHAR 1 0
NULL No split / no QS / unlimited delivery
1 Split qty. according to calendar days per period
2 Split qty. equally according to periods
3 Assign whole qty. to every period
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
O Open
C Closed
A To be archived
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
NULL None
R Regular
U Unlimited
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