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	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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
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 Accounting
1	ERP EHP7	6.0	NEHC_INS	110	1	IS-H: Health Insurance Card (Insurance Data)	Patient Accounting

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	LNCRD	Sequence Number of Health Insurance Card	nvarchar	10	Allow NULL?
3	LNCRD_INS	Sequence Number of Details for Health Insurance Card	nvarchar	5	Allow NULL?
4	INSURANCE_NAME	Name 1 of organization	nvarchar	40	Allow NULL?
5	KOSTR_INSTN	IS-H: Institute Indicator	nvarchar	10	Allow NULL?
6	KOSTR_LAND	IS-H: Country of Business Partner	nvarchar	3	Allow NULL?
7	STCODE	Country ISO code	nvarchar	2	Allow NULL?
8	INSTNR	IS-H: EHIC - Institute Code of Responsible Insurance Carrier	nvarchar	10	Allow NULL?
9	ACNYM	IS-H: EHIC - Acronym of Responsible Insurance Carrier	nvarchar	21	Allow NULL?
10	CARDNR	EHIC - Card Number (Alphanumeric)	nvarchar	20	Allow NULL?
11	PERSID	IS-H: Personal ID Number	nvarchar	20	Allow NULL?
12	CERTIF_BEGDT	IS-H: EHIC - Valid From	nvarchar	8	Allow NULL?
13	CERTIF_ENDDT	IS-H: EHIC - Validity End	nvarchar	8	Allow NULL?
14	CERTIF_ISSUEDT	IS-H: EHIC - Issue Date of Replacement Certificate	nvarchar	8	Allow NULL?
15	CERTIF_ISSUEDBY	IS-H: Card/Certificate - Issuing Organization	nvarchar	4	Allow NULL?
16	ERDAT	IS-H: Date when Record Created	nvarchar	8	Allow NULL?
17	ERTIM	IS-H: Time Record Created	nvarchar	6	Allow NULL?
18	ERUSR	IS-H: Name of Employee who Created Record	nvarchar	12	Allow NULL?
19	UPDAT	IS-H: Date of Last Change	nvarchar	8	Allow NULL?
20	UPTIM	IS-H: Time of Last Change	nvarchar	6	Allow NULL?
21	UPUSR	IS-H: Name of Person who Last Changed Data	nvarchar	12	Allow NULL?
22	STORN	IS-H: Cancellation Indicator	char	1	Allow NULL?
23	MID_NNAME	IS-H: Last Name of Main Person Insured	nvarchar	35	Allow NULL?
24	MID_VNAME	IS-H: First Name of Main Person Insured	nvarchar	35	Allow NULL?
25	INS_TYP	IS-H: Insurance Type	char	1	Allow NULL?
26	CTBCDE	IS-H: Exemption Reason	nvarchar	50	Allow NULL?
27	CTBCDEL	Indicator that Long Text Exists	char	1	Allow NULL?
28	PHYSGK	IS-H: Attending Physician	nvarchar	60	Allow NULL?
29	INS_BEGDT	IS-H: Start Date of Insurance	nvarchar	8	Allow NULL?
30	INS_ENDDT	IS-H: End Date of Insurance	nvarchar	8	Allow NULL?
31	COV_TYP	IS-H: Coverage Type	nvarchar	2	Allow NULL?
32	COV_BEGDT	IS-H: Start Date of Coverage	nvarchar	8	Allow NULL?
33	COV_ENDDT	IS-H: End Date of Coverage	nvarchar	8	Allow NULL?
34	ABR_KOSTR_INSTN	IS-H: Institute Indicator	nvarchar	10	Allow NULL?
35	EGK_CDM_AVSD		nvarchar	20	Allow NULL?
36	EGK_KOSTR_NAME		nvarchar	45	Allow NULL?
37	EGK_ABR_KOSTR_NA		nvarchar	45	Allow NULL?
38	EGK_RECHTSKREIS		char	1	Allow NULL?
39	EGK_VERS_ART		char	1	Allow NULL?
40	EGK_VERS_STAT_RS		char	1	Allow NULL?
41	EGK_KOSTENERST_A		char	1	Allow NULL?
42	EGK_KOSTENERST_S		char	1	Allow NULL?
43	EGK_WOP		nvarchar	2	Allow NULL?
44	EGK_PKV_VERB_TAR		nvarchar	2	Allow NULL?
45	EGK_PKV_BEIH_BER		nvarchar	2	Allow NULL?
46	EGK_STAT_WLU		nvarchar	2	Allow NULL?
47	EGK_WLU_PROZ		nvarchar	3	Allow NULL?
48	EGK_HS_WLU		nvarchar	6	Allow NULL?
49	EGK_STAT_WLA		nvarchar	2	Allow NULL?
50	EGK_STAT_WLA_PRO		nvarchar	3	Allow NULL?
51	EGK_PKV_CLINICCA		char	1	Allow NULL?
52	EGK_CDM_GVSD		nvarchar	20	Allow NULL?
53	EGK_ZUZA_STATUS		char	1	Allow NULL?
54	EGK_ZUZA_STATU_B		nvarchar	8	Allow NULL?
55	EGK_BES_PERS_GRU		nvarchar	2	Allow NULL?
56	EGK_DMP_KZ		nvarchar	2	Allow NULL?
57	EGK_EINL_DAT_MLG		nvarchar	8	Allow NULL?
58	EGK_VKZML		nvarchar	40	Allow NULL?
59	EGK_KOSTENER		char	1	Allow NULL?
60	EGK_KOSTENER_AE		char	1	Allow NULL?
61	EGK_KOSTENER_ZV		char	1	Allow NULL?
62	EGK_KOSTENER_VL		char	1	Allow NULL?
63	EGK_RLA		char	1	Allow NULL?
64	EGK_RLA_B		nvarchar	8	Allow NULL?
65	EGK_RLA_E		nvarchar	8	Allow NULL?
66	EGK_SELV_AE		char	1	Allow NULL?
67	EGK_SELV_ZAE		char	1	Allow NULL?
68	EGK_SELV		nvarchar	4	Allow NULL?
69	/ISHFR/A_HISCTYP	IS-H FR: Health Insurer Type	nvarchar	2	Allow NULL?
70	/ISHFR/A_HIFUND	IS-H FR: Health Insurer	nvarchar	3	Allow NULL?
71	/ISHFR/A_PROORG	IS-H FR: Administrative Unit	nvarchar	4	Allow NULL?
72	KOSTR	IS-H: Insurance Provider	nvarchar	10	Allow NULL?
73	BAG		nvarchar	5	Allow NULL?
74	EANR	Insurer's IAN	nvarchar	13	Allow NULL?
75	INSFORM	Insurance Form	nvarchar	2	Allow NULL?
76	INSFORM_TEXT	Description of Insurance Form	nvarchar	40	Allow NULL?
77	CANTON	Canton	nvarchar	2	Allow NULL?
78	ACCIDENT	Accident Coverage SIA	nvarchar	2	Allow NULL?
79	SERVDEF	Service Deferment	char	1	Allow NULL?
80	VVG_EXIST	Supplementary Insurance Available Yes/No	char	1	Allow NULL?
81	BASEINS	Basic Insurance	nvarchar	2	Allow NULL?
82	DESCRIPTION		nvarchar	40	Allow NULL?
83	PHONE		nvarchar	30	Allow NULL?
84	EMAIL		nvarchar	100	Allow NULL?
85	NAME1		nvarchar	40	Allow NULL?
86	NAME2		nvarchar	40	Allow NULL?
87	INS_POST_CODE	City postal code	nvarchar	10	Allow NULL?
88	INS_CITY	City	nvarchar	40	Allow NULL?
89	INS_COUNTRY	Country Key	nvarchar	3	Allow NULL?
90	INS_STREET	Street	nvarchar	60	Allow NULL?
91	INS_HOUSE_NUM	House Number	nvarchar	10	Allow NULL?
92	INS_STREET_SUPPL	Street 2	nvarchar	40	Allow NULL?
93	INS_LOCATION	Location	nvarchar	40	Allow NULL?
94	INS_PO_BOX	PO Box	nvarchar	10	Allow NULL?
95	INS_PO_BOX_TEXT	PO Box Text	nvarchar	15	Allow NULL?
96	INS_POST_CODE3	Foreign Postal Code	nvarchar	15	Allow NULL?
97	MDELAY		char	1	Allow NULL?
98	MEDHORS	Coverage for Unlisted Drug	nvarchar	2	Allow NULL?
99	UMEDHORS	Accident Coverage for Unlisted Drugs	nvarchar	2	Allow NULL?
100	MEDKOMP	Coverage for Drugs in Complementary Medicine	nvarchar	2	Allow NULL?
101	UMEDKOMP	Accident Coverage for Drugs in Complementary Medicine	nvarchar	2	Allow NULL?
102	SPITABT	Hospital Department	nvarchar	2	Allow NULL?
103	SPITMOD	Hospital Model	nvarchar	2	Allow NULL?
104	USPITVERS	Accident Coverage for Hospital Insurance	nvarchar	2	Allow NULL?
105	COVINT_DRUGS		char	1	Allow NULL?
106	COVINT_HOSP		char	1	Allow NULL?
107	DATEOFIMPORT		nvarchar	8	Allow NULL?
108	TIMEOFIMPORT		nvarchar	6	Allow NULL?
109	REMARK_KVG		char	1	Allow NULL?
110	REMARK_HOSP		char	1	Allow NULL?

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

110 COLUMNS | 1 INDEXES | ERP 6.0 | NEHC_INS TABLE

TOP ERP 6.0 | NEHC_INS COLUMNS

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

110 COLUMNS | 1 INDEXES | ERP 6.0 | NEHC_INS TABLE

TOPERP 6.0 | NEHC_INS COLUMNS

TOPERP 6.0 | NEHC_INS INDEXES

TOP ERP 6.0 | NEHC_INS COLUMNS

TOP ERP 6.0 | NEHC_INS INDEXES