N2DWSWL_WORK SAP (Situation) Table details
Dictionary Type: Table
Description: Situation
Description: Situation
Table field list including key, data, relationships and ABAP select examples
N2DWSWL_WORK is a standard SAP Table which is used to store Situation data and is available within R/3 SAP systems depending on the version and release level.
The N2DWSWL_WORK table consists of various fields, each holding specific information or linking keys about Situation data available in SAP. These include WORK_ID (Situation Key), EINRI (Institution), PATNR (IS-H: Patient Number), AREA (Work Area).. 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: Cannot Be Enhanced
SAP N2DWSWL_WORK 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 | |||
WORK_ID | Situation Key | N2DWSWL_WORK_ID | CHAR | 33 | N2DWSWL_ID | ||||
EINRI | Institution | EINRI | CHAR | 4 | Assigned to domain | ALPHA | EINRI | EIN | |
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
AREA | Work Area | N2DWSWL_AREA | CHAR | 4 | N2DWSWL_AREA | N2DWSWL_AREA | |||
WS_ID | Situation Template Key | N2DWSWL_WS_ID | CHAR | 33 | N2DWSWL_ID | ||||
SHORT_CODE | Situation Identification | N2DWSWL_WORK_SHORT_CODE | CHAR | 20 | N2DWSWL_SHORT_CODE | ||||
NAME | Situation Name | N2DWSWL_WORK_NAME | CHAR | 40 | TEXT40 | ||||
WORK_STATE | Situation Status | N2DWSWL_WORK_STATE | CHAR | 2 | N2DWSWL_WORK_STATE | ||||
WORK_STARTED_ON | Start of Processing Date for this Situation | N2DWSWL_WORK_STARTED_ON | DATS | 8 | N2DWSWL_DATE | ||||
WORK_STARTED_AT | Start of Processing Time for this Situation | N2DWSWL_WORK_STARTED_AT | TIMS | 6 | N2DWSWL_TIME | ||||
WORK_STARTED_BY | User who Started Situation | N2DWSWL_WORK_STARTED_BY | CHAR | 12 | N2DWSWL_USER | ||||
WORK_CLOSED_ON | Date When Situation Was Closed | N2DWSWL_WORK_CLOSED_ON | DATS | 8 | N2DWSWL_DATE | ||||
WORK_CLOSED_AT | Time When Situation Was Closed | N2DWSWL_WORK_CLOSED_AT | TIMS | 6 | N2DWSWL_TIME | ||||
WORK_CLOSED_BY | User Who Closed Situation | N2DWSWL_WORK_CLOSED_BY | CHAR | 12 | N2DWSWL_USER | ||||
INFO_MODE | Patient Viewer Setting for Situation | N2DWSWL_INFO_MODE_WS | CHAR | 2 | N2DWSWL_INFO_MODE_WS | ||||
INFO_ID | Info Item Code | N2DWSWL_INFO_ID | CHAR | 33 | N2DWSWL_ID | ||||
HAS_NOTE | Note Available | N2DWSWL_HAS_NOTE | CHAR | 1 | ISH_ON_OFF | ||||
CONTACT_PERSON | Name of Contact Person | N2DWSWL_CONTACT_PERSON | CHAR | 40 | TEXT40 | ||||
CONTACT_PHONE | Telephone Number of Contact Person | N2DWSWL_CONTACT_PHONE | CHAR | 30 | CHAR30 | ||||
CONTACT_EMAIL | e-mail Address of Contact Person | N2DWSWL_CONTACT_EMAIL | CHAR | 53 | N2DWSWL_CONTACT_EMAIL | ||||
SEL_VARIANT | ABAP: Name of variant (without program name) | VARIANT | CHAR | 14 | Assigned to domain | VARIANT | |||
FUN_VARIANT | Identification of Function Variant | NFVARID | CHAR | 15 | CHAR15 | ||||
AUTO_CLOSE | Close Situation after Completion of All Tasks | N2DWSWL_WORK_AUTO_CLOSE | CHAR | 1 | N2DWSWL_WORK_AUTO_CLOSE | ||||
WORK_OFFSET | Setting for Closing and Deleting Situation | N2DWSWL_WORK_OFFSET | CHAR | 2 | N2DWSWL_WORK_OFFSET | ||||
ACCESS_OFFSET | No. of Days Situation Is Available After Closing | N2DWSWL_ACCESS_OFFSET | INT2 | 5 | INT2 | ||||
CLOSE_OFFSET | Days Until Work Situation Can Be Closed by System | N2DWSWL_CLOSE_OFFSET | INT2 | 5 | INT2 | ||||
DELETE_AFTER | Work Situation Can Be Deleted After this Date | N2DWSWL_DELETE_AFTER | DATS | 8 | |||||
INSDATE | Date of Creation | N2DWSWL_INSDATE | DATS | 8 | N2DWSWL_DATE | ||||
INSUSER | User who Created Data Record | N2DWSWL_INSUSER | CHAR | 12 | N2DWSWL_USER | ||||
UPDDATE | Date on Which Record Was Last Changed | N2DWSWL_UPDDATE | DATS | 8 | N2DWSWL_DATE | ||||
UPDUSER | User Who Last Changed Data Record | N2DWSWL_UPDUSER | CHAR | 12 | N2DWSWL_USER | ||||
WORK_PLAN_DATE | Planned Date of Situation | N2DWSWL_WORK_PLAN_DATE | DATS | 8 | N2DWSWL_WORK_PLAN_DATE | ||||
TASK_CREATED | Situation Tasks Have Been Created | N2DWSWL_TASK_CREATED | CHAR | 1 | ISH_ON_OFF | ||||
CLIO_CONFIG_ID | Clinical Overview: Key of Web Dynpro Configuration | N2CLIO_WD_CONFIG_ID | CHAR | 32 | |||||
CHART_CONFIG_ID | Charting: Chart Layout | N2CHART_LAYOUT_ID | CHAR | 25 | Assigned to domain | N2CHART_LAYOUT_ID | |||
CLIO_MODE | Display Mode Clinical Overview | N2DWSWL_CLIO_MODE | CHAR | 1 | N2CLIO_USAGE | ||||
PRODUCED_BY | Object Source | N2DWSWL_PRODUCED_BY | CHAR | 2 | N2DWSWL_PRODUCED_BY | ||||
CHART_MODE | Display Mode for Chart | N2DWSWL_CHART_MODE | CHAR | 1 | N2CHART_DWS_USAGE | ||||
WORK_HIDE | Hide Situation in Dialogs | N2DWSWL_WORK_HIDE | CHAR | 1 | N2DWSWL_WORK_HIDE |
Key field | Non-key field |
How do I retrieve data from SAP table N2DWSWL_WORK using ABAP code
The following ABAP code Example will allow you to do a basic selection on N2DWSWL_WORK to SELECT all data from the tableDATA: WA_N2DWSWL_WORK TYPE N2DWSWL_WORK.
SELECT SINGLE *
FROM N2DWSWL_WORK
INTO CORRESPONDING FIELDS OF WA_N2DWSWL_WORK
WHERE...
How to access SAP table N2DWSWL_WORK
Within an ECC or HANA version of SAP you can also view further information about N2DWSWL_WORK 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