TRVS4_MILEAGE_D

Transparent Table Application Table
71 Fields 2 CDS Views

Draft table for entity I_TRAVELEXPENSEMILEAGE

TRVS4_MILEAGE_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELEXPENSEMILEAGE. It contains 71 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelExpenseMileageDraft view_entity from EXTENSION Travel Expense Mileage - Extn
R_TravelExpenseMileageDraft view_entity from BASIC Travel Expense Mileage Draft

Fields (71)

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 travelmileagesequencenumber KEY_MILE Sequence Number of Miles/Kilometers Distribution
travelexpnsequentialnumber PTRV_HDVRS Sequential no.
travelmileagedate DATKM Date
totalmilesrate VDM_TRVS4_TOTAL_DISTANCE Total Distance
domesticmilesrate KMINL Domes.M/Km
travelvehiclelicenseplate KFZKZ License Plate
travelvehiclemake KFZMA Veh.Make/Model
numberofpassenger AZMIT No. Passengers
travelbaggageweight VDM_TRVS4_BAG_WGHT Luggage Weight
additionalflatrateisapplicable VDM_ADDLFLATRATEENTPRISESPCFC Additional Flat Rate:Enterprise Specific
vehicletype KZPMF Vehicle Type
travelvehicleclass PKWKL Vehicle Class
country VDM_CTRY_REG Country / Region
triptypeenterprise VDM_ENTERPRISETYPE Trip Type, Company-Specific
triptypeenterprisename VDM_TT_COMSP_NAME Trip Type Enterprise Name
tripstartinglocationname VDM_TRVS4_FROM_LOC Departure Point
tripendlocationname VDM_TRVS4_TO_LOC Destination
travelmileageeditortext PTRV_WEB_EDITOR Editor
travelcomputeddistancerate COMPUTED_DIST Distance in M/Km
departurecityname AD_CITY1 City
departurepostalcode AD_PSTCD1 Postal Code
departurestreetname AD_STREET Street
departurehousenumber AD_HSNM1 House Number
departurecountry VDM_CTRY_REG Country / Region
departureregion VDM_TRVS4_STATE State
arrivalcityname AD_CITY1 City
arrivalpostalcode AD_PSTCD1 Postal Code
arrivalstreetname AD_STREET Street
arrivalhousenumber AD_HSNM1 House Number
arrivalcountry VDM_CTRY_REG Country / Region
arrivalregion VDM_TRVS4_STATE State
travelweightunit VDM_TRAVELWEIGHTUNIT Weight Unit
travelvehicletypename VDM_TRVS4_VEHTYPENAME Vehicle Type Name
travelvehicleclassname VDM_TRVS4_VEHICLECLASSNAME Vehicle Class Name
trvlexpntotalreimbursementamt VDM_TRVS4_REIMBURSEMENTAMOUNT Total Reimbursement
currency TRVWAERS Currency
departurecountryname VDM_DEPTCOUNTRYNAME Name Country / Region
traveldistanceunit VDM_TRAVELDISTANCEUNIT Distance Unit
arrivalcountryname VDM_ARRVLCOUNTRYNAME Name Country / Region
trvladditionalinformationtext PTRV_PTK10_ADD_INFO Additional Info
trvlmlgedepartureaddressnumber AD_ADDRNUM Address Number
trvlmlgearrivaladdressnumber AD_ADDRNUM Address Number
trvlmlgeisindautomdetmfuelpr PTRV_FUEL_RCPT_EXIST Automatic Price
trvlmlgefuelpriceperunitamount PTRV_FUEL_PRICE Price per Unit
travelmileagefuelpricecurrency WAERS Currency
trvlmlgedeptdistrictname AD_CITY2 District
trvlmlgearrivaldistrictname AD_CITY2 District
trvlmlgeisindkilometerdisplay MILEAGE_DISPLAY_ONLY Km Display Only
trvlmlgedeptcitylocationcode VDM_CITYLOCATIONCODE Location Code
trvlmlgearrvlcitylocationcode VDM_CITYLOCATIONCODE Location Code
trvlmlgeisindicatorroundtrip ROUND_TRIP Round Trip
trvlmlgetestingprocedureoffuel PTRV_CAR_CONSUMPTION_TYPE Consumption Type
tripregion RGION Trip Region
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
mlgelocllastchgddtetme ABP_LASTCHANGE_TSTMPL Changed On
destinationassignment KEYZI Dest.Assignment
travelcountryregion VDM_REG_CTRY Country / Region
travelcountryregiondeparture VDM_REG_CTRY Country / Region
travelcountryregionarrival VDM_REG_CTRY Country / Region
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_trvmileage_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_TRAVELEXPENSEMILEAGE
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_MILEAGE_D (
    MANDT,                           -- Client [MANDT]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    TRAVELTRIPNUMBER,                -- Trip Number [REINR]
    TRAVELREQUUID,                   -- UUID [SYSUUID_X16]
    SEQREQUUID,                      -- UUID [SYSUUID_X16]
    TRAVELMILEAGESEQUENCENUMBER,     -- Sequence Number of Miles/Kilometers Distribution [KEY_MILE]
    TRAVELEXPNSEQUENTIALNUMBER,      -- Sequential no. [PTRV_HDVRS]
    TRAVELMILEAGEDATE,               -- Date [DATKM]
    TOTALMILESRATE,                  -- Total Distance [VDM_TRVS4_TOTAL_DISTANCE]
    DOMESTICMILESRATE,               -- Domes.M/Km [KMINL]
    TRAVELVEHICLELICENSEPLATE,       -- License Plate [KFZKZ]
    TRAVELVEHICLEMAKE,               -- Veh.Make/Model [KFZMA]
    NUMBEROFPASSENGER,               -- No. Passengers [AZMIT]
    TRAVELBAGGAGEWEIGHT,             -- Luggage Weight [VDM_TRVS4_BAG_WGHT]
    ADDITIONALFLATRATEISAPPLICABLE,  -- Additional Flat Rate:Enterprise Specific [VDM_ADDLFLATRATEENTPRISESPCFC]
    VEHICLETYPE,                     -- Vehicle Type [KZPMF]
    TRAVELVEHICLECLASS,              -- Vehicle Class [PKWKL]
    COUNTRY,                         -- Country / Region [VDM_CTRY_REG]
    TRIPTYPEENTERPRISE,              -- Trip Type, Company-Specific [VDM_ENTERPRISETYPE]
    TRIPTYPEENTERPRISENAME,          -- Trip Type Enterprise Name [VDM_TT_COMSP_NAME]
    TRIPSTARTINGLOCATIONNAME,        -- Departure Point [VDM_TRVS4_FROM_LOC]
    TRIPENDLOCATIONNAME,             -- Destination [VDM_TRVS4_TO_LOC]
    TRAVELMILEAGEEDITORTEXT,         -- Editor [PTRV_WEB_EDITOR]
    TRAVELCOMPUTEDDISTANCERATE,      -- Distance in M/Km [COMPUTED_DIST]
    DEPARTURECITYNAME,               -- City [AD_CITY1]
    DEPARTUREPOSTALCODE,             -- Postal Code [AD_PSTCD1]
    DEPARTURESTREETNAME,             -- Street [AD_STREET]
    DEPARTUREHOUSENUMBER,            -- House Number [AD_HSNM1]
    DEPARTURECOUNTRY,                -- Country / Region [VDM_CTRY_REG]
    DEPARTUREREGION,                 -- State [VDM_TRVS4_STATE]
    ARRIVALCITYNAME,                 -- City [AD_CITY1]
    ARRIVALPOSTALCODE,               -- Postal Code [AD_PSTCD1]
    ARRIVALSTREETNAME,               -- Street [AD_STREET]
    ARRIVALHOUSENUMBER,              -- House Number [AD_HSNM1]
    ARRIVALCOUNTRY,                  -- Country / Region [VDM_CTRY_REG]
    ARRIVALREGION,                   -- State [VDM_TRVS4_STATE]
    TRAVELWEIGHTUNIT,                -- Weight Unit [VDM_TRAVELWEIGHTUNIT]
    TRAVELVEHICLETYPENAME,           -- Vehicle Type Name [VDM_TRVS4_VEHTYPENAME]
    TRAVELVEHICLECLASSNAME,          -- Vehicle Class Name [VDM_TRVS4_VEHICLECLASSNAME]
    TRVLEXPNTOTALREIMBURSEMENTAMT,   -- Total Reimbursement [VDM_TRVS4_REIMBURSEMENTAMOUNT]
    CURRENCY,                        -- Currency [TRVWAERS]
    DEPARTURECOUNTRYNAME,            -- Name Country / Region [VDM_DEPTCOUNTRYNAME]
    TRAVELDISTANCEUNIT,              -- Distance Unit [VDM_TRAVELDISTANCEUNIT]
    ARRIVALCOUNTRYNAME,              -- Name Country / Region [VDM_ARRVLCOUNTRYNAME]
    TRVLADDITIONALINFORMATIONTEXT,   -- Additional Info [PTRV_PTK10_ADD_INFO]
    TRVLMLGEDEPARTUREADDRESSNUMBER,  -- Address Number [AD_ADDRNUM]
    TRVLMLGEARRIVALADDRESSNUMBER,    -- Address Number [AD_ADDRNUM]
    TRVLMLGEISINDAUTOMDETMFUELPR,    -- Automatic Price [PTRV_FUEL_RCPT_EXIST]
    TRVLMLGEFUELPRICEPERUNITAMOUNT,  -- Price per Unit [PTRV_FUEL_PRICE]
    TRAVELMILEAGEFUELPRICECURRENCY,  -- Currency [WAERS]
    TRVLMLGEDEPTDISTRICTNAME,        -- District [AD_CITY2]
    TRVLMLGEARRIVALDISTRICTNAME,     -- District [AD_CITY2]
    TRVLMLGEISINDKILOMETERDISPLAY,   -- Km Display Only [MILEAGE_DISPLAY_ONLY]
    TRVLMLGEDEPTCITYLOCATIONCODE,    -- Location Code [VDM_CITYLOCATIONCODE]
    TRVLMLGEARRVLCITYLOCATIONCODE,   -- Location Code [VDM_CITYLOCATIONCODE]
    TRVLMLGEISINDICATORROUNDTRIP,    -- Round Trip [ROUND_TRIP]
    TRVLMLGETESTINGPROCEDUREOFFUEL,  -- Consumption Type [PTRV_CAR_CONSUMPTION_TYPE]
    TRIPREGION,                      -- Trip Region [RGION]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    MLGELOCLLASTCHGDDTETME,          -- Changed On [ABP_LASTCHANGE_TSTMPL]
    DESTINATIONASSIGNMENT,           -- Dest.Assignment [KEYZI]
    TRAVELCOUNTRYREGION,             -- Country / Region [VDM_REG_CTRY]
    TRAVELCOUNTRYREGIONDEPARTURE,    -- Country / Region [VDM_REG_CTRY]
    TRAVELCOUNTRYREGIONARRIVAL,      -- 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_TRVMILEAGE_INCL_EEW_PS,    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELMILEAGESEQUENCENUMBER)
);

Learn More