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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

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 :: SAP Healthcare - Industry-Specific Components for Hospitals :: Patient Management
1	ERP EHP7	6.0	NTMN	80	9	IS-H: Patient-Specific Appointments (Header Table for NAPP)	Patient Management

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	TMNID	IS-H: Identification of Appointment	nvarchar	10	Allow NULL?
3	EINRI	Institution	nvarchar	4	Allow NULL?
4	PATNR	IS-H: Patient Number	nvarchar	10	Allow NULL?
5	PZIFF	Check Digit for Patient	char	1	Allow NULL?
6	EXTNR	IS-H: External Patient Identification	nvarchar	20	Allow NULL?
7	FALNR	IS-H: Case Number	nvarchar	10	Allow NULL?
8	FZIFF	Check Digit for Case	char	1	Allow NULL?
9	FALAR	IS-H: Case Type	char	1	Allow NULL?
10	TMNLB	IS-H: Sequence Number of Movement	nvarchar	5	Allow NULL?
11	TMNOE	IS-H: Planned Organizational Unit	nvarchar	8	Allow NULL?
12	TMNDT	IS-H: Date of Appointment	nvarchar	8	Allow NULL?
13	TMNZT	IS-H: Time of Appointment	nvarchar	6	Allow NULL?
14	TMNDR	IS-H: Duration of Appointment	nvarchar	4	Allow NULL?
15	NNAME	Patient Last Name	nvarchar	30	Allow NULL?
16	VNAME	IS-H: Patient First Name	nvarchar	30	Allow NULL?
17	NNAMS	IS-H: Standardized Last Name	nvarchar	80	Allow NULL?
18	VNAMS	Standardized First Name	nvarchar	80	Allow NULL?
19	TITEL	IS-H: Title	nvarchar	15	Allow NULL?
20	NAMZU	IS-H: Name Affix	nvarchar	15	Allow NULL?
21	VORSW	IS-H: Name Prefix	nvarchar	15	Allow NULL?
22	GBNAM	IS-H: Birthname	nvarchar	30	Allow NULL?
23	GBNAS	IS-H: Standardized Birth Name	nvarchar	80	Allow NULL?
24	GBDAT	IS-H: Birthdate	nvarchar	8	Allow NULL?
25	GSCHL	IS-H: Sex Indicator - Internal	char	1	Allow NULL?
26	TELF1	IS-H: Patient Telephone Number	nvarchar	16	Allow NULL?
27	TODKZ	IS-H: Patient Is Deceased	char	1	Allow NULL?
28	SOURC	IS-H: Application that Created Object	char	1	Allow NULL?
29	TMTAG	IS-H: Appointment on Given Day	char	1	Allow NULL?
30	REFID	IS-H: Reference Number of Next Appointment	nvarchar	10	Allow NULL?
31	NOTAN	IS-H: Emergency Admission Indicator	char	1	Allow NULL?
32	KRZAN	IS-H: Quick Admission Indicator	char	1	Allow NULL?
33	BEKAT	Treatment Category	nvarchar	6	Allow NULL?
34	RISKF	IS-H: Risk Information Exists for the Patient	char	1	Allow NULL?
35	CLASS	IS-H: Patient Class	nvarchar	4	Allow NULL?
36	BNKZ	IS-H: Notification of Appointment Desired	char	1	Allow NULL?
37	BNDT	IS-H: Date on which patient was last notified	nvarchar	8	Allow NULL?
38	BNART	IS-H: Type of Notification (Tel., Written)	char	1	Allow NULL?
39	EINBDT	IS-H: Date of Appointment of which Patient Last Notified	nvarchar	8	Allow NULL?
40	EINBZT	IS-H: Time of Appointment of which Patient Last Notified	nvarchar	6	Allow NULL?
41	EINBOE	Nursing Org. Unit of Patient's Last Scheduled Appointment	nvarchar	8	Allow NULL?
42	EINBPER	IS-H: Person/Physician of Last Patient Appt Notification	nvarchar	10	Allow NULL?
43	EINBZIM	IS-H: Building Unit of Last Patient Notification	nvarchar	8	Allow NULL?
44	ERDAT	IS-H: Date when Record Created	nvarchar	8	Allow NULL?
45	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	Allow NULL?
46	UPDAT	IS-H: Date of Last Change	nvarchar	8	Allow NULL?
47	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	Allow NULL?
48	FATYP	Case Category	nvarchar	2	Allow NULL?
49	BWART	IS-H: Movement Type	nvarchar	2	Allow NULL?
50	TPART	Transport Type	nvarchar	2	Allow NULL?
51	BWPRIO	Prioritization for Request/Movement (Internal)	nvarchar	3	Allow NULL?
52	MEDTX	Medical Text	nvarchar	50	Allow NULL?
53	TMSTG	Cancellation Reason for an Appointment	nvarchar	3	Allow NULL?
54	STORN	IS-H: Cancellation Indicator	char	1	Allow NULL?
55	STUSR	IS-H: Name of User who Canceled Data Record	nvarchar	12	Allow NULL?
56	STDAT	Date of Cancellation	nvarchar	8	Allow NULL?
57	VBUND		char	1	Allow NULL?
58	BWGR1	Movement Reason - 1st and 2nd Positions	nvarchar	2	Allow NULL?
59	BWGR2	Movement Reason - 3rd and 4th Positions	nvarchar	2	Allow NULL?
60	UARNR	IS-H: Personnel Number of Referring Physician	nvarchar	10	Allow NULL?
61	TMPDT	IS-H: Date Planned for Appointment	nvarchar	8	Allow NULL?
62	TMPZT	IS-H: Time Planned for Appointment	nvarchar	6	Allow NULL?
63	GPLVN	IS-H*MED: Employee or User who Last Planned Appointment	nvarchar	12	Allow NULL?
64	GPLTY	IS-H*MED: Appointment Changed by: Employee/User ID	char	1	Allow NULL?
65	EMAIL	IS-H: Internet Mail (SMTP) Address	nvarchar	241	Allow NULL?
66	BEWTY	Movement Category	char	1	Allow NULL?
67	CHAINID	IS-H: Link ID for Interdependent Appointments	nvarchar	10	Allow NULL?
68	UNITID	IS-H: Treatment Unit ID	nvarchar	3	Allow NULL?
69	DISTMIN	IS-H: Minimum Interval Between Appointments	nvarchar	3	Allow NULL?
70	DISTMAX	IS-H: Maximum Interval Between Appointments	nvarchar	3	Allow NULL?
71	DISTUNIT	IS-H: Time Unit for Interval Between Two Appointments	char	1	Allow NULL?
72	CYCLE	IS-H: Appointment Cycle	nvarchar	3	Allow NULL?
73	CYCLEUNIT	IS-H: Time Unit for Appointment Cycle	char	1	Allow NULL?
74	VKGID	IS-H: CORD/PREG: ID of an Order Item (Preregistration)	nvarchar	8	Allow NULL?
75	PAPID	IS-H: Provisional Patient Number	nvarchar	10	Allow NULL?
76	APCNID	IS-H: Identification of an Appointment Template	nvarchar	32	Allow NULL?
77	ENDPL	IS-H: Planning Complete	char	1	Allow NULL?
78	TIMESTAMP	Timestamp in Short Form (YYYYMMDDhhmmss)	decimal	15
79	CAUSECHNG	Reason for Change	nvarchar	50	Allow NULL?
80	CSECHGID	Reason for Change ID	nvarchar	3	Allow NULL?

Name	Primary	Unique	Type	Columns
NTMN~0	Yes	Yes	CLUSTERED	TMNID, MANDT
NTMN~1	No	No	NONCLUSTERED	TMNDT, EINRI, PATNR, MANDT
NTMN~2	No	No	NONCLUSTERED	CHAINID, MANDT
NTMN~4	No	No	NONCLUSTERED	TMNLB, EINRI, FALNR, MANDT
NTMN~5	No	No	NONCLUSTERED	MANDT, TMNZT, TMNDT, TMNOE
NTMN~6	No	No	NONCLUSTERED	TMNDT, UARNR, MANDT
NTMN~7	No	No	NONCLUSTERED	MANDT, STORN, VKGID
NTMN~8	No	No	NONCLUSTERED	TMNDT, EINRI, PAPID, MANDT
NTMN~9	No	No	NONCLUSTERED	APCNID, 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

80 COLUMNS | 9 INDEXES | ERP 6.0 | NTMN TABLE

TOP ERP 6.0 | NTMN COLUMNS

TOP ERP 6.0 | NTMN 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

80 COLUMNS | 9 INDEXES | ERP 6.0 | NTMN TABLE

TOPERP 6.0 | NTMN COLUMNS

TOPERP 6.0 | NTMN INDEXES

TOP ERP 6.0 | NTMN COLUMNS

TOP ERP 6.0 | NTMN INDEXES