	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

50 columns | ERP 6.0 | EXTNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	NNL_ZH308_V9_R04	ZH308 V09 Record04 Soll Daten	19	EXTNR		nvarchar	6	0
2	NNL_ZH308_V9_R06	ZH308 V09 Record06 Soll Daten	18	EXTNR		nvarchar	6	0
3	NNL_ZH308_V9_R16	ZH308 V09 Record16 Soll Daten	18	EXTNR		nvarchar	6	0
4	TNNL_CBVCARETYPE	CBV Sorgetyp	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
5	TNNL_CBVCLINDAYS	CBV Pflegetage	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
6	TNNL_CBV_AGE	CBV Alter	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
7	TNNL_CBV_CONTACT	CBV Kontakt Typ	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
8	TNNL_CBV_GENDER	CBV Geschlecht	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
9	TNNL_CBV_MAINACT	CBV Hauptaktivität	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
10	TNNL_CBV_SPEM	CBV Spezialgebiet	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
11	TNNL_CBV_TYP_ACT	CBV Leistungs Typ Gruppe	3	EXTNR	IS-H: Alternative Identifikation einer Tarifposition	nvarchar	12	0
12	TNRT3	Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields	3	EXTNR	Number range number	nvarchar	2	0
13	TNRT6	Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields	3	EXTNR	Number range number	nvarchar	2	0
14	TNRT8	Test no.ranges:with subobject;dep.group;2 no.range fields	4	EXTNR	Number range number	nvarchar	2	0
15	TNRT8A	Test no.ranges:with subobject;dep.group;2 no.range fields	4	EXTNR	Number range number	nvarchar	2	0
16	VIXCESM180DEC	Modelo 180 - Witholding Tax Declarer Line 01	18	EXTNR	External ID Number of Tax Return	nvarchar	13	0
17	PIQDBAGM_EXT	Transfer Regulations: External Acad. Achievements	3	EXTNR	Sequence Number of External Academic Achievement	nvarchar	3	0
TOPBasic Data
18	NC301	IS-HCM: Order Table Data Transmission for EDI	30	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
19	NC301S	IS-HCM: EDI Status Management	46	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
20	NC301T	IS-H EDI Temporary Storage for Old EDI Msg. Status Records	46	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
TOPClinical System
21	N1PRPAT	IS-H*MED: PATREG: Patientenstammdatentabelle	51	EXTNR	IS-H: Harici hasta taniticisi	nvarchar	20	0
22	N1PRTMPPAT	IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle	52	EXTNR	IS-H: Harici hasta taniticisi	nvarchar	20	0
23	N1PRTMPPATLOC	IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal	52	EXTNR	IS-H: Harici hasta taniticisi	nvarchar	20	0
24	NDOCA	IS-H*MED: Document Management Data for Archived Documents	49	EXTNR	IS-H: External Medical Record/Document ID	nvarchar	15	0
25	NDOCSTORNO	IS-H*MED: Canceled Documents	50	EXTNR	IS-H: External Medical Record/Document ID	nvarchar	15	0
TOPDefault Risk and Limit System
26	KLZUEXTOBJ	Assignment of External Administration Key to Object Number	4	EXTNR	External Administration Number	nvarchar	40	0
TOPDistributor-Reseller-Management
27	/SAPHT/DRMCSADRV	DRM: Sales Area derivation	3	EXTNR	Additional data, e.g. ILN or D&B no.	nvarchar	70	0
TOPOverhead Cost Controlling
28	CSKR	Resource master record	11	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
TOPOverhead Cost Orders
29	COBRB	Distribution Rules Settlement Rule Order Settlement	56	EXTNR	Distribution Rule Number	nvarchar	3	0
TOPPatient Accounting
30	NEHC_PAT	IS-H: Health Insurance Card (Patient Data)	51	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
31	NTPK	IS-H: Header Data of Service Item	7	EXTNR	IS-H: Alternative Identification of Service Catalog Item	nvarchar	12	0
32	NTPV	IS-H: Assign Service to Base Planning Object	8	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
TOPPatient Management
33	NDOC	IS-H: Assignment of IS-H Objects to Documents in DMS	49	EXTNR	IS-H: External Medical Record/Document ID	nvarchar	15	0
34	NPAP	IS-H: Provisional Patient Master Data	15	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
35	NPAT	IS-H: Patient Master Data (General)	42	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
36	NTMN	IS-H: Patient-Specific Appointments (Header Table for NAPP)	6	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
37	NWAN	IS-H: Bad Debt Parties	27	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
TOPProduct Cost Planning
38	CKBS	Base Planning Object - Unit Costing	3	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
39	CKBT	Texts for CKBS	3	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
40	CKHS	Header: Unit Costing (Control + Totals)	61	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
41	CKIS	Items Unit Costing/Itemization Product Costing	27	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
42	CKPS	Unit Costing Items	19	EXTNR	Base Planning Object (External Number)	nvarchar	18	0
TOPPurchasing
43	EREV	Version in Purchasing	17	EXTNR	External Change Number of Version	nvarchar	20	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
44	ISH_HCF_HEADER	Header for Index Table	8	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
45	ISH_IDX_HEADER	Header for Index Table	9	EXTNR	IS-H: External Patient Identification	nvarchar	20	0
46	NLDBC_TRJ_LEIST	IS-H NL: Traject Leistungen	3	EXTNR	Verrichting binnen een verrichtingencatalogus	nvarchar	10	0
47	NLDBC_ZW_SPEC	IS-H NL: DBC leistungs gewicht kategorie pro fachrichtung	3	EXTNR	Verrichting binnen een verrichtingencatalogus	nvarchar	10	0
48	NTPKCH	IS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED)	37	EXTNR	IS-H CH: codice prestazione est. (MEDIDATA)	nvarchar	20	0
TOPTariffs, Duties and Permits
49	OIH30H	Tracking header	12	EXTNR	External tracking number	nvarchar	18	0
TOPWaste Management
50	EWA_WA_WEIGHOFFL	Offline Weighing	4	EXTNR	External Number for Offline Weighing	nvarchar	20	0

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

50 columns | ERP 6.0 | EXTNR