N2GL_ACT SAP (pathways Activity) Table details

Dictionary Type: Table
Description: pathways Activity




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




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

N2GL_ACT is a standard SAP Table which is used to store pathways Activity data and is available within R/3 SAP systems depending on the version and release level.

The N2GL_ACT table consists of various fields, each holding specific information or linking keys about pathways Activity data available in SAP. These include ACT_ID (pathways Activity Key), PATH_ID (Patient Pathway Key), STEP_ID (Step Key), GL_ID (Treatment Pathway ID).. 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 N2GL_ACT 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
ACT_IDpathways Activity Key N2GL_ACT_IDCHAR32N2GL_ID
PATH_IDPatient Pathway Key N2GL_TM_IDCHAR32SYSUUID_C
STEP_IDStep Key N2GL_STEP_IDCHAR32SYSUUID_C
GL_IDTreatment Pathway ID N2GL_GL_IDCHAR32SYSUUID_C
GL_VERSION_IDTreatment Pathway ID N2GL_GL_IDCHAR32SYSUUID_C
ORGIDpathways Organizational Unit N2GL_ORGIDCHAR8Assigned to domainALPHAORGID
EMREmployee Responsible N2GL_VMACHAR10Assigned to domainALPHARI_KUNNR
ACT_DATEPathways Date of Activity N2GL_ACT_DATEDATS8DATUM
ACT_TIMEPatways: Activity Time N2GL_ACT_TIMETIMS6UZEIT
ACT_TYPEpathways Activity Type N2GL_ACT_TYPCHAR6TN2CATCONTN2CAT_CONT
ACT_MCATpathways Main Category of Activity N2GL_ACT_MCATCHAR6Assigned to domainN2CAT_CAT
ACT_CATpathways Category of Activity N2GL_ACT_CATCHAR6Assigned to domainN2CAT_CAT
ACT_HAS_NOTEpathways Notes Exist for Activity N2GL_ACT_HAS_NOTECHAR1ISH_ON_OFF
EINRIInstitution EINRICHAR4Assigned to domainALPHAEINRIEIN
FALNRIS-H: Case Number FALNRCHAR10Assigned to domainALPHAFALNRFAL
ACT_UNDOpathways Activity Was Undone N2GL_ACT_UNDOCHAR1ISH_ON_OFF
ACT_MONTHpathways - Month, in Which Activity Was Executed N2GL_ACT_MONTHACCP6N2GL_MONTH
INSDATECreated On N2GL_INSDATEDATS8N2GL_DATE
INSUSERUser who Created Data Record N2GL_INSUSERCHAR12N2GL_USER
UPDDATEDate on Which Record Was Last Changed N2GL_UPDDATEDATS8N2GL_DATE
UPDUSERUser who Last Changed Record N2GL_UPDUSERCHAR12N2GL_USER
DELDATEDate, on Which Deletion Indicator Was Set N2GL_DELDATEDATS8N2GL_DATE
DELUSERUser Who Set Deletion Indicator N2GL_DELUSERCHAR12N2GL_USER
DELFLAGDeletion Indicator N2GL_DELFLAGCHAR1ISH_ON_OFF

Key field Non-key field



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

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

SELECT SINGLE *
FROM N2GL_ACT
INTO CORRESPONDING FIELDS OF WA_N2GL_ACT
WHERE...

How to access SAP table N2GL_ACT

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