	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

144 columns | ERP 6.0 | PATNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ISHCDP/NBDN001	Erweiterung Todesdaten für Todesanzeige	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
2	MLAUFKEPHH	History table for summarized MLAUFKEPH data	12	PATNR	Partner number for costing	nvarchar	6	0
3	N1MCI_MSG	Message Log	6	PATNR	IS-H: Patient Number	nvarchar	10	0
4	N1MESORTORDHDR	Medication: Header for Man. Sorting	3	PATNR	IS-H: Patient Number	nvarchar	10	0
5	N2CHART_USR_LAYO	SL Chart: User-Specific Chart Layout	5	PATNR	IS-H: Patient Number	nvarchar	10	0
6	NHCF_QUEUE_MAP	IS-H: Map SOA Event Sequence ID to IS-H Business Object	3	PATNR	IS-H: Patient Number	nvarchar	10	0
7	NNLCAREREQ_IDX	Sorgefrage Index	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
8	NNL_FYSIO	Tabelle Physiotherapie	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
9	NNL_MED_MESS	LBZ medizinische Meldungen	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
10	NNL_ZH308_V9_R02	ZH308 V09 Record02 Soll Daten	10	PATNR		nvarchar	11	0
11	NNL_ZH308_V9_R04	ZH308 V09 Record04 Soll Daten	7	PATNR	IS-H: Patientennummer	nvarchar	10	0
12	NNL_ZH308_V9_R06	ZH308 V09 Record06 Soll Daten	7	PATNR	IS-H: Patientennummer	nvarchar	10	0
13	NNL_ZH308_V9_R16	ZH308 V09 Record16 Soll Daten	7	PATNR	IS-H: Patientennummer	nvarchar	10	0
TOPActual CostingMaterial Ledger
14	CKMLKEPH	Material Ledger: Cost Component Split (Elements)	12	PATNR	Partner number for costing	nvarchar	6	0
15	CKMLPRKEPH	Material Ledger: Cost Component Split (Elements) for Prices	9	PATNR	Partner number for costing	nvarchar	6	0
16	MLAUFKEPH	ML: Cost Component Split (Components) for Order History	11	PATNR	Partner number for costing	nvarchar	6	0
17	MLBEKEPH	ML: Cost Comp. Split (Elements) for Purchase Order History	10	PATNR	Partner number for costing	nvarchar	6	0
18	MLKEPH	ML Document: Cost Component Split (Elements) for Values	10	PATNR	Partner number for costing	nvarchar	6	0
19	MLPRKEPH	ML Document: Cost Component Split (Components)for Prices	10	PATNR	Partner number for costing	nvarchar	6	0
TOPBasic Data
20	NC301	IS-HCM: Order Table Data Transmission for EDI	29	PATNR	IS-H: Patient Number	nvarchar	10	0
21	NC301S	IS-HCM: EDI Status Management	45	PATNR	IS-H: Patient Number	nvarchar	10	0
22	NC301T	IS-H EDI Temporary Storage for Old EDI Msg. Status Records	45	PATNR	IS-H: Patient Number	nvarchar	10	0
23	NFOR	IS-H: Form Log	2	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPBusiness Partners
24	NPNT	Patient Master Data	51	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPClinical System
25	N1DCS_DAUERDIA	IS-H*MEd: DCS: Quick Entry Long-Term Diagnoses	3	PATNR	IS-H: Patient Number	nvarchar	10	0
26	N1DCS_DAUERTHE	IS-H*MED: DCS: Quick Entry Long-Term Therapies	3	PATNR	IS-H: Patient Number	nvarchar	10	0
27	N1MEORDER	IS-H*MED: Medication, Medication Order	4	PATNR	IS-H: Patient Number	nvarchar	10	0
28	N1MEVO	OBSOLETE: Prescription of a Medication	5	PATNR	IS-H: Patient Number	nvarchar	10	0
29	N1PATFAL	IS-H*MED: Relationship between patient and case	4	PATNR	IS-H: Patient Number	nvarchar	10	0
30	N1PATM	IS-H*MED: Medical Patient Master Record	2	PATNR	IS-H: Patient Number	nvarchar	10	0
31	N1POPAKTE	IS-H*Med: Patient Organizer - Redundant Structure	4	PATNR	Patient Number	nvarchar	10	0
32	N1PRANF	IS-H*MED: PATREG: Anforderungen	40	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
33	N1PRDOC	IS-H*MED: PATREG: Dokumente	8	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
34	N1PREFETCHSPOOL	IS-H*MED: RAD Prefetching Tasks	4	PATNR	IS-H: Patient Number	nvarchar	10	0
35	N1PRFAL	IS-H*MED: PATREG: Fälle	5	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
36	N1PRLEM	IS-H*MED: PATREG: Leistungen	5	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
37	N1PRPATLOG	IS-H*MED: PATREG: Fehlerprotokoll für Patientenstammdaten	3	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
38	N1PRPATVERGL	IS-H*MED: PATREG: bestimmt ob NPAT Satz an PATREG übertrag	3	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
39	N1PRPATZUO	IS-H*MED: PATREG: Patientenregisterzuordnungstabelle	4	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
40	N1PRRSF	IS-H*MED: PATREG: Risikofaktoren	3	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
41	N1PRTMN	IS-H*MED: PATREG: Termine	4	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
42	N1PRTMPCPYPAT	IS-H*MED: PATREG: NPAT Kopie des Teilnehmers	2	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
43	N1PRTMPPAT	IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle	3	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
44	N1PRTMPPAT2PR	IS-H*MED: PATREG: Zuordnung NPAT -> N1PRPAT Patienten	3	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
45	N1PRTMPPATLOC	IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal	3	PATNR	PATREG: Hasta taniticisi	nvarchar	10	0
46	N1PRVKG	IS-H*MED: PATREG: Vormerkungen	4	PATNR	IS-H: Hasta numarasi	nvarchar	10	0
47	N1RISMIS	IS-H*MED: Data transfer error (case - patient)	4	PATNR	IS-H: Patient Number	nvarchar	10	0
48	N1SIOBUSA	i.s.h.med: Patient Record, Indicator-Object Assignment	13	PATNR	IS-H: Patient Number	nvarchar	10	0
49	N1SRV	Services: Service Data	6	PATNR	IS-H: Patient Number	nvarchar	10	0
50	N1THERS	IS-H*MED: Therapeutic Scheme	4	PATNR	IS-H: Patient Number	nvarchar	10	0
51	N1THS	IS-H*MED: Medication - Order Profile	5	PATNR	IS-H: Patient Number	nvarchar	10	0
52	N2AD_ALLERGY	Allergy Documentation - Allergies	2	PATNR	IS-H: Patient Number	nvarchar	10	0
53	N2AD_PAT	Allergy Documentation - Overall Allergy Status (OAS)	2	PATNR	IS-H: Patient Number	nvarchar	10	0
54	N2AD_REACT	Allergy Documentation - Reactions	2	PATNR	IS-H: Patient Number	nvarchar	10	0
55	N2BATMP	IS-H*MED: Temporary treatment order	2	PATNR	IS-H: Patient Number	nvarchar	10	0
56	N2CCF_MSGS	CCF: Message Table	15	PATNR	IS-H: Patient Number	nvarchar	10	0
57	N2CLIM_OBSVS	Vital Signs: Examination	13	PATNR	IS-H: Patient Number	nvarchar	10	0
58	N2CLIM_PATNR	Dummy Table for Lock Object	3	PATNR	IS-H: Patient Number	nvarchar	10	0
59	N2CLIM_PLDVS	Vital Signs: Definite Planned Measurement (with Time)	6	PATNR	IS-H: Patient Number	nvarchar	10	0
60	N2CLIM_SDLVS	Vital Signs: Measurement Plan for Patient (Cycles)	6	PATNR	IS-H: Patient Number	nvarchar	10	0
61	N2DGAILEM	ISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI	5	PATNR	IS-H: Patientennummer	nvarchar	10	0
62	N2DOCFAL	IS-H*MED: Case Data for Archived Documents	5	PATNR	IS-H: Patient Number	nvarchar	10	0
63	N2DOCREFPAT	IS-H*MED: Empty Table for Lock Object Patient Ref. Level	5	PATNR	IS-H: Patient Number	nvarchar	10	0
64	N2DSDEVICE_ARCH	ISHMED: Archive Transfer Data from Interfaces	5	PATNR	IS-H: Patient Number	nvarchar	10	0
65	N2DSDEVICE_DATA	ISHMED: Transfer Data from Interface	5	PATNR	IS-H: Patient Number	nvarchar	10	0
66	N2DWORKLIST	IS-H*MED RAD: Work list (RIS - PACS work list)	3	PATNR	IS-H: Patient Number	nvarchar	10	0
67	N2DWSWL_TASKD	Provisional Task	4	PATNR	IS-H: Patient Number	nvarchar	10	0
68	N2DWSWL_WORKD	Provisional Situation	4	PATNR	IS-H: Patient Number	nvarchar	10	0
69	N2GL_TM_PROF	IS-H*MED: Occupational Groups for Subsequent Activity	2	PATNR	IS-H: Patient Number	nvarchar	10	0
70	N2GL_TM_SCHEDULE	pathways Patient Pathway	4	PATNR	IS-H: Patient Number	nvarchar	10	0
71	N2GL_TR_DIA	Treatment Pathway: Proposal for Patient Pathway	3	PATNR	IS-H: Patient Number	nvarchar	10	0
72	N2PHYO_ORDER	Physician Order	4	PATNR	IS-H: Patient Number	nvarchar	10	0
73	NDOCA	IS-H*MED: Document Management Data for Archived Documents	9	PATNR	IS-H: Patient Number	nvarchar	10	0
74	NDOCSTORNO	IS-H*MED: Canceled Documents	10	PATNR	IS-H: Patient Number	nvarchar	10	0
75	NLEM	IS-H*MED: Medical Service	4	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPCommunication
76	NHCF_EVENT	IS-H: HCF: Triggered Unprocessed Events	8	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPDocuments
77	N1IM_STUDY	Meta Data of Image Study	4	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPMedical Patient Data Organization Patient Organizer
78	N1STRUCMEDREC	IS-H*MED: Health Problems (Struct. Med. Patient Record)	3	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPNursing
79	N1NRSPH	Nursing Plan: Header Data	6	PATNR	IS-H: Patient Number	nvarchar	10	0
80	N1NRSPKMS	Nursing Plan: NCPS Classifications	4	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPPatient Accounting
81	NCIR	IS-H: Insurance Relationships of a Case	100	PATNR	IS-H: Patient Number	nvarchar	10	0
82	NEHC	Health Insurance Card EHC	6	PATNR	IS-H: Patient Number	nvarchar	10	0
83	NPATVVDEBI	IS-H: Table for RNUVVDEBI	3	PATNR	IS-H: Patient Number	nvarchar	10	0
84	NPIR	IS-H: Insurance Relationship Proposal Pool	2	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPPatient Management
85	N1ANF	IS-H*MED: Request	36	PATNR	IS-H: Patient Number	nvarchar	10	0
86	N1CORDER	IS-H: Clinical Order	5	PATNR	IS-H: Patient Number	nvarchar	10	0
87	N1VKG	IS-H: Item of Clinical Order (Preregistration)	9	PATNR	IS-H: Patient Number	nvarchar	10	0
88	NDAT_CHANGE	IS-H: Log Data for Unprotecting Fields	2	PATNR	IS-H: Patient Number	nvarchar	10	0
89	NDOC	IS-H: Assignment of IS-H Objects to Documents in DMS	9	PATNR	IS-H: Patient Number	nvarchar	10	0
90	NFAL	IS-H: Cases	5	PATNR	IS-H: Patient Number	nvarchar	10	0
91	NFALA	IS-H: Archived Cases: Obsolete as of 4.72 (Info via SARI)	5	PATNR	IS-H: Patient Number	nvarchar	10	0
92	NKAV	ISH: Intermediate File Creation/Borrowing/Transfer of Recrds	3	PATNR	IS-H: Patient Number	nvarchar	10	0
93	NPAE	IS-H: Patient Master Data (Institution-Related)	3	PATNR	IS-H: Patient Number	nvarchar	10	0
94	NPAT	IS-H: Patient Master Data (General)	2	PATNR	IS-H: Patient Number	nvarchar	10	0
95	NPGZ	IS-H: Assignment of Patient to Business Partner	2	PATNR	IS-H: Patient Number	nvarchar	10	0
96	NPIX	IS-H: Patient name index	3	PATNR	IS-H: Patient Number	nvarchar	10	0
97	NRSF	IS-H: Patient Risk Factors	2	PATNR	IS-H: Patient Number	nvarchar	10	0
98	NTMN	IS-H: Patient-Specific Appointments (Header Table for NAPP)	4	PATNR	IS-H: Patient Number	nvarchar	10	0
99	NTRC	IS-H: Trace Log Messages	16	PATNR	IS-H: Patient Number	nvarchar	10	0
100	NVVP	IS-H: Patient-related insurance relationship	2	PATNR	IS-H: Patient Number	nvarchar	10	0
101	NWAN	IS-H: Bad Debt Parties	26	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPPatient Transport Service
102	N1FAT	IS-H*MED: Transport Orders	4	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPPersonnel Administration
103	T7CO01	Additional data of the company	17	PATNR	Employer registration number	nvarchar	15	0
TOPProduct Cost Planning
104	CKIS	Items Unit Costing/Itemization Product Costing	100	PATNR	Partner number for costing	nvarchar	6	0
105	KEKO	Product Costing - Header Data	107	PATNR	Partner number for costing	nvarchar	6	0
106	KEPH	Product Costing: Cost Components for Cost of Goods Mfd	9	PATNR	Partner number for costing	nvarchar	6	0
TOPProfit Center Accounting
107	PATN	Partner number/organizational unit	2	PATNR	Partner number for costing	nvarchar	6	0
TOPPublic Sector
108	T7MXPBS1P	ISSSTE branch code and paying agent number	6	PATNR	ISSSTE paying agent number	nvarchar	6	0
TOPSAP Ambulatory Care Management
109	NREDOMA	IS-H: Table Renewable Documents - Header Data	2	PATNR	IS-H: Patient Number	nvarchar	10	0
110	NREDOMA_DIAG	IS-H: Renewable Documents - Diagnoses	8	PATNR	IS-H: Patient Number	nvarchar	10	0
111	NWOINC	IS-H: Work Incapacity Certificates	2	PATNR	IS-H: Patient Number	nvarchar	10	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
112	ISH_HCF_HEADER	Header for Index Table	7	PATNR	IS-H: Patient Number	nvarchar	10	0
113	ISH_IDX_HEADER	Header for Index Table	8	PATNR	IS-H: Patient Number	nvarchar	10	0
114	N2DWSWL_TASK	Task	4	PATNR	IS-H: Patient Number	nvarchar	10	0
115	N2DWSWL_TASKPROF	Occupational Groups of Tasks in Processing	3	PATNR	IS-H: Patient Number	nvarchar	10	0
116	N2DWSWL_TPACK	Profile	4	PATNR	IS-H: Patient Number	nvarchar	10	0
117	N2DWSWL_WORK	Situation	4	PATNR	IS-H: Patient Number	nvarchar	10	0
118	NLBSN	Burgerservice nummer	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
119	NLDBC_005	NL-DBC: DBC Tabelle	4	PATNR	IS-H: Patiëntnummer	nvarchar	10	0
120	NLDBC_006_TRJ	IS-H: NL-DBC: Sorgestrecke	5	PATNR	IS-H: Patiëntnummer	nvarchar	10	0
121	NLGGZ_CARE_PRO	Geisteskrankheit DBC Sorgestrecke	5	PATNR	IS-H: Patientennummer	nvarchar	10	0
122	NLGGZ_CODE	Geisteskrankheit DBC kode	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
123	NLGGZ_CODE_DIAGN	Geisteskranheit GGZ zusatz diagnose	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
124	NLGGZ_CODE_LOG	Geisteskrankheit DBC protokoltabelle	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
125	NLGGZ_DIAG_LOG	Geisteskrankheit DBC zusatz diagnosen protkoltabelle	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
126	NLGGZ_DIS	Geisteskrankheit DIS protokolle	7	PATNR	IS-H: Patientennummer	nvarchar	10	0
127	NLGGZ_DIS_LOG	DIS GGZ protokoltabelle	6	PATNR	IS-H: Patientennummer	nvarchar	10	0
128	NLGGZ_PAT_GRP	Geisteskrankheit patient gruppe aktuell	5	PATNR	IS-H: Patientennummer	nvarchar	10	0
129	NLGGZ_SERVICE_CP	Geisteskrankheit leistungen Leistungsgruppe kopie	3	PATNR	IS-H: Patientennummer	nvarchar	10	0
130	NLVERK	Rechnungregister-kopf	7	PATNR	IS-H: Patiëntnummer	nvarchar	10	0
131	NNAU	IS-H NL: Confirmation of coverage info from ins. provider	7	PATNR	IS-H: Patient Number	nvarchar	10	0
132	NNLEK	IS-H NL: Data for treatment certificates	3	PATNR	IS-H: Patiëntnummer	nvarchar	10	0
133	NNLZP	IS-H NL: LAZR Bewegingsgegevens LAZR-interface	16	PATNR	IS-H NL: LAZR-patiëntnummer	nvarchar	15	0
134	NPSPAT	IS-H: Pseudonymized Patient Master Data (General)	2	PATNR	IS-H: Patient Number	nvarchar	10	0
135	NPSPIX	IS-H: Index of Pseudonymized Patient Names	3	PATNR	IS-H: Patient Number	nvarchar	10	0
136	NWAT_GIN_STATIR	IS-H AT: Versicherungsstatus des Patienten	2	PATNR	IS-H: Patientennummer	nvarchar	10	0
137	NWCHPATREC	IS-H CH: PATREC - erstellte Statistiksätze	9	PATNR	IS-H: numero paziente	nvarchar	10	0
138	NWCHPATREC_ID	IS-H CH: PATREC - künstl. Patienten-, Fall- und Geburtskeys	3	PATNR	IS-H: numero paziente	nvarchar	10	0
139	NWCHPSY	IS-H: Tab. für BFS-Statistik um Psychodaten bereitzustelle	4	PATNR	IS-H: numero paziente	nvarchar	10	0
140	NWCH_BOA_ARCH	Protokoll-Archiv für die Massendeckungsabfrage	12	PATNR	IS-H: Patientennummer	nvarchar	10	0
141	NWCH_BOA_PROT	Protokoll für die Massendeckungsabfrage	12	PATNR	IS-H: Patientennummer	nvarchar	10	0
142	TNLGGZ_PAT_GRP	Geisteskrankheit patient gruppe	4	PATNR	IS-H: Patientennummer	nvarchar	10	0
TOPVital Signs
143	N1VP	Vital Sign Movement Data	5	PATNR	IS-H: Patient Number	nvarchar	10	0
144	N1VP_PAT	Dummy Table for Vital Signs - Patient Lock	2	PATNR	IS-H: Patient Number	nvarchar	10	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

144 columns | ERP 6.0 | PATNR