TRVS4_E_ADV_D

Transparent Table Application Table
28 Fields 2 CDS Views

Draft table for entity I_TRAVELEXPENSEADVANCE

TRVS4_E_ADV_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELEXPENSEADVANCE. It contains 28 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelExpenseAdvanceDraft view_entity from EXTENSION Travel Expense Advance - Extn
R_TravelExpenseAdvanceDraft view_entity from BASIC Travel Expense Advance Draft

Fields (28)

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
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.

-- Draft table for entity I_TRAVELEXPENSEADVANCE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_E_ADV_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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_TRVADVANCE_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELREQUESTSEQUENCENUMBER)
);

Learn More