OIJ08_TRPACCRLOG

Transparent Table Application Table
16 Fields 1 CDS Views

Accrual log table

OIJ08_TRPACCRLOG is an SAP database table in S/4HANA. Accrual log table. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TripAccrualLog view from BASIC Trip Accrual log history

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY clnt MANDT Client
KEY trip_id OIJ08_TRIPID Trip ID
KEY trip_item OIJ08_TRIP_POSNR Trip Item Number
KEY charge_key OIJ08_CHRG_KEY Charge Key
KEY seqnr OIJ_SEQNR Sequence number
debit_glaccount SAKNR G/L Account
credit_glaccount SAKNR G/L Account
last_accur_month OIJ08_LST_ACR_MON Last Accrual Month
accural_amount OIJ08_ACCR_AMNT Accrual Amount
accural_curr OIJ08_ACCR_CURR Accrual Amount Curr
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By

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.

-- Accrual log table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRPACCRLOG (
    CLNT,              -- Client [MANDT]
    TRIP_ID,           -- Trip ID [OIJ08_TRIPID]
    TRIP_ITEM,         -- Trip Item Number [OIJ08_TRIP_POSNR]
    CHARGE_KEY,        -- Charge Key [OIJ08_CHRG_KEY]
    SEQNR,             -- Sequence number [OIJ_SEQNR]
    DEBIT_GLACCOUNT,   -- G/L Account [SAKNR]
    CREDIT_GLACCOUNT,  -- G/L Account [SAKNR]
    LAST_ACCUR_MONTH,  -- Last Accrual Month [OIJ08_LST_ACR_MON]
    ACCURAL_AMOUNT,    -- Accrual Amount [OIJ08_ACCR_AMNT]
    ACCURAL_CURR,      -- Accrual Amount Curr [OIJ08_ACCR_CURR]
    ERDAT,             -- Created On [ERDAT]
    ERZEIT,            -- Created [OI0_ERTIM]
    ERNAM,             -- Created By [ERNAM]
    AEDAT,             -- Changed On [AEDAT]
    AEZEIT,            -- Changed [OI0_AETIM]
    AENAM,             -- Changed By [AENAM]
    PRIMARY KEY (CLNT, TRIP_ID, TRIP_ITEM, CHARGE_KEY, SEQNR)
);

Learn More