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,        -- Per Diem Reimb Stat [VDM_REIMBMTGRPSTATUTORY]
    TRVLREQREIMBMTGRPENT,           -- PD Reimb Group Ent. [VDM_REIMBMTGRPENTERPRISE]
    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,                  -- abap.char
    ENDTIMEZONE,                    -- abap.char
    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]
    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_TRVREQUEST_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID)
);