SAP Table TOIA2

Exchange types

TOIA2 (Exchange types) 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 TOIA2 to other SAP tables.

TOIA2 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EXGTYP Exchange type OIA_EXGTYP CHAR 4 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
NETCYC Netting cycle (FI blocking indicator) OIA_NETCYC T008 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
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
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
OISBREL Sub product/ base product relevence indicator OIA_SBREL NUMC 3 0
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
OIA_EXADD User exit for displaying additional exchange data OIA_EXADD TFRM NUMC 3 0
MATNETCYC Invoicing cycle for purchase material costs OIA_MATCYC TOIA10 NUMC 1 0
OICHSBP Sub/base product user exit routine OIA_CHSBP NUMC 3 0
EVGTYPE Evergreen type OIA_EVTYPE CHAR 1 0
NULL None
R Regular
U Unlimited

TOIA2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TOIA2 ENTLU TOIA2 MANDT TOIA3 Exchange Breakdown indicator MANDT
TOIA2 ENTLU TOIA2 ENTLU TOIA3 Exchange Breakdown indicator ENTLU
TOIA2 MANDT TOIA2 MANDT T000 Clients MANDT
TOIA2 MATNETCYC TOIA2 MANDT TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) MANDT
TOIA2 MATNETCYC TOIA2 MATNETCYC TOIA10 Invoicing Cycle Number (IS-Oil EXG standard/core object) OIINVCYC
TOIA2 NETCYC TOIA2 NETCYC T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TOIA2 NETCYC TOIA2 MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TOIA2 OIA_EXADD 'OIAH' TFRM Form Routines for Requirements/Formulas/Data Transports GRPZE
TOIA2 OIA_EXADD TOIA2 OIA_EXADD TFRM Form Routines for Requirements/Formulas/Data Transports GRPNO