SAP table OIA01 (Exchange header (IS-Oil EXG standard/core object))

SAP table OIA01 has 2 primary key fields being MANDT,EXGNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
EXGNUM Exchange agreement number CHAR 10 0 OIA_EXGNUM
EXGTYP Exchange type CHAR 4 0 TOIA2 OIA_EXGTYP
EXGPTR Exchange partner (vendor number) CHAR 10 0 LFA1 OIA_EXGPTR
PTRREF Exchange partner reference code CHAR 20 0 OIA_PTRREF
MATPST Posting rules for material CHAR 1 0 OIA_MATPST
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
FEEPST Posting rules for fees CHAR 1 0 OIA_FEEPST
1 External
2 Internal
NETTNG Netting indicator CHAR 1 0 OIA_NETTNG
Netting not active
X Netting active
ENTLU Breakdown ind. for scheduling on contract/call-off level CHAR 1 0 TOIA3 OIA_ENTLU
OWNCHK Ownership check indicator CHAR 1 0 OIA_OWNCHK
No ownership checking
X Ownership checking
NUMKR Number range for exchanges document CHAR 2 0 OIA_NUMKR
FEECHK Fee check indicator (apply minimum of one fee to exchange) CHAR 1 0 OIA_FEECHK
No exchange fees applicable
X Exchange fees applicable
OIA_IPMVAT VAT on internally-posted material CHAR 1 0 OIA_IPMVAT
No VAT calculation
X VAT calculation with subtotal V of pricing procedure
SPLIT How to split quantity in quantity schedule CHAR 1 0 OIA_SPLIT
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 the record was created DATS 8 0 ERDAT
ERTIM Time of creation TIMS 6 0 OI0_ERTIM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Time of day the record was changed TIMS 6 0 OI0_AETIM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
NETCYC Netting cycle (FI blocking indicator) CHAR 1 0 T008 OIA_NETCYC
OISBREL Sub product/ base product relevence indicator NUMC 3 0 OIA_SBREL
OICHSBP Sub/base product user exit routine NUMC 3 0 OIA_CHSBP
OIA_BASELO Base location CHAR 15 0 OIA_BASELO
EXGSTAT Status of an exchange agreement CHAR 1 0 OIA_EXSTAT
A To be archived
C Closed
O Open
BEGDA Starting date (exchange agreement) DATS 8 0 OIA_EXBEGD
ENDDA Closing date (exchange agreement) DATS 8 0 OIA_EXENDD
REVDA Review date (exchange agreement) DATS 8 0 OIA_EXREVD
EVGTYPE Evergreen type CHAR 1 0 OIA_EVTYPE
None
R Regular
U Unlimited
NOTPER Notice period for exchange agreement DEC 3 0 OIA_NOTPER
EXGSELECT Flag to Set Exchange exgreements Not Selectable CHAR 1 0 OIA_EXGSELECT
OIA_PB_FEE Indicator for Pricing-Based Exchange Fee CHAR 1 0 OIA_PB_FEE
Indicator OFF
X Indicator ON
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

OIA01 foreign key relationships

Table Field Check Table Check Field
0 OIA01 ENTLU TOIA3 Exchange Breakdown indicator MANDT
1 OIA01 EXGPTR LFA1 Supplier Master (General Section) MANDT
1 OIA01 EXGPTR LFA1 Supplier Master (General Section) LIFNR
0 OIA01 EXGTYP TOIA2 Exchange types MANDT
0 OIA01 EXGTYP TOIA2 Exchange types EXGTYP
1 OIA01 MANDT T000 Clients MANDT
0 OIA01 NETCYC T008 Blocking Reasons for Automatic Payment Transcations MANDT
0 OIA01 NETCYC T008 Blocking Reasons for Automatic Payment Transcations ZAHLS