OIJ08_TRIPCHRG

Transparent Table Application Table
66 Fields 4 CDS Views

Trip Charge Details

OIJ08_TRIPCHRG is an SAP database table in S/4HANA. Trip Charge Details. It contains 66 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_SchedOfCharges view from EXTENSION Extension CDS for Trip Schedule of Charges
E_TripSchedOfChargesTP view from EXTENSION Trip Schedule of Charges Extension CDS
I_TripItemPayableChrg view left_outer BASIC Trip Item Payable Charges
I_TripSchedOfChargesTP view from TRANSACTIONAL Schedule of demurrage charges for a trip

Fields (66)

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
charge_type oij08_chrg_type Charge type
transfer_ind oij08_trns_ind Transfer Indicator
so_num vbeln SD Document
po_num ebeln Purchasing Doc.
last_accur_month oij08_lst_acr_mon Last Accrual Month
matnr matnr Material
werks werks_d Plant
lgort lgort_d Location
auart auart Sales Doc. Type
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
spart spart Division
kunnr kunnr Customer
bstkd bstkd Cust. Reference
lifnr lifnr Supplier
ekorg ekorg Purchasing Org.
ekgrp ekgrp Purch. Group
bukrs bukrs Company Code
laytime_type oij08_laytm_type Laytime Type
event oij_el_ltev Laytime event
laytime_qty oij_lt_actual Actual laytime
laytime_uom oij_lt_uom UoM Laytime
comments oit_laytcomment COMMENT
saknr saknr G/L Account
rev_profitcentre prctr Profit Center
rev_costcentre kostl Cost Center
debit_glaccount saknr G/L Account
credit_glaccount saknr G/L Account
accural_amount oij08_accr_amnt Accrual Amount
accural_curr oij08_accr_curr Accrual Amount Curr
start_accnt_date oij08_st_acc_dat St Account Date
last_accural_date oij08_lst_acr_dat Last Accrual Date
allocation_rule oij08_allc_rule Allocation Rule
allocation_percentage kgcper Percent
del_ind oit_del_ind Delete Indicator
cost_object_type oit_costobjecttype Cost Object Type
netwr netwr Net Value
tax mwsbp Tax Amount
mwskz mwskz Tax Code
waerk waerk Doc. Currency
tax_curr waerk Doc. Currency
doc_curr waerk Doc. Currency
excg_rate oit_excg_rate Trip Exchange Rate
paymentterms dzterm Pyt Terms
ktext1 sh_text1 Short Text
srvpos asnum Activity number
menge mengev Quantity
kostl kostl Cost Center
sakto saknr G/L Account
grossprice sbrtwr Gross
gross_curr waers Currency
sumlimit sumlimit Overall Limit
matkl matkl Material Group
transfer_date kdatb Validity Start
netwr_trip_curr netwr Net Value
trip_curr waers Currency
kalsm kalsmasd Pric. Procedure
sd_contract vbeln_va Sales Document
sd_contract_itm posnr_va Item
mm_contract ebeln Purchasing Doc.
mm_contract_itm ebelp Item
alloc_all boolean Boolean Variable (X = True, - = False, Space = Unknown)

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 Charge Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRIPCHRG (
    MANDT,                  -- Client [mandt]
    TRIP_ID,                -- Trip ID [oij08_tripid]
    TRIP_ITEM,              -- Trip Item Number [oij08_trip_posnr]
    CHARGE_KEY,             -- Charge Key [oij08_chrg_key]
    CHARGE_TYPE,            -- Charge type [oij08_chrg_type]
    TRANSFER_IND,           -- Transfer Indicator [oij08_trns_ind]
    SO_NUM,                 -- SD Document [vbeln]
    PO_NUM,                 -- Purchasing Doc. [ebeln]
    LAST_ACCUR_MONTH,       -- Last Accrual Month [oij08_lst_acr_mon]
    MATNR,                  -- Material [matnr]
    WERKS,                  -- Plant [werks_d]
    LGORT,                  -- Location [lgort_d]
    AUART,                  -- Sales Doc. Type [auart]
    VKORG,                  -- Sales Org. [vkorg]
    VTWEG,                  -- Distr. Channel [vtweg]
    SPART,                  -- Division [spart]
    KUNNR,                  -- Customer [kunnr]
    BSTKD,                  -- Cust. Reference [bstkd]
    LIFNR,                  -- Supplier [lifnr]
    EKORG,                  -- Purchasing Org. [ekorg]
    EKGRP,                  -- Purch. Group [ekgrp]
    BUKRS,                  -- Company Code [bukrs]
    LAYTIME_TYPE,           -- Laytime Type [oij08_laytm_type]
    EVENT,                  -- Laytime event [oij_el_ltev]
    LAYTIME_QTY,            -- Actual laytime [oij_lt_actual]
    LAYTIME_UOM,            -- UoM Laytime [oij_lt_uom]
    COMMENTS,               -- COMMENT [oit_laytcomment]
    SAKNR,                  -- G/L Account [saknr]
    REV_PROFITCENTRE,       -- Profit Center [prctr]
    REV_COSTCENTRE,         -- Cost Center [kostl]
    DEBIT_GLACCOUNT,        -- G/L Account [saknr]
    CREDIT_GLACCOUNT,       -- G/L Account [saknr]
    ACCURAL_AMOUNT,         -- Accrual Amount [oij08_accr_amnt]
    ACCURAL_CURR,           -- Accrual Amount Curr [oij08_accr_curr]
    START_ACCNT_DATE,       -- St Account Date [oij08_st_acc_dat]
    LAST_ACCURAL_DATE,      -- Last Accrual Date [oij08_lst_acr_dat]
    ALLOCATION_RULE,        -- Allocation Rule [oij08_allc_rule]
    ALLOCATION_PERCENTAGE,  -- Percent [kgcper]
    DEL_IND,                -- Delete Indicator [oit_del_ind]
    COST_OBJECT_TYPE,       -- Cost Object Type [oit_costobjecttype]
    NETWR,                  -- Net Value [netwr]
    TAX,                    -- Tax Amount [mwsbp]
    MWSKZ,                  -- Tax Code [mwskz]
    WAERK,                  -- Doc. Currency [waerk]
    TAX_CURR,               -- Doc. Currency [waerk]
    DOC_CURR,               -- Doc. Currency [waerk]
    EXCG_RATE,              -- Trip Exchange Rate [oit_excg_rate]
    PAYMENTTERMS,           -- Pyt Terms [dzterm]
    KTEXT1,                 -- Short Text [sh_text1]
    SRVPOS,                 -- Activity number [asnum]
    MENGE,                  -- Quantity [mengev]
    KOSTL,                  -- Cost Center [kostl]
    SAKTO,                  -- G/L Account [saknr]
    GROSSPRICE,             -- Gross [sbrtwr]
    GROSS_CURR,             -- Currency [waers]
    SUMLIMIT,               -- Overall Limit [sumlimit]
    MATKL,                  -- Material Group [matkl]
    TRANSFER_DATE,          -- Validity Start [kdatb]
    NETWR_TRIP_CURR,        -- Net Value [netwr]
    TRIP_CURR,              -- Currency [waers]
    KALSM,                  -- Pric. Procedure [kalsmasd]
    SD_CONTRACT,            -- Sales Document [vbeln_va]
    SD_CONTRACT_ITM,        -- Item [posnr_va]
    MM_CONTRACT,            -- Purchasing Doc. [ebeln]
    MM_CONTRACT_ITM,        -- Item [ebelp]
    ALLOC_ALL,              -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM, CHARGE_KEY)
);

Learn More