TRVS4_ADVANCE

Transparent Table Application Table
15 Fields 2 CDS Views

Travel Advance

TRVS4_ADVANCE is an SAP database table in S/4HANA. Travel Advance. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelAdvancesData view_entity from EXTENSION Travel Advances - Extension
I_TravelAdvancesData view_entity from BASIC Travel Advances Data

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pernr pernr_d Personnel No.
KEY reinr reinr Trip Number
KEY hdvrs ptrv_hdvrs Sequential no.
KEY adv_number vscnr Sequence Number
display_only advance_display_only Advance Display Only
adv_amount gesba Amount
adv_curr waers Currency
exch_rate ukurs_curr Exchange Rate
s_factor ffact_curr Ratio (from)
t_factor tfact_curr Ratio (to)
pay_amount gebah Amount
pay_curr ptrv_paycurr Accounting in
cash xfeld Checkbox
pay_date datvs Payment Date

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.

-- Travel Advance
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_ADVANCE (
    MANDT,         -- Client [mandt]
    PERNR,         -- Personnel No. [pernr_d]
    REINR,         -- Trip Number [reinr]
    HDVRS,         -- Sequential no. [ptrv_hdvrs]
    ADV_NUMBER,    -- Sequence Number [vscnr]
    DISPLAY_ONLY,  -- Advance Display Only [advance_display_only]
    ADV_AMOUNT,    -- Amount [gesba]
    ADV_CURR,      -- Currency [waers]
    EXCH_RATE,     -- Exchange Rate [ukurs_curr]
    S_FACTOR,      -- Ratio (from) [ffact_curr]
    T_FACTOR,      -- Ratio (to) [tfact_curr]
    PAY_AMOUNT,    -- Amount [gebah]
    PAY_CURR,      -- Accounting in [ptrv_paycurr]
    CASH,          -- Checkbox [xfeld]
    PAY_DATE,      -- Payment Date [datvs]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, ADV_NUMBER)
);

Learn More