TRVS4_PERDIEM

Transparent Table Application Table
23 Fields 2 CDS Views

Travel Per-Diem deductions

TRVS4_PERDIEM is an SAP database table in S/4HANA. Travel Per-Diem deductions. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlExpnPerDiemDeductionData view_entity from EXTENSION Trvl Expn Per Diem Deduction - Extension
I_TrvlExpnPerDiemDeductionData view_entity from BASIC Travel Expense Per Diem Deduction Data

Fields (23)

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 ded_date abzda Date
break_de xfeld Checkbox
break_de_time deduc_time Time of Deduction
lunch_de xfeld Checkbox
lunch_de_time deduc_time Time of Deduction
dinne_de xfeld Checkbox
dinne_de_time deduc_time Time of Deduction
night_de xfeld Checkbox
night_de_time deduc_time Time of Deduction
lu_coupn xfeld Checkbox
meals_de_stagg xfeld Checkbox
night_de_stagg xfeld Checkbox
display_only deduction_display_only Deduct.Display Only
break_pik ptrv_sb_frstk P/K Breakfast
lunch_pik ptrv_sb_mitag Pay./Kd Lunch
dinne_pik ptrv_sb_abend P/K Dinner
brft_rec_no nrbel Document Number
lnch_rec_no nrbel Document Number
dinn_rec_no nrbel Document Number

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 Per-Diem deductions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_PERDIEM (
    MANDT,           -- Client [mandt]
    PERNR,           -- Personnel No. [pernr_d]
    REINR,           -- Trip Number [reinr]
    HDVRS,           -- Sequential no. [ptrv_hdvrs]
    DED_DATE,        -- Date [abzda]
    BREAK_DE,        -- Checkbox [xfeld]
    BREAK_DE_TIME,   -- Time of Deduction [deduc_time]
    LUNCH_DE,        -- Checkbox [xfeld]
    LUNCH_DE_TIME,   -- Time of Deduction [deduc_time]
    DINNE_DE,        -- Checkbox [xfeld]
    DINNE_DE_TIME,   -- Time of Deduction [deduc_time]
    NIGHT_DE,        -- Checkbox [xfeld]
    NIGHT_DE_TIME,   -- Time of Deduction [deduc_time]
    LU_COUPN,        -- Checkbox [xfeld]
    MEALS_DE_STAGG,  -- Checkbox [xfeld]
    NIGHT_DE_STAGG,  -- Checkbox [xfeld]
    DISPLAY_ONLY,    -- Deduct.Display Only [deduction_display_only]
    BREAK_PIK,       -- P/K Breakfast [ptrv_sb_frstk]
    LUNCH_PIK,       -- Pay./Kd Lunch [ptrv_sb_mitag]
    DINNE_PIK,       -- P/K Dinner [ptrv_sb_abend]
    BRFT_REC_NO,     -- Document Number [nrbel]
    LNCH_REC_NO,     -- Document Number [nrbel]
    DINN_REC_NO,     -- Document Number [nrbel]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, DED_DATE)
);

Learn More