N2DWSWL_WORK SAP (Situation) Table details

Dictionary Type: Table
Description: Situation




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




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
WORK_IDSituation Key N2DWSWL_WORK_IDCHAR33N2DWSWL_ID
EINRIInstitution EINRICHAR4Assigned to domainALPHAEINRIEIN
PATNRIS-H: Patient Number PATNRCHAR10Assigned to domainALPHAPATNRPAT
AREAWork Area N2DWSWL_AREACHAR4N2DWSWL_AREAN2DWSWL_AREA
WS_IDSituation Template Key N2DWSWL_WS_IDCHAR33N2DWSWL_ID
SHORT_CODESituation Identification N2DWSWL_WORK_SHORT_CODECHAR20N2DWSWL_SHORT_CODE
NAMESituation Name N2DWSWL_WORK_NAMECHAR40TEXT40
WORK_STATESituation Status N2DWSWL_WORK_STATECHAR2N2DWSWL_WORK_STATE
WORK_STARTED_ONStart of Processing Date for this Situation N2DWSWL_WORK_STARTED_ONDATS8N2DWSWL_DATE
WORK_STARTED_ATStart of Processing Time for this Situation N2DWSWL_WORK_STARTED_ATTIMS6N2DWSWL_TIME
WORK_STARTED_BYUser who Started Situation N2DWSWL_WORK_STARTED_BYCHAR12N2DWSWL_USER
WORK_CLOSED_ONDate When Situation Was Closed N2DWSWL_WORK_CLOSED_ONDATS8N2DWSWL_DATE
WORK_CLOSED_ATTime When Situation Was Closed N2DWSWL_WORK_CLOSED_ATTIMS6N2DWSWL_TIME
WORK_CLOSED_BYUser Who Closed Situation N2DWSWL_WORK_CLOSED_BYCHAR12N2DWSWL_USER
INFO_MODEPatient Viewer Setting for Situation N2DWSWL_INFO_MODE_WSCHAR2N2DWSWL_INFO_MODE_WS
INFO_IDInfo Item Code N2DWSWL_INFO_IDCHAR33N2DWSWL_ID
HAS_NOTENote Available N2DWSWL_HAS_NOTECHAR1ISH_ON_OFF
CONTACT_PERSONName of Contact Person N2DWSWL_CONTACT_PERSONCHAR40TEXT40
CONTACT_PHONETelephone Number of Contact Person N2DWSWL_CONTACT_PHONECHAR30CHAR30
CONTACT_EMAILe-mail Address of Contact Person N2DWSWL_CONTACT_EMAILCHAR53N2DWSWL_CONTACT_EMAIL
SEL_VARIANTABAP: Name of variant (without program name) VARIANTCHAR14Assigned to domainVARIANT
FUN_VARIANTIdentification of Function Variant NFVARIDCHAR15CHAR15
AUTO_CLOSEClose Situation after Completion of All Tasks N2DWSWL_WORK_AUTO_CLOSECHAR1N2DWSWL_WORK_AUTO_CLOSE
WORK_OFFSETSetting for Closing and Deleting Situation N2DWSWL_WORK_OFFSETCHAR2N2DWSWL_WORK_OFFSET
ACCESS_OFFSETNo. of Days Situation Is Available After Closing N2DWSWL_ACCESS_OFFSETINT25INT2
CLOSE_OFFSETDays Until Work Situation Can Be Closed by System N2DWSWL_CLOSE_OFFSETINT25INT2
DELETE_AFTERWork Situation Can Be Deleted After this Date N2DWSWL_DELETE_AFTERDATS8
INSDATEDate of Creation N2DWSWL_INSDATEDATS8N2DWSWL_DATE
INSUSERUser who Created Data Record N2DWSWL_INSUSERCHAR12N2DWSWL_USER
UPDDATEDate on Which Record Was Last Changed N2DWSWL_UPDDATEDATS8N2DWSWL_DATE
UPDUSERUser Who Last Changed Data Record N2DWSWL_UPDUSERCHAR12N2DWSWL_USER
WORK_PLAN_DATEPlanned Date of Situation N2DWSWL_WORK_PLAN_DATEDATS8N2DWSWL_WORK_PLAN_DATE
TASK_CREATEDSituation Tasks Have Been Created N2DWSWL_TASK_CREATEDCHAR1ISH_ON_OFF
CLIO_CONFIG_IDClinical Overview: Key of Web Dynpro Configuration N2CLIO_WD_CONFIG_IDCHAR32
CHART_CONFIG_IDCharting: Chart Layout N2CHART_LAYOUT_IDCHAR25Assigned to domainN2CHART_LAYOUT_ID
CLIO_MODEDisplay Mode Clinical Overview N2DWSWL_CLIO_MODECHAR1N2CLIO_USAGE
PRODUCED_BYObject Source N2DWSWL_PRODUCED_BYCHAR2N2DWSWL_PRODUCED_BY
CHART_MODEDisplay Mode for Chart N2DWSWL_CHART_MODECHAR1N2CHART_DWS_USAGE
WORK_HIDEHide Situation in Dialogs N2DWSWL_WORK_HIDECHAR1N2DWSWL_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 table
DATA: 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 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!