WFA_TS_AGT_ROT_EXT SAP (External data structure for WFM Employee WFA_AGT_ROT) Structure details
Description: External data structure for WFM Employee WFA_AGT_ROT
Related tables to WFA_TS_AGT_ROT_EXT
Access table WFA_TS_AGT_ROT_EXT
Structure field list including key, data, relationships and ABAP select examples
WFA_TS_AGT_ROT_EXT 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 "External data structure for WFM Employee WFA_AGT_ROT" 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_AGT_ROT_EXT TYPE WFA_TS_AGT_ROT_EXT.
The WFA_TS_AGT_ROT_EXT table consists of various fields, each holding specific information or linking keys about External data structure for WFM Employee WFA_AGT_ROT data available in SAP. These include ROTATION_SET_ID (Rotation Set Id), ROTATION_ID (Rotation Id), IS_ACTIVE (Active Flag for Rotation), ROT_NDX (Rotation index within the set).. 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: Can be enhanced (character-type or numeric)
SAP WFA_TS_AGT_ROT_EXT 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 |
| ROTATION_SET_ID | Rotation Set Id | WFA_ROTATION_SET_ID | CHAR | 32 | WFA_ID | ||||
| ROTATION_ID | Rotation Id | WFA_ROTATION_ID | CHAR | 32 | WFA_ID | ||||
| IS_ACTIVE | Active Flag for Rotation | WFA_TV_ROT_ACTIVE_FLAG | CHAR | 1 | WFA_ROT_ACTIVE_FLAG | ||||
| ROT_NDX | Rotation index within the set | WFA_ROT_NDX | INT4 | 10 | |||||
| WORKRULE_SET_ID | Work Rule Set Id | WFA_WORKRULEID | CHAR | 32 | Assigned to domain | WFA_WORKRULEID | |||
| AVAIL_ID | Availability Id | WFA_AVAIL_ID | CHAR | 32 | WFA_ID | ||||
| SET_SHIFT_ID | Set Shift ID, Set Shifts Table, TimeInterval Subject Area | WFA_SET_SHIFT_ID | CHAR | 32 | WFA_ID | ||||
| PREF_ID | Preference Id | WFA_PREF_ID | CHAR | 32 | WFA_ID | ||||
| 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 | |||
| SETSHT_TMPL_ID | Set Shift Template ID, Set Shifts Config Table, TimeInterval | WFA_SET_SHIFT_TEMPLATE_ID | CHAR | 20 | Assigned to domain | ALPHA | WFA_SET_SHIFT_TEMPLATE_ID | ||
| WRKRL_TMPL_ID | Work Rule Template Set ID | WFA_WKRLTEMPID | CHAR | 20 | Assigned to domain | ALPHA | WFA_WKRLTEMPID | ||
| AVAIL_TMPL_ID | Availability Template ID | WFA_AVAIL_TMP_ID | CHAR | 20 | Assigned to domain | ALPHA | WFA_AVAIL_TMP_ID | ||
| WFA_AGT_ROT_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
| EFFECTIVE_DATE | Effective Date | WFA_EFFECTIVE_DATE | DATS | 8 | |||||
| EFFECTIVE_ON_DATE | Effective Date | WFA_EFFECTIVE_DATE | DATS | 8 | |||||
| SNAME | Language-Dependent Identifier of an Availability Rotation | WFA_TV_ROTATION_SHORT_TEXT | CHAR | 20 | WFA_SNAME | ||||
| LNAME | Language-Dependent Text for Availability Rotation | WFA_TV_ROTATION_TEXT | CHAR | 60 | WFA_LNAME | ||||
| OVERWRITE_TEMPORARY | Generic Indicator for Special Data Overwrite Features | WFA_TV_DATA_OVERWRITE | CHAR | 1 | WFA_BOOLEAN | ||||
| WFA_AGT_ROT_TR_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
| Key field | Non-key field |
How do I retrieve data from SAP structure WFA_TS_AGT_ROT_EXT using ABAP code?
As WFA_TS_AGT_ROT_EXT 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_AGT_ROT_EXT as there is no data to select.How to access SAP table WFA_TS_AGT_ROT_EXT
Within an ECC or HANA version of SAP you can also view further information about WFA_TS_AGT_ROT_EXT 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