FTPT_REQ_HEAD

Transparent Table Application Table
21 Fields 3 CDS Views

Rahmendaten des Reiseantrages

FTPT_REQ_HEAD is an SAP database table in S/4HANA. Rahmendaten des Reiseantrages. It contains 21 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 (21)

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

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.

-- Rahmendaten des Reiseantrages
-- 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]
    PRIMARY KEY (MANDT, PERNR, REINR, REQUESTVRS, PLAN_REQUEST)
);

Learn More