TRVS4_PERDIEM_D

Transparent Table Application Table
30 Fields 2 CDS Views

Draft table for entity I_TRVLEXPENSEPERDIEMDEDUCTION

TRVS4_PERDIEM_D is an SAP database table in S/4HANA. Draft table for entity I_TRVLEXPENSEPERDIEMDEDUCTION. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlExpnPerDiemDeductionDrft view_entity from EXTENSION TrvlExpn PerDiem Ducdn - Extension
R_TrvlExpnPerDiemDeductionDrft view_entity from BASIC Travel Expense Per Diem Deduction Draft

Fields (30)

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 perdiemdeductiondate ABZDA Date
travelexpnsequentialnumber PTRV_HDVRS Sequential no.
perdiembreakfastisdeducted VDM_BREAK_DE Breakfast
perdiembreakfastdeductiontime VDM_BREAK_DE_TIME Breakfast Time of Deduction
perdiemlunchisdeducted VDM_LUNCH_DE Lunch
perdiemlunchdeductiontime VDM_LUNCH_DE_TIME Lunch Time of Deduction
perdiemdinnerisdeducted VDM_DINNER_DE Dinner
perdiemdinnerdeductiontime VDM_DINNE_DE_TIME Dinner Time of Deduction
perdiemovernightisdeducted VDM_NIGHT_DE Forenight
perdiemovernightdeductiontime VDM_NIGHT_DE_TIME Overnight Time of Deduction
perdiemmealcouponisdeducted VDM_LU_COUPON Meal Coupons
perdiempaytforbrkfstisddctd VDM_BREAK_PIK Payment in Kind Breakfast
perdiempaytforlunchisddctd VDM_LUNCH_PIK Payment in Kind Lunch
perdiempaytfordinnerisddctd VDM_DINNE_PIK Payment in Kind Dinner
perdiembreakfastrecordnumber NRBEL Document Number
perdiemlunchrecordnumber NRBEL Document Number
perdiemdinnerrecordnumber NRBEL Document Number
perdiemlocllastchgddtetme 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_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.

-- Draft table for entity I_TRVLEXPENSEPERDIEMDEDUCTION
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_PERDIEM_D (
    MANDT,                          -- Client [MANDT]
    PERSONNELNUMBER,                -- Personnel No. [PERNR_D]
    TRAVELTRIPNUMBER,               -- Trip Number [REINR]
    TRAVELREQUUID,                  -- UUID [SYSUUID_X16]
    SEQREQUUID,                     -- UUID [SYSUUID_X16]
    PERDIEMDEDUCTIONDATE,           -- Date [ABZDA]
    TRAVELEXPNSEQUENTIALNUMBER,     -- Sequential no. [PTRV_HDVRS]
    PERDIEMBREAKFASTISDEDUCTED,     -- Breakfast [VDM_BREAK_DE]
    PERDIEMBREAKFASTDEDUCTIONTIME,  -- Breakfast Time of Deduction [VDM_BREAK_DE_TIME]
    PERDIEMLUNCHISDEDUCTED,         -- Lunch [VDM_LUNCH_DE]
    PERDIEMLUNCHDEDUCTIONTIME,      -- Lunch Time of Deduction [VDM_LUNCH_DE_TIME]
    PERDIEMDINNERISDEDUCTED,        -- Dinner [VDM_DINNER_DE]
    PERDIEMDINNERDEDUCTIONTIME,     -- Dinner Time of Deduction [VDM_DINNE_DE_TIME]
    PERDIEMOVERNIGHTISDEDUCTED,     -- Forenight [VDM_NIGHT_DE]
    PERDIEMOVERNIGHTDEDUCTIONTIME,  -- Overnight Time of Deduction [VDM_NIGHT_DE_TIME]
    PERDIEMMEALCOUPONISDEDUCTED,    -- Meal Coupons [VDM_LU_COUPON]
    PERDIEMPAYTFORBRKFSTISDDCTD,    -- Payment in Kind Breakfast [VDM_BREAK_PIK]
    PERDIEMPAYTFORLUNCHISDDCTD,     -- Payment in Kind Lunch [VDM_LUNCH_PIK]
    PERDIEMPAYTFORDINNERISDDCTD,    -- Payment in Kind Dinner [VDM_DINNE_PIK]
    PERDIEMBREAKFASTRECORDNUMBER,   -- Document Number [NRBEL]
    PERDIEMLUNCHRECORDNUMBER,       -- Document Number [NRBEL]
    PERDIEMDINNERRECORDNUMBER,      -- Document Number [NRBEL]
    PERDIEMLOCLLASTCHGDDTETME,      -- 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_TRVPERDIEM_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, PERDIEMDEDUCTIONDATE)
);

Learn More