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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
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	NPAT	136	13	IS-H: Patient Master Data (General)	Patient Management

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PATNR	IS-H: Patient Number	nvarchar	10	Allow NULL?
3	EINRI	Institution	nvarchar	4	Allow NULL?
4	GSCHL	IS-H: Sex Indicator - Internal	char	1	Allow NULL?
5	NNAME	Patient Last Name	nvarchar	30	Allow NULL?
6	NNAMS	IS-H: Standardized Last Name	nvarchar	80	Allow NULL?
7	VNAME	IS-H: Patient First Name	nvarchar	30	Allow NULL?
8	VNAMS	Standardized First Name	nvarchar	80	Allow NULL?
9	TITEL	IS-H: Title	nvarchar	15	Allow NULL?
10	NAMZU	IS-H: Name Affix	nvarchar	15	Allow NULL?
11	VORSW	IS-H: Name Prefix	nvarchar	15	Allow NULL?
12	NAME2	Pseudonym, Order Name	nvarchar	30	Allow NULL?
13	GBDAT	IS-H: Birthdate	nvarchar	8	Allow NULL?
14	GBNAM	IS-H: Birthname	nvarchar	30	Allow NULL?
15	GBNAS	IS-H: Standardized Birth Name	nvarchar	80	Allow NULL?
16	GLAND	IS-H: Country of Birth	nvarchar	3	Allow NULL?
17	TODKZ	IS-H: Patient Is Deceased	char	1	Allow NULL?
18	TODDT	IS-H: Date of Death From	nvarchar	8	Allow NULL?
19	TODZT	Time of Death From	nvarchar	6	Allow NULL?
20	TODDB	Date of Death To	nvarchar	8	Allow NULL?
21	TODZB	IS-H: Time of Death To	nvarchar	6	Allow NULL?
22	TODUR	IS-H: Cause of Death	nvarchar	3	Allow NULL?
23	ANRED	IS-H: Form-of-Address Key	nvarchar	2	Allow NULL?
24	FAMST	IS-H: Marital Status	char	1	Allow NULL?
25	KONFE	IS-H: Religion	nvarchar	2	Allow NULL?
26	NATIO	IS-H: Nationality	nvarchar	3	Allow NULL?
27	SPRAS	Patient Language	char	1	Allow NULL?
28	LAND	IS-H: Country of patient's place of residence	nvarchar	3	Allow NULL?
29	PSTLZ	IS-H: Patient Postal Code	nvarchar	10	Allow NULL?
30	ORT	IS-H: City where Patient Resides	nvarchar	25	Allow NULL?
31	ORT2	Patient District	nvarchar	25	Allow NULL?
32	STRAS	IS-H: Street and House Number of Patient	nvarchar	30	Allow NULL?
33	BLAND	IS-H: Region (Federal State, Province, County)	nvarchar	3	Allow NULL?
34	GEBIE	IS-H: Geographical Area	nvarchar	9	Allow NULL?
35	TELF1	IS-H: Patient Telephone Number	nvarchar	16	Allow NULL?
36	SPEND	Organ Donor Indicator	char	1	Allow NULL?
37	SPENT	Explanation for Donor Indicator	nvarchar	50	Allow NULL?
38	SPELT	Indicator that Long Text Exists	char	1	Allow NULL?
39	VIPKZ	IS-H: VIP Indicator	char	1	Allow NULL?
40	ARCHV	IS-H: Archived Data Indicator	char	1	Allow NULL?
41	STATU	Patient Status	char	1	Allow NULL?
42	EXTNR	IS-H: External Patient Identification	nvarchar	20	Allow NULL?
43	NOTAN	IS-H: Emergency Admission Indicator	char	1	Allow NULL?
44	KRZAN	IS-H: Quick Admission Indicator	char	1	Allow NULL?
45	RFPAT	Reference to Patient Number in Merging	nvarchar	10	Allow NULL?
46	RFZIF	Check Digit for Patient	char	1	Allow NULL?
47	BERUF	IS-H: Patient Occupation	nvarchar	25	Allow NULL?
48	AGNUM	IS-H: Patient's Employer	nvarchar	10	Allow NULL?
49	AGNAM	IS-H: Employer Name	nvarchar	30	Allow NULL?
50	AGLAN	IS-H: Employer Country	nvarchar	3	Allow NULL?
51	AGPLZ	IS-H: Employer Postal Code	nvarchar	10	Allow NULL?
52	AGORT	IS-H: Employer City	nvarchar	25	Allow NULL?
53	AGSTR	IS-H: Employer Street	nvarchar	30	Allow NULL?
54	AGTEL	IS-H: Employer Telephone Number	nvarchar	16	Allow NULL?
55	RVNUM	IS-H: Social Insurance Number	nvarchar	20	Allow NULL?
56	ANNA1	IS-H: Last Name of Person to Be Contacted	nvarchar	30	Allow NULL?
57	ANVN1	IS-H: First Name of Person to Be Contacted	nvarchar	30	Allow NULL?
58	ANLA1	Country of the Person to Be Contacted	nvarchar	3	Allow NULL?
59	ANPL1	IS-H: Postal Code	nvarchar	10	Allow NULL?
60	ANOR1	IS-H: City where Person to Be Contacted Resides	nvarchar	25	Allow NULL?
61	ANST1	IS-H: Street and House Number of Person to Be Contacted	nvarchar	30	Allow NULL?
62	ANTE1	IS-H: Telephone Number of Person to Be Contacted	nvarchar	16	Allow NULL?
63	ANVV1	IS-H: Relationship	char	1	Allow NULL?
64	VMKZ1	IS-H: Legal Representative	char	1	Allow NULL?
65	ANNA2	IS-H: Last Name of Person to Be Contacted	nvarchar	30	Allow NULL?
66	ANVN2	IS-H: First Name of Person to Be Contacted	nvarchar	30	Allow NULL?
67	ANLA2	Country of the Person to Be Contacted	nvarchar	3	Allow NULL?
68	ANPL2	IS-H: Postal Code	nvarchar	10	Allow NULL?
69	ANOR2	IS-H: City where Person to Be Contacted Resides	nvarchar	25	Allow NULL?
70	ANST2	IS-H: Street and House Number of Person to Be Contacted	nvarchar	30	Allow NULL?
71	ANTE2	IS-H: Telephone Number of Person to Be Contacted	nvarchar	16	Allow NULL?
72	ANVV2	IS-H: Relationship	char	1	Allow NULL?
73	VMKZ2	IS-H: Legal Representative	char	1	Allow NULL?
74	KZTXT	IS-H: Comment on Patient	nvarchar	50	Allow NULL?
75	LGTXT	Indicator that Long Text Exists	char	1	Allow NULL?
76	BEGDT	IS-H: Valid-From Date of Record	nvarchar	8	Allow NULL?
77	ENDDT	IS-H: Valid-To Date of Record	nvarchar	8	Allow NULL?
78	HISTK	Indicator that History Records Are Available	char	1	Allow NULL?
79	RISKF	IS-H: Risk Information Exists for the Patient	char	1	Allow NULL?
80	TESTP	Test Patient Status	char	1	Allow NULL?
81	PZIFF	Check Digit for Patient	char	1	Allow NULL?
82	ERDAT	IS-H: Date when Record Created	nvarchar	8	Allow NULL?
83	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	Allow NULL?
84	UPDAT	IS-H: Date of Last Change	nvarchar	8	Allow NULL?
85	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	Allow NULL?
86	STORN	IS-H: Cancellation Indicator	char	1	Allow NULL?
87	STUSR	IS-H: Name of User who Canceled Data Record	nvarchar	12	Allow NULL?
88	STDAT	Date of Cancellation	nvarchar	8	Allow NULL?
89	GBORT	IS-H: Patient Birthplace	nvarchar	25	Allow NULL?
90	HARNR	IS-H: Personnel Number of Family Physician	nvarchar	10	Allow NULL?
91	EARNR	IS-H: Personnel Number of Referring Physician	nvarchar	10	Allow NULL?
92	UARNR	IS-H: Personnel Number of Referring Physician	nvarchar	10	Allow NULL?
93	RACE	IS-H: Race	nvarchar	2	Allow NULL?
94	RESID	Indicator That Patient Is Non-Resident	char	1	Allow NULL?
95	PASSTY	Type of Identification Document	nvarchar	2	Allow NULL?
96	PASSNR	IS-H: Identification Document Number	nvarchar	15	Allow NULL?
97	ADRNR	IS-H: Address Number	nvarchar	10	Allow NULL?
98	ADROB	IS-H: Address Object	nvarchar	4	Allow NULL?
99	ADNAG	IS-H: Address Number	nvarchar	10	Allow NULL?
100	ADOAG	IS-H: Address Object	nvarchar	4	Allow NULL?
101	ADNN1	IS-H: Address Number	nvarchar	10	Allow NULL?
102	ADON1	IS-H: Address Object	nvarchar	4	Allow NULL?
103	ADNN2	IS-H: Address Number	nvarchar	10	Allow NULL?
104	ADON2	IS-H: Address Object	nvarchar	4	Allow NULL?
105	ANEX1	External Identification of Next of Kin	nvarchar	20	Allow NULL?
106	ANEX2	External Identification of Next of Kin	nvarchar	20	Allow NULL?
107	ADRN2	IS-H: Address Number	nvarchar	10	Allow NULL?
108	ADRO2	IS-H: Address Object	nvarchar	4	Allow NULL?
109	INACT	'Inactive' Indicator	char	1	Allow NULL?
110	USER1	IS-H: User-Defined Field 1	nvarchar	20	Allow NULL?
111	USER2	IS-H: User-Defined Field 2	nvarchar	20	Allow NULL?
112	USER3	IS-H: User-Defined Field 3	nvarchar	8	Allow NULL?
113	USER4	IS-H: User-Defined Field 4	nvarchar	8	Allow NULL?
114	USER5	IS-H: User-Defined Field 5	nvarchar	50	Allow NULL?
115	USER6	IS-H: User-Defined Field 6	char	1	Allow NULL?
116	EXTAUFG		char	1	Allow NULL?
117	EXTAUFGA		nvarchar	2	Allow NULL?
118	EMPSC	IS-H: Employed Since	nvarchar	8	Allow NULL?
119	UNKNOWN_GBDAT	Birthdate Is Unknown	char	1	Allow NULL?
120	MIG_DONE	Indicator Specifying Record Is Migrated to BP Table	char	1	Allow NULL?
121	INSID		nvarchar	10	Allow NULL?
122	ISTAT_BPL	ISTAT Code	nvarchar	6	Allow NULL?
123	TAXNUM	Tax Number of Person	nvarchar	20	Allow NULL?
124	TAXNUM_IND	Tax Number Indicator	char	1	Allow NULL?
125	STP	STP Code	nvarchar	16	Allow NULL?
126	STP_ENDDT	End of Validity of STP Code	nvarchar	8	Allow NULL?
127	CONS_PERSDATA	Consent for Processing of Personal Data	char	1	Allow NULL?
128	/ISHFR/BIRTHRK	IS-H FR: Birth Rank	char	1	Allow NULL?
129	DTH_LOC	Location of Death	nvarchar	2	Allow NULL?
130	OCCUP	National Occupation Category	nvarchar	5	Allow NULL?
131	NARNR_S	Postdischarge Physician for Inpatient Stays	nvarchar	10	Allow NULL?
132	NARNR_A	Postdischarge Physician for Outpatient Stays	nvarchar	10	Allow NULL?
133	VNAME_LONG	Patient First Name	nvarchar	70	Allow NULL?
134	NNAME_LONG	Patient Last Name	nvarchar	70	Allow NULL?
135	GBNAM_LONG	Birth Name	nvarchar	70	Allow NULL?
136	TITLE_ACA2	Second academic title (key)	nvarchar	4	Allow NULL?

Name	Primary	Unique	Type	Columns
NPAT~0	Yes	Yes	CLUSTERED	PATNR, MANDT
NPAT~1	No	No	NONCLUSTERED	GBDAT, MANDT
NPAT~10	No	No	NONCLUSTERED	TAXNUM, MANDT
NPAT~11	No	No	NONCLUSTERED	STP, MANDT
NPAT~12	No	No	NONCLUSTERED	ADRNR, MANDT
NPAT~2	No	No	NONCLUSTERED	KRZAN, MANDT
NPAT~3	No	No	NONCLUSTERED	GBNAS, MANDT
NPAT~4	No	No	NONCLUSTERED	EXTNR, MANDT
NPAT~5	No	No	NONCLUSTERED	RVNUM, MANDT
NPAT~6	No	No	NONCLUSTERED	NOTAN, MANDT
NPAT~7	No	No	NONCLUSTERED	STDAT, RFPAT, MANDT
NPAT~8	No	No	NONCLUSTERED	PASSNR, MANDT
NPAT~9	No	No	NONCLUSTERED	INSID, 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

136 COLUMNS | 13 INDEXES | ERP 6.0 | NPAT TABLE

TOP ERP 6.0 | NPAT COLUMNS

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

136 COLUMNS | 13 INDEXES | ERP 6.0 | NPAT TABLE

TOPERP 6.0 | NPAT COLUMNS

TOPERP 6.0 | NPAT INDEXES

TOP ERP 6.0 | NPAT COLUMNS

TOP ERP 6.0 | NPAT INDEXES