OIJ08_TRIPPRCNG

Transparent Table Application Table
31 Fields 1 CDS Views

Trip Pricing Details

OIJ08_TRIPPRCNG is an SAP database table in S/4HANA. Trip Pricing Details. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TripPricingElementsTP view from TRANSACTIONAL Trip demurrage pricing elements

Fields (31)

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 kalsm kalsmasd Pric. Procedure
KEY kschl kschl Condition Type
kbetr kbetr Amount
koein koein Unit
kpein kpein Pricing Unit
kmein kvmei Condition Unit
kwert kwert Condition Value
waerk waerk Doc. Currency
bosta bosta Agmt status
kumza kumza Numer.for Conv.
varcond varcond Variant Key
amount vfprc_element_value Condition Value
amount_curr waerk Doc. Currency
tax_code mwskz Tax Code
kkurs kkurs Cond.exch.rate
netwr netwr Net Value
del_ind oit_del_ind Delete Indicator
kaend_loe kaend_loe Delete
kaend_btr kaend_btr Amount/Percent
kaend_wrt kaend_wrt Value
ksteu ksteu Cond.Control
koupd koupd Condit. Update
kherk kherk Condit.Origin
kmanu kmanu Manual Entries
krech krech Calculat.Type
kntyp kntyp Condit.Category
kbetr_manual kbetr_manul KBETR Manual

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 Pricing Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ08_TRIPPRCNG (
    MANDT,         -- Client [mandt]
    TRIP_ID,       -- Trip ID [oij08_tripid]
    TRIP_ITEM,     -- Trip Item Number [oij08_trip_posnr]
    CHARGE_KEY,    -- Charge Key [oij08_chrg_key]
    KALSM,         -- Pric. Procedure [kalsmasd]
    KSCHL,         -- Condition Type [kschl]
    KBETR,         -- Amount [kbetr]
    KOEIN,         -- Unit [koein]
    KPEIN,         -- Pricing Unit [kpein]
    KMEIN,         -- Condition Unit [kvmei]
    KWERT,         -- Condition Value [kwert]
    WAERK,         -- Doc. Currency [waerk]
    BOSTA,         -- Agmt status [bosta]
    KUMZA,         -- Numer.for Conv. [kumza]
    VARCOND,       -- Variant Key [varcond]
    AMOUNT,        -- Condition Value [vfprc_element_value]
    AMOUNT_CURR,   -- Doc. Currency [waerk]
    TAX_CODE,      -- Tax Code [mwskz]
    KKURS,         -- Cond.exch.rate [kkurs]
    NETWR,         -- Net Value [netwr]
    DEL_IND,       -- Delete Indicator [oit_del_ind]
    KAEND_LOE,     -- Delete [kaend_loe]
    KAEND_BTR,     -- Amount/Percent [kaend_btr]
    KAEND_WRT,     -- Value [kaend_wrt]
    KSTEU,         -- Cond.Control [ksteu]
    KOUPD,         -- Condit. Update [koupd]
    KHERK,         -- Condit.Origin [kherk]
    KMANU,         -- Manual Entries [kmanu]
    KRECH,         -- Calculat.Type [krech]
    KNTYP,         -- Condit.Category [kntyp]
    KBETR_MANUAL,  -- KBETR Manual [kbetr_manul]
    PRIMARY KEY (MANDT, TRIP_ID, TRIP_ITEM, CHARGE_KEY, KALSM, KSCHL)
);

Learn More