OIT_TRIPCOSTALOC

Transparent Table Application Table

Trip cost object allocation table

OIT_TRIPCOSTALOC is an SAP database table in S/4HANA. Trip cost object allocation table. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TripCostAllocationMMTP view from TRANSACTIONAL Cost allocation for MM
I_TripCostAllocationSDTP view from TRANSACTIONAL CDS for Cost allocation objects

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt 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 SEQNR IT record no.
pspnr PS_POSNR WBS Element
prctr PRCTR Profit Center
kostl KOSTL Cost Center
anln1 ANLN1 Asset
aufnr AUFNR Order
afpos CO_POSNR Item Number
nplnr NPLNR Network
paobjnr RKEOBJNR Profit. segment
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.

-- Trip cost object allocation table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIT_TRIPCOSTALOC (
    MANDT,       -- Client [MANDT]
    TRIP_ID,     -- Trip ID [OIJ08_TRIPID]
    TRIP_ITEM,   -- Trip Item Number [OIJ08_TRIP_POSNR]
    CHARGE_KEY,  -- Charge Key [OIJ08_CHRG_KEY]
    SEQNR,       -- IT record no. [SEQNR]
    PSPNR,       -- WBS Element [PS_POSNR]
    PRCTR,       -- Profit Center [PRCTR]
    KOSTL,       -- Cost Center [KOSTL]
    ANLN1,       -- Asset [ANLN1]
    AUFNR,       -- Order [AUFNR]
    AFPOS,       -- Item Number [CO_POSNR]
    NPLNR,       -- Network [NPLNR]
    PAOBJNR,     -- Profit. segment [RKEOBJNR]
    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 (MANDT, TRIP_ID, TRIP_ITEM, CHARGE_KEY, SEQNR)
);