TRVS4_EXPENSE_D

Transparent Table Application Table
218 Fields 2 CDS Views

Draft table for entity I_TRAVELEXPENSE

TRVS4_EXPENSE_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELEXPENSE. It contains 218 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelExpenseDraft view_entity from EXTENSION Travel Expense - Extn
R_TravelExpenseDraft view_entity from BASIC Travel Expense Draft

Fields (218)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY personnelnumber PERNR_D Personnel No.
KEY traveltripnumber REINR Trip Number
KEY travelrequuid SYSUUID_X16 UUID
travelexpnsequentialnumber PTRV_HDVRS Sequential no.
periodsequentialnumber PTRV_PDVRS Sequence Number
tripdeparturedate VDM_DATV1 Start Date
departurebegintime REBEU Trip Begins At
triparrivaldate VDM_DATB1 End Date
arrivalendtime REENU Trip Ends At
tripreasontext VDM_REASON Reason
tripdestination VDM_DESTINATION Destination
country VDM_CTRY_REG Country / Region
maindestinationregion VDM_MAINDESTREGION Region: Main Dest
domesticdeptdate VDM_BORDERTRIPDEPTDATE Border Trip Out Date
travelexpenseoutboundtime UHRGH Time
domesticarrvldate VDM_BORDERTRIPRETURNDATE Border Return Date
triprettime VDM_BORDERRETTIME Border Return Time
triptypeenterprise VDM_TRVS4_TTENTERPRISE Enterprise Trip Type
tripschema RSCHE Trip Schema
triptypestatutory VDM_TRVS4_STATUTORY_TRIP_TYPE Statutory Trip Type
typeoftripactivityvalue VDM_PLAN_ACTIVITY Activity (Planning)
mealsperdiem VDM_DE_STAGG Reimbursement
accommodationhasperdiem VDM_DE_STAGG1 Reimbursement
nrofovernightperdiemnights ANUEP PD Nights
trvlexpnhasmealsperdiemreducn VDM_MEALSPERDIEMREDUCTION Meals Per Diem Reduc
maxnrofperdiemnights ANUEP PD Nights
tripactivitytype KZTKT Activity
estimatedcost VDM_TOTAL_ESTIMATED_COST Total Estimated Cost
estimatedcostcrcy VDM_ESTDCOSTCRCY Estimated Cost Currency
paymentcurrency WAERS Currency
travelrequestisexists VDM_REQUEST Request ID
travelplanisexists VDM_PLAN Plan ID Indicator
triphasexpenses VDM_EXPENSE Reference Expense ID
tripprintstatusvalue P_PRINT Print Status
trvlexpnapprovalstatus ANTRG Request/Trip
settlmtstatus VDM_SETTLEMENTSTATUS Settlement Status
trvlexpnhasfinancetransf UEBRF FI Transfer
humrscepayrolltransfer VDM_HRPAYROLLTRANSFER HR Payroll Transfer
datamdmexchistransf VDM_DATAMEDIUMEXCHTRANSFERIND Data Medium Exch Transf
countrygroup MOLGA HCM Local.
tripprovisionvariant VDM_TRIPPROVISIONVARIANT Trip Provision Variant
tripsettlementdate PTRV_ACCDT Settl Date
tripsettlementtime PTRV_ACCTM Settlement Time
postingsequencenumber VDM_POSTINGRUNREF Posting Run Ref
trvlexpnhasmilesperacctg PTRV_NO_MILES_ACCOUNTING No ml/km acctng
tripislocked PTRV_TLOCK Trip locked
lastchangedate AEDAT Changed On
lastchangedattime AEUHR Changed at
changedbyname AENAM Changed By
changereportname AEREP Change Report
movingcostsrefundvalue VDM_MOVINGCOSTSREFUNDCONF Moving Cost Refund
adminofficemovelabel PTRV_PS_ACCEPTING_DEPARTMENT Accepting Dept
diffntendoftrvlallwncdte VDM_DIFFNTENDOFTRVLALLWNCDTE Travel Allow End
departurework VDM_DEPTRFRMRESIDENCEORWPLC Departure
arrivalwork VDM_PTRV_ARRVL Arrival
returnworkplacevalue PTRV_RETRN Return
trvlexpnnmbrforcorrespgwrk PTRV_DANTN Trip Start Work
assocdbustripnrofret VDM_TRIPNMBROFASSOCDBUSRET Ref Biz Trip Return
departureperioddate REBED Trip Begins On
tripbeginsattime VDM_BEGINTIME Begins At
arrivalperioddate REEND Trip Ends On
tripendsattime VDM_ENDTIME Ends At
perdiemsprtnallwnctxndte VDM_STRTOFTXNPERDIEMNALLWNCDTE Tax Per Diem Start Date
separationallwnctxnstartdate VDM_TAXSEPARATIONALLWNC Start Tax Sep. Allow
trvlexpnallwnclvl1dte VDM_DTEREDUC1 Date: Reduc Level 1
trvlexpnallwnclvl2dte VDM_DTEREDUC2 Date: Reduc Level 2
workstartdate VDM_WORKSTARTDATE Work Start Date
workcommencestime PTRV_PS_UHRV1_DIENST Time Work Commences
workenddate VDM_WORKENDDATE Work End Date
workendstime PTRV_PS_UHRB1_DIENST Time Work Ends
assocdsuperiorsprtnallwnc VDM_ASSOCDSPRTNALLWNC Separation Allowance
homehasseparationallwnctxn VDM_HOMESEPALLWNCTXN Home for Sep. Allow.
trvlexpnnrofdaysoutbandret VDM_DAILYRETAOUTBNMBR Daily Ret & Outb Trp Days
trvlexpnnrofdaysoutborret VDM_DAILYRETOOUTBNMBR Daily Ret or OutbTrp Days
distancetoworkplacevalue PTRVPS_TR_ENTFERNUNG Distance
mealsisgratuitousformonth PTRV_V_UNENTGELTLICH Gratuitous Meals
acmdtnisgratuitousformnth VDM_GRATUITOUSACMDTN Gratuitous Accomodat
trvlexpensereimbursementgroup VDM_REIMBMTGRPFORREDUCNMEALS Reimburs. meal deduc
bustripisapproved PTRV_PERM_TRIP_APPROVAL Standing Approval
fulltripreimbmtisrequested VDM_FULLTRIPSGMTREIMBMTISREQD Trip Reimb Requested
significantofclhasintrst VDM_SIGNIFICANTOFCLINTRST SignifOfficialInt
maxtripsgmtreimbmtisincrd PTRV_WEG_ERH_MAX Increased TSR
trvlexpnhasreimbursement PTRV_NOT_PAID No Reimbursement
shortdistancetowplcvalue PTRV_ENTF_WO_DO Short Distance
statryexclsnperdisexpired VDM_STATRYEXCLSNPERDEXPRD Exclu. Perio expired
trvlexpnhasprvttripbrk VDM_DURNOFPRIVATETRIPBREAK Private Trip Break
mealsperdiemhastxn VDM_MEALSPERDIEMHASTXN Auto Acmd Meals Tax
mealsperdiemhasmnltxn VDM_MEALSPERDIEMHASMNLTXN Manual Meals Taxation
acmdtnperdiemhasmnltxn VDM_ACMDTNPERDIEMHASMNLTXN Manual Acmd Taxation
referencedate PTRV_DATTN Reference Date
travelexpenseamountisrounded PTRV_ROUNDING Round
trvlexpnestdcostfrmplnamt VDM_ESTDCOST_PLAN Estimated Costs Plan
trvlexpnestdcostfrmreqamt VDM_ESTDCOST_REQUEST Estimated Cost Request
reasonfordifferencetext VDM_REASONFORDIFFERENCE Reason for Difference
dailyallwncislmtdto180 PTRV_PS_DZ_LIMIT_180 DA Limit 180
wholetriphastaxation PTRVPS_TAX_TRIP Taxation of Trip
periodnumberoftrip PTRV_PEROD Period Number
periodtype PTRV_PS_PERIODENART Period type
newadminofficename VDM_NEWADMINOFFICENAME Admin Office Move
addressdeparturename PTRV_ADDR_DEPAR Departure Point
addressarrivalname PTRV_ADDR_ARRVL Arrival Point
currentdutycountry VDM_CURRENTDUTYCOUNTRY Duty Country / Region
currentdutyregion PTRV_PS_DUTY_REGION Duty Region
sprtnallwncrelocnmbr VDM_SPRTNALLWNCRELOC Sep. Allow. Reloc.
kitchenamenities PTRV_KITCHEN_TEMP_ACCOMODATION Kitchen Amen.
numberofpersons PTRV_PS_NUMBER_PERSONS Persons
triptypeenterprisename VDM_TRIPTYPEENTERPRISENAME Border Crossing: Enterprise Specific
tripactivitytypename VDM_PLAN_ACTIVITY_NAME Activity Name
countrygroupname VDM_TRIPCTRYGRPREGION Deptr Cntry / Grp / Rgn
tripctryreg VDM_RGNOFRETTRIPBRDRCROSSING Region: Border Cross
travelcountryregiongroup VDM_REG_CTRY Country / Region
travelstatuscriticality VDM_TRAVEL_STATUSCRITICALITY Travel Status Criticality
travelexpensepostingdate BUDAT Posting Date
travelexpensestatuscriticality VDM_TRAVEL_STATUSCRITICALITY Travel Status Criticality
travelexpensestatus VDM_TRIP_STATUS Trip Status
travelstatus VDM_TRIP_STATUS Trip Status
companycode BUKRS Company Code
costcenter KOSTL Cost Center
personworkagrmtauthzngrpg VDSK1 Org.key
trvlexpnemplgrpg VDM_EMPLGRPGFORTRVLMGMT Employee Grouping
trvlexpnreimbmtgrpstatry VDM_REIMBMTGRPSTATUTORY Per Diem Reimb Stat
trvlexpnreimbmtgrpent VDM_REIMBMTGRPENTERPRISE PD Reimb Group Ent.
personnelarea PERSA Personnel area
tripauthznfctrval abap.char
destinationassignment KEYZI Dest.Assignment
cityname PAD_ORT01 City
streetname VDM_STREETANDHOUSENMBR Street and House Number
postalcode PSTLZ Postal Code
districtname PAD_ORT02 District
housenumber AD_HSNM1 House Number
travellocationcode PTRV_CITY_CODE Community Code No.
travelcommunitycityname PAD_ORT01 City
travelcommunitypostcode PSTLZ Postal Code
travelcommunitydistrictname PAD_ORT02 District
travelemployeename VDM_FRMTDEMPLAPPLCNTNAME Employee
travelemployeeuseridentifier SYSID System ID
trvlexpnstartdatetime VDM_STARTDATETIME Start Date and Time
starttimezone TIMEZONE Time Zone
trvlexpnenddatetime VDM_ENDDATETIME End Date and Time
endtimezone TIMEZONE Time Zone
travelexpenseeditortext PTRV_WEB_EDITOR Editor
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
locallastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
travelexpensecreatedby SYUNAME User Name
travelexpenselastchangedby SYUNAME User Name
travelexpenseismodified abap.char
trvlexpnreimbursementamount abap.curr
travelexpensetotalamount abap.curr
mealsperdiemreimbmtamount abap.curr
acmdtnperdiemreimbmtamount abap.curr
travelcountryregion VDM_REG_CTRY Country / Region
accommodationhasperdiem_h abap.raw
acmdtnisgratuitousformnth_h abap.raw
acmdtnperdiemhasmnltxn_h abap.raw
addressarrivalname_h abap.raw
addressdeparturename_h abap.raw
arrivalendtime_h abap.raw
arrivalwork_h abap.raw
cityname_h abap.raw
currentdutycountry_h abap.raw
currentdutyregion_h abap.raw
dailyallwncislmtdto180_h abap.raw
departurebegintime_h abap.raw
departurework_h abap.raw
distancetoworkplacevalue_h abap.raw
districtname_h abap.raw
domesticarrvldate_h abap.raw
domesticdeptdate_h abap.raw
fulltripreimbmtisrequested_h abap.raw
homehasseparationallwnctxn_h abap.raw
housenumber_h abap.raw
kitchenamenities_h abap.raw
maxtripsgmtreimbmtisincrd_h abap.raw
mealsisgratuitousformonth_h abap.raw
mealsperdiem_h abap.raw
mealsperdiemhasmnltxn_h abap.raw
mealsperdiemhastxn_h abap.raw
movingcostsrefundvalue_h abap.raw
nrofovernightperdiemnights_h abap.raw
numberofpersons_h abap.raw
postalcode_h abap.raw
reasonfordifferencetext_h abap.raw
referencedate_h abap.raw
returnworkplacevalue_h abap.raw
shortdistancetowplcvalue_h abap.raw
significantofclhasintrst_h abap.raw
streetname_h abap.raw
travelcountryregion_h abap.raw
travelcountryregiongroup_h abap.raw
travelexpenseeditortext_h abap.raw
travelexpenseoutboundtime_h abap.raw
travellocationcode_h abap.raw
tripactivitytype_h abap.raw
triparrivaldate_h abap.raw
tripbeginsattime_h abap.raw
tripdeparturedate_h abap.raw
tripdestination_h abap.raw
tripendsattime_h abap.raw
tripreasontext_h abap.raw
triprettime_h abap.raw
triptypeenterprise_h abap.raw
triptypestatutory_h abap.raw
typeoftripactivityvalue_h abap.raw
workcommencestime_h abap.raw
workenddate_h abap.raw
workendstime_h abap.raw
workstartdate_h abap.raw
trvlexpnamountexceedingtext abap.sstr
reasonfordifflistishidden abap.char
trvlexpnapprovername VDM_TRVLEXPNAPPROVERNAME Approver
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_trvexpense_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_TRAVELEXPENSE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_EXPENSE_D (
    MANDT,                           -- Client [MANDT]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    TRAVELTRIPNUMBER,                -- Trip Number [REINR]
    TRAVELREQUUID,                   -- UUID [SYSUUID_X16]
    TRAVELEXPNSEQUENTIALNUMBER,      -- Sequential no. [PTRV_HDVRS]
    PERIODSEQUENTIALNUMBER,          -- Sequence Number [PTRV_PDVRS]
    TRIPDEPARTUREDATE,               -- Start Date [VDM_DATV1]
    DEPARTUREBEGINTIME,              -- Trip Begins At [REBEU]
    TRIPARRIVALDATE,                 -- End Date [VDM_DATB1]
    ARRIVALENDTIME,                  -- Trip Ends At [REENU]
    TRIPREASONTEXT,                  -- Reason [VDM_REASON]
    TRIPDESTINATION,                 -- Destination [VDM_DESTINATION]
    COUNTRY,                         -- Country / Region [VDM_CTRY_REG]
    MAINDESTINATIONREGION,           -- Region: Main Dest [VDM_MAINDESTREGION]
    DOMESTICDEPTDATE,                -- Border Trip Out Date [VDM_BORDERTRIPDEPTDATE]
    TRAVELEXPENSEOUTBOUNDTIME,       -- Time [UHRGH]
    DOMESTICARRVLDATE,               -- Border Return Date [VDM_BORDERTRIPRETURNDATE]
    TRIPRETTIME,                     -- Border Return Time [VDM_BORDERRETTIME]
    TRIPTYPEENTERPRISE,              -- Enterprise Trip Type [VDM_TRVS4_TTENTERPRISE]
    TRIPSCHEMA,                      -- Trip Schema [RSCHE]
    TRIPTYPESTATUTORY,               -- Statutory Trip Type [VDM_TRVS4_STATUTORY_TRIP_TYPE]
    TYPEOFTRIPACTIVITYVALUE,         -- Activity (Planning) [VDM_PLAN_ACTIVITY]
    MEALSPERDIEM,                    -- Reimbursement [VDM_DE_STAGG]
    ACCOMMODATIONHASPERDIEM,         -- Reimbursement [VDM_DE_STAGG1]
    NROFOVERNIGHTPERDIEMNIGHTS,      -- PD Nights [ANUEP]
    TRVLEXPNHASMEALSPERDIEMREDUCN,   -- Meals Per Diem Reduc [VDM_MEALSPERDIEMREDUCTION]
    MAXNROFPERDIEMNIGHTS,            -- PD Nights [ANUEP]
    TRIPACTIVITYTYPE,                -- Activity [KZTKT]
    ESTIMATEDCOST,                   -- Total Estimated Cost [VDM_TOTAL_ESTIMATED_COST]
    ESTIMATEDCOSTCRCY,               -- Estimated Cost Currency [VDM_ESTDCOSTCRCY]
    PAYMENTCURRENCY,                 -- Currency [WAERS]
    TRAVELREQUESTISEXISTS,           -- Request ID [VDM_REQUEST]
    TRAVELPLANISEXISTS,              -- Plan ID Indicator [VDM_PLAN]
    TRIPHASEXPENSES,                 -- Reference Expense ID [VDM_EXPENSE]
    TRIPPRINTSTATUSVALUE,            -- Print Status [P_PRINT]
    TRVLEXPNAPPROVALSTATUS,          -- Request/Trip [ANTRG]
    SETTLMTSTATUS,                   -- Settlement Status [VDM_SETTLEMENTSTATUS]
    TRVLEXPNHASFINANCETRANSF,        -- FI Transfer [UEBRF]
    HUMRSCEPAYROLLTRANSFER,          -- HR Payroll Transfer [VDM_HRPAYROLLTRANSFER]
    DATAMDMEXCHISTRANSF,             -- Data Medium Exch Transf [VDM_DATAMEDIUMEXCHTRANSFERIND]
    COUNTRYGROUP,                    -- HCM Local. [MOLGA]
    TRIPPROVISIONVARIANT,            -- Trip Provision Variant [VDM_TRIPPROVISIONVARIANT]
    TRIPSETTLEMENTDATE,              -- Settl Date [PTRV_ACCDT]
    TRIPSETTLEMENTTIME,              -- Settlement Time [PTRV_ACCTM]
    POSTINGSEQUENCENUMBER,           -- Posting Run Ref [VDM_POSTINGRUNREF]
    TRVLEXPNHASMILESPERACCTG,        -- No ml/km acctng [PTRV_NO_MILES_ACCOUNTING]
    TRIPISLOCKED,                    -- Trip locked [PTRV_TLOCK]
    LASTCHANGEDATE,                  -- Changed On [AEDAT]
    LASTCHANGEDATTIME,               -- Changed at [AEUHR]
    CHANGEDBYNAME,                   -- Changed By [AENAM]
    CHANGEREPORTNAME,                -- Change Report [AEREP]
    MOVINGCOSTSREFUNDVALUE,          -- Moving Cost Refund [VDM_MOVINGCOSTSREFUNDCONF]
    ADMINOFFICEMOVELABEL,            -- Accepting Dept [PTRV_PS_ACCEPTING_DEPARTMENT]
    DIFFNTENDOFTRVLALLWNCDTE,        -- Travel Allow End [VDM_DIFFNTENDOFTRVLALLWNCDTE]
    DEPARTUREWORK,                   -- Departure [VDM_DEPTRFRMRESIDENCEORWPLC]
    ARRIVALWORK,                     -- Arrival [VDM_PTRV_ARRVL]
    RETURNWORKPLACEVALUE,            -- Return [PTRV_RETRN]
    TRVLEXPNNMBRFORCORRESPGWRK,      -- Trip Start Work [PTRV_DANTN]
    ASSOCDBUSTRIPNROFRET,            -- Ref Biz Trip Return [VDM_TRIPNMBROFASSOCDBUSRET]
    DEPARTUREPERIODDATE,             -- Trip Begins On [REBED]
    TRIPBEGINSATTIME,                -- Begins At [VDM_BEGINTIME]
    ARRIVALPERIODDATE,               -- Trip Ends On [REEND]
    TRIPENDSATTIME,                  -- Ends At [VDM_ENDTIME]
    PERDIEMSPRTNALLWNCTXNDTE,        -- Tax Per Diem Start Date [VDM_STRTOFTXNPERDIEMNALLWNCDTE]
    SEPARATIONALLWNCTXNSTARTDATE,    -- Start Tax Sep. Allow [VDM_TAXSEPARATIONALLWNC]
    TRVLEXPNALLWNCLVL1DTE,           -- Date: Reduc Level 1 [VDM_DTEREDUC1]
    TRVLEXPNALLWNCLVL2DTE,           -- Date: Reduc Level 2 [VDM_DTEREDUC2]
    WORKSTARTDATE,                   -- Work Start Date [VDM_WORKSTARTDATE]
    WORKCOMMENCESTIME,               -- Time Work Commences [PTRV_PS_UHRV1_DIENST]
    WORKENDDATE,                     -- Work End Date [VDM_WORKENDDATE]
    WORKENDSTIME,                    -- Time Work Ends [PTRV_PS_UHRB1_DIENST]
    ASSOCDSUPERIORSPRTNALLWNC,       -- Separation Allowance [VDM_ASSOCDSPRTNALLWNC]
    HOMEHASSEPARATIONALLWNCTXN,      -- Home for Sep. Allow. [VDM_HOMESEPALLWNCTXN]
    TRVLEXPNNROFDAYSOUTBANDRET,      -- Daily Ret & Outb Trp Days [VDM_DAILYRETAOUTBNMBR]
    TRVLEXPNNROFDAYSOUTBORRET,       -- Daily Ret or OutbTrp Days [VDM_DAILYRETOOUTBNMBR]
    DISTANCETOWORKPLACEVALUE,        -- Distance [PTRVPS_TR_ENTFERNUNG]
    MEALSISGRATUITOUSFORMONTH,       -- Gratuitous Meals [PTRV_V_UNENTGELTLICH]
    ACMDTNISGRATUITOUSFORMNTH,       -- Gratuitous Accomodat [VDM_GRATUITOUSACMDTN]
    TRVLEXPENSEREIMBURSEMENTGROUP,   -- Reimburs. meal deduc [VDM_REIMBMTGRPFORREDUCNMEALS]
    BUSTRIPISAPPROVED,               -- Standing Approval [PTRV_PERM_TRIP_APPROVAL]
    FULLTRIPREIMBMTISREQUESTED,      -- Trip Reimb Requested [VDM_FULLTRIPSGMTREIMBMTISREQD]
    SIGNIFICANTOFCLHASINTRST,        -- SignifOfficialInt [VDM_SIGNIFICANTOFCLINTRST]
    MAXTRIPSGMTREIMBMTISINCRD,       -- Increased TSR [PTRV_WEG_ERH_MAX]
    TRVLEXPNHASREIMBURSEMENT,        -- No Reimbursement [PTRV_NOT_PAID]
    SHORTDISTANCETOWPLCVALUE,        -- Short Distance [PTRV_ENTF_WO_DO]
    STATRYEXCLSNPERDISEXPIRED,       -- Exclu. Perio expired [VDM_STATRYEXCLSNPERDEXPRD]
    TRVLEXPNHASPRVTTRIPBRK,          -- Private Trip Break [VDM_DURNOFPRIVATETRIPBREAK]
    MEALSPERDIEMHASTXN,              -- Auto Acmd Meals Tax [VDM_MEALSPERDIEMHASTXN]
    MEALSPERDIEMHASMNLTXN,           -- Manual Meals Taxation [VDM_MEALSPERDIEMHASMNLTXN]
    ACMDTNPERDIEMHASMNLTXN,          -- Manual Acmd Taxation [VDM_ACMDTNPERDIEMHASMNLTXN]
    REFERENCEDATE,                   -- Reference Date [PTRV_DATTN]
    TRAVELEXPENSEAMOUNTISROUNDED,    -- Round [PTRV_ROUNDING]
    TRVLEXPNESTDCOSTFRMPLNAMT,       -- Estimated Costs Plan [VDM_ESTDCOST_PLAN]
    TRVLEXPNESTDCOSTFRMREQAMT,       -- Estimated Cost Request [VDM_ESTDCOST_REQUEST]
    REASONFORDIFFERENCETEXT,         -- Reason for Difference [VDM_REASONFORDIFFERENCE]
    DAILYALLWNCISLMTDTO180,          -- DA Limit 180 [PTRV_PS_DZ_LIMIT_180]
    WHOLETRIPHASTAXATION,            -- Taxation of Trip [PTRVPS_TAX_TRIP]
    PERIODNUMBEROFTRIP,              -- Period Number [PTRV_PEROD]
    PERIODTYPE,                      -- Period type [PTRV_PS_PERIODENART]
    NEWADMINOFFICENAME,              -- Admin Office Move [VDM_NEWADMINOFFICENAME]
    ADDRESSDEPARTURENAME,            -- Departure Point [PTRV_ADDR_DEPAR]
    ADDRESSARRIVALNAME,              -- Arrival Point [PTRV_ADDR_ARRVL]
    CURRENTDUTYCOUNTRY,              -- Duty Country / Region [VDM_CURRENTDUTYCOUNTRY]
    CURRENTDUTYREGION,               -- Duty Region [PTRV_PS_DUTY_REGION]
    SPRTNALLWNCRELOCNMBR,            -- Sep. Allow. Reloc. [VDM_SPRTNALLWNCRELOC]
    KITCHENAMENITIES,                -- Kitchen Amen. [PTRV_KITCHEN_TEMP_ACCOMODATION]
    NUMBEROFPERSONS,                 -- Persons [PTRV_PS_NUMBER_PERSONS]
    TRIPTYPEENTERPRISENAME,          -- Border Crossing: Enterprise Specific [VDM_TRIPTYPEENTERPRISENAME]
    TRIPACTIVITYTYPENAME,            -- Activity Name [VDM_PLAN_ACTIVITY_NAME]
    COUNTRYGROUPNAME,                -- Deptr Cntry / Grp / Rgn [VDM_TRIPCTRYGRPREGION]
    TRIPCTRYREG,                     -- Region: Border Cross [VDM_RGNOFRETTRIPBRDRCROSSING]
    TRAVELCOUNTRYREGIONGROUP,        -- Country / Region [VDM_REG_CTRY]
    TRAVELSTATUSCRITICALITY,         -- Travel Status Criticality [VDM_TRAVEL_STATUSCRITICALITY]
    TRAVELEXPENSEPOSTINGDATE,        -- Posting Date [BUDAT]
    TRAVELEXPENSESTATUSCRITICALITY,  -- Travel Status Criticality [VDM_TRAVEL_STATUSCRITICALITY]
    TRAVELEXPENSESTATUS,             -- Trip Status [VDM_TRIP_STATUS]
    TRAVELSTATUS,                    -- Trip Status [VDM_TRIP_STATUS]
    COMPANYCODE,                     -- Company Code [BUKRS]
    COSTCENTER,                      -- Cost Center [KOSTL]
    PERSONWORKAGRMTAUTHZNGRPG,       -- Org.key [VDSK1]
    TRVLEXPNEMPLGRPG,                -- Employee Grouping [VDM_EMPLGRPGFORTRVLMGMT]
    TRVLEXPNREIMBMTGRPSTATRY,        -- Per Diem Reimb Stat [VDM_REIMBMTGRPSTATUTORY]
    TRVLEXPNREIMBMTGRPENT,           -- PD Reimb Group Ent. [VDM_REIMBMTGRPENTERPRISE]
    PERSONNELAREA,                   -- Personnel area [PERSA]
    TRIPAUTHZNFCTRVAL,               -- abap.char
    DESTINATIONASSIGNMENT,           -- Dest.Assignment [KEYZI]
    CITYNAME,                        -- City [PAD_ORT01]
    STREETNAME,                      -- Street and House Number [VDM_STREETANDHOUSENMBR]
    POSTALCODE,                      -- Postal Code [PSTLZ]
    DISTRICTNAME,                    -- District [PAD_ORT02]
    HOUSENUMBER,                     -- House Number [AD_HSNM1]
    TRAVELLOCATIONCODE,              -- Community Code No. [PTRV_CITY_CODE]
    TRAVELCOMMUNITYCITYNAME,         -- City [PAD_ORT01]
    TRAVELCOMMUNITYPOSTCODE,         -- Postal Code [PSTLZ]
    TRAVELCOMMUNITYDISTRICTNAME,     -- District [PAD_ORT02]
    TRAVELEMPLOYEENAME,              -- Employee [VDM_FRMTDEMPLAPPLCNTNAME]
    TRAVELEMPLOYEEUSERIDENTIFIER,    -- System ID [SYSID]
    TRVLEXPNSTARTDATETIME,           -- Start Date and Time [VDM_STARTDATETIME]
    STARTTIMEZONE,                   -- Time Zone [TIMEZONE]
    TRVLEXPNENDDATETIME,             -- End Date and Time [VDM_ENDDATETIME]
    ENDTIMEZONE,                     -- Time Zone [TIMEZONE]
    TRAVELEXPENSEEDITORTEXT,         -- Editor [PTRV_WEB_EDITOR]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    LOCALLASTCHANGEDATETIME,         -- Changed On [ABP_LASTCHANGE_TSTMPL]
    TRAVELEXPENSECREATEDBY,          -- User Name [SYUNAME]
    TRAVELEXPENSELASTCHANGEDBY,      -- User Name [SYUNAME]
    TRAVELEXPENSEISMODIFIED,         -- abap.char
    TRVLEXPNREIMBURSEMENTAMOUNT,     -- abap.curr
    TRAVELEXPENSETOTALAMOUNT,        -- abap.curr
    MEALSPERDIEMREIMBMTAMOUNT,       -- abap.curr
    ACMDTNPERDIEMREIMBMTAMOUNT,      -- abap.curr
    TRAVELCOUNTRYREGION,             -- Country / Region [VDM_REG_CTRY]
    ACCOMMODATIONHASPERDIEM_H,       -- abap.raw
    ACMDTNISGRATUITOUSFORMNTH_H,     -- abap.raw
    ACMDTNPERDIEMHASMNLTXN_H,        -- abap.raw
    ADDRESSARRIVALNAME_H,            -- abap.raw
    ADDRESSDEPARTURENAME_H,          -- abap.raw
    ARRIVALENDTIME_H,                -- abap.raw
    ARRIVALWORK_H,                   -- abap.raw
    CITYNAME_H,                      -- abap.raw
    CURRENTDUTYCOUNTRY_H,            -- abap.raw
    CURRENTDUTYREGION_H,             -- abap.raw
    DAILYALLWNCISLMTDTO180_H,        -- abap.raw
    DEPARTUREBEGINTIME_H,            -- abap.raw
    DEPARTUREWORK_H,                 -- abap.raw
    DISTANCETOWORKPLACEVALUE_H,      -- abap.raw
    DISTRICTNAME_H,                  -- abap.raw
    DOMESTICARRVLDATE_H,             -- abap.raw
    DOMESTICDEPTDATE_H,              -- abap.raw
    FULLTRIPREIMBMTISREQUESTED_H,    -- abap.raw
    HOMEHASSEPARATIONALLWNCTXN_H,    -- abap.raw
    HOUSENUMBER_H,                   -- abap.raw
    KITCHENAMENITIES_H,              -- abap.raw
    MAXTRIPSGMTREIMBMTISINCRD_H,     -- abap.raw
    MEALSISGRATUITOUSFORMONTH_H,     -- abap.raw
    MEALSPERDIEM_H,                  -- abap.raw
    MEALSPERDIEMHASMNLTXN_H,         -- abap.raw
    MEALSPERDIEMHASTXN_H,            -- abap.raw
    MOVINGCOSTSREFUNDVALUE_H,        -- abap.raw
    NROFOVERNIGHTPERDIEMNIGHTS_H,    -- abap.raw
    NUMBEROFPERSONS_H,               -- abap.raw
    POSTALCODE_H,                    -- abap.raw
    REASONFORDIFFERENCETEXT_H,       -- abap.raw
    REFERENCEDATE_H,                 -- abap.raw
    RETURNWORKPLACEVALUE_H,          -- abap.raw
    SHORTDISTANCETOWPLCVALUE_H,      -- abap.raw
    SIGNIFICANTOFCLHASINTRST_H,      -- abap.raw
    STREETNAME_H,                    -- abap.raw
    TRAVELCOUNTRYREGION_H,           -- abap.raw
    TRAVELCOUNTRYREGIONGROUP_H,      -- abap.raw
    TRAVELEXPENSEEDITORTEXT_H,       -- abap.raw
    TRAVELEXPENSEOUTBOUNDTIME_H,     -- abap.raw
    TRAVELLOCATIONCODE_H,            -- abap.raw
    TRIPACTIVITYTYPE_H,              -- abap.raw
    TRIPARRIVALDATE_H,               -- abap.raw
    TRIPBEGINSATTIME_H,              -- abap.raw
    TRIPDEPARTUREDATE_H,             -- abap.raw
    TRIPDESTINATION_H,               -- abap.raw
    TRIPENDSATTIME_H,                -- abap.raw
    TRIPREASONTEXT_H,                -- abap.raw
    TRIPRETTIME_H,                   -- abap.raw
    TRIPTYPEENTERPRISE_H,            -- abap.raw
    TRIPTYPESTATUTORY_H,             -- abap.raw
    TYPEOFTRIPACTIVITYVALUE_H,       -- abap.raw
    WORKCOMMENCESTIME_H,             -- abap.raw
    WORKENDDATE_H,                   -- abap.raw
    WORKENDSTIME_H,                  -- abap.raw
    WORKSTARTDATE_H,                 -- abap.raw
    TRVLEXPNAMOUNTEXCEEDINGTEXT,     -- abap.sstr
    REASONFORDIFFLISTISHIDDEN,       -- abap.char
    TRVLEXPNAPPROVERNAME,            -- Approver [VDM_TRVLEXPNAPPROVERNAME]
    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_TRVEXPENSE_INCL_EEW_PS,    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID)
);

Learn More