FTPT_PLAN

Transparent Table Application Table
16 Fields 1 CDS Views

General Plan Data

FTPT_PLAN is an SAP database table in S/4HANA. General Plan Data. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TravelPlan view_entity from BASIC Travel Plan

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERNR_D Personnel No.
KEY reinr REINR Trip Number
KEY plannr PLAN_NR Plan Number
date_beg PLAN_DATBEG Start Date
time_beg PLAN_ZEIBEG Start Time
date_end PLAN_DATEND End date
time_end PLAN_ZEIEND End Time
destination PLAN_ZIEL Plan trip destin.
reason RKUNDE Reason
activity_type PLAN_ACTIVITY Activity Type
status PLAN_STATUS Planning Status
changed_by SYUNAME User Name
changed_at_date SYDATUM Current Date
changed_at_time SYUZEIT Time
policy_violation PLAN_POLICY_VIOLATION Policy Violation

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.

-- General Plan Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FTPT_PLAN (
    MANDT,             -- Client [MANDT]
    PERNR,             -- Personnel No. [PERNR_D]
    REINR,             -- Trip Number [REINR]
    PLANNR,            -- Plan Number [PLAN_NR]
    DATE_BEG,          -- Start Date [PLAN_DATBEG]
    TIME_BEG,          -- Start Time [PLAN_ZEIBEG]
    DATE_END,          -- End date [PLAN_DATEND]
    TIME_END,          -- End Time [PLAN_ZEIEND]
    DESTINATION,       -- Plan trip destin. [PLAN_ZIEL]
    REASON,            -- Reason [RKUNDE]
    ACTIVITY_TYPE,     -- Activity Type [PLAN_ACTIVITY]
    STATUS,            -- Planning Status [PLAN_STATUS]
    CHANGED_BY,        -- User Name [SYUNAME]
    CHANGED_AT_DATE,   -- Current Date [SYDATUM]
    CHANGED_AT_TIME,   -- Time [SYUZEIT]
    POLICY_VIOLATION,  -- Policy Violation [PLAN_POLICY_VIOLATION]
    PRIMARY KEY (MANDT, PERNR, REINR, PLANNR)
);

Learn More