RMPS_DESK_WORKITEM_LIST SAP (Desk: Displayable Attributes of Work Item List) Structure details
Description: Desk: Displayable Attributes of Work Item List
Related tables to RMPS_DESK_WORKITEM_LIST
Access table RMPS_DESK_WORKITEM_LIST
Structure field list including key, data, relationships and ABAP select examples
RMPS_DESK_WORKITEM_LIST 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 "Desk: Displayable Attributes of Work Item List" 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_RMPS_DESK_WORKITEM_LIST TYPE RMPS_DESK_WORKITEM_LIST.
The RMPS_DESK_WORKITEM_LIST table consists of various fields, each holding specific information or linking keys about Desk: Displayable Attributes of Work Item List data available in SAP. These include EXT_KEY (Case ID), EXT_REF (External reference), CREATED_BY (Created By), CREATE_TIME (Created On).. 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 (Deep)
SAP RMPS_DESK_WORKITEM_LIST 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 |
EXT_KEY | Case ID | SCMG_EXT_KEY | CHAR | 12 | ALPHA | SCMG_EXT_KEY | |||
EXT_REF | External reference | SCMG_EXT_REF | CHAR | 30 | CHAR30 | ||||
CREATED_BY | Created By | SCMG_CREATE_USER | CHAR | 12 | USR02 | XUBNAME | |||
CREATE_TIME | Created On | SCMG_CREATE_TIME | DEC | 15 | TSTPS | SCMG_TIMESTAMP | |||
CHANGED_BY | Last Changed by | SCMG_CHANGE_USER | CHAR | 12 | USR02 | XUBNAME | |||
CHANGE_TIME | Last Changed On | SCMG_CHANGE_TIME | DEC | 15 | TSTPS | SCMG_TIMESTAMP | |||
CLOSED_BY | Closed by User | SCMG_CLOSED_BY | CHAR | 12 | USR02 | XUBNAME | |||
CLOSING_TIME | Closed at Time | SCMG_CLOSING_TIME | DEC | 15 | TSTPS | SCMG_TIMESTAMP | |||
PLAN_END_DATE | Planned Close Date | SCMG_PLAN_END_DATE | DATS | 8 | DATUM | ||||
PROCESSOR | Processor | SCMG_PROCESSOR | CHAR | 12 | USR02 | XUBNAME | USER_ADDR | ||
CASE_TITLE | Case Title | SCMG_CASE_TITLE | CHAR | 80 | TEXT80 | ||||
ESCAL_REASON | Reason for Escalation | SCMG_ESCAL_REASON | CHAR | 2 | SCMGATTR_SESCAL | CHAR2 | |||
CATEGORY | Category | SCMG_CATEGORY | CHAR | 4 | Assigned to domain | CHAR4 | |||
PRIORITY | Priority | SCMG_PRIORITY | NUMC | 1 | SCMGATTR_PRIO | NUM01 | |||
PROFILE_ID | Case: Status Profile | SCMGSTATUSPROFID | CHAR | 8 | SCMGSTATPROF | SCMGPROFID | |||
STAT_ORDERNO | Case: Status | SCMGSTATUSONR | NUMC | 2 | SCMGSTATPROFS | SCMGSTATUSONR | |||
STAT_PARA | Case: System Status | SCMGSTATPARA | CHAR | 3 | SCMGSTAT | CHAR03 | |||
STAT_OBJNR | Case: Status Object Number (GUID), (Central Status Managmnt) | SCMGSTATOBJNR | CHAR | 32 | SYSUUID_C | ||||
STAT_LINE | Case: System Status Description (Central Status Management) | SCMGSTATLINE | CHAR | 40 | SCMGSTATLINE | ||||
STAT_USER_LINE | Case: User Status Description (Central Status Management) | SCMGSTATUSERLINE | CHAR | 40 | SCMGSTATLINE | ||||
REASON_CODE | Reason for Case | SCMG_REASON_CODE | CHAR | 4 | Assigned to domain | CHAR4 | |||
ACTIVE_TIME_END | End of Runtime | RMPS_ACTIVE_TIME_END | DATS | 8 | BEGDA | RMPSDATS | |||
ACTIVE_TIME_START | Start of Runtime | RMPS_ACTIVE_TIME_START | DATS | 8 | BEGDA | RMPSDATS | |||
ATTACHMENT | Attachment of a Letter | RMPS_ATTACHMENT | CHAR | 64 | SDOK_PROPV | ||||
BPART_POST | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BPART_ADD | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
CITY | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
DEPARTMENT | Initiating Position | RMPS_DEPARTMENT | NUMC | 8 | RMPS_DEPARTMENT | H_RMPS_DEPARTMENT | |||
DISPOSAL_STATE | Disposal Status | RMPS_DISPOSAL_STATE | CHAR | 10 | DISST | RMPS_DISPOSAL_STATE | |||
DISPOSAL_STATE_CONVEXT | Disposal Status (Conversion Exit) | RMPS_DISPOSAL_STATE_CONVEXT | CHAR | 10 | DISST | RMPS_DISPOSAL_STATE_CONVEXT | |||
DOC_TYPE | Incoming Item Type | RMPSPETYPE | CHAR | 10 | RMPSPOSTTYPE | RMPSPETYPE | RMPS_S_DOCTYPE | ||
DOCUMENT_TYPE | Record Type | RMPSDOCTYPE | CHAR | 40 | Assigned to domain | DOCTY | RMPSDOCTYPE | H_RMPS_DOCUMENT_TYPE | |
ENTRY_DATE | Date Received | RMPS_ENTRY_DATE | DATS | 8 | BEGDA | RMPSDATS | |||
FILEPLAN | Record Plan | RMPS_FILEPLAN | CHAR | 64 | SDOK_PROPV | ||||
FGN_TRANS_REF | External Reference Number | RMPS_FGN_TRANS_REF | CHAR | 64 | SDOK_PROPV | ||||
FIRST_NAME | First name | AD_NAMEFIR | CHAR | 40 | TEXT40 | ||||
INSTITUTION | Address: Institution | RMPS_INSTITUTION | CHAR | 64 | SDOK_PROPV | ||||
LETTER_DATE | Date of Letter | RMPS_LETTER_DATE | DATS | 8 | BEGDA | RMPSDATS | |||
OBJTYPE_POST | Object Type | SWO_OBJTYP | CHAR | 10 | Assigned to domain | OJ_NAME | OBJ | ||
OBJKEY_POST | Object Key of Incoming Post Item | RMPS_OBJKEY | CHAR | 64 | SDOK_PROPV | ||||
ADR_ORGUNIT | Address: Organizational Unit | RMPS_ADR_ORGUNIT | CHAR | 64 | SDOK_PROPV | ||||
PATHID | Process Route | RMPS_DOM_PATHID | NUMC | 12 | Assigned to domain | SRMWFPTHID | |||
POSTCODE | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
PREV_DOCUMENT_ID | Old Reference Number | RMPS_PREV_DOCUMENT_ID | CHAR | 64 | SDOK_PROPV | ||||
PUT_AWAY | Temporary Object | RMPS_PUT_AWAY | CHAR | 1 | RMPS_PUT_AWAY | ||||
RECORD_TYPE | Record Type | RMPSRECTYPE | CHAR | 40 | Assigned to domain | RECTY | RMPSRECTYPE | H_RMPS_RECORD_TYPE | |
RECORD_SUBJECT | Record Reference | RMPS_RECORD_SUBJECT | CHAR | 64 | SDOK_PROPV | ||||
REF_RULE_TYPE | Rule Type | SRMRGTYPE | CHAR | 3 | Assigned to domain | SRMRGTYPE | SRMRGTYPE | ||
SEND_DATE | Date Sent | RMPS_SEND_DATE | DATS | 8 | BEGDA | RMPSDATS | |||
STORDUR | Storage Time (with Conv. Exit) | RMPS_STORAGE_DURATION_CONVEXIT | CHAR | 20 | STORD | RMPS_STORAGE_DURATION_CONVEXIT | |||
STORAGE_END | End of Retention Time | RMPS_STORAGE_END | DATS | 8 | BEGDA | RMPSDATS | |||
STORAGE_START | Start of Retention Period | RMPS_STORAGE_START | DATS | 8 | BEGDA | RMPSDATS | |||
STORAGE_PLACE | Storage Location | RMPS_STORAGE_PLACE_CONVEXIT | CHAR | 16 | STORP | RMPS_STORAGE_PLACE_CONVEXIT | |||
STREET | House Number and Street | PD_STRAS | CHAR | 30 | TEXT30 | ||||
SUBJECT | Letter Reference | RMPS_SUBJECT | CHAR | 64 | SDOK_PROPV | ||||
SUBJECT_DETAIL | Here as Further Subdivision of Subject of Letter | RMPS_SUBJECT_DETAIL | CHAR | 64 | SDOK_PROPV | ||||
SURNAME | Last name | AD_NAMELAS | CHAR | 40 | TEXT40 | ||||
VOLUME | Band (last Band) | RMPS_VOLUME | CHAR | 64 | SDOK_PROPV | ||||
VRGNG_TYPE | Case Type | RMPS_CASE_TYPE | CHAR | 4 | Assigned to domain | SCMGCASE_TYPE | |||
VRGNG_SUBJECT | Case Reference | RMPS_CASE_SUBJECT | CHAR | 64 | SDOK_PROPV | ||||
RESPONSIBLE | Initiator or Person Responsible | RMPS_RESPONSIBLE | CHAR | 12 | Assigned to domain | XUBNAME | |||
MAILTXT_INACT | Indicator Do not Display Mail Text | RMPS_TXT_INACT | CHAR | 1 | SRMFLAG | ||||
CASE_TYPE | Case Type | RMPS_CASE_TYPE | CHAR | 4 | Assigned to domain | SCMGCASE_TYPE | |||
KEY_WORD | Keyword | SRMGSKEYWD | CHAR | 64 | SDOK_PROPV | ||||
WHEREABOUTS | Curr. Location | RMPS_WHEREABOUTS | CHAR | 64 | RMPS_WHEREABOUTS | ||||
WHERE_DATE | Date of Current Location | RMPS_WHERE_DATE | DATS | 8 | BEGDA | RMPSDATS | |||
WHERE_COMMENT | Comment on Location | RMPS_WHERE_COMMENT | CHAR | 64 | SRMRGDESC | ||||
PS_WHERE_TYPE | Address Category of Current Location | RMPS_WHERE_TYPE | CHAR | 2 | RMPS_WHERE_TYPE | ||||
SECURE_LEVEL | Authorization level | SCMG_SECURE_LEVEL | CHAR | 1 | Assigned to domain | CHAR1 | |||
REC_REFERENCE | Reference Number of Superior Record | RMPS_REFERENCE | CHAR | 64 | SDOK_PROPV | ||||
FPLAN_POS | Record Plan Item | RMPS_FPLAN_POS | CHAR | 64 | RMPS_FPLAN_POS | ||||
INBDOC_TYPE | Incoming Item Type | RMPSPETYPE | CHAR | 10 | Assigned to domain | RMPSPETYPE | RMPS_S_DOCTYPE | ||
VOL_SUBJECT | Reference of Record Volume | RMPS_VOL_SUBJECT | CHAR | 64 | SDOK_PROPV | ||||
BARCODE | SAP ArchiveLink: Document ID | SAEARDOID | CHAR | 40 | SADC40 | ||||
EXPORTABLE | Flag for signaling if a document should not be exported | RMPS_EXPORT_FLAG | CHAR | 1 | SRMFLAG | ||||
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WI_ID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
WI_TYPE | Work item type | SWW_WITYPE | CHAR | 1 | SWW_WITYPE | ||||
WI_CREATOR | Creator of a work item | SWW_OBJID | CHAR | 90 | SWO_OBJID | ||||
WI_LANG | Language for Texts of a Work Item | SWW_LANG | LANG | 1 | T002 | ISOLA | SPRAS | ||
WI_TEXT | Work item text | SWW_WITEXT | CHAR | 120 | TEXT120 | ||||
WI_RHTEXT | Short Text from Task | SWW_RHTEXT | CHAR | 40 | CHAR40 | ||||
WI_STAT | Processing Status of a Work Item | SWW_WISTAT | CHAR | 12 | Assigned to domain | SWW_WISTAT | |||
WI_CD | Creation Date of Work Item | SWW_CD | DATS | 8 | SYDATS | ||||
WI_CT | Creation Time of Work Item | SWW_CT | TIMS | 6 | SYTIME | ||||
WI_AED | End Date of Work Item | SWW_AED | DATS | 8 | SYDATS | ||||
WI_AAGENT | Actual Agent of Work Item | SWW_AAGENT | CHAR | 12 | SYCHAR12 | ||||
WI_AADDR | Key for BOR Object of Type ADDRESS (SWWADDRKEY) | SWWADDRESS | CHAR | 28 | SYCHAR28 | ||||
WI_CRUSER | User Who Created the Work Item | SWW_CRUSER | CHAR | 12 | SYCHAR12 | ||||
WI_CRADDR | Key for BOR Object of Type ADDRESS (SWWADDRKEY) | SWWADDRESS | CHAR | 28 | SYCHAR28 | ||||
WI_CHCKWI | Superordinate Work Item | SWW_CHCKWI | NUMC | 12 | SWWWIHEAD | SWW_WIID | |||
WI_CBFB | Callback Function Module for Work Item Feedback | SWW_CBFB | CHAR | 30 | Assigned to domain | FUNCNAME | |||
WI_RH_TASK | Task ID | SWW_TASK | CHAR | 14 | HROBJEC_14 | ||||
WI_PRIO | Priority of a Work Item | SWW_PRIO | NUMC | 1 | SWD_PRIORI | ||||
WI_CONFIRM | Indicator showing that end of processing must be confirmed | SWW_WICONF | CHAR | 1 | XFELD | ||||
WI_COMP_EV | Indicator Denoting That Completion By Event Is Possible | SWW_COMPEV | CHAR | 1 | XFELD | ||||
WI_FORW_BY | (Last) forwarder of work item | SWW_FORWBY | CHAR | 12 | SYCHAR12 | ||||
WI_DISABLE | Flag: Work item is currently locked | SWW_DISABL | CHAR | 1 | XFELD | ||||
WI_REJECT | Indicator Denoting that Work Item Can Be Rejected by Agent | SWW_REJECT | CHAR | 1 | XFELD | ||||
TCLASS | Classification of Tasks | HR_TASK_CL | CHAR | 12 | T77TC | ALPHA | HR_TASK_CL | ||
NOTE_EXIST | Indicator Denoting that At Least One Note Exists for the WI | SWW_NOTEEX | CHAR | 1 | XFELD | ||||
NOTIFY | Flag: Whether a Notification of Completion Is To Be Sent | SWW_NOTIFY | CHAR | 1 | XFELD | ||||
RETRY_CNT | Retries for Work Items with Temporary Errors | SWW_RETCNT | NUMC | 2 | SWW_COUNT2 | ||||
MAX_RETRY | Retries for Work Items with Temporary Errors | SWW_RETCNT | NUMC | 2 | SWW_COUNT2 | ||||
RC_MODELED | Indicator whether return code modeled in step definition | SWW_RCMODL | CHAR | 1 | XFELD | ||||
CB_DONE | Status Transition for Executed Work Item Completed | SWW_CBDONE | CHAR | 1 | XFELD | ||||
HANDLE | ID of Workflow Trace | SWT_HANDL_ | NUMC | 12 | SWT_HANDLE | ||||
SYNCCHAIN | Flag: WI Is Part of a Synchronous Processing Chain | SWW_CHAIN | CHAR | 1 | XFELD | ||||
NO_DEADL | Flag Denoting Whether WI Contains Deadline Data | SWW_DEADFL | CHAR | 1 | XFELD | ||||
WI_DH_STAT | Deadline Status of a Work Item | SWW_WIDHST | NUMC | 4 | Assigned to domain | SWW_WIDHST | |||
WI_RELEASE | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
WLC_DISPL | Display of WI in WLC modeled in step definition | SWW_MODDIS | CHAR | 1 | SWW_MODDIS | ||||
WI_RESTLOG | Minimize Number of Entries in Workflow Log | SWD_NOLOG | CHAR | 1 | SWD_NOLOG | ||||
REMOTE_ID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
REMOTE_SYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
STATUS_EVT | Flag: Whether Event STATUS_CHANGED Is To Be Triggered (FIs) | SWW_STAEVT | CHAR | 1 | XFELD | ||||
TIMEOUT | Time Interval Between Creation of Work Item and Timeout | SWD_BI_W_O | INT4 | 10 | SWD_TIME_O | ||||
WF_TYPE | Type of Workflow Definition: Standard, Checklist, Ad Hoc, .. | SWD_WFTYPE | NUMC | 4 | SWD_DWFTYP | ||||
WLC_FLAGS | WF: Internal, conversion of 4-byte integer <-> 4-byte hex. | SWA_X4 | RAW | 4 | SWA_STATES | ||||
XMLPROT | Transfer Format Used In Web Activity | SWD_XMLPRT | NUMC | 2 | Assigned to domain | SWD_XMLPRT | |||
WAIT4CB | Wait For Feedback By XML | SWD_WAIT4C | CHAR | 1 | XFELD | ||||
TOP_WI_ID | Workflow: Unique ID of Top-Level Instance (6.1/get) | SWFRTWIID | NUMC | 12 | Assigned to domain | SWW_WIID | |||
DEF_GUID | Workflow: Unique ID of Step Definition (6.1/get) | SWFRDGUID | CHAR | 40 | CHAR40 | ||||
EXEC_TIME | Workflow: De Facto Execution Time in Sec (6.1/get) | SWFREXECTM | INT4 | 10 | |||||
NOTE_COUNT | Number of Attachments | SWFRNOTECN | INT4 | 10 | |||||
PRS_PROFIL | Type of Persistence Profile | SWD_PERSID | NUMC | 4 | SWD_PERSID | ||||
CREA_TMP | Workflow: Creation Time Stamp | SWFRCRETS | DEC | 21(7) | TZNTSTMPL | ||||
CHECK_STAT | Workflow: Status of Post Condition/Wait Condition | SWW_CHKSTA | NUMC | 2 | SWW_CHKSTA | ||||
BLOCKTYPE | WFM: Block Type | SWP_BLOCKTYPE | NUMC | 4 | SWP_BLOCKTYPE | ||||
PARENT_WI | Parent of a Work Item | SWFRPARWI | NUMC | 12 | Assigned to domain | SWW_WIID | |||
RNDNUMBER | Workflow: Random Number | SWF_RNDNUM | NUMC | 2 | SWF_RNDNUM | ||||
WFD_ID | Number of workflow definition | SWD_WFD_ID | CHAR | 10 | Assigned to domain | SWD_WFDIDS | |||
WFD_VERSION | Version | SWD_VERSIO | CHAR | 4 | SWD_VERSIO | ||||
WFD_EXETYP | Workflow Type | SWD_EXETYP | CHAR | 1 | SWD_EXETYP | ||||
PROCCAT | Process Category | SWD_PROCCAT | CHAR | 10 | SWD_PROCCAT | ||||
TOP_TASK | Task Identifier of Top-Level Task | SWW_TOP_TASK | CHAR | 14 | HROBJEC_14 | ||||
LIST_STATUS_ICON | Status of entry, for example, unread or resubmission | SIN_STICON | CHAR | 36 | SO_QICON | ||||
BU_DESCRIP_LONG | Sender | RMPS_POST_SENDER_DESCRIPTION | CHAR | 80 | CHAR80 | ||||
SRM_DOCUMENT_ID | Document Number | RMPS_DOC_REF | CHAR | 64 | SDOK_PROPV | ||||
USER_CREATED_TXT | Element Created by | RMPS_USER_CREATED_TXT | CHAR | 80 | TEXT80 | ||||
USER_CHANGED_TXT | Element Changed by | RMPS_USER_CHANGED_TXT | CHAR | 80 | TEXT80 | ||||
USER_RESPONSIBLE_TXT | Initiator | RMPS_USER_RESPONSIBLE_TXT | CHAR | 80 | TEXT80 |
Key field | Non-key field |
How do I retrieve data from SAP structure RMPS_DESK_WORKITEM_LIST using ABAP code?
As RMPS_DESK_WORKITEM_LIST 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 RMPS_DESK_WORKITEM_LIST as there is no data to select.How to access SAP table RMPS_DESK_WORKITEM_LIST
Within an ECC or HANA version of SAP you can also view further information about RMPS_DESK_WORKITEM_LIST 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