SAP table TPT_TMW_PROFILE (Time Manager's Workplace: Profile Settings)

SAP table TPT_TMW_PROFILE has 2 primary key fields being MANDT,PROFILE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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