1. Home
  2. Resources
  3. SAP Tables
  4. TPT_TMW_PROFILE - Time Manager's Workplace: Profile Settings

SAP Table TPT_TMW_PROFILE

Time Manager's Workplace: Profile Settings

TPT_TMW_PROFILE (Time Manager's Workplace: Profile Settings) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TPT_TMW_PROFILE to other SAP tables.

TPT_TMW_PROFILE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PROFILE Time Manager's Workplace: Profile PT_TMW_PROFILE CHAR 30 0
DATEID Time Manager's Workplace: Initial Period PT_TMW_DATEID NUMC 2 0
01 Current day
02 Current week
03 Current month
RELPOSBEGNUMBER Relative Position for Start and End Date PT_TMW_RELATIVE_POSITION NUMC 3 0
RELPOSBEGUNIT Unit for Relative Position of Start and End Date PT_TMW_RELATIVE_UNIT CHAR 3 0
010 Days
011 Weeks
012 Months
RELPOSENDNUMBER Relative Position for Start and End Date PT_TMW_RELATIVE_POSITION NUMC 3 0
RELPOSENDUNIT Unit for Relative Position of Start and End Date PT_TMW_RELATIVE_UNIT CHAR 3 0
010 Days
011 Weeks
012 Months
FIRSTDAYOFWEEK Weekday PT_TMW_WEEKDAY NUMC 1 0
0 Sunday
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday
CHANGESUBLA Profile Settings: Change Subset IDs PT_TMW_CHANGE_SUBLA_ALLOWED CHAR 1 0
X Yes
NULL No
USRSELIDGROUPID Employee Selection Group: User-Specific PT_TMW_EMP_SEL_GROUPID_USR CHAR 20 0
GENSELIDGROUPID Employee Selection Group: For All Users PT_TMW_EMP_SEL_GROUPID_GEN CHAR 20 0
SETSELIDAREA Functional Area for Interactive Employee Selection PT_TMW_SELID_AREA CHAR 24 0
SETSELIDGROUPID Employee Selection Group: Online PT_TMW_EMP_SEL_GROUPID_SET CHAR 20 0
RELPOSNUMBER Relative Position for Initial Period PT_TMW_RELATIVE_PERIOD_POS NUMC 3 0
RELPOSUNIT Unit for Relative Position of Start and End Date PT_TMW_RELATIVE_UNIT CHAR 3 0
010 Days
011 Weeks
012 Months
PERSELBEGNUMBER Relative Position for Employee Selection Period PT_TMW_RELATIVE_PERSEL_POS NUMC 3 0
PERSELBEGUNIT Unit for Relative Position of Start and End Date PT_TMW_RELATIVE_UNIT CHAR 3 0
010 Days
011 Weeks
012 Months
PERSELENDNUMBER Relative Position for Employee Selection Period PT_TMW_RELATIVE_PERSEL_POS NUMC 3 0
PERSELENDUNIT Unit for Relative Position of Start and End Date PT_TMW_RELATIVE_UNIT CHAR 3 0
010 Days
011 Weeks
012 Months
RELPOSDIRECTION Direction PT_DIRECTION CHAR 1 0
1 Forwards
2 Backwards
MLINETOP Profile Setting: Message Line in Upper Screen Area PT_TMW_MLINE_TOP CHAR 1 0
X Yes
NULL No

TPT_TMW_PROFILE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TPT_TMW_PROFILE MANDT TPT_TMW_PROFILE MANDT T000 Clients MANDT