WFA_TS_WRKRL_TEMPL_DATA SAP (WFM workrule template data) Structure details
Description: WFM workrule template data
Related tables to WFA_TS_WRKRL_TEMPL_DATA
Access table WFA_TS_WRKRL_TEMPL_DATA
Structure field list including key, data, relationships and ABAP select examples
WFA_TS_WRKRL_TEMPL_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "WFM workrule template data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_WFA_TS_WRKRL_TEMPL_DATA TYPE WFA_TS_WRKRL_TEMPL_DATA.
The WFA_TS_WRKRL_TEMPL_DATA table consists of various fields, each holding specific information or linking keys about WFM workrule template data data available in SAP. These include EDITABLE (Boolean ( True = 'X', False = ' ')), MINHRSWEEK (Minimum Hours per Week), MAXHRSWEEK (Maximum Hours per Week), MINHOURSSHIFT (Minimum Hours per Shift).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP WFA_TS_WRKRL_TEMPL_DATA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
TEMPLATE_ID | Work Rule Template Set ID | WFA_WKRLTEMPID | CHAR | 20 | Assigned to domain | ALPHA | WFA_WKRLTEMPID | ||
EDITABLE | Boolean ( True = 'X', False = ' ') | WFA_BOOLEAN | CHAR | 1 | WFA_BOOLEAN | ||||
MINHRSWEEK | Minimum Hours per Week | WFA_TV_MIN_HRS_WEEK | DEC | 10(2) | DEC10_2 | ||||
MAXHRSWEEK | Maximum Hours per Week | WFA_TV_MAX_HRS_WEEK | DEC | 10(2) | DEC10_2 | ||||
MINHOURSSHIFT | Minimum Hours per Shift | WFA_TV_MIN_HRS_SHIFT | DEC | 10(2) | DEC10_2 | ||||
MAXHOURSSHIFT | Maximum Hours per Shift | WFA_TV_MAX_HRS_SHIFT | DEC | 10(2) | DEC10_2 | ||||
WKENDMAXHRSSHIFT | Maximum Hours for a Shift on a Weekend Day | WFA_TV_MAX_HRS_SHIFT_WEEKEND | DEC | 10(2) | DEC10_2 | ||||
MAXSCHEDDAYSWEEK | Maximum Number of Scheduled Days per Week | WFA_TV_MAX_SCHED_DAYS_WEEK | INT1 | 3 | |||||
MINTIMBTSHIFTS | Minimum Hours between Consecutive Shifts | WFA_TV_MIN_TIME_BETWEEN_SHIFT | DEC | 10(2) | DEC10_2 | ||||
MAXCONSECUTIVEDS | Maximum Number of Consecutive Work Days | WFA_TV_MAX_CONSEC_DAYS | INT1 | 3 | |||||
TWODAYSOFFINROW | Indicator two Consecutive Days Off | WFA_TV_TWO_DAYS_OFF_IN_ROW | CHAR | 1 | WFA_BOOLEAN | ||||
TWODAYSOFFWKEND | Indicator two Days Off includes Weekend Day | WFA_TV_TWO_DAYS_OFF_WEEKEND | CHAR | 1 | WFA_BOOLEAN | ||||
ALTWEEKENDSOFF | Indicator Alternate Weekend Off | WFA_TV_ALTERNATE_WEEKEND_OFF | CHAR | 1 | WFA_BOOLEAN | ||||
HOLIDAYOFF | Indicator Holidays Off | WFA_TV_HOLIDAY_OFF | CHAR | 1 | WFA_BOOLEAN | ||||
ALLOWOVERTIME | Indicator: Allow Overtime Work | WFA_TV_ALLOW_OVERTIME | CHAR | 1 | WFA_BOOLEAN | ||||
MAXOTDAY | Maximum Hours for Overtime per Day | WFA_TV_MAX_HRS_OVERTIME_DAY | DEC | 10(2) | DEC10_2 | ||||
MAXOTWEEK | Maximum Hours of Overtime per Week | WFA_TV_MAX_HRS_OVERTIME_WEEK | DEC | 10(2) | DEC10_2 | ||||
SPLIT_SHIFTS | Indicator Split-Shift-Eligible | WFA_TV_SPLIT_SHIFT | CHAR | 1 | WFA_BOOLEAN | ||||
MAX_PARTS_DAY | Maximum Number of Shift Parts per Day | WFA_TV_MAX_SHIFT_PARTS_DAY | INT1 | 3 | |||||
MAX_SPLIT_DAYS | Maximum Number of Days with Split Shifts per Week | WFA_TV_MAX_DAYS_SPLIT_WEEK | INT1 | 3 | |||||
MIN_HOUR_PART | Minimum Hours per Shift Part | WFA_TV_MIN_HRS_SHIFT_PART | DEC | 10(2) | DEC10_2 | ||||
MIN_GAP_PART | Minimum Hours Gap Between Shift Parts | WFA_TV_MIN_HRS_GAP_SHIFT_PART | DEC | 10(2) | DEC10_2 | ||||
MAX_GAP_PART | Maximum Hours Gap Between Shift Parts | WFA_TV_MAX_HRS_GAP_SHIFT_PART | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MIN1 | Minimum Working Hours During Special Hours | WFA_TV_MIN_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MAX1 | Maximum Working Hours During Special Hours | WFA_TV_MAX_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MIN2 | Minimum Working Hours During Special Hours | WFA_TV_MIN_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MAX2 | Maximum Working Hours During Special Hours | WFA_TV_MAX_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MIN3 | Minimum Working Hours During Special Hours | WFA_TV_MIN_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MAX3 | Maximum Working Hours During Special Hours | WFA_TV_MAX_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MIN4 | Minimum Working Hours During Special Hours | WFA_TV_MIN_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MAX4 | Maximum Working Hours During Special Hours | WFA_TV_MAX_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MIN5 | Minimum Working Hours During Special Hours | WFA_TV_MIN_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MAX5 | Maximum Working Hours During Special Hours | WFA_TV_MAX_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MIN6 | Minimum Working Hours During Special Hours | WFA_TV_MIN_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_MAX6 | Maximum Working Hours During Special Hours | WFA_TV_MAX_HRS_SPEC_HOURS | DEC | 10(2) | DEC10_2 | ||||
ONE_WEEK_REST | Consecutive Hours off per Week | WFA_TV_REST_PERIOD_1_WEEK | INT1 | 3 | |||||
TWO_WEEK_REST | Consecutive Hours off per Two Weeks | WFA_TV_REST_PERIOD_2_WEEKS | INT1 | 3 | |||||
SPECIAL_DAYP1 | Indicator: Special Day Part Allowed | WFA_TV_SPEC_DAY_PART_ALLOWED | CHAR | 1 | WFA_BOOLEAN | ||||
SPECIAL_DAYP_M1 | Maximum Time for Special Day Part | WFA_TV_MAX_TIME_SPEC_DAY_PART | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_DAYP2 | Indicator: Special Day Part Allowed | WFA_TV_SPEC_DAY_PART_ALLOWED | CHAR | 1 | WFA_BOOLEAN | ||||
SPECIAL_DAYP_M2 | Maximum Time for Special Day Part | WFA_TV_MAX_TIME_SPEC_DAY_PART | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_DAYP3 | Indicator: Special Day Part Allowed | WFA_TV_SPEC_DAY_PART_ALLOWED | CHAR | 1 | WFA_BOOLEAN | ||||
SPECIAL_DAYP_M3 | Maximum Time for Special Day Part | WFA_TV_MAX_TIME_SPEC_DAY_PART | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_DAYP4 | Indicator: Special Day Part Allowed | WFA_TV_SPEC_DAY_PART_ALLOWED | CHAR | 1 | WFA_BOOLEAN | ||||
SPECIAL_DAYP_M4 | Maximum Time for Special Day Part | WFA_TV_MAX_TIME_SPEC_DAY_PART | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_DAYP5 | Indicator: Special Day Part Allowed | WFA_TV_SPEC_DAY_PART_ALLOWED | CHAR | 1 | WFA_BOOLEAN | ||||
SPECIAL_DAYP_M5 | Maximum Time for Special Day Part | WFA_TV_MAX_TIME_SPEC_DAY_PART | DEC | 10(2) | DEC10_2 | ||||
SPECIAL_DAYP6 | Indicator: Special Day Part Allowed | WFA_TV_SPEC_DAY_PART_ALLOWED | CHAR | 1 | WFA_BOOLEAN | ||||
SPECIAL_DAYP_M6 | Maximum Time for Special Day Part | WFA_TV_MAX_TIME_SPEC_DAY_PART | DEC | 10(2) | DEC10_2 | ||||
MON_OFF_VAL | Period Rules: Number of Mondays Off | WFA_TV_MON_OFF | DEC | 5(2) | |||||
MON_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
TUE_OFF_VAL | Period Rules: Number of Tuesdays Off | WFA_TV_TUE_OFF | DEC | 5(2) | |||||
TUE_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
WED_OFF_VAL | Period Rules: Number of Wednesdays Off | WFA_TV_WED_OFF | DEC | 5(2) | |||||
WED_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
THU_OFF_VAL | Period Rules: Number of Thursdays Off | WFA_TV_THU_OFF | DEC | 5(2) | |||||
THU_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
FRI_OFF_VAL | Period Rules: Number of Fridays Off | WFA_TV_FRI_OFF | DEC | 5(2) | |||||
FRI_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
SAT_OFF_VAL | Period Rules: Number of Saturdays Off | WFA_TV_SAT_OFF | DEC | 5(2) | |||||
SAT_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
SUN_OFF_VAL | Period Rules: Number of Sundays Off | WFA_TV_SUN_OFF | DEC | 5(2) | |||||
SUN_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
MAX_AVG_HR_VAL | Period Rules: Maximum Weekly Average - Hours | WFA_TV_MAX_AVG_HOURS | DEC | 5(2) | |||||
MAX_AVG_HR_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
MAX_AVG_D_VAL | Period Rules: Maximum Weekly Average - Days | WFA_TV_MAX_AVG_DAYS | DEC | 5(2) | |||||
MAX_AVG_D_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
MAX_AVG_OT_VAL | Period Rules: Maximum Weekly Average - Overtime Hours | WFA_TV_MAX_AVG_OT_HOURS | DEC | 5(2) | |||||
MAX_AVG_OT_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
PART_WD_OFF_VAL | Period Rules: Number of Partial Weekends Off | WFA_TV_PART_WD_OFF | DEC | 5(2) | |||||
PART_WD_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 | |||||
FULL_WD_OFF_VAL | Period Rules: Number of Full Weekends Off | WFA_TV_FULL_WD_OFF | DEC | 5(2) | |||||
FULL_WD_OFF_WEEK | Period Rules: Within Period of xxx Weeks | WFA_TV_WITHIN_N_WEEKS | INT1 | 3 |
Key field | Non-key field |
How do I retrieve data from SAP structure WFA_TS_WRKRL_TEMPL_DATA using ABAP code?
As WFA_TS_WRKRL_TEMPL_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WFA_TS_WRKRL_TEMPL_DATA as there is no data to select.How to access SAP table WFA_TS_WRKRL_TEMPL_DATA
Within an ECC or HANA version of SAP you can also view further information about WFA_TS_WRKRL_TEMPL_DATA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects