OIA01

Transparent Table Application Table
33 Fields 4 CDS Views

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

OIA01 is an SAP database table in S/4HANA. Exchange header (IS-Oil EXG standard/core object). It contains 33 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/dmbe/i_Exchange_Agreement_Hdr view from Exchange Agreement Header
E_OIL_ExchangeAgreement view_entity from EXTENSION Exchange Agreement - Extension
I_ExchangeHeader view from BASIC Exchange Header
I_OIL_ExchangeAgreementHeader view_entity from BASIC Exchange Agreement

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY exgnum OIA_EXGNUM Exchange no.
exgtyp OIA_EXGTYP Exchange type
exgptr OIA_EXGPTR Exg.partner
ptrref OIA_PTRREF Partner ref.
matpst OIA_MATPST Mat.posting
feepst OIA_FEEPST Fee posting
nettng OIA_NETTNG Netting active
entlu OIA_ENTLU QS breakdown
ownchk OIA_OWNCHK Ownership check
numkr OIA_NUMKR No.range
feechk OIA_FEECHK Apply fee check
oia_ipmvat OIA_IPMVAT VAT on int.mat.
split OIA_SPLIT QS split
erdat ERDAT Created On
ertim OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aetim OI0_AETIM Changed
aenam AENAM Changed By
netcyc OIA_NETCYC Netting cycle
oisbrel OIA_SBREL S/B prod.ind.
oichsbp OIA_CHSBP S/B prod. check
oia_baselo OIA_BASELO Base location
exgstat OIA_EXSTAT Exchange status
begda OIA_EXBEGD Starting date
endda OIA_EXENDD Closing date
revda OIA_EXREVD Review date
evgtype OIA_EVTYPE Evergreen type
notper OIA_NOTPER Notice period
exgselect OIA_EXGSELECT Flag to Sel Exchange
oia_pb_fee OIA_PB_FEE Pricing-based fees
_dataaging DATA_TEMPERATURE Data Aging

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 header (IS-Oil EXG standard/core object)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIA01 (
    MANDT,       -- Client [MANDT]
    EXGNUM,      -- Exchange no. [OIA_EXGNUM]
    EXGTYP,      -- Exchange type [OIA_EXGTYP]
    EXGPTR,      -- Exg.partner [OIA_EXGPTR]
    PTRREF,      -- Partner ref. [OIA_PTRREF]
    MATPST,      -- Mat.posting [OIA_MATPST]
    FEEPST,      -- Fee posting [OIA_FEEPST]
    NETTNG,      -- Netting active [OIA_NETTNG]
    ENTLU,       -- QS breakdown [OIA_ENTLU]
    OWNCHK,      -- Ownership check [OIA_OWNCHK]
    NUMKR,       -- No.range [OIA_NUMKR]
    FEECHK,      -- Apply fee check [OIA_FEECHK]
    OIA_IPMVAT,  -- VAT on int.mat. [OIA_IPMVAT]
    SPLIT,       -- QS split [OIA_SPLIT]
    ERDAT,       -- Created On [ERDAT]
    ERTIM,       -- Created [OI0_ERTIM]
    ERNAM,       -- Created By [ERNAM]
    AEDAT,       -- Changed On [AEDAT]
    AETIM,       -- Changed [OI0_AETIM]
    AENAM,       -- Changed By [AENAM]
    NETCYC,      -- Netting cycle [OIA_NETCYC]
    OISBREL,     -- S/B prod.ind. [OIA_SBREL]
    OICHSBP,     -- S/B prod. check [OIA_CHSBP]
    OIA_BASELO,  -- Base location [OIA_BASELO]
    EXGSTAT,     -- Exchange status [OIA_EXSTAT]
    BEGDA,       -- Starting date [OIA_EXBEGD]
    ENDDA,       -- Closing date [OIA_EXENDD]
    REVDA,       -- Review date [OIA_EXREVD]
    EVGTYPE,     -- Evergreen type [OIA_EVTYPE]
    NOTPER,      -- Notice period [OIA_NOTPER]
    EXGSELECT,   -- Flag to Sel Exchange [OIA_EXGSELECT]
    OIA_PB_FEE,  -- Pricing-based fees [OIA_PB_FEE]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, EXGNUM)
);

Learn More