OIANF

Transparent Table Application Table
75 Fields 2 CDS Views

Fee Condition Records

OIANF is an SAP database table in S/4HANA. Fee Condition Records. It contains 75 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OIL_ExchFeeConditionRecord view_entity from BASIC Fee Condition Records
I_OIL_EXGFeeConditionRecords view_entity from BASIC IS Oil Exchanges Fee Condition Records

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY knumv KNUMV Doc. Condition
KEY kposn KPOSN Item
KEY stunr STUNR Step Number
KEY zaehk DZAEHK Counter
kappl KAPPL Application
kschl KSCHA Condition Type
kdatu KDATU CndnPricingDate
krech KRECH Calculat.Type
kawrt KAWRT Cond.Basis
kbetr KBETR Amount
waers WAERS Currency
kkurs KKURS Cond.exch.rate
kpein KPEIN Pricing Unit
kmein KVMEI Condition Unit
kumza KUMZA Numer.for Conv.
kumne KUMNE Den. for Conv.
kntyp KNTYP Condit.Category
kstat KSTAT Statistical
knprs KNPRS Pricing Type
kruek KRUEK Accruals
kreli KRELI Inv.List Cond.
kherk KHERK Condit.Origin
kgrpe KGRPE Group Condition
koupd KOUPD Condit. Update
kolnr KOLNR Access
knumh KNUMH Cond.Record No.
kopos KOPOS Sequent. No. of Cond
kvsl1 KVSL1 Account Key
sakn1 SAKNR G/L Account
mwsk1 MWSKZ Tax Code
kvsl2 KVSL2 Accruals
sakn2 SAKNR G/L Account
mwsk2 MWSKZ Tax Code
lifnr LIFNR Supplier
kunnr KUNNR_KO Customer
kdiff KDIFF CondRoundDiff.
kwert KWERT Condition Value
ksteu KSTEU Cond.Control
kinak KINAK Inactive
koaid KOAID Condition Class
zaeko DZAEKO HdCond.Counter
kmxaw KMXAW Max Basis Value
kmxwr KMXWR Maximum Amount
oikostl OIA_KOSTL Exg cost center
oiacpol OIA_ACPOL Acct. Policy
oifeeman OIA_FEEMAN Fee rate ind.
oikwert OIA_KWERT Clearing amount
oifeeprt OIA_FEEPRT Print.cond
oigrnet OIC_GRNET Gr/net ind.
oignstra OIC_GNSTRA Gr/net strategy
oigrchk OIC_GRCHK Unit check
oiinvcyc OIA_INVCYC Invoice cycle
oiinvcyact OIA_INCYCI Inv.CycleInd
oiincyst OIA_INCYST Cond.stat.
oia_spltiv OIA_SPLTIV Split IV
oia_zterm DZTERM Pyt Terms
kfaktor KFAKTOR CondFactor
kdupl KDUPL Structure Cond.
kfaktor1 KFAKTOR1 CondFactor
oilicin OIH_LICIN Internal lic.no
oilictp OIH_LICTP License type
oireport OIC_REPORT Report number
oidata OIC_DATA Data capture
oihead OIC_HEAD Header format
oiitem OIC_ITEM Item format
oierrhan OIC_SECERR Error handling
kzbzg KZBZG Scale Base Type
kstbs KSTBS Scale Base Val.
konms KONMS Scale UoM
konws KONWS Scale Currency
kawrt_k KAWRT Cond.Basis
kwaeh KWAEH Cndn Currency
kwert_k KWERT Condition Value
_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.

-- Fee Condition Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIANF (
    MANDT,       -- Client [MANDT]
    KNUMV,       -- Doc. Condition [KNUMV]
    KPOSN,       -- Item [KPOSN]
    STUNR,       -- Step Number [STUNR]
    ZAEHK,       -- Counter [DZAEHK]
    KAPPL,       -- Application [KAPPL]
    KSCHL,       -- Condition Type [KSCHA]
    KDATU,       -- CndnPricingDate [KDATU]
    KRECH,       -- Calculat.Type [KRECH]
    KAWRT,       -- Cond.Basis [KAWRT]
    KBETR,       -- Amount [KBETR]
    WAERS,       -- Currency [WAERS]
    KKURS,       -- Cond.exch.rate [KKURS]
    KPEIN,       -- Pricing Unit [KPEIN]
    KMEIN,       -- Condition Unit [KVMEI]
    KUMZA,       -- Numer.for Conv. [KUMZA]
    KUMNE,       -- Den. for Conv. [KUMNE]
    KNTYP,       -- Condit.Category [KNTYP]
    KSTAT,       -- Statistical [KSTAT]
    KNPRS,       -- Pricing Type [KNPRS]
    KRUEK,       -- Accruals [KRUEK]
    KRELI,       -- Inv.List Cond. [KRELI]
    KHERK,       -- Condit.Origin [KHERK]
    KGRPE,       -- Group Condition [KGRPE]
    KOUPD,       -- Condit. Update [KOUPD]
    KOLNR,       -- Access [KOLNR]
    KNUMH,       -- Cond.Record No. [KNUMH]
    KOPOS,       -- Sequent. No. of Cond [KOPOS]
    KVSL1,       -- Account Key [KVSL1]
    SAKN1,       -- G/L Account [SAKNR]
    MWSK1,       -- Tax Code [MWSKZ]
    KVSL2,       -- Accruals [KVSL2]
    SAKN2,       -- G/L Account [SAKNR]
    MWSK2,       -- Tax Code [MWSKZ]
    LIFNR,       -- Supplier [LIFNR]
    KUNNR,       -- Customer [KUNNR_KO]
    KDIFF,       -- CondRoundDiff. [KDIFF]
    KWERT,       -- Condition Value [KWERT]
    KSTEU,       -- Cond.Control [KSTEU]
    KINAK,       -- Inactive [KINAK]
    KOAID,       -- Condition Class [KOAID]
    ZAEKO,       -- HdCond.Counter [DZAEKO]
    KMXAW,       -- Max Basis Value [KMXAW]
    KMXWR,       -- Maximum Amount [KMXWR]
    OIKOSTL,     -- Exg cost center [OIA_KOSTL]
    OIACPOL,     -- Acct. Policy [OIA_ACPOL]
    OIFEEMAN,    -- Fee rate ind. [OIA_FEEMAN]
    OIKWERT,     -- Clearing amount [OIA_KWERT]
    OIFEEPRT,    -- Print.cond [OIA_FEEPRT]
    OIGRNET,     -- Gr/net ind. [OIC_GRNET]
    OIGNSTRA,    -- Gr/net strategy [OIC_GNSTRA]
    OIGRCHK,     -- Unit check [OIC_GRCHK]
    OIINVCYC,    -- Invoice cycle [OIA_INVCYC]
    OIINVCYACT,  -- Inv.CycleInd [OIA_INCYCI]
    OIINCYST,    -- Cond.stat. [OIA_INCYST]
    OIA_SPLTIV,  -- Split IV [OIA_SPLTIV]
    OIA_ZTERM,   -- Pyt Terms [DZTERM]
    KFAKTOR,     -- CondFactor [KFAKTOR]
    KDUPL,       -- Structure Cond. [KDUPL]
    KFAKTOR1,    -- CondFactor [KFAKTOR1]
    OILICIN,     -- Internal lic.no [OIH_LICIN]
    OILICTP,     -- License type [OIH_LICTP]
    OIREPORT,    -- Report number [OIC_REPORT]
    OIDATA,      -- Data capture [OIC_DATA]
    OIHEAD,      -- Header format [OIC_HEAD]
    OIITEM,      -- Item format [OIC_ITEM]
    OIERRHAN,    -- Error handling [OIC_SECERR]
    KZBZG,       -- Scale Base Type [KZBZG]
    KSTBS,       -- Scale Base Val. [KSTBS]
    KONMS,       -- Scale UoM [KONMS]
    KONWS,       -- Scale Currency [KONWS]
    KAWRT_K,     -- Cond.Basis [KAWRT]
    KWAEH,       -- Cndn Currency [KWAEH]
    KWERT_K,     -- Condition Value [KWERT]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, KNUMV, KPOSN, STUNR, ZAEHK)
);

Learn More