TRVS4_MILEAGE

Transparent Table Application Table
62 Fields 2 CDS Views

Travel Mileage

TRVS4_MILEAGE is an SAP database table in S/4HANA. Travel Mileage. It contains 62 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelExpenseMileageData view_entity from EXTENSION Travel Expense Mileage - Extension
I_TravelExpenseMileageData view_entity from BASIC Travel Expense Mileage

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERNR_D Personnel No.
KEY reinr REINR Trip Number
KEY hdvrs PTRV_HDVRS Sequential no.
KEY key_mile KEY_MILE Sequence Number of Miles/Kilometers Distribution
mil_date DATKM Date
m_total KMGES Total Miles/Km
m_domest KMINL Domes.M/Km
lic_plat KFZKZ License Plate
car_make KFZMA Veh.Make/Model
passenge AZMIT No. Passengers
bag_wght KGGEP Baggage Weight
add_flra BETPA Add.FR Ent.
veh_type KZPMF Vehicle Type
veh_clas PKWKL Vehicle Class
country LNDGR Trip Ctry/Reg
region RGION Trip Region
loc_from PTRV_LOC_FROM Start Location
loc_to PTRV_LOC_TO End Location
tt_comsp BEREI Trip Type E
m_acc_dom KMKUM Accum. M/Km
m_acc_abr KMKUM Accum. M/Km
add_info PTRV_PTK10_ADD_INFO Additional Info
display_only MILEAGE_DISPLAY_ONLY Km Display Only
editor PTRV_WEB_EDITOR Editor
computed_dist COMPUTED_DIST Distance in M/Km
round_trip ROUND_TRIP Round Trip
consumption_type PTRV_CAR_CONSUMPTION_TYPE Consumption Type
fuel_rcpt_exist PTRV_FUEL_RCPT_EXIST Automatic Price
fuel_price PTRV_FUEL_PRICE Price per Unit
fuel_price_curr WAERS Currency
adrnrad1 AD_ADDRNUM Address Number
cityad1 AD_CITY1 City
city_districtad1 AD_CITY2 District
post_codead1 AD_PSTCD1 Postal Code
city_codead1 PTRV_CITY_CODE Community Code No.
streetad1 AD_STREET Street
house_numad1 AD_HSNM1 House Number
countryad1 LAND1 Country/Reg.
regionad1 REGIO Region
adrnrad2 AD_ADDRNUM Address Number
cityad2 AD_CITY1 City
city_districtad2 AD_CITY2 District
post_codead2 AD_PSTCD1 Postal Code
city_codead2 PTRV_CITY_CODE Community Code No.
streetad2 AD_STREET Street
house_numad2 AD_HSNM1 House Number
countryad2 LAND1 Country/Reg.
regionad2 REGIO Region
veh_type_name TEXT_KZPMF Name
veh_clas_name TEXT_PKWKL Name
country_region_name TEXT_RGION Name Ctry/Region
tt_comsp_name TEXT_BEREI Name
key_stop_name LTEXT Long Text
calculatedamount PTRV_PD_MILEAGE Travel FlatRate
currency TRVWAERS Currency
distance_unit UNIT Unit
weight_unit UNIT Unit
country_region_name2 TEXT_RGION Name Ctry/Region
country_name2 TEXT_RGION Name Ctry/Region
key_stop KEYZI Dest.Assignment
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.

-- Travel Mileage
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_MILEAGE (
    MANDT,                         -- Client [MANDT]
    PERNR,                         -- Personnel No. [PERNR_D]
    REINR,                         -- Trip Number [REINR]
    HDVRS,                         -- Sequential no. [PTRV_HDVRS]
    KEY_MILE,                      -- Sequence Number of Miles/Kilometers Distribution [KEY_MILE]
    MIL_DATE,                      -- Date [DATKM]
    M_TOTAL,                       -- Total Miles/Km [KMGES]
    M_DOMEST,                      -- Domes.M/Km [KMINL]
    LIC_PLAT,                      -- License Plate [KFZKZ]
    CAR_MAKE,                      -- Veh.Make/Model [KFZMA]
    PASSENGE,                      -- No. Passengers [AZMIT]
    BAG_WGHT,                      -- Baggage Weight [KGGEP]
    ADD_FLRA,                      -- Add.FR Ent. [BETPA]
    VEH_TYPE,                      -- Vehicle Type [KZPMF]
    VEH_CLAS,                      -- Vehicle Class [PKWKL]
    COUNTRY,                       -- Trip Ctry/Reg [LNDGR]
    REGION,                        -- Trip Region [RGION]
    LOC_FROM,                      -- Start Location [PTRV_LOC_FROM]
    LOC_TO,                        -- End Location [PTRV_LOC_TO]
    TT_COMSP,                      -- Trip Type E [BEREI]
    M_ACC_DOM,                     -- Accum. M/Km [KMKUM]
    M_ACC_ABR,                     -- Accum. M/Km [KMKUM]
    ADD_INFO,                      -- Additional Info [PTRV_PTK10_ADD_INFO]
    DISPLAY_ONLY,                  -- Km Display Only [MILEAGE_DISPLAY_ONLY]
    EDITOR,                        -- Editor [PTRV_WEB_EDITOR]
    COMPUTED_DIST,                 -- Distance in M/Km [COMPUTED_DIST]
    ROUND_TRIP,                    -- Round Trip [ROUND_TRIP]
    CONSUMPTION_TYPE,              -- Consumption Type [PTRV_CAR_CONSUMPTION_TYPE]
    FUEL_RCPT_EXIST,               -- Automatic Price [PTRV_FUEL_RCPT_EXIST]
    FUEL_PRICE,                    -- Price per Unit [PTRV_FUEL_PRICE]
    FUEL_PRICE_CURR,               -- Currency [WAERS]
    ADRNRAD1,                      -- Address Number [AD_ADDRNUM]
    CITYAD1,                       -- City [AD_CITY1]
    CITY_DISTRICTAD1,              -- District [AD_CITY2]
    POST_CODEAD1,                  -- Postal Code [AD_PSTCD1]
    CITY_CODEAD1,                  -- Community Code No. [PTRV_CITY_CODE]
    STREETAD1,                     -- Street [AD_STREET]
    HOUSE_NUMAD1,                  -- House Number [AD_HSNM1]
    COUNTRYAD1,                    -- Country/Reg. [LAND1]
    REGIONAD1,                     -- Region [REGIO]
    ADRNRAD2,                      -- Address Number [AD_ADDRNUM]
    CITYAD2,                       -- City [AD_CITY1]
    CITY_DISTRICTAD2,              -- District [AD_CITY2]
    POST_CODEAD2,                  -- Postal Code [AD_PSTCD1]
    CITY_CODEAD2,                  -- Community Code No. [PTRV_CITY_CODE]
    STREETAD2,                     -- Street [AD_STREET]
    HOUSE_NUMAD2,                  -- House Number [AD_HSNM1]
    COUNTRYAD2,                    -- Country/Reg. [LAND1]
    REGIONAD2,                     -- Region [REGIO]
    VEH_TYPE_NAME,                 -- Name [TEXT_KZPMF]
    VEH_CLAS_NAME,                 -- Name [TEXT_PKWKL]
    COUNTRY_REGION_NAME,           -- Name Ctry/Region [TEXT_RGION]
    TT_COMSP_NAME,                 -- Name [TEXT_BEREI]
    KEY_STOP_NAME,                 -- Long Text [LTEXT]
    CALCULATEDAMOUNT,              -- Travel FlatRate [PTRV_PD_MILEAGE]
    CURRENCY,                      -- Currency [TRVWAERS]
    DISTANCE_UNIT,                 -- Unit [UNIT]
    WEIGHT_UNIT,                   -- Unit [UNIT]
    COUNTRY_REGION_NAME2,          -- Name Ctry/Region [TEXT_RGION]
    COUNTRY_NAME2,                 -- Name Ctry/Region [TEXT_RGION]
    KEY_STOP,                      -- Dest.Assignment [KEYZI]
    DUMMY_TRVMILEAGE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, KEY_MILE)
);

Learn More