OIAFE

Transparent Table Application Table
27 Fields 1 CDS Views

Fee history table

OIAFE is an SAP database table in S/4HANA. Fee history table. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_FeeHistory view_entity from BASIC Fee history

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY gjahr GJAHR Fiscal Year
KEY lfbnr WEBLN GR document
KEY lfpos LFPOS Ref. Doc. Item
KEY belnr BELNR_D Document Number
KEY blpos LFPOS Ref. Doc. Item
KEY vgabe VGABE Trans./ev. type
knumv KNUMV Doc. Condition
bewtp BEWTP PO History Cat.
budat BUDAT Posting Date
menge MENGE_D Quantity
oidmbtr OIA_DMBTR Fee (curr.)
oiwrbtr OIA_WRBTR Fee amount
waers WAERS Currency
arewr OIA_AREWR GR/IR clr.val.
shkzg SHKZG Debit/Credit
lifnr LIFNR Supplier
xblnr OIA_XBLNR Ext.del.noteNr
frbnr FRBNR1 Bill of Lading
erdat ERDAT Created On
ertim OI0_ERTIM Created
reewr OIA_REEWR Invoice value
refwr OIA_REFWR Inv.val.
oinegpstg OIA_NGPSTL Neg. fee line
_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 history table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIAFE (
    MANDT,       -- Client [MANDT]
    EBELN,       -- Purchasing Doc. [EBELN]
    EBELP,       -- Item [EBELP]
    GJAHR,       -- Fiscal Year [GJAHR]
    LFBNR,       -- GR document [WEBLN]
    LFPOS,       -- Ref. Doc. Item [LFPOS]
    BELNR,       -- Document Number [BELNR_D]
    BLPOS,       -- Ref. Doc. Item [LFPOS]
    VGABE,       -- Trans./ev. type [VGABE]
    KNUMV,       -- Doc. Condition [KNUMV]
    BEWTP,       -- PO History Cat. [BEWTP]
    BUDAT,       -- Posting Date [BUDAT]
    MENGE,       -- Quantity [MENGE_D]
    OIDMBTR,     -- Fee (curr.) [OIA_DMBTR]
    OIWRBTR,     -- Fee amount [OIA_WRBTR]
    WAERS,       -- Currency [WAERS]
    AREWR,       -- GR/IR clr.val. [OIA_AREWR]
    SHKZG,       -- Debit/Credit [SHKZG]
    LIFNR,       -- Supplier [LIFNR]
    XBLNR,       -- Ext.del.noteNr [OIA_XBLNR]
    FRBNR,       -- Bill of Lading [FRBNR1]
    ERDAT,       -- Created On [ERDAT]
    ERTIM,       -- Created [OI0_ERTIM]
    REEWR,       -- Invoice value [OIA_REEWR]
    REFWR,       -- Inv.val. [OIA_REFWR]
    OINEGPSTG,   -- Neg. fee line [OIA_NGPSTL]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, EBELN, EBELP, GJAHR, LFBNR, LFPOS, BELNR, BLPOS, VGABE)
);

Learn More