ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	EINRI	Institution	nvarchar	4	Allow NULL?
3	DTID	Document Category ID	nvarchar	10	Allow NULL?
4	DTVERS	Version Number	nvarchar	3	Allow NULL?
5	ETID	Ident of the DE to DC Assignment	nvarchar	4	Allow NULL?
6	DTUUID	PMD: UUID	nvarchar	32	Allow NULL?
7	PFADLEVEL	Path Level of Documentation Element	nvarchar	2	Allow NULL?
8	DEPFAD	'Path' of the Doc.Element via Structures	nvarchar	100	Allow NULL?
9	DEID	Ident. of Documentation Element	nvarchar	10	Allow NULL?
10	DELEN	Unused	nvarchar	2	Allow NULL?
11	DDTAB	Table Name	nvarchar	30	Allow NULL?
12	TABFD	Field Name	nvarchar	30	Allow NULL?
13	DYNFD	Identifier of Field in Screen	nvarchar	10	Allow NULL?
14	DYNPR	Relative Dynpro number	nvarchar	4	Allow NULL?
15	OBLIG	Mandatory Entry	char	1	Allow NULL?
16	AREA	Area Identifier in Screen/Report	nvarchar	2	Allow NULL?
17	FDRU	Control Indicator for Page Feed	char	1	Allow NULL?
18	DEEA	Input/Output field	char	1	Allow NULL?
19	NOBEZ	Indicator: Without Label	char	1	Allow NULL?
20	STRUC	Documentation Element: Structure	char	1	Allow NULL?
21	GRAPH	Graphics Type (Picture)	char	1	Allow NULL?
22	HOEHE	Height of Doc.Element Structure	nvarchar	3	Allow NULL?
23	BREITE	Visual Output Width	nvarchar	3	Allow NULL?
24	DETYP	Category of Documentation Element	char	1	Allow NULL?
25	DAID	Data element (semantic domain)	nvarchar	30	Allow NULL?
26	TABKZ	Indicator for Generation of Storage Structures	char	1	Allow NULL?
27	RTXTLEN	DocEl. Descriptor/Fixed Txt Length for Printout	nvarchar	2	Allow NULL?
28	TXTLEN	Identifier length in the screen	nvarchar	2	Allow NULL?
29	DOVOREX	Default Rule	nvarchar	5	Allow NULL?
30	STRUCTYP	Type of Structure	char	1	Allow NULL?
31	VARLOOP	PMD: Display Radio Buttons	char	1	Allow NULL?
32	BUTWIDTH	Button width for radio buttons	nvarchar	3	Allow NULL?
33	NUMOCC	Number of Rows	nvarchar	3	Allow NULL?
34	SUBPOOL	Program for the subscreen	nvarchar	40	Allow NULL?
35	SUBDYNP	Dynpro Number for Subscreen	nvarchar	4	Allow NULL?
36	SUBFORM	Form Routine for Subscreen Data in the Report	nvarchar	30	Allow NULL?
37	FDBSID	PMD: Name of External Data Module (ID)	nvarchar	10	Allow NULL?
38	ISREF	Referencing Inclusion of External Data	char	1	Allow NULL?
39	PARAMSTR	PMD: Fixed Parameters for Query Routine	nvarchar	65	Allow NULL?
40	NQUERY	Perform New Search in Every Case	char	1	Allow NULL?
41	ISAEND	Changing Inclusion of External Data	char	1	Allow NULL?
42	HELPF4	Integrate F4-Help with External Data Module	char	1	Allow NULL?
43	FDB_GET_REQUEST	Save Prompt (Query) when Updating	char	1	Allow NULL?
44	FDB_UPD_REQUEST	Save Query when Changing	char	1	Allow NULL?
45	LABSID	Name of the Link Module (ID)	nvarchar	30	Allow NULL?
46	LINKELETYP	PMD: Link Module Interface Display	char	1	Allow NULL?
47	OUTPUTLEN	Output Length	nvarchar	6	Allow NULL?
48	WTABEXI	Document Element Domains Contain Fixed Values	char	1	Allow NULL?
49	GETFROM	Field contents from?	char	1	Allow NULL?
50	FUNCTION1	Function code for pushbutton	nvarchar	20	Allow NULL?
51	WREQUEST	Trigger event?	char	1	Allow NULL?
52	XPRANUM	PMD: Number of Recently Run XPRAs	nvarchar	3	Allow NULL?
53	DESEQ	Print Sequence of Doc.Elements	nvarchar	5	Allow NULL?
54	SCRY	Row Position of the Value	nvarchar	4	Allow NULL?
55	SCRX	Column Position of the Value	nvarchar	3	Allow NULL?
56	REPY	Report: Y PosValue	nvarchar	4	Allow NULL?
57	REPX	Report: X PosValue	nvarchar	3	Allow NULL?
58	SCRYBEZ	Row Position of the Identifier	nvarchar	4	Allow NULL?
59	SCRXBEZ	Column Position of the Identifier	nvarchar	3	Allow NULL?
60	REPYBEZ	Report: Y Position Descriptor	nvarchar	4	Allow NULL?
61	REPXBEZ	Report: X PosDescriptor	nvarchar	3	Allow NULL?
62	PW1SEQBEZ	Sequence Order in View	nvarchar	5	Allow NULL?
63	PW1SEQVAL	Print Sequence	nvarchar	5	Allow NULL?
64	PW1XBEZ	Window1: X Position Descriptor	nvarchar	3	Allow NULL?
65	PW1YBEZ	Window1: Y Position Descriptor	nvarchar	4	Allow NULL?
66	PW1XVAL	Window1: X Position Value	nvarchar	3	Allow NULL?
67	PW1YVAL	Window1: Y Position Value	nvarchar	4	Allow NULL?
68	PW2SEQBEZ	Window2: Seq. Descriptor	nvarchar	5	Allow NULL?
69	PW2SEQVAL	Window2: SeqVal	nvarchar	5	Allow NULL?
70	PW2XBEZ	Line Feed	nvarchar	3	Allow NULL?
71	PW2YBEZ	Window2: Y Item Descriptor	nvarchar	4	Allow NULL?
72	PW2XVAL	Window2: X Position Value	nvarchar	3	Allow NULL?
73	PW2YVAL	Window2: Y Item Value	nvarchar	4	Allow NULL?
74	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	Allow NULL?
75	ERDAT	IS-H: Date when Record Created	nvarchar	8	Allow NULL?
76	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	Allow NULL?
77	UPDAT	IS-H: Date of Last Change	nvarchar	8	Allow NULL?
78	STATUS	Status for Doc.Categ. Assignments (N2ET)	char	1	Allow NULL?
79	REFFLD	Reference Field for External Data and Links	nvarchar	30	Allow NULL?
80	PTXTEL	Text Element in SAPscript Form	nvarchar	30	Allow NULL?
81	PW1NAME	Window name	nvarchar	8	Allow NULL?
82	PW1SUPR	Suppress descriptor when no data	char	1	Allow NULL?
83	PW1ABSFBEZ	Window1: Paragraph Format Descriptor	nvarchar	2	Allow NULL?
84	PW1ABSFVAL	Window1: Paragraph Format Value	nvarchar	2	Allow NULL?
85	PW2NAME	Window2: Name	nvarchar	8	Allow NULL?
86	PW2SUPR	Expand Table	char	1	Allow NULL?
87	PW2ABSFBEZ	Window2: Paragraph Format Descriptor	nvarchar	2	Allow NULL?
88	PW2ABSFVAL	Window2: Paragraph Format Value	nvarchar	2	Allow NULL?
89	ALIAS1	Alias for a Documentation Element	nvarchar	12	Allow NULL?
90	ALIASFD	Alias of an element for External Data Supply	nvarchar	12	Allow NULL?
91	FDPERALIAS	Ext. Data Supply by Alias	char	1	Allow NULL?
92	FKTF1	UserExit for F1 Help	nvarchar	30	Allow NULL?
93	MODF1	INCLUDE F1 Help	nvarchar	40	Allow NULL?
94	FKTF4	FORM routine for F4 Help	nvarchar	30	Allow NULL?
95	MODF4	INCLUDE F4 Help	nvarchar	40	Allow NULL?
96	FKTCV	User exit for checking values	nvarchar	30	Allow NULL?
97	MODCV	Include 'CheckValues'	nvarchar	40	Allow NULL?
98	FKTPV	'PrintValues' Form Routine	nvarchar	30	Allow NULL?
99	MODPV	Include 'Print Values'	nvarchar	40	Allow NULL?
100	DYNFNLANG	Name of a Screen Element	nvarchar	132	Allow NULL?
101	IFNAME	Interface representation	nvarchar	30	Allow NULL?
102	DYNNUM	'Real' Dynpro Number	nvarchar	4	Allow NULL?
103	DIOPT1	PMD: Dialog Option	char	1	Allow NULL?
104	PW1CHFBEZ	1st Character Format for Label	nvarchar	2	Allow NULL?
105	PW1CHFVAL	1st Character Format for Value	nvarchar	2	Allow NULL?
106	PFETTBEZ	Identifier Bold? (Yes/No)	char	1	Allow NULL?
107	PFETTVAL	Value Bold? (Yes/No)	char	1	Allow NULL?
108	PKURSBEZ	Identifier in Italics?	char	1	Allow NULL?
109	PKURSVAL	Value in Italics?	char	1	Allow NULL?
110	PULINBEZ	Identifier Underlined?	char	1	Allow NULL?
111	PULINVAL	Value Underlined?	char	1	Allow NULL?
112	PCHARF2BEZ	2nd Character Format for Value	nvarchar	2	Allow NULL?
113	PCHARF2VAL	2nd Character Format for Value	nvarchar	2	Allow NULL?
114	FKTPUSH	Pushbutton: Function routine	nvarchar	30	Allow NULL?
115	MODPUSH	Pushbutton: Function include	nvarchar	40	Allow NULL?
116	ICON_TEXT	Quickinfo for an icon	nvarchar	30	Allow NULL?
117	ICON_NAME	Name of an Icon	nvarchar	30	Allow NULL?
118	ICON_SIZE	Icon: Output length	tinyint	3
119	DIOPT2	PMD: Dialog Option	char	1	Allow NULL?
120	DIOPT3	PMD: Dialog Option	char	1	Allow NULL?
121	DIOPT4	PMD: Dialog Option	char	1	Allow NULL?
122	DIOPT5	PMD: Dialog Option	char	1	Allow NULL?
123	DIOPT6	PMD: Dialog Option	char	1	Allow NULL?
124	PROPT1	Param.doc: Print option	char	1	Allow NULL?
125	FKTDIS	User exit for supplying a display field	nvarchar	30	Allow NULL?
126	MODDIS	INCLUDE for user exit display	nvarchar	40	Allow NULL?
127	ALL_DYN	on which screens Element is to appear	char	1	Allow NULL?
128	FKTMODIF	User exit for the screen modification	nvarchar	30	Allow NULL?
129	MODMODIF	INCLUDE for modification user exit	nvarchar	40	Allow NULL?
130	GRP4MODIF	Modification group 4	nvarchar	3	Allow NULL?
131	CARD_SEQ	Sequence of tab pages in a register	nvarchar	4	Allow NULL?
132	DYNNUM_SUPER	'Real' Dynpro Number	nvarchar	4	Allow NULL?
133	ETID_REG	ETID of the Upper-Level Tab	nvarchar	4	Allow NULL?
134	ETID_CARD	ETID of the Upper-Level Tab Page	nvarchar	4	Allow NULL?
135	ETID_MULT	ETID for the upper-level multiple structure	nvarchar	4	Allow NULL?
136	ETID_SUPER	ETID of structure directly above (f.a. structure types)	nvarchar	4	Allow NULL?
137	NOPRINT	PMD: Do Not Print	char	1	Allow NULL?
138	FKTF4_GSD	PMD: F4-Help User Exit (Standard)	nvarchar	30	Allow NULL?
139	FKTCV_GSD	PMD: Element-Check-User Exit (Standard)	nvarchar	30	Allow NULL?
140	FKTMODIF_GSD	PMD: Element-Modification User Exit (Standard)	nvarchar	30	Allow NULL?
141	FKTPUSH_GSD	PMD: Function User Exit (Standard)	nvarchar	30	Allow NULL?
142	FKTDIS_GSD	PMD: Display User Exit (Standard)	nvarchar	30	Allow NULL?
143	FKTF4_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
144	FKTCV_NO	PMD: User exit active with...	char	1	Allow NULL?
145	FKTMODIF_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
146	FKTPUSH_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
147	FKTDIS_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
148	FKTF4_GSD_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
149	FKTCV_GSD_NO	PMD: User exit active with...	char	1	Allow NULL?
150	FKTMODIF_GSD_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
151	FKTPUSH_GSD_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
152	FKTDIS_GSD_NO	PMD: Deactivate Element User Exit	char	1	Allow NULL?
153	DATAREFFLD	Field Name for Data Address	nvarchar	30	Allow NULL?
154	DIOPT7	PMD: Dialog Option	char	1	Allow NULL?
155	DIOPT8	PMD: Dialog Option	char	1	Allow NULL?
156	WIDREAL	Visual Output Width	nvarchar	3	Allow NULL?
157	P0_PATH	PMD: New Path	ntext	1073741823

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