Search SAP tables
Table field list including key, data, relationships and ABAP select examples WFA_EMP_WR_PERM is a standard SAP Table which is used to store Employee work rule assigment and values data and is available within R/3 SAP systems depending on the version and release level.
The WFA_EMP_WR_PERM table consists of various fields, each holding specific information or linking keys about Employee work rule assigment and values data available in SAP. These include PARTNER (Business Partner Number), START_DATE (Start Date), TEMPLATE_ID (Work Rule Template Set ID), TEMP_OVERWRITE (Boolean ( True = 'X', False = ' ')).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WFA_EMP_WR_PERM table 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
MANDT Client MANDT CLNT 3 Assigned to domain MANDT PARTNER Business Partner Number BU_PARTNER CHAR 10 Assigned to domain ALPHA BU_PARTNER BPA BUPA START_DATE Start Date WFA_START_DATE DATS 8 TEMPLATE_ID Work Rule Template Set ID WFA_WKRLTEMPID CHAR 20 Assigned to domain ALPHA WFA_WKRLTEMPID TEMP_OVERWRITE Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN ROT_SET_ID Rotation Set Id WFA_ROTATION_SET_ID CHAR 32 WFA_ID END_DATE End Date WFA_END_DATE DATS 8 MINHRSWEEK Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 MAXHRSWEEK Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 MINHOURSSHIFT Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 MAXHOURSSHIFT Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 WKENDMAXHRSSHIFT Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 MAXSCHEDDAYSWEEK Number of Days WFA_NUM_OF_DAYS INT1 3 MINTIMBTSHIFTS Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 MAXCONSECUTIVEDS Number of Days WFA_NUM_OF_DAYS INT1 3 TWODAYSOFFINROW Flag (Active = 'X', Inactive = ' ') WFA_FLAG CHAR 1 WFA_BOOLEAN TWODAYSOFFWKEND Flag (Active = 'X', Inactive = ' ') WFA_FLAG CHAR 1 WFA_BOOLEAN ALTWEEKENDSOFF Flag (Active = 'X', Inactive = ' ') WFA_FLAG CHAR 1 WFA_BOOLEAN HOLIDAYOFF Flag (Active = 'X', Inactive = ' ') WFA_FLAG CHAR 1 WFA_BOOLEAN ALLOWOVERTIME Flag (Active = 'X', Inactive = ' ') WFA_FLAG CHAR 1 WFA_BOOLEAN MAXOTDAY Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 MAXOTWEEK Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPLIT_SHIFTS Flag (Active = 'X', Inactive = ' ') WFA_FLAG CHAR 1 WFA_BOOLEAN MAX_PARTS_DAY Dummy for B20 int1 (Local Everywhere) INT1 INT1 3 INT1 MAX_SPLIT_DAYS Number of Days WFA_NUM_OF_DAYS INT1 3 MIN_HOUR_PART Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 MIN_GAP_PART Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 MAX_GAP_PART Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_MIN1 Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 SPECIAL_MAX1 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_MIN2 Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 SPECIAL_MAX2 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_MIN3 Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 SPECIAL_MAX3 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_MIN4 Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 SPECIAL_MAX4 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_MIN5 Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 SPECIAL_MAX5 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_MIN6 Minimum Value WFA_MIN_VALUE DEC 10(2) DEC10_2 SPECIAL_MAX6 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 ONE_WEEK_REST Weekly Rest Value WFA_REST_VALUE INT1 3 TWO_WEEK_REST Weekly Rest Value WFA_REST_VALUE INT1 3 SPECIAL_DAYP1 Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN SPECIAL_DAYP_M1 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_DAYP2 Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN SPECIAL_DAYP_M2 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_DAYP3 Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN SPECIAL_DAYP_M3 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_DAYP4 Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN SPECIAL_DAYP_M4 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_DAYP5 Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN SPECIAL_DAYP_M5 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 SPECIAL_DAYP6 Boolean ( True = 'X', False = ' ') WFA_BOOLEAN CHAR 1 WFA_BOOLEAN SPECIAL_DAYP_M6 Maximum Value WFA_MAX_VALUE DEC 10(2) DEC10_2 MON_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) MON_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 TUE_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) TUE_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 WED_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) WED_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 THU_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) THU_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 FRI_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) FRI_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 SAT_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) SAT_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 SUN_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) SUN_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 MAX_AVG_HR_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) MAX_AVG_HR_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 MAX_AVG_D_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) MAX_AVG_D_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 MAX_AVG_OT_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) MAX_AVG_OT_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 PART_WD_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) PART_WD_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 FULL_WD_OFF_VAL Value for period rule WFA_PERIOD_RULEVAL DEC 5(2) FULL_WD_OFF_WEEK Weeks for period rule WFA_PERIOD_RULE_WEEK INT1 3 CREATED_BY Created By WFA_CRUNAME CHAR 12 USNAM CREATED_AT Created At WFA_CRTIME DEC 15 TMPST WFA_TZNTSTMPS CHANGED_BY Last Changed By WFA_CHUNAME CHAR 12 USNAM CHANGED_AT Last Changed At WFA_CHTIME DEC 15 TMPST WFA_TZNTSTMPS WFA_AGT_PERM_ROT_WRKRL_DUMMY Dummy function in length 1 DUMMY CHAR 1 DUMMY WFA_AGT_PRM_NONROT_WRKRL_DUMMY Dummy function in length 1 DUMMY CHAR 1 DUMMY
How do I retrieve data from SAP table WFA_EMP_WR_PERM using ABAP code
The following ABAP code Example will allow you to do a basic selection on WFA_EMP_WR_PERM to SELECT all data from the table
DATA: WA_WFA_EMP_WR_PERM TYPE WFA_EMP_WR_PERM.
SELECT SINGLE *
FROM WFA_EMP_WR_PERM
INTO CORRESPONDING FIELDS OF WA_WFA_EMP_WR_PERM
WHERE...
How to access SAP table WFA_EMP_WR_PERM
Within an ECC or HANA version of SAP you can also view further information about WFA_EMP_WR_PERM and the data within it using relevant transactions such as
SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects
What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!