TRVS4_REQUEST_D

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_TRAVELREQUEST
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_REQUEST_D (
    MANDT,                          -- Client [mandt]
    PERSONNELNUMBER,                -- Personnel No. [pernr_d]
    TRAVELTRIPNUMBER,               -- Trip Number [reinr]
    TRAVELREQUUID,                  -- UUID [sysuuid_x16]
    TRAVELEXPNSEQUENTIALNUMBER,     -- Sequential no. [ptrv_hdvrs]
    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]
    TRAVELREQUESTOUTBOUNDTIME,      -- Time [uhrgh]
    DOMESTICARRVLDATE,              -- Border Return Date [vdm_bordertripreturndate]
    TRIPRETTIME,                    -- Border Return Time [vdm_borderrettime]
    TRIPCTRYREG,                    -- Region: Border Cross [vdm_rgnofrettripbrdrcrossing]
    TRIPTYPEENTERPRISE,             -- Trip Type Ent Specific [vdm_triptypeenterprise]
    TRIPSCHEMA,                     -- Trip Schema [rsche]
    TRIPTYPESTATUTORY,              -- Statutory Trip Type [vdm_trvs4_statutory_trip_type]
    TYPEOFTRIPACTIVITYVALUE,        -- Activity (Planning) [vdm_plan_activity]
    MEALSPERDIEM,                   -- Meals Per Diems [verpa]
    ACCOMMODATIONHASPERDIEM,        -- Accom. per Diem [uepkz]
    NROFOVERNIGHTPERDIEMNIGHTS,     -- PD Nights [anuep]
    MAXNROFPERDIEMNIGHTS,           -- Meals Per Diem Reduc [vdm_mealsperdiemreduction]
    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]
    TRVLREQAPPROVALSTATUS,          -- Request/Trip [antrg]
    SETTLMTSTATUS,                  -- Settlement Status [vdm_settlementstatus]
    TRVLREQHASFINANCETRANSF,        -- 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]
    TRVLREQHASMILESPERACCTG,        -- 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]
    TRVLREQNMBRFORCORRESPGWRK,      -- Trip Start Work [ptrv_dantn]
    ASSOCDBUSTRIPNROFRET,           -- Ref Biz Trip Return [vdm_tripnmbrofassocdbusret]
    PERDIEMSPRTNALLWNCTXNDTE,       -- Tax Per Diem Start Date [vdm_strtoftxnperdiemnallwncdte]
    SEPARATIONALLWNCTXNSTARTDATE,   -- Start Tax Sep. Allow [vdm_taxseparationallwnc]
    TRVLREQALLWNCLVL1DTE,           -- Date: Reduc Level 1 [vdm_dtereduc1]
    TRVLREQALLWNCLVL2DTE,           -- 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]
    TRVLREQNROFDAYSOUTBANDRET,      -- Daily Ret & Outb Trp Days [vdm_dailyretaoutbnmbr]
    TRVLREQNROFDAYSOUTBORRET,       -- Daily Ret or OutbTrp Days [vdm_dailyretooutbnmbr]
    DISTANCETOWORKPLACEVALUE,       -- Distance [ptrvps_tr_entfernung]
    MEALSISGRATUITOUSFORMONTH,      -- Gratuitous Meals [ptrv_v_unentgeltlich]
    ACMDTNISGRATUITOUSFORMNTH,      -- Gratuitous Accomodat [vdm_gratuitousacmdtn]
    TRVLREQUESTREIMBURSEMENTGROUP,  -- 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]
    TRVLREQHASREIMBURSEMENT,        -- No Reimbursement [ptrv_not_paid]
    SHORTDISTANCETOWPLCVALUE,       -- Short Distance [ptrv_entf_wo_do]
    STATRYEXCLSNPERDISEXPIRED,      -- Exclu. Perio expired [vdm_statryexclsnperdexprd]
    TRVLREQHASPRVTTRIPBRK,          -- 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]
    TRAVELREQUESTAMOUNTISROUNDED,   -- Round [ptrv_rounding]
    TRVLREQESTDCOSTFRMPLNAMT,       -- Estimated Costs Plan [vdm_estdcost_plan]
    TRVLREQESTDCOSTFRMREQAMT,       -- 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]
    TRAVELSTATUSCRITICALITY,        -- Travel Status Criticality [vdm_travel_statuscriticality]
    TRAVELSTATUS,                   -- Trip Status [vdm_trip_status]
    COMPANYCODE,                    -- Company Code [bukrs]
    COSTCENTER,                     -- Cost Center [kostl]
    PERSONWORKAGRMTAUTHZNGRPG,      -- Org.key [vdsk1]
    TRVLREQEMPLGRPG,                -- Employee Grouping [vdm_emplgrpgfortrvlmgmt]
    TRVLREQREIMBMTGRPSTATRY,        -- EE group [persg]
    TRVLREQREIMBMTGRPENT,           -- EE subgroup [persk]
    PERSONNELAREA,                  -- Personnel area [persa]
    TRIPAUTHZNFCTRVAL,              -- abap.char
    CITYNAME,                       -- City [ad_city1]
    STREETNAME,                     -- Street [ad_street]
    POSTALCODE,                     -- Postal Code [ad_pstcd1]
    DISTRICTNAME,                   -- District [ad_city2]
    TRAVELCOMMUNITYCITYNAME,        -- City [ad_city1]
    TRAVELCOMMUNITYPOSTCODE,        -- Postal Code [ad_pstcd1]
    TRAVELCOMMUNITYDISTRICTNAME,    -- District [ad_city2]
    TRAVELLOCATIONCODE,             -- Location Code [vdm_s4_locationcode]
    TRAVELEMPLOYEENAME,             -- Employee [vdm_frmtdemplapplcntname]
    TRAVELEMPLOYEEUSERIDENTIFIER,   -- System ID [sysid]
    TRVLREQAREPLANREQ,              -- Plan Request ID [plan_request]
    TRAVELVERSIONNUMBER,            -- Version number [request_version]
    TRAVELREQUESTEDITORTEXT,        -- Editor [ptrv_web_editor]
    STARTTIMEZONE,                  -- Time Zone [timezone]
    ENDTIMEZONE,                    -- Time Zone [timezone]
    TRVLREQSTARTDATETIME,           -- Start Date and Time [vdm_startdatetime]
    TRVLREQENDDATETIME,             -- End Date and Time [vdm_enddatetime]
    LASTCHANGEDATETIME,             -- Last Changed On [vdm_lastchangedon]
    LOCALLASTCHANGEDATETIME,        -- Changed On [abp_lastchange_tstmpl]
    TRAVELREQUESTCREATEDBY,         -- User Name [syuname]
    TRAVELREQUESTLASTCHANGEDBY,     -- User Name [syuname]
    TRAVELREQUESTISMODIFIED,        -- abap.char
    TRAVELCOUNTRYREGION,            -- Country / Region [vdm_reg_ctry]
    AUTHORITYCHECKPERSNUMBERVALUE,  -- Pers.No.Check [authp]
    NUMBEROFPASSENGERWITHME,        -- No. of Passengers [ptrv_no_carry_others]
    PSSNGRISCARRIEDBYOTHEMPL,       -- Passenger w/Other E. [ptrv_carried_by_other]
    CARPOOLDRIVER,                  -- Taking Passengers [ptrv_carry_others]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID)
);