TOIA2
Exchange types
TOIA2 is an SAP database table in S/4HANA. Exchange types. It contains 17 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ExchangeAgreementType | view | from | BASIC | Exchange Agreement Type |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | exgtyp | oia_exgtyp | Exchange type | |||
| matpst | oia_matpst | Mat.posting | ||||
| feepst | oia_feepst | Fee posting | ||||
| nettng | oia_nettng | Netting active | ||||
| netcyc | oia_netcyc | Netting cycle | ||||
| entlu | oia_entlu | QS breakdown | ||||
| ownchk | oia_ownchk | Ownership check | ||||
| numkr | oia_numkr | No.range | ||||
| feechk | oia_feechk | Apply fee check | ||||
| split | oia_split | QS split | ||||
| oisbrel | oia_sbrel | S/B prod.ind. | ||||
| oia_ipmvat | oia_ipmvat | VAT on int.mat. | ||||
| oia_exadd | oia_exadd | Add. exch.data | ||||
| matnetcyc | oia_matcyc | Mat. inv. cycle | ||||
| oichsbp | oia_chsbp | S/B prod. check | ||||
| evgtype | oia_evtype | Evergreen type |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Exchange types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TOIA2 (
MANDT, -- Client [mandt]
EXGTYP, -- Exchange type [oia_exgtyp]
MATPST, -- Mat.posting [oia_matpst]
FEEPST, -- Fee posting [oia_feepst]
NETTNG, -- Netting active [oia_nettng]
NETCYC, -- Netting cycle [oia_netcyc]
ENTLU, -- QS breakdown [oia_entlu]
OWNCHK, -- Ownership check [oia_ownchk]
NUMKR, -- No.range [oia_numkr]
FEECHK, -- Apply fee check [oia_feechk]
SPLIT, -- QS split [oia_split]
OISBREL, -- S/B prod.ind. [oia_sbrel]
OIA_IPMVAT, -- VAT on int.mat. [oia_ipmvat]
OIA_EXADD, -- Add. exch.data [oia_exadd]
MATNETCYC, -- Mat. inv. cycle [oia_matcyc]
OICHSBP, -- S/B prod. check [oia_chsbp]
EVGTYPE, -- Evergreen type [oia_evtype]
PRIMARY KEY (MANDT, EXGTYP)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA