WFA_EMPERROT SAP (Employee Work Rule Rotation) Table details

Dictionary Type: Table
Description: Employee Work Rule Rotation




ABAP Code to SELECT data from WFA_EMPERROT
Related tables to WFA_EMPERROT
Access table WFA_EMPERROT




Table field list including key, data, relationships and ABAP select examples

WFA_EMPERROT is a standard SAP Table which is used to store Employee Work Rule Rotation data and is available within R/3 SAP systems depending on the version and release level.

The WFA_EMPERROT table consists of various fields, each holding specific information or linking keys about Employee Work Rule Rotation data available in SAP. These include MANDT (Client), ROTATION_SET_ID (Rotation Set Id), ROTATION_ID (Rotation Id), IS_ACTIVE (Flag (Active = 'X', Inactive = ' ')).. 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_EMPERROT 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
ROTATION_SET_IDRotation Set Id WFA_ROTATION_SET_IDCHAR32WFA_AGT_ROTSTWFA_ID
ROTATION_IDRotation Id WFA_ROTATION_IDCHAR32WFA_ID
IS_ACTIVEFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
ROT_NDXRotation index within the set WFA_ROT_NDXINT410
WRKRL_TMPL_IDWork Rule Template Set ID WFA_WKRLTEMPIDCHAR20Assigned to domainALPHAWFA_WKRLTEMPID
TEMP_OVERWRITEBoolean ( True = 'X', False = ' ') WFA_BOOLEANCHAR1WFA_BOOLEAN
MINHRSWEEKMinimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
MAXHRSWEEKMaximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
MINHOURSSHIFTMinimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
MAXHOURSSHIFTMaximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
WKENDMAXHRSSHIFTMaximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
MAXSCHEDDAYSWEEKNumber of Days WFA_NUM_OF_DAYSINT13
MINTIMBTSHIFTSMinimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
MAXCONSECUTIVEDSNumber of Days WFA_NUM_OF_DAYSINT13
TWODAYSOFFINROWFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
TWODAYSOFFWKENDFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
ALTWEEKENDSOFFFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
HOLIDAYOFFFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
ALLOWOVERTIMEFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
MAXOTDAYMaximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
MAXOTWEEKMaximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPLIT_SHIFTSFlag (Active = 'X', Inactive = ' ') WFA_FLAGCHAR1WFA_BOOLEAN
MAX_PARTS_DAYDummy for B20 int1 (Local Everywhere) INT1INT13INT1
MAX_SPLIT_DAYSNumber of Days WFA_NUM_OF_DAYSINT13
MIN_HOUR_PARTMinimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
MIN_GAP_PARTMinimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
MAX_GAP_PARTMaximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPECIAL_MIN1Minimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
SPECIAL_MAX1Maximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPECIAL_MIN2Minimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
SPECIAL_MAX2Maximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPECIAL_MIN3Minimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
SPECIAL_MAX3Maximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPECIAL_MIN4Minimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
SPECIAL_MAX4Maximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPECIAL_MIN5Minimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
SPECIAL_MAX5Maximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
SPECIAL_MIN6Minimum Value WFA_MIN_VALUEDEC10(2) DEC10_2
SPECIAL_MAX6Maximum Value WFA_MAX_VALUEDEC10(2) DEC10_2
CREATED_BYCreated By WFA_CRUNAMECHAR12USNAM
CREATED_ATCreated At WFA_CRTIMEDEC15TMPSTWFA_TZNTSTMPS
CHANGED_BYLast Changed By WFA_CHUNAMECHAR12USNAM
CHANGED_ATLast Changed At WFA_CHTIMEDEC15TMPSTWFA_TZNTSTMPS
WFA_AGT_WRKRL_ROT_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
WFA_AGT_PERM_ROT_WRKRL_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY

Key field Non-key field



How do I retrieve data from SAP table WFA_EMPERROT using ABAP code

The following ABAP code Example will allow you to do a basic selection on WFA_EMPERROT to SELECT all data from the table
DATA: WA_WFA_EMPERROT TYPE WFA_EMPERROT.

SELECT SINGLE *
FROM WFA_EMPERROT
INTO CORRESPONDING FIELDS OF WA_WFA_EMPERROT
WHERE...

How to access SAP table WFA_EMPERROT

Within an ECC or HANA version of SAP you can also view further information about WFA_EMPERROT 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



Comments on this SAP object

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!