TRVS4_ADVANCE_D

Transparent Table Application Table
21 Fields 2 CDS Views

Draft table for entity I_TRAVELADVANCE

TRVS4_ADVANCE_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELADVANCE. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelRequestAdvanceDraft view_entity from EXTENSION Trvl Req Advance - Extn
R_TrvlReqAdvanceDraft view_entity from BASIC Trvl Req Advance Draft

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY personnelnumber pernr_d Personnel No.
KEY traveltripnumber reinr Trip Number
KEY travelrequuid sysuuid_x16 UUID
KEY seqrequuid sysuuid_x16 UUID
KEY travelrequestsequencenumber vscnr Sequence Number
travelexpnsequentialnumber ptrv_hdvrs Sequential no.
advanceisdisplayonly advance_display_only Advance Display Only
trvladvncamtinadvnccrcy vdm_advamt Amount
advancecurrency vdm_advcrcy Advance Currency
travelrequestexchangerate vdm_ukurs_curr Exchange Rate
currencyunitfromratio ffact_curr Ratio (from)
currencyunittoratio tfact_curr Ratio (to)
paymentamount vdm_pay_amount Amount in Settlement Currency
paymentcurrency ptrv_paycurr Accounting in
advanceisincash vdm_cash Cash
paymentdate datvs Payment Date
advancecurrencyname ltext Long Text
paymentcurrencyname ltext Long Text
lastchangedatetime vdm_lastchangedon Last Changed On
advnclocllastchgddtetme abp_lastchange_tstmpl Changed On

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.

-- Draft table for entity I_TRAVELADVANCE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_ADVANCE_D (
    MANDT,                        -- Client [mandt]
    PERSONNELNUMBER,              -- Personnel No. [pernr_d]
    TRAVELTRIPNUMBER,             -- Trip Number [reinr]
    TRAVELREQUUID,                -- UUID [sysuuid_x16]
    SEQREQUUID,                   -- UUID [sysuuid_x16]
    TRAVELREQUESTSEQUENCENUMBER,  -- Sequence Number [vscnr]
    TRAVELEXPNSEQUENTIALNUMBER,   -- Sequential no. [ptrv_hdvrs]
    ADVANCEISDISPLAYONLY,         -- Advance Display Only [advance_display_only]
    TRVLADVNCAMTINADVNCCRCY,      -- Amount [vdm_advamt]
    ADVANCECURRENCY,              -- Advance Currency [vdm_advcrcy]
    TRAVELREQUESTEXCHANGERATE,    -- Exchange Rate [vdm_ukurs_curr]
    CURRENCYUNITFROMRATIO,        -- Ratio (from) [ffact_curr]
    CURRENCYUNITTORATIO,          -- Ratio (to) [tfact_curr]
    PAYMENTAMOUNT,                -- Amount in Settlement Currency [vdm_pay_amount]
    PAYMENTCURRENCY,              -- Accounting in [ptrv_paycurr]
    ADVANCEISINCASH,              -- Cash [vdm_cash]
    PAYMENTDATE,                  -- Payment Date [datvs]
    ADVANCECURRENCYNAME,          -- Long Text [ltext]
    PAYMENTCURRENCYNAME,          -- Long Text [ltext]
    LASTCHANGEDATETIME,           -- Last Changed On [vdm_lastchangedon]
    ADVNCLOCLLASTCHGDDTETME,      -- Changed On [abp_lastchange_tstmpl]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELREQUESTSEQUENCENUMBER)
);

Learn More