TOIA2

Transparent Table Customizing Table
17 Fields 2 CDS Views

Exchange types

TOIA2 is an SAP database table in S/4HANA. Exchange types. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ExchangeAgreementType view from BASIC Exchange Agreement Type
I_OIL_ExchangeAgreementTypeVH view_entity from BASIC Exchange Agreement types

Fields (17)

KeyField Data ElementDescription DomainTypeLength
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