TRVS4_PERDIEM

Transparent Table Application Table
60 Fields 2 CDS Views

Travel Per-Diem deductions

TRVS4_PERDIEM is an SAP database table in S/4HANA. Travel Per-Diem deductions. It contains 60 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 (60)

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
visiblebre XFELD Checkbox
inputbre XFELD Checkbox
requiredbre XFELD Checkbox
visiblebrt XFELD Checkbox
inputbrt XFELD Checkbox
requiredbrt XFELD Checkbox
lunch_de XFELD Checkbox
lunch_de_time DEDUC_TIME Time of Deduction
visiblelnc XFELD Checkbox
inputlnc XFELD Checkbox
requiredlnc XFELD Checkbox
visiblelnt XFELD Checkbox
inputlnt XFELD Checkbox
requiredlnt XFELD Checkbox
dinne_de XFELD Checkbox
dinne_de_time DEDUC_TIME Time of Deduction
visibledin XFELD Checkbox
inputdin XFELD Checkbox
requireddin XFELD Checkbox
visibledit XFELD Checkbox
inputdit XFELD Checkbox
requireddit XFELD Checkbox
night_de XFELD Checkbox
night_de_time DEDUC_TIME Time of Deduction
visiblengt XFELD Checkbox
inputngt XFELD Checkbox
requiredngt XFELD Checkbox
lu_coupn XFELD Checkbox
visiblecup XFELD Checkbox
inputcup XFELD Checkbox
requiredcup 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
visiblebpk XFELD Checkbox
inputbpk XFELD Checkbox
requiredbpk XFELD Checkbox
lunch_pik PTRV_SB_MITAG Pay./Kd Lunch
visiblelpk XFELD Checkbox
inputlpk XFELD Checkbox
requiredlpk XFELD Checkbox
dinne_pik PTRV_SB_ABEND P/K Dinner
visibledpk XFELD Checkbox
inputdpk XFELD Checkbox
requireddpk XFELD Checkbox
brft_rec_no NRBEL Document Number
lnch_rec_no NRBEL Document Number
dinn_rec_no NRBEL Document Number
meals_de_stagg_name LTEXT Long Text
night_de_stagg_name LTEXT Long Text
weekday_name TAGBEZ Day name
dummy_trvperdiem_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 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]
    VISIBLEBRE,                    -- Checkbox [XFELD]
    INPUTBRE,                      -- Checkbox [XFELD]
    REQUIREDBRE,                   -- Checkbox [XFELD]
    VISIBLEBRT,                    -- Checkbox [XFELD]
    INPUTBRT,                      -- Checkbox [XFELD]
    REQUIREDBRT,                   -- Checkbox [XFELD]
    LUNCH_DE,                      -- Checkbox [XFELD]
    LUNCH_DE_TIME,                 -- Time of Deduction [DEDUC_TIME]
    VISIBLELNC,                    -- Checkbox [XFELD]
    INPUTLNC,                      -- Checkbox [XFELD]
    REQUIREDLNC,                   -- Checkbox [XFELD]
    VISIBLELNT,                    -- Checkbox [XFELD]
    INPUTLNT,                      -- Checkbox [XFELD]
    REQUIREDLNT,                   -- Checkbox [XFELD]
    DINNE_DE,                      -- Checkbox [XFELD]
    DINNE_DE_TIME,                 -- Time of Deduction [DEDUC_TIME]
    VISIBLEDIN,                    -- Checkbox [XFELD]
    INPUTDIN,                      -- Checkbox [XFELD]
    REQUIREDDIN,                   -- Checkbox [XFELD]
    VISIBLEDIT,                    -- Checkbox [XFELD]
    INPUTDIT,                      -- Checkbox [XFELD]
    REQUIREDDIT,                   -- Checkbox [XFELD]
    NIGHT_DE,                      -- Checkbox [XFELD]
    NIGHT_DE_TIME,                 -- Time of Deduction [DEDUC_TIME]
    VISIBLENGT,                    -- Checkbox [XFELD]
    INPUTNGT,                      -- Checkbox [XFELD]
    REQUIREDNGT,                   -- Checkbox [XFELD]
    LU_COUPN,                      -- Checkbox [XFELD]
    VISIBLECUP,                    -- Checkbox [XFELD]
    INPUTCUP,                      -- Checkbox [XFELD]
    REQUIREDCUP,                   -- 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]
    VISIBLEBPK,                    -- Checkbox [XFELD]
    INPUTBPK,                      -- Checkbox [XFELD]
    REQUIREDBPK,                   -- Checkbox [XFELD]
    LUNCH_PIK,                     -- Pay./Kd Lunch [PTRV_SB_MITAG]
    VISIBLELPK,                    -- Checkbox [XFELD]
    INPUTLPK,                      -- Checkbox [XFELD]
    REQUIREDLPK,                   -- Checkbox [XFELD]
    DINNE_PIK,                     -- P/K Dinner [PTRV_SB_ABEND]
    VISIBLEDPK,                    -- Checkbox [XFELD]
    INPUTDPK,                      -- Checkbox [XFELD]
    REQUIREDDPK,                   -- Checkbox [XFELD]
    BRFT_REC_NO,                   -- Document Number [NRBEL]
    LNCH_REC_NO,                   -- Document Number [NRBEL]
    DINN_REC_NO,                   -- Document Number [NRBEL]
    MEALS_DE_STAGG_NAME,           -- Long Text [LTEXT]
    NIGHT_DE_STAGG_NAME,           -- Long Text [LTEXT]
    WEEKDAY_NAME,                  -- Day name [TAGBEZ]
    DUMMY_TRVPERDIEM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, DED_DATE)
);

Learn More