	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

157 COLUMNS | 1 INDEXES | ERP 6.0 | N2ET TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2ET	157	1	IS-H*MED: Table of docElement to DocCategory assignments	Clinical System

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, EINRI, DTID, DTVERS, ETID, DTUUID, PFADLEVEL, DEPFAD, DEID, DELEN, DDTAB, TABFD, DYNFD, DYNPR, OBLIG, AREA, FDRU, DEEA, NOBEZ, STRUC, GRAPH, HOEHE, BREITE, DETYP, DAID, TABKZ, RTXTLEN, TXTLEN, DOVOREX, STRUCTYP, VARLOOP, BUTWIDTH, NUMOCC, SUBPOOL, SUBDYNP, SUBFORM, FDBSID, ISREF, PARAMSTR, NQUERY, ISAEND, HELPF4, FDB_GET_REQUEST, FDB_UPD_REQUEST, LABSID, LINKELETYP, OUTPUTLEN, WTABEXI, GETFROM, FUNCTION1, WREQUEST, XPRANUM, DESEQ, SCRY, SCRX, REPY, REPX, SCRYBEZ, SCRXBEZ, REPYBEZ, REPXBEZ, PW1SEQBEZ, PW1SEQVAL, PW1XBEZ, PW1YBEZ, PW1XVAL, PW1YVAL, PW2SEQBEZ, PW2SEQVAL, PW2XBEZ, PW2YBEZ, PW2XVAL, PW2YVAL, ERUSR, ERDAT, UPUSR, UPDAT, STATUS, REFFLD, PTXTEL, PW1NAME, PW1SUPR, PW1ABSFBEZ, PW1ABSFVAL, PW2NAME, PW2SUPR, PW2ABSFBEZ, PW2ABSFVAL, ALIAS1, ALIASFD, FDPERALIAS, FKTF1, MODF1, FKTF4, MODF4, FKTCV, MODCV, FKTPV, MODPV, DYNFNLANG, IFNAME, DYNNUM, DIOPT1, PW1CHFBEZ, PW1CHFVAL, PFETTBEZ, PFETTVAL, PKURSBEZ, PKURSVAL, PULINBEZ, PULINVAL, PCHARF2BEZ, PCHARF2VAL, FKTPUSH, MODPUSH, ICON_TEXT, ICON_NAME, ICON_SIZE, DIOPT2, DIOPT3, DIOPT4, DIOPT5, DIOPT6, PROPT1, FKTDIS, MODDIS, ALL_DYN, FKTMODIF, MODMODIF, GRP4MODIF, CARD_SEQ, DYNNUM_SUPER, ETID_REG, ETID_CARD, ETID_MULT, ETID_SUPER, NOPRINT, FKTF4_GSD, FKTCV_GSD, FKTMODIF_GSD, FKTPUSH_GSD, FKTDIS_GSD, FKTF4_NO, FKTCV_NO, FKTMODIF_NO, FKTPUSH_NO, FKTDIS_NO, FKTF4_GSD_NO, FKTCV_GSD_NO, FKTMODIF_GSD_NO, FKTPUSH_GSD_NO, FKTDIS_GSD_NO, DATAREFFLD, DIOPT7, DIOPT8, WIDREAL, P0_PATH FROM N2ET

TOP ERP 6.0 | N2ET COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	EINRI	Institution	nvarchar	4	CHAR	(N' ')	No	TN01	EINRI	Allow NULL?
3	DTID	Document Category ID	nvarchar	10	CHAR	(N' ')	No	N2DT	N2_DTID	Allow NULL?
4	DTVERS	Version Number	nvarchar	3	NUMC	(N'000')	No		N2_VERS	Allow NULL?
5	ETID	Ident of the DE to DC Assignment	nvarchar	4	NUMC	(N'0000')	No		N2_ETID	Allow NULL?
6	DTUUID	PMD: UUID	nvarchar	32	CHAR	(N' ')	Yes		N2_DT_UUID	Allow NULL?
7	PFADLEVEL	Path Level of Documentation Element	nvarchar	2	NUMC	(N'00')	Yes		N2_PFLEVEL	Allow NULL?
8	DEPFAD	'Path' of the Doc.Element via Structures	nvarchar	100	CHAR	(N' ')	Yes		N2_DEPFAD	Allow NULL?
9	DEID	Ident. of Documentation Element	nvarchar	10	CHAR	(N' ')	Yes	N2DE	N2_DEID	Allow NULL?
10	DELEN	Unused	nvarchar	2	NUMC	(N'00')	Yes		N2_DALEN	Allow NULL?
11	DDTAB	Table Name	nvarchar	30	CHAR	(N' ')	Yes	*	TABNAME	Allow NULL?
12	TABFD	Field Name	nvarchar	30	CHAR	(N' ')	Yes	*	FIELDNAME	Allow NULL?
13	DYNFD	Identifier of Field in Screen	nvarchar	10	CHAR	(N' ')	Yes		N2_DYNFD	Allow NULL?
14	DYNPR	Relative Dynpro number	nvarchar	4	NUMC	(N'0000')	Yes		N2_DYNPR	Allow NULL?
15	OBLIG	Mandatory Entry	char	1	CHAR	(N' ')	Yes		N2_OBLIG	Allow NULL?
16	AREA	Area Identifier in Screen/Report	nvarchar	2	CHAR	(N' ')	Yes		N2_DYNAR	Allow NULL?
17	FDRU	Control Indicator for Page Feed	char	1	CHAR	(N' ')	Yes		N2_FDRU	Allow NULL?
18	DEEA	Input/Output field	char	1	CHAR	(N' ')	Yes		N2_DEEA	Allow NULL?
19	NOBEZ	Indicator: Without Label	char	1	CHAR	(N' ')	Yes		N2_NOBEZ	Allow NULL?
20	STRUC	Documentation Element: Structure	char	1	CHAR	(N' ')	Yes		N2_STRUC	Allow NULL?
21	GRAPH	Graphics Type (Picture)	char	1	CHAR	(N' ')	Yes		N2_GRAPH	Allow NULL?
22	HOEHE	Height of Doc.Element Structure	nvarchar	3	NUMC	(N'000')	Yes		N2_HOEHE	Allow NULL?
23	BREITE	Visual Output Width	nvarchar	3	NUMC	(N'000')	Yes		N2_BREITE	Allow NULL?
24	DETYP	Category of Documentation Element	char	1	CHAR	(N' ')	Yes		N2_DETYP	Allow NULL?
25	DAID	Data element (semantic domain)	nvarchar	30	CHAR	(N' ')	Yes	*	ROLLNAME	Allow NULL?
26	TABKZ	Indicator for Generation of Storage Structures	char	1	CHAR	(N' ')	Yes		N2_TABKZ	Allow NULL?
27	RTXTLEN	DocEl. Descriptor/Fixed Txt Length for Printout	nvarchar	2	NUMC	(N'00')	Yes		N2_RTXTLEN	Allow NULL?
28	TXTLEN	Identifier length in the screen	nvarchar	2	NUMC	(N'00')	Yes		N2_TXTLEN	Allow NULL?
29	DOVOREX	Default Rule	nvarchar	5	CHAR	(N' ')	Yes		N2_DOVOREX	Allow NULL?
30	STRUCTYP	Type of Structure	char	1	CHAR	(N' ')	Yes		N2_STRTYP	Allow NULL?
31	VARLOOP	PMD: Display Radio Buttons	char	1	CHAR	(N' ')	Yes		N2_VARLOOP	Allow NULL?
32	BUTWIDTH	Button width for radio buttons	nvarchar	3	NUMC	(N'000')	Yes		N2_BUTWIDTH	Allow NULL?
33	NUMOCC	Number of Rows	nvarchar	3	NUMC	(N'000')	Yes		N2_NUMOCC	Allow NULL?
34	SUBPOOL	Program for the subscreen	nvarchar	40	CHAR	(N' ')	Yes		N2_SUBPOOL	Allow NULL?
35	SUBDYNP	Dynpro Number for Subscreen	nvarchar	4	NUMC	(N'0000')	Yes		N2_SUBDYNP	Allow NULL?
36	SUBFORM	Form Routine for Subscreen Data in the Report	nvarchar	30	CHAR	(N' ')	Yes	*	N2_SUBFORM	Allow NULL?
37	FDBSID	PMD: Name of External Data Module (ID)	nvarchar	10	CHAR	(N' ')	Yes	N2FDBS	N2_FDBSID	Allow NULL?
38	ISREF	Referencing Inclusion of External Data	char	1	CHAR	(N' ')	Yes		N2_ISREF	Allow NULL?
39	PARAMSTR	PMD: Fixed Parameters for Query Routine	nvarchar	65	CHAR	(N' ')	Yes		N2_PARAMST	Allow NULL?
40	NQUERY	Perform New Search in Every Case	char	1	CHAR	(N' ')	Yes		N2_NQUERY	Allow NULL?
41	ISAEND	Changing Inclusion of External Data	char	1	CHAR	(N' ')	Yes		N2_ISAEND	Allow NULL?
42	HELPF4	Integrate F4-Help with External Data Module	char	1	CHAR	(N' ')	Yes		N2_HELPF4	Allow NULL?
43	FDB_GET_REQUEST	Save Prompt (Query) when Updating	char	1	CHAR	(N' ')	Yes		N2_FDB_GET_REQUEST	Allow NULL?
44	FDB_UPD_REQUEST	Save Query when Changing	char	1	CHAR	(N' ')	Yes		N2_FDB_UPD_REQUEST	Allow NULL?
45	LABSID	Name of the Link Module (ID)	nvarchar	30	CHAR	(N' ')	Yes	N2LINKMODS	N2_LABSID	Allow NULL?
46	LINKELETYP	PMD: Link Module Interface Display	char	1	CHAR	(N' ')	Yes		N2_LINKELETYP	Allow NULL?
47	OUTPUTLEN	Output Length	nvarchar	6	NUMC	(N'000000')	Yes		OUTPUTLEN	Allow NULL?
48	WTABEXI	Document Element Domains Contain Fixed Values	char	1	CHAR	(N' ')	Yes		N2_WTABEXI	Allow NULL?
49	GETFROM	Field contents from?	char	1	CHAR	(N' ')	Yes		N2_GETFROM	Allow NULL?
50	FUNCTION1	Function code for pushbutton	nvarchar	20	CHAR	(N' ')	Yes		SCRFFCOD	Allow NULL?
51	WREQUEST	Trigger event?	char	1	CHAR	(N' ')	Yes		N2_WREQUEST	Allow NULL?
52	XPRANUM	PMD: Number of Recently Run XPRAs	nvarchar	3	NUMC	(N'000')	Yes		N2_XPRANUM	Allow NULL?
53	DESEQ	Print Sequence of Doc.Elements	nvarchar	5	NUMC	(N'00000')	Yes		N2_DESEQ	Allow NULL?
54	SCRY	Row Position of the Value	nvarchar	4	NUMC	(N'0000')	Yes		N2_SCRY	Allow NULL?
55	SCRX	Column Position of the Value	nvarchar	3	NUMC	(N'000')	Yes		N2_SCRX	Allow NULL?
56	REPY	Report: Y PosValue	nvarchar	4	NUMC	(N'0000')	Yes		N2_REPY	Allow NULL?
57	REPX	Report: X PosValue	nvarchar	3	NUMC	(N'000')	Yes		N2_REPX	Allow NULL?
58	SCRYBEZ	Row Position of the Identifier	nvarchar	4	NUMC	(N'0000')	Yes		N2_SCRYBEZ	Allow NULL?
59	SCRXBEZ	Column Position of the Identifier	nvarchar	3	NUMC	(N'000')	Yes		N2_SCRXBEZ	Allow NULL?
60	REPYBEZ	Report: Y Position Descriptor	nvarchar	4	NUMC	(N'0000')	Yes		N2_REPYBEZ	Allow NULL?
61	REPXBEZ	Report: X PosDescriptor	nvarchar	3	NUMC	(N'000')	Yes		N2_REPXBEZ	Allow NULL?
62	PW1SEQBEZ	Sequence Order in View	nvarchar	5	NUMC	(N'00000')	Yes		N2_PW1SQBZ	Allow NULL?
63	PW1SEQVAL	Print Sequence	nvarchar	5	NUMC	(N'00000')	Yes		N2_PW1SQVL	Allow NULL?
64	PW1XBEZ	Window1: X Position Descriptor	nvarchar	3	NUMC	(N'000')	Yes		N2_PW1XBEZ	Allow NULL?
65	PW1YBEZ	Window1: Y Position Descriptor	nvarchar	4	NUMC	(N'0000')	Yes		N2_PW1YBEZ	Allow NULL?
66	PW1XVAL	Window1: X Position Value	nvarchar	3	NUMC	(N'000')	Yes		N2_PW1XVAL	Allow NULL?
67	PW1YVAL	Window1: Y Position Value	nvarchar	4	NUMC	(N'0000')	Yes		N2_PW1YVAL	Allow NULL?
68	PW2SEQBEZ	Window2: Seq. Descriptor	nvarchar	5	NUMC	(N'00000')	Yes		N2_PW2SQBZ	Allow NULL?
69	PW2SEQVAL	Window2: SeqVal	nvarchar	5	NUMC	(N'00000')	Yes		N2_PW2SQVL	Allow NULL?
70	PW2XBEZ	Line Feed	nvarchar	3	NUMC	(N'000')	Yes		N2_PW2XBEZ	Allow NULL?
71	PW2YBEZ	Window2: Y Item Descriptor	nvarchar	4	NUMC	(N'0000')	Yes		N2_PW2YBEZ	Allow NULL?
72	PW2XVAL	Window2: X Position Value	nvarchar	3	NUMC	(N'000')	Yes		N2_PW2XVAL	Allow NULL?
73	PW2YVAL	Window2: Y Item Value	nvarchar	4	NUMC	(N'0000')	Yes		N2_PW2YVAL	Allow NULL?
74	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	CHAR	(N' ')	Yes		RI_ERNAM	Allow NULL?
75	ERDAT	IS-H: Date when Record Created	nvarchar	8	DATS	(N'00000000')	Yes		RI_ERDAT	Allow NULL?
76	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	CHAR	(N' ')	Yes		RI_UPNAM	Allow NULL?
77	UPDAT	IS-H: Date of Last Change	nvarchar	8	DATS	(N'00000000')	Yes		RI_UPDAT	Allow NULL?
78	STATUS	Status for Doc.Categ. Assignments (N2ET)	char	1	CHAR	(N' ')	Yes		N2_ETSTAT	Allow NULL?
79	REFFLD	Reference Field for External Data and Links	nvarchar	30	CHAR	(N' ')	Yes	*	N2_REFFLD	Allow NULL?
80	PTXTEL	Text Element in SAPscript Form	nvarchar	30	CHAR	(N' ')	Yes		N2_PTXTEL	Allow NULL?
81	PW1NAME	Window name	nvarchar	8	CHAR	(N' ')	Yes		N2_PW1NAME	Allow NULL?
82	PW1SUPR	Suppress descriptor when no data	char	1	CHAR	(N' ')	Yes		N2_PW1SUPR	Allow NULL?
83	PW1ABSFBEZ	Window1: Paragraph Format Descriptor	nvarchar	2	CHAR	(N' ')	Yes		N2_PW1AFBZ	Allow NULL?
84	PW1ABSFVAL	Window1: Paragraph Format Value	nvarchar	2	CHAR	(N' ')	Yes		N2_PW1AFVL	Allow NULL?
85	PW2NAME	Window2: Name	nvarchar	8	CHAR	(N' ')	Yes		N2_PW2NAME	Allow NULL?
86	PW2SUPR	Expand Table	char	1	CHAR	(N' ')	Yes		N2_PW2SUPR	Allow NULL?
87	PW2ABSFBEZ	Window2: Paragraph Format Descriptor	nvarchar	2	CHAR	(N' ')	Yes		N2_PW2AFBZ	Allow NULL?
88	PW2ABSFVAL	Window2: Paragraph Format Value	nvarchar	2	CHAR	(N' ')	Yes		N2_PW2AFVL	Allow NULL?
89	ALIAS1	Alias for a Documentation Element	nvarchar	12	CHAR	(N' ')	Yes		N2_ALIAS1	Allow NULL?
90	ALIASFD	Alias of an element for External Data Supply	nvarchar	12	CHAR	(N' ')	Yes		N2_ALIASFD	Allow NULL?
91	FDPERALIAS	Ext. Data Supply by Alias	char	1	CHAR	(N' ')	Yes		N2_FDPERALIAS	Allow NULL?
92	FKTF1	UserExit for F1 Help	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTF1	Allow NULL?
93	MODF1	INCLUDE F1 Help	nvarchar	40	CHAR	(N' ')	Yes		N2_MODF1	Allow NULL?
94	FKTF4	FORM routine for F4 Help	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTF4	Allow NULL?
95	MODF4	INCLUDE F4 Help	nvarchar	40	CHAR	(N' ')	Yes		N2_MODF4	Allow NULL?
96	FKTCV	User exit for checking values	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTCV	Allow NULL?
97	MODCV	Include 'CheckValues'	nvarchar	40	CHAR	(N' ')	Yes		N2_MODCV	Allow NULL?
98	FKTPV	'PrintValues' Form Routine	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTPV	Allow NULL?
99	MODPV	Include 'Print Values'	nvarchar	40	CHAR	(N' ')	Yes		N2_MODPV	Allow NULL?
100	DYNFNLANG	Name of a Screen Element	nvarchar	132	CHAR	(N' ')	Yes		SCRFNAME	Allow NULL?
101	IFNAME	Interface representation	nvarchar	30	CHAR	(N' ')	Yes		N2_IFNAME	Allow NULL?
102	DYNNUM	'Real' Dynpro Number	nvarchar	4	NUMC	(N'0000')	Yes		N2_DYNNUM	Allow NULL?
103	DIOPT1	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
104	PW1CHFBEZ	1st Character Format for Label	nvarchar	2	CHAR	(N' ')	Yes		N2_PW1CFBZ	Allow NULL?
105	PW1CHFVAL	1st Character Format for Value	nvarchar	2	CHAR	(N' ')	Yes		N2_PW1CFVL	Allow NULL?
106	PFETTBEZ	Identifier Bold? (Yes/No)	char	1	CHAR	(N' ')	Yes		N2_PFETTBZ	Allow NULL?
107	PFETTVAL	Value Bold? (Yes/No)	char	1	CHAR	(N' ')	Yes		N2_PFETTVL	Allow NULL?
108	PKURSBEZ	Identifier in Italics?	char	1	CHAR	(N' ')	Yes		N2_PKURSBZ	Allow NULL?
109	PKURSVAL	Value in Italics?	char	1	CHAR	(N' ')	Yes		N2_PKURSVL	Allow NULL?
110	PULINBEZ	Identifier Underlined?	char	1	CHAR	(N' ')	Yes		N2_PULINBZ	Allow NULL?
111	PULINVAL	Value Underlined?	char	1	CHAR	(N' ')	Yes		N2_PULINVL	Allow NULL?
112	PCHARF2BEZ	2nd Character Format for Value	nvarchar	2	CHAR	(N' ')	Yes		N2_PW2CFBZ	Allow NULL?
113	PCHARF2VAL	2nd Character Format for Value	nvarchar	2	CHAR	(N' ')	Yes		N2_PW2CFVL	Allow NULL?
114	FKTPUSH	Pushbutton: Function routine	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTPUSH	Allow NULL?
115	MODPUSH	Pushbutton: Function include	nvarchar	40	CHAR	(N' ')	Yes		N2_MODPUSH	Allow NULL?
116	ICON_TEXT	Quickinfo for an icon	nvarchar	30	CHAR	(N' ')	Yes		ICONQUICK	Allow NULL?
117	ICON_NAME	Name of an Icon	nvarchar	30	CHAR	(N' ')	Yes		ICONNAME	Allow NULL?
118	ICON_SIZE	Icon: Output length	tinyint	3	INT1	((0))	Yes		ICONLENGTH
119	DIOPT2	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
120	DIOPT3	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
121	DIOPT4	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
122	DIOPT5	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
123	DIOPT6	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
124	PROPT1	Param.doc: Print option	char	1	CHAR	(N' ')	Yes		N2_PROPT	Allow NULL?
125	FKTDIS	User exit for supplying a display field	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTDIS	Allow NULL?
126	MODDIS	INCLUDE for user exit display	nvarchar	40	CHAR	(N' ')	Yes		N2_MODDIS	Allow NULL?
127	ALL_DYN	on which screens Element is to appear	char	1	CHAR	(N' ')	Yes		N2_ALL_DYN	Allow NULL?
128	FKTMODIF	User exit for the screen modification	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTMODIF	Allow NULL?
129	MODMODIF	INCLUDE for modification user exit	nvarchar	40	CHAR	(N' ')	Yes		N2_MODMODIF	Allow NULL?
130	GRP4MODIF	Modification group 4	nvarchar	3	CHAR	(N' ')	Yes		SCRFGRP4	Allow NULL?
131	CARD_SEQ	Sequence of tab pages in a register	nvarchar	4	NUMC	(N'0000')	Yes		N2_CARD_SEQ	Allow NULL?
132	DYNNUM_SUPER	'Real' Dynpro Number	nvarchar	4	NUMC	(N'0000')	Yes		N2_DYNNUM	Allow NULL?
133	ETID_REG	ETID of the Upper-Level Tab	nvarchar	4	NUMC	(N'0000')	Yes	*	N2_ETID_REG	Allow NULL?
134	ETID_CARD	ETID of the Upper-Level Tab Page	nvarchar	4	NUMC	(N'0000')	Yes	*	N2_ETID_CARD	Allow NULL?
135	ETID_MULT	ETID for the upper-level multiple structure	nvarchar	4	NUMC	(N'0000')	Yes	*	N2_ETID_MULT	Allow NULL?
136	ETID_SUPER	ETID of structure directly above (f.a. structure types)	nvarchar	4	NUMC	(N'0000')	Yes	*	N2_ETID_SUPER	Allow NULL?
137	NOPRINT	PMD: Do Not Print	char	1	CHAR	(N' ')	Yes		N2_NOPRINT	Allow NULL?
138	FKTF4_GSD	PMD: F4-Help User Exit (Standard)	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTF4_GSD	Allow NULL?
139	FKTCV_GSD	PMD: Element-Check-User Exit (Standard)	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTCV_GSD	Allow NULL?
140	FKTMODIF_GSD	PMD: Element-Modification User Exit (Standard)	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTMODIF_GSD	Allow NULL?
141	FKTPUSH_GSD	PMD: Function User Exit (Standard)	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTPUSH_GSD	Allow NULL?
142	FKTDIS_GSD	PMD: Display User Exit (Standard)	nvarchar	30	CHAR	(N' ')	Yes	*	N2_FKTDIS_GSD	Allow NULL?
143	FKTF4_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
144	FKTCV_NO	PMD: User exit active with...	char	1	CHAR	(N' ')	Yes		N2_UECHECK_ACTIV_AT	Allow NULL?
145	FKTMODIF_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
146	FKTPUSH_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
147	FKTDIS_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
148	FKTF4_GSD_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
149	FKTCV_GSD_NO	PMD: User exit active with...	char	1	CHAR	(N' ')	Yes		N2_UECHECK_ACTIV_AT	Allow NULL?
150	FKTMODIF_GSD_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
151	FKTPUSH_GSD_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
152	FKTDIS_GSD_NO	PMD: Deactivate Element User Exit	char	1	CHAR	(N' ')	Yes		N2_EUEXIT_DEAKT	Allow NULL?
153	DATAREFFLD	Field Name for Data Address	nvarchar	30	CHAR	(N' ')	Yes	*	N2_DATAREF	Allow NULL?
154	DIOPT7	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
155	DIOPT8	PMD: Dialog Option	char	1	CHAR	(N' ')	Yes		N2_DIOPT	Allow NULL?
156	WIDREAL	Visual Output Width	nvarchar	3	NUMC	(N'000')	Yes		N2_BREITE	Allow NULL?
157	P0_PATH	PMD: New Path	ntext	1073741823			Yes		N2P0_PATH

TOP ERP 6.0 | N2ET INDEXES

Name	Primary	Unique	Type	Columns
N2ET~0	Yes	Yes	CLUSTERED	ETID, DTVERS, DTID, EINRI, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

157 COLUMNS | 1 INDEXES | ERP 6.0 | N2ET TABLE

TOP ERP 6.0 | N2ET COLUMNS

TOP ERP 6.0 | N2ET INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

157 COLUMNS | 1 INDEXES | ERP 6.0 | N2ET TABLE

TOPERP 6.0 | N2ET COLUMNS

TOPERP 6.0 | N2ET INDEXES

TOP ERP 6.0 | N2ET COLUMNS

TOP ERP 6.0 | N2ET INDEXES