TRVS4_EXPENSE_D

Transparent Table Application Table
222 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 222 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 (222)

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 persg EE group
trvlexpnreimbmtgrpent persk EE subgroup
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
authoritycheckpersnumbervalue char1 Single-Character Flag
landingdestctrydate vdm_datv1 Start Date
landingatdesttime vdm_borderrettime Border Return Time
departureabroaddate vdm_datv1 Start Date
departureabroadtime vdm_borderrettime Border Return Time
abroadlandingischeck xfeld Checkbox
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
landingdestctrydate_h abap.raw
landingatdesttime_h abap.raw
departureabroaddate_h abap.raw
departureabroadtime_h abap.raw
abroadlandingischeck_h abap.raw
trvlexpnamountexceedingtext abap.sstring
reasonfordifflistishidden abap.char
trvlexpnapprovername vdm_trvlexpnapprovername Approver

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,        -- EE group [persg]
    TRVLEXPNREIMBMTGRPENT,           -- EE subgroup [persk]
    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]
    AUTHORITYCHECKPERSNUMBERVALUE,   -- Single-Character Flag [char1]
    LANDINGDESTCTRYDATE,             -- Start Date [vdm_datv1]
    LANDINGATDESTTIME,               -- Border Return Time [vdm_borderrettime]
    DEPARTUREABROADDATE,             -- Start Date [vdm_datv1]
    DEPARTUREABROADTIME,             -- Border Return Time [vdm_borderrettime]
    ABROADLANDINGISCHECK,            -- Checkbox [xfeld]
    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
    LANDINGDESTCTRYDATE_H,           -- abap.raw
    LANDINGATDESTTIME_H,             -- abap.raw
    DEPARTUREABROADDATE_H,           -- abap.raw
    DEPARTUREABROADTIME_H,           -- abap.raw
    ABROADLANDINGISCHECK_H,          -- abap.raw
    TRVLEXPNAMOUNTEXCEEDINGTEXT,     -- abap.sstring
    REASONFORDIFFLISTISHIDDEN,       -- abap.char
    TRVLEXPNAPPROVERNAME,            -- Approver [vdm_trvlexpnapprovername]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID)
);

Learn More