TRVS4_ADVANCE

Transparent Table Application Table
18 Fields 2 CDS Views

Travel Advance

TRVS4_ADVANCE is an SAP database table in S/4HANA. Travel Advance. It contains 18 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 (18)

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
adv_curr_name LTEXT Long Text
pay_curr_name LTEXT Long Text
dummy_trvadvance_incl_eew_ps CFD_DUMMY Dummy

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]
    ADV_CURR_NAME,                 -- Long Text [LTEXT]
    PAY_CURR_NAME,                 -- Long Text [LTEXT]
    DUMMY_TRVADVANCE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, ADV_NUMBER)
);

Learn More