N2ET SAP (IS-H*MED: Table of docElement to DocCategory assignments) Table details
Dictionary Type: Table
Description: IS-H*MED: Table of docElement to DocCategory assignments
Description: IS-H*MED: Table of docElement to DocCategory assignments
Table field list including key, data, relationships and ABAP select examples
N2ET is a standard SAP Table which is used to store IS-H*MED: Table of docElement to DocCategory assignments data and is available within R/3 SAP systems depending on the version and release level.
The N2ET table consists of various fields, each holding specific information or linking keys about IS-H*MED: Table of docElement to DocCategory assignments data available in SAP. These include EINRI (Institution), DTID (Document Category ID), DTVERS (Version Number), ETID (Ident of the DE to DC Assignment).. 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: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = N2ETT
SAP N2ET 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 | T000 | MANDT | |||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
DTID | Document Category ID | N2_DTID | CHAR | 10 | N2DT | N2_DTID | DTY | N2_DTID | |
DTVERS | Version Number | N2_VERS | NUMC | 3 | N2_VERS | ||||
ETID | Ident of the DE to DC Assignment | N2_ETID | NUMC | 4 | N2_ETID | ||||
DTUUID | PMD: UUID | N2_DT_UUID | CHAR | 32 | SYSUUID_C | ||||
PFADLEVEL | Path Level of Documentation Element | N2_PFLEVEL | NUMC | 2 | NUM02 | ||||
DEPFAD | 'Path' of the Doc.Element via Structures | N2_DEPFAD | CHAR | 100 | CHAR100 | ||||
DEID | Ident. of Documentation Element | N2_DEID | CHAR | 10 | N2DE | N2_DEID | |||
DELEN | Unused | N2_DALEN | NUMC | 2 | NUMC02 | ||||
DDTAB | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
TABFD | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
DYNFD | Identifier of Field in Screen | N2_DYNFD | CHAR | 10 | CHAR10 | ||||
DYNPR | Relative Dynpro number | N2_DYNPR | NUMC | 4 | DYNPRONR | ||||
OBLIG | Mandatory Entry | N2_OBLIG | CHAR | 1 | N2_OBLIG | ||||
AREA | Area Identifier in Screen/Report | N2_DYNAR | CHAR | 2 | N2_DYNAR | ||||
FDRU | Control Indicator for Page Feed | N2_FDRU | CHAR | 1 | XFELD | ||||
DEEA | Input/Output field | N2_DEEA | CHAR | 1 | N2_DEEA | ||||
NOBEZ | Indicator: Without Label | N2_NOBEZ | CHAR | 1 | XFELD | ||||
STRUC | Documentation Element: Structure | N2_STRUC | CHAR | 1 | XFELD | ||||
GRAPH | Graphics Type (Picture) | N2_GRAPH | CHAR | 1 | XFELD | ||||
HOEHE | Height of Doc.Element Structure | N2_HOEHE | NUMC | 3 | NUMC03 | ||||
BREITE | Visual Output Width | N2_BREITE | NUMC | 3 | NUMC03 | ||||
DETYP | Category of Documentation Element | N2_DETYP | CHAR | 1 | N2_DETYP | ||||
DAID | Data element (semantic domain) | ROLLNAME | CHAR | 30 | Assigned to domain | ROLLNAME | ROL | DD_DTEL | |
TABKZ | Indicator for Generation of Storage Structures | N2_TABKZ | CHAR | 1 | XFELD | ||||
RTXTLEN | DocEl. Descriptor/Fixed Txt Length for Printout | N2_RTXTLEN | NUMC | 2 | SCRLEN | ||||
TXTLEN | Identifier length in the screen | N2_TXTLEN | NUMC | 2 | SCRLEN | ||||
DOVOREX | Default Rule | N2_DOVOREX | CHAR | 5 | CONVEXIT | ||||
STRUCTYP | Type of Structure | N2_STRTYP | CHAR | 1 | N2_STRTYP | ||||
VARLOOP | PMD: Display Radio Buttons | N2_VARLOOP | CHAR | 1 | XFELD | ||||
BUTWIDTH | Button width for radio buttons | N2_BUTWIDTH | NUMC | 3 | N2_BUTWIDTH | ||||
NUMOCC | Number of Rows | N2_NUMOCC | NUMC | 3 | NUMC03 | ||||
SUBPOOL | Program for the subscreen | N2_SUBPOOL | CHAR | 40 | PROGRAM_ID | ||||
SUBDYNP | Dynpro Number for Subscreen | N2_SUBDYNP | NUMC | 4 | DYNPRONR | ||||
SUBFORM | Form Routine for Subscreen Data in the Report | N2_SUBFORM | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FDBSID | PMD: Name of External Data Module (ID) | N2_FDBSID | CHAR | 10 | N2FDBS | N2_FDBSID | |||
ISREF | Referencing Inclusion of External Data | N2_ISREF | CHAR | 1 | XFELD | ||||
PARAMSTR | PMD: Fixed Parameters for Query Routine | N2_PARAMST | CHAR | 65 | TEXT65 | ||||
NQUERY | Perform New Search in Every Case | N2_NQUERY | CHAR | 1 | XFELD | ||||
ISAEND | Changing Inclusion of External Data | N2_ISAEND | CHAR | 1 | XFELD | ||||
HELPF4 | Integrate F4-Help with External Data Module | N2_HELPF4 | CHAR | 1 | XFELD | ||||
FDB_GET_REQUEST | Save Prompt (Query) when Updating | N2_FDB_GET_REQUEST | CHAR | 1 | XFELD | ||||
FDB_UPD_REQUEST | Save Query when Changing | N2_FDB_UPD_REQUEST | CHAR | 1 | XFELD | ||||
LABSID | Name of the Link Module (ID) | N2_LABSID | CHAR | 30 | N2LINKMODS | N2_LABSID | |||
LINKELETYP | PMD: Link Module Interface Display | N2_LINKELETYP | CHAR | 1 | N2_LINKELETYP | ||||
OUTPUTLEN | Output Length | OUTPUTLEN | NUMC | 6 | DDLENG | ||||
WTABEXI | Document Element Domains Contain Fixed Values | N2_WTABEXI | CHAR | 1 | XFELD | ||||
GETFROM | Field contents from? | N2_GETFROM | CHAR | 1 | N2_GETFROM | ||||
FUNCTION1 | Function code for pushbutton | SCRFFCOD | CHAR | 20 | GUI_FUNC | ||||
WREQUEST | Trigger event? | N2_WREQUEST | CHAR | 1 | XFELD | ||||
XPRANUM | PMD: Number of Recently Run XPRAs | N2_XPRANUM | NUMC | 3 | |||||
DESEQ | Print Sequence of Doc.Elements | N2_DESEQ | NUMC | 5 | NUM05 | ||||
SCRY | Row Position of the Value | N2_SCRY | NUMC | 4 | NUM04 | ||||
SCRX | Column Position of the Value | N2_SCRX | NUMC | 3 | NUM03 | ||||
REPY | Report: Y PosValue | N2_REPY | NUMC | 4 | NUM04 | ||||
REPX | Report: X PosValue | N2_REPX | NUMC | 3 | NUM03 | ||||
SCRYBEZ | Row Position of the Identifier | N2_SCRYBEZ | NUMC | 4 | NUM04 | ||||
SCRXBEZ | Column Position of the Identifier | N2_SCRXBEZ | NUMC | 3 | NUM03 | ||||
REPYBEZ | Report: Y Position Descriptor | N2_REPYBEZ | NUMC | 4 | NUM04 | ||||
REPXBEZ | Report: X PosDescriptor | N2_REPXBEZ | NUMC | 3 | NUM03 | ||||
PW1SEQBEZ | Sequence Order in View | N2_PW1SQBZ | NUMC | 5 | NUM05 | ||||
PW1SEQVAL | Print Sequence | N2_PW1SQVL | NUMC | 5 | NUM05 | ||||
PW1XBEZ | Window1: X Position Descriptor | N2_PW1XBEZ | NUMC | 3 | NUM03 | ||||
PW1YBEZ | Window1: Y Position Descriptor | N2_PW1YBEZ | NUMC | 4 | NUM04 | ||||
PW1XVAL | Window1: X Position Value | N2_PW1XVAL | NUMC | 3 | NUM03 | ||||
PW1YVAL | Window1: Y Position Value | N2_PW1YVAL | NUMC | 4 | NUM04 | ||||
PW2SEQBEZ | Window2: Seq. Descriptor | N2_PW2SQBZ | NUMC | 5 | NUM05 | ||||
PW2SEQVAL | Window2: SeqVal | N2_PW2SQVL | NUMC | 5 | NUM05 | ||||
PW2XBEZ | Line Feed | N2_PW2XBEZ | NUMC | 3 | NUM03 | ||||
PW2YBEZ | Window2: Y Item Descriptor | N2_PW2YBEZ | NUMC | 4 | NUM04 | ||||
PW2XVAL | Window2: X Position Value | N2_PW2XVAL | NUMC | 3 | NUM03 | ||||
PW2YVAL | Window2: Y Item Value | N2_PW2YVAL | NUMC | 4 | NUM04 | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
STATUS | Status for Doc.Categ. Assignments (N2ET) | N2_ETSTAT | CHAR | 1 | N2_ETSTAT | ||||
REFFLD | Reference Field for External Data and Links | N2_REFFLD | CHAR | 30 | Assigned to domain | FDNAME | |||
PTXTEL | Text Element in SAPscript Form | N2_PTXTEL | CHAR | 30 | N2_PTXTEL | ||||
PW1NAME | Window name | N2_PW1NAME | CHAR | 8 | N2_WINNAM | ||||
PW1SUPR | Suppress descriptor when no data | N2_PW1SUPR | CHAR | 1 | XFELD | ||||
PW1ABSFBEZ | Window1: Paragraph Format Descriptor | N2_PW1AFBZ | CHAR | 2 | N2_ABSFORM | ||||
PW1ABSFVAL | Window1: Paragraph Format Value | N2_PW1AFVL | CHAR | 2 | N2_ABSFORM | ||||
PW2NAME | Window2: Name | N2_PW2NAME | CHAR | 8 | N2_WINNAM | ||||
PW2SUPR | Expand Table | N2_PW2SUPR | CHAR | 1 | XFELD | ||||
PW2ABSFBEZ | Window2: Paragraph Format Descriptor | N2_PW2AFBZ | CHAR | 2 | N2_ABSFORM | ||||
PW2ABSFVAL | Window2: Paragraph Format Value | N2_PW2AFVL | CHAR | 2 | N2_ABSFORM | ||||
ALIAS1 | Alias for a Documentation Element | N2_ALIAS1 | CHAR | 12 | N2_ALIAS1 | ||||
ALIASFD | Alias of an element for External Data Supply | N2_ALIASFD | CHAR | 12 | N2_ALIAS1 | ||||
FDPERALIAS | Ext. Data Supply by Alias | N2_FDPERALIAS | CHAR | 1 | XFELD | ||||
FKTF1 | UserExit for F1 Help | N2_FKTF1 | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODF1 | INCLUDE F1 Help | N2_MODF1 | CHAR | 40 | PROGRAM_ID | ||||
FKTF4 | FORM routine for F4 Help | N2_FKTF4 | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODF4 | INCLUDE F4 Help | N2_MODF4 | CHAR | 40 | PROGRAM_ID | ||||
FKTCV | User exit for checking values | N2_FKTCV | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODCV | Include 'CheckValues' | N2_MODCV | CHAR | 40 | PROGRAM_ID | ||||
FKTPV | 'PrintValues' Form Routine | N2_FKTPV | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODPV | Include 'Print Values' | N2_MODPV | CHAR | 40 | PROGRAM_ID | ||||
DYNFNLANG | Name of a Screen Element | SCRFNAME | CHAR | 132 | DYNFNAM | ||||
IFNAME | Interface representation | N2_IFNAME | CHAR | 30 | N2_VARNAME | ||||
DYNNUM | 'Real' Dynpro Number | N2_DYNNUM | NUMC | 4 | N2_DYNNUM | ||||
DIOPT1 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
PW1CHFBEZ | 1st Character Format for Label | N2_PW1CFBZ | CHAR | 2 | N2_CHRFOR | ||||
PW1CHFVAL | 1st Character Format for Value | N2_PW1CFVL | CHAR | 2 | N2_CHRFOR | ||||
PFETTBEZ | Identifier Bold? (Yes/No) | N2_PFETTBZ | CHAR | 1 | XFELD | ||||
PFETTVAL | Value Bold? (Yes/No) | N2_PFETTVL | CHAR | 1 | XFELD | ||||
PKURSBEZ | Identifier in Italics? | N2_PKURSBZ | CHAR | 1 | XFELD | ||||
PKURSVAL | Value in Italics? | N2_PKURSVL | CHAR | 1 | XFELD | ||||
PULINBEZ | Identifier Underlined? | N2_PULINBZ | CHAR | 1 | XFELD | ||||
PULINVAL | Value Underlined? | N2_PULINVL | CHAR | 1 | XFELD | ||||
PCHARF2BEZ | 2nd Character Format for Value | N2_PW2CFBZ | CHAR | 2 | N2_CHRFOR | ||||
PCHARF2VAL | 2nd Character Format for Value | N2_PW2CFVL | CHAR | 2 | N2_CHRFOR | ||||
FKTPUSH | Pushbutton: Function routine | N2_FKTPUSH | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODPUSH | Pushbutton: Function include | N2_MODPUSH | CHAR | 40 | PROGRAM_ID | ||||
ICON_TEXT | Quickinfo for an icon | ICONQUICK | CHAR | 30 | ICONTEXT | ||||
ICON_NAME | Name of an Icon | ICONNAME | CHAR | 30 | ICONNAME | ||||
ICON_SIZE | Icon: Output length | ICONLENGTH | INT1 | 3 | ICONLENGTH | ||||
DIOPT2 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
DIOPT3 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
DIOPT4 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
DIOPT5 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
DIOPT6 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
PROPT1 | Param.doc: Print option | N2_PROPT | CHAR | 1 | N2_OPTION | ||||
FKTDIS | User exit for supplying a display field | N2_FKTDIS | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODDIS | INCLUDE for user exit display | N2_MODDIS | CHAR | 40 | PROGRAM_ID | ||||
ALL_DYN | on which screens Element is to appear | N2_ALL_DYN | CHAR | 1 | N2_WHICH_DYN | ||||
FKTMODIF | User exit for the screen modification | N2_FKTMODIF | CHAR | 30 | Assigned to domain | FUNCNAME | |||
MODMODIF | INCLUDE for modification user exit | N2_MODMODIF | CHAR | 40 | PROGRAM_ID | ||||
GRP4MODIF | Modification group 4 | SCRFGRP4 | CHAR | 3 | SCRPCHA3 | ||||
CARD_SEQ | Sequence of tab pages in a register | N2_CARD_SEQ | NUMC | 4 | N2_CARD_SEQ | ||||
DYNNUM_SUPER | 'Real' Dynpro Number | N2_DYNNUM | NUMC | 4 | N2_DYNNUM | ||||
ETID_REG | ETID of the Upper-Level Tab | N2_ETID_REG | NUMC | 4 | Assigned to domain | N2_ETID | |||
ETID_CARD | ETID of the Upper-Level Tab Page | N2_ETID_CARD | NUMC | 4 | Assigned to domain | N2_ETID | |||
ETID_MULT | ETID for the upper-level multiple structure | N2_ETID_MULT | NUMC | 4 | Assigned to domain | N2_ETID | |||
ETID_SUPER | ETID of structure directly above (f.a. structure types) | N2_ETID_SUPER | NUMC | 4 | Assigned to domain | N2_ETID | |||
NOPRINT | PMD: Do Not Print | N2_NOPRINT | CHAR | 1 | XFELD | ||||
FKTF4_GSD | PMD: F4-Help User Exit (Standard) | N2_FKTF4_GSD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FKTCV_GSD | PMD: Element-Check-User Exit (Standard) | N2_FKTCV_GSD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FKTMODIF_GSD | PMD: Element-Modification User Exit (Standard) | N2_FKTMODIF_GSD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FKTPUSH_GSD | PMD: Function User Exit (Standard) | N2_FKTPUSH_GSD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FKTDIS_GSD | PMD: Display User Exit (Standard) | N2_FKTDIS_GSD | CHAR | 30 | Assigned to domain | FUNCNAME | |||
FKTF4_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTCV_NO | PMD: User exit active with... | N2_UECHECK_ACTIV_AT | CHAR | 1 | N2_UECHECK_ACTIV_AT | ||||
FKTMODIF_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTPUSH_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTDIS_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTF4_GSD_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTCV_GSD_NO | PMD: User exit active with... | N2_UECHECK_ACTIV_AT | CHAR | 1 | N2_UECHECK_ACTIV_AT | ||||
FKTMODIF_GSD_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTPUSH_GSD_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
FKTDIS_GSD_NO | PMD: Deactivate Element User Exit | N2_EUEXIT_DEAKT | CHAR | 1 | XFELD | ||||
DATAREFFLD | Field Name for Data Address | N2_DATAREF | CHAR | 30 | Assigned to domain | FDNAME | |||
DIOPT7 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
DIOPT8 | PMD: Dialog Option | N2_DIOPT | CHAR | 1 | N2_OPTION | ||||
WIDREAL | Visual Output Width | N2_BREITE | NUMC | 3 | NUMC03 | ||||
P0_PATH | PMD: New Path | N2P0_PATH | STRG | 0 |
Key field | Non-key field |
How do I retrieve data from SAP table N2ET using ABAP code
The following ABAP code Example will allow you to do a basic selection on N2ET to SELECT all data from the tableDATA: WA_N2ET TYPE N2ET.
SELECT SINGLE *
FROM N2ET
INTO CORRESPONDING FIELDS OF WA_N2ET
WHERE...
How to access SAP table N2ET
Within an ECC or HANA version of SAP you can also view further information about N2ET 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