1. SAP Tutorial
  2. FI Module

FTPT_TM_MEMO SAP table for – Memo table for Travel Management

Here we would like to draw your attention to FTPT_TM_MEMO table in SAP. As we know it is being mainly used with the SAP FI-TV (Travel Management in FI) component which is coming under FI module (Financial Accounting). FTPT_TM_MEMO is a SAP standard transp table used for storing Memo table for Travel Management related data in SAP. It comes under the package PTRP.

SAP FTPT_TM_MEMO table

Table FTPT_TM_MEMO technical data

TableFTPT_TM_MEMO
Data storingMemo table for Travel Management
ModuleFI
Sub ModuleFI-TV-PL
SAP PackagePTRP
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_HRGXX
Table CategoryTRANSP

SAP FTPT_TM_MEMO Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FTPT_TM_MEMO table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERNR : Personnel Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • REINR : Trip Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • SCHEM : Trip schema
    Its data type is CHAR (Character String) with field length 2
  • KZREA : Trip Type: Statutory
    Its data type is CHAR (Character String) with field length 1
  • BEREI : Trip Type: Enterprise-Specific
    Its data type is CHAR (Character String) with field length 1
  • KZTKT : Trip Activity Type
    Its data type is CHAR (Character String) with field length 1
  • ZORT1 : Location
    Its data type is CHAR (Character String) with field length 17
  • ZLAND : Trip Country / Trip Country Group
    Its data type is CHAR (Character String) with field length 3
  • HRGIO : Region of Main Destination
    Its data type is CHAR (Character String) with field length 5
  • KUNDE : Reason for trip (e.g. customer/requisitioner)
    Its data type is CHAR (Character String) with field length 17
  • DATV1 : Beginning Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRV1 : Beginning Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATB1 : End Date of Trip Segment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRB1 : End Time of Trip Segment
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • VERPA : Per-Diem Accounting for Meals
    Its data type is CHAR (Character String) with field length 1
  • DATH1 : Border Crossing (Trip Out): Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRH1 : Time: Border crossing(trip out)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • DATR1 : Border Crossing (Return Trip): Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UHRR1 : Time: Border crossing(return trip)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

    • FTPT_TM_MEMO related tables

    • TA20B1 : Control Variants – Travel Planning (Language-Dependent)
    • TA20Q_CAT : Define Queue Categories of Sales Office
    • TA21CAR1 : Car Rental Rates (Language-Dependent)
    • TA20PF : Travel Profiles – Methods of Payment
    • TA20BH : Displayable Hotel Rates of User Groups
    • TA20LE : Tree Node (Current Settings for Travel Planning)
    • TA20K1 : Reasons (Language-Dependent)
    • TA20DB : Access Parameters for Deutsche Bahn via API
    • TA20NCR : Negotiated Car Rental Rates
    • TA20REBF : Discount Agreement for Flights
    • FTPT_TM_MEMO : Memo table for Travel Management
    • TA21REGION : IATA/ATPCO Areas
    • TA20GDS_CODES : Assignment of SAP Codes to GDS Codes
    • TA20SUBSCRPT_ASG : Logon to External Reservation System per Sales Office
    • TA20_SWITCH : Global Control Parameters
    • TA20C1 : Enterprise-Spec. Travel Service Categories (Language-Dep.)
    • TA20RMRK : Company-Specific PNR Elements
    • TA20OFFICE_FIND : Access Parameters per Group ID – Sales Office Determination
    • FTPT_FLIGHT_FCMP : Assignment table: flights <-> rate components
    • TA20NEGOF : Negotiated Flight Fares (Corporate Nego Fares)

    Related References

    Related Tutorials

    T706_CONST SAP table for – PA parameters: Travel Management

    T706_CONST table in SAP FI (Travel Management in FI) module. This table is used for storing data of PA parameters:...

    T706Y SAP table for – Names for Employee Groupings for Travel Management

    T706Y table in SAP FI (Travel Management in FI) module. This table is used for storing data of Names for...

    T702Y SAP table for – Employee Groupings for Travel Management

    T702Y table in SAP FI (Travel Management in FI) module. This table is used for storing data of Employee Groupings...

    PTRV_ADMIN SAP table for – Travel Management: Administrative Data for Personnel Numbers

    PTRV_ADMIN table in SAP FI (Travel Management in FI) module. This table is used for storing data of Travel Management:...

    PTRV_VATDETAIL SAP table for – Supplier Data for VAT Refund in Travel Management

    PTRV_VATDETAIL table in SAP FI (Travel Management in FI) module. This table is used for storing data of Supplier Data...

    FTPT_REQ_HEAD SAP table for – Framework Data of Travel Request

    FTPT_REQ_HEAD table in SAP FI (Travel Management in FI) module. This table is used for storing data of Framework Data...

    TA20PPI SAP table for – Assignment Table of Trip Rules for Travel Profiles

    TA20PPI table in SAP FI (Travel Management in FI) module. This table is used for storing data of Assignment Table...

    «
    »