FTPT_REQ_HEAD

Transparent Table Application Table
45 Fields 3 CDS Views

Framework Data of Travel Request

FTPT_REQ_HEAD is an SAP database table in S/4HANA. Framework Data of Travel Request. It contains 45 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_TravelGeneralData view_entity from EXTENSION Travel Request General Data - Extension
I_TravelReqFrameworkData view_entity from BASIC Travel Request Framework Data
I_TrvlAprvdFutureRequest view_entity inner BASIC Future Approved Travel Requests

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERNR_D Personnel No.
KEY reinr REINR Trip Number
KEY requestvrs REQUEST_VERSION Version number
KEY plan_request PLAN_REQUEST Plan Request ID
location_end REQUEST_END Destination
country_end LAND1 Country/Reg.
request_reason REQUEST_REASON Reason
date_beg REQUEST_DATEBEG Begins On
time_beg REQUEST_TIMEBEG Start Time
date_end REQUEST_DATEEND Ends On
time_end REQUEST_TIMEEND Ends At
activity_type PLAN_ACTIVITY Activity Type
estimated_cost PTRV_ESTIMATED_COST Total Cost
currency TRVWAERS Currency
status PLAN_STATUS Planning Status
dates AEDAT Changed On
times AEUHR Changed at
uname AENAM Changed By
repid AEREP Change Report
depar PTRV_DEPAR Departure
createdby ANGNAM Created By
approvedby GENNAM Approved By
delivery_date REQ_DELIVERY_DATE Delivery Date
delivery_loc REQ_DELIVERY_LOC Delivery Locat.
delivery_area REQ_DELIVERY_AREA Delivery Area
delivery_empl REQ_DELIVERY_EMPLOYEE Recipient
arrival_work PTRV_ARRIVAL_WORK Arrival
return_work PTRV_RETURN_WORK Arrival
t_actype KZTKT Activity
perm_trip_appr PTRV_PERM_TRIP_APPROVAL Standing Approval
tt_statu KZREA Trip Type S
tt_comsp BEREI Trip Type E
gwe PTRV_ANTRAG_GWE Full TSR
edi PTRV_ERH_DIENST_INT SignifOfficialInt
carry_oth PTRV_NO_CARRY_OTHERS No. of Passengers
carried_by_oth PTRV_CARRIED_BY_OTHER Passenger w/Other E.
datecow PTRV_PS_DATV1_DIENST Work Start
timecow PTRV_PS_UHRV1_DIENST Time Work Commences
dateeow PTRV_PS_DATB1_DIENST Date Work Ends
timeeow PTRV_PS_UHRB1_DIENST Time Work Ends
incr_max_tripseg_reimb PTRV_WEG_ERH_MAX Increased TSR
addr_depar PTRV_ADDR_DEPAR Departure Point
addr_arrvl PTRV_ADDR_ARRVL Arrival Point
dummy_trvrequest_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.

-- Framework Data of Travel Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FTPT_REQ_HEAD (
    MANDT,                         -- Client [MANDT]
    PERNR,                         -- Personnel No. [PERNR_D]
    REINR,                         -- Trip Number [REINR]
    REQUESTVRS,                    -- Version number [REQUEST_VERSION]
    PLAN_REQUEST,                  -- Plan Request ID [PLAN_REQUEST]
    LOCATION_END,                  -- Destination [REQUEST_END]
    COUNTRY_END,                   -- Country/Reg. [LAND1]
    REQUEST_REASON,                -- Reason [REQUEST_REASON]
    DATE_BEG,                      -- Begins On [REQUEST_DATEBEG]
    TIME_BEG,                      -- Start Time [REQUEST_TIMEBEG]
    DATE_END,                      -- Ends On [REQUEST_DATEEND]
    TIME_END,                      -- Ends At [REQUEST_TIMEEND]
    ACTIVITY_TYPE,                 -- Activity Type [PLAN_ACTIVITY]
    ESTIMATED_COST,                -- Total Cost [PTRV_ESTIMATED_COST]
    CURRENCY,                      -- Currency [TRVWAERS]
    STATUS,                        -- Planning Status [PLAN_STATUS]
    DATES,                         -- Changed On [AEDAT]
    TIMES,                         -- Changed at [AEUHR]
    UNAME,                         -- Changed By [AENAM]
    REPID,                         -- Change Report [AEREP]
    DEPAR,                         -- Departure [PTRV_DEPAR]
    CREATEDBY,                     -- Created By [ANGNAM]
    APPROVEDBY,                    -- Approved By [GENNAM]
    DELIVERY_DATE,                 -- Delivery Date [REQ_DELIVERY_DATE]
    DELIVERY_LOC,                  -- Delivery Locat. [REQ_DELIVERY_LOC]
    DELIVERY_AREA,                 -- Delivery Area [REQ_DELIVERY_AREA]
    DELIVERY_EMPL,                 -- Recipient [REQ_DELIVERY_EMPLOYEE]
    ARRIVAL_WORK,                  -- Arrival [PTRV_ARRIVAL_WORK]
    RETURN_WORK,                   -- Arrival [PTRV_RETURN_WORK]
    T_ACTYPE,                      -- Activity [KZTKT]
    PERM_TRIP_APPR,                -- Standing Approval [PTRV_PERM_TRIP_APPROVAL]
    TT_STATU,                      -- Trip Type S [KZREA]
    TT_COMSP,                      -- Trip Type E [BEREI]
    GWE,                           -- Full TSR [PTRV_ANTRAG_GWE]
    EDI,                           -- SignifOfficialInt [PTRV_ERH_DIENST_INT]
    CARRY_OTH,                     -- No. of Passengers [PTRV_NO_CARRY_OTHERS]
    CARRIED_BY_OTH,                -- Passenger w/Other E. [PTRV_CARRIED_BY_OTHER]
    DATECOW,                       -- Work Start [PTRV_PS_DATV1_DIENST]
    TIMECOW,                       -- Time Work Commences [PTRV_PS_UHRV1_DIENST]
    DATEEOW,                       -- Date Work Ends [PTRV_PS_DATB1_DIENST]
    TIMEEOW,                       -- Time Work Ends [PTRV_PS_UHRB1_DIENST]
    INCR_MAX_TRIPSEG_REIMB,        -- Increased TSR [PTRV_WEG_ERH_MAX]
    ADDR_DEPAR,                    -- Departure Point [PTRV_ADDR_DEPAR]
    ADDR_ARRVL,                    -- Arrival Point [PTRV_ADDR_ARRVL]
    DUMMY_TRVREQUEST_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, REQUESTVRS, PLAN_REQUEST)
);

Learn More