SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

145 columns | Print definition?ERP 6.0  | STUSR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Data
1TNOBJIS-H: Objects for Client Reset Program11STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPClinical System
2N1BEZYIS-H*MED: Cycles with NLEI reference29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
3N1CYDEFISHMED: Cycle Definition29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
4N1DCSCLASSIS-H*MED: Classifications for Services and Diagnoses20STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
5N1DCS_DAUERDIAIS-H*MEd: DCS: Quick Entry Long-Term Diagnoses17STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
6N1DCS_DAUERTHEIS-H*MED: DCS: Quick Entry Long-Term Therapies23STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
7N1EADDOCIS-H*MED: Medication, Event Administration Document18STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
8N1EDRUGIS-H*MED: Drug Event - Drug Assignment29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
9N1EPREPDOCIS-H*MED: Preparation Documentation of Event9STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
10N1IPBAIS-H*MED: Asnmt. of Indiv. Nurs. Plan to Basic HospCat.Entry14STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
11N1IPLEIS-H*MED:Assignmt of Nursing Anchor Service to the ntpk12STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
12N1IPSTIS-H*MED: Asgmt of Stnd. Nursing Plans to Ind. Nursing Plans9STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
13N1LSMAZIS-H*MED: Service/employee assign. (delete after 3.03!)10STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
14N1LSTEAMIS-H*MED: Tasks/Employees for a Service17STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
15N1MEALERTi.s.h.med: Drug Alerts29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
16N1MEALMOAi.s.h.med: Medication: Assign Drug Alert to Medication Order12STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
17N1MEDOBSOLETE: Patient-Related Medication Data for a Prescription19STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
18N1MEEVENTIS-H*MED: Medication, Medication Event44STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
19N1MEOACTi.s.h.med: Medication, Order Activities24STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
20N1MEORDERIS-H*MED: Medication, Medication Order76STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
21N1MEORDERTHCLAi.s.h.med: Medication, Order -> Indication14STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
22N1MERGOBSOLETE: Medication Event21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
23N1MEVOOBSOLETE: Prescription of a Medication29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
24N1ODRUGIS-H*MED: Medication, Drugs of Order40STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
25N1ORATEIS-H*MED: Medication, Dosage Quantities Infusions27STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
26N1PRANFIS-H*MED: PATREG: Anforderungen36STUSRIS-H: Iptal eden sorumlunun adinvarchar120
27N1PRBEWIS-H*MED: PATREG: Bewegungen28STUSRIS-H: Iptal eden sorumlunun adinvarchar120
28N1PRDIAIS-H*MED: PATREG: Diagnosen38STUSRIS-H: Iptal eden sorumlunun adinvarchar120
29N1PRDOCIS-H*MED: PATREG: Dokumente42STUSRIS-H: Iptal eden sorumlunun adinvarchar120
30N1PRFALIS-H*MED: PATREG: Fälle20STUSRIS-H: Iptal eden sorumlunun adinvarchar120
31N1PRLEMIS-H*MED: PATREG: Leistungen29STUSRIS-H: Iptal eden sorumlunun adinvarchar120
32N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle76STUSRIS-H: Iptal eden sorumlunun adinvarchar120
33N1PRPATZUOIS-H*MED: PATREG: Patientenregisterzuordnungstabelle9STUSRIS-H: Iptal eden sorumlunun adinvarchar120
34N1PRTMNIS-H*MED: PATREG: Termine25STUSRIS-H: Iptal eden sorumlunun adinvarchar120
35N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle77STUSRIS-H: Iptal eden sorumlunun adinvarchar120
36N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal77STUSRIS-H: Iptal eden sorumlunun adinvarchar120
37N1PRVKGIS-H*MED: PATREG: Vormerkungen21STUSRIS-H: Iptal eden sorumlunun adinvarchar120
38N1TMSTPDURi.s.h..med: Duration for Time Stamps19STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
39N1TPGCLAi.s.h. med: Medication: Template Group - Classif. Code Asgmt16STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
40N1TPGDIAGAi.s.h.med: Medication: Template Group - Diagnosis Assignment17STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
41N1TPGOUAi.s.h.med: Medication OU Template Group Assignment11STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
42N1TPGROUPMedication: Order Template Group21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
43N1TPGSTRUCAi.s.h.med: Medication Template Group - Problem Assignment16STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
44N1TPGUSERAi.s.h.med: Medication User Template Group Assignment10STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
45N1TPMEORDERIS-H*MED: Medication, Medication Order Template63STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
46N1TPODRUGIS-H*MED: Medication, Drugs of Templates43STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
47N1TPORATEIS-H*MED: Dosage Quantities of Template35STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
48N1TPTPGRAIS-H*MED: Template - Template Group Assignment14STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
49N2CA_CORD_CARDISHMED: Data for Cardiology Order Component23STUSRUser Who Deleted Recordnvarchar120
50N2CA_CORD_ECGISHMED: Data for ECG Order Component24STUSRUser Who Deleted Recordnvarchar120
51N2CA_CORD_HCATISHMED: Data for Cardiac Catheter Order Component34STUSRUser Who Deleted Recordnvarchar120
52N2CA_CORD_HCAT_IISHMED: Interventions for Cardiac Catheter Order Component15STUSRUser Who Deleted Recordnvarchar120
53N2CLIM_OBSVSVital Signs: Examination33STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
54N2CLIM_PLDVSVital Signs: Definite Planned Measurement (with Time)26STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
55N2CLIM_SDLVSVital Signs: Measurement Plan for Patient (Cycles)26STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
56N2CLIM_VALVSVital Signs: Measured Values39STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
57N2DOCFALIS-H*MED: Case Data for Archived Documents34STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
58N2MV_ADRARTAddress Type Control Table15STUSRUser Who Deleted Recordnvarchar120
59N2MV_EMTYPRecipient Type Control Table16STUSRUser Who Deleted Recordnvarchar120
60N2MV_SCRMODField Control Control Table44STUSRUser Who Deleted Recordnvarchar120
61N2MV_VSDATRecipient Data Table52STUSRUser Who Deleted Recordnvarchar120
62N2MV_VSVORPresetting Control Table25STUSRUser Who Deleted Recordnvarchar120
63N2MV_VSWEGDispatch Route Control Table16STUSRUser Who Deleted Recordnvarchar120
64N2OKIS-H*MED: Surgery Complications (AVB)16STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
65NDOCAIS-H*MED: Document Management Data for Archived Documents23STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
66NDOCSTORNOIS-H*MED: Canceled Documents24STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPMedical Patient Data Organization Patient Organizer
67N1STRUCMEDRECIS-H*MED: Health Problems (Struct. Med. Patient Record)20STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPPatient Accounting
68NCIRIS-H: Insurance Relationships of a Case50STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
69NFAGIS-H: Case accrual12STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
70NFAGACPIS-H: Daily delimitation: check multiple execution9STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
71NICPIS-H: Surgical Procedure Codes Performed17STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
72NICP2IS-H: INACTIVE since 4.71 - DO NOT USE !17STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
73NMATOIS-H: Material requisition by nurse station28STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
74NMATPIS-H: Material planned for case30STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
75NMATVIS-H: Material Entered for Case29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
76NPIRIS-H: Insurance Relationship Proposal Pool49STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPPatient Management
77N1ANFIS-H*MED: Request32STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
78N1APCNIS-H: Appointment Defaults34STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
79N1APCNDIS-H*MED: Appointment Template Dependencies12STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
80N1CORDERIS-H: Clinical Order42STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
81N1VKGIS-H: Item of Clinical Order (Preregistration)39STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
82NAPPIS-H: Provisional Appointments for Visit Scheduling27STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
83NATMIS-H/IS-H*MED: Time Slot Modification23STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
84NBEWIS-H: Movements for Case48STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
85NBKZIS-H: Movement assignments for Ins. Verifications/Certific.7STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
86NCTOContext-to-Object Assignment9STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
87NCTXIS-H: Context13STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
88NDIAIS-H: Diagnoses36STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
89NDIPIS-H: Diagnoses for Preregistered Patient13STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
90NDOCIS-H: Assignment of IS-H Objects to Documents in DMS23STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
91NFALIS-H: Cases34STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
92NFFZIS-H: Assignment of a case to another case12STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
93NFPZIS-H: Assignment of a case to a person13STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
94NGEBIS-H: Birth Data of Newborns21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
95NIPPIS-H: Provisional Insurance Relationship of Preregistration18STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
96NKSKIS-H: Insurance verification/certificate - Header data32STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
97NKSPIS-H: Insurance verification/certificate - item data15STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
98NLEIIS-H: Services Performed41STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
99NPAEIS-H: Patient Master Data (Institution-Related)10STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
100NPAPIS-H: Provisional Patient Master Data26STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
101NPATIS-H: Patient Master Data (General)87STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
102NPCPIS-H: Procedures for Preregistered Patient13STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
103NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)55STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
104NVVFIS-H: Case-Related Insurance Relationships20STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
105NVVPIS-H: Patient-related insurance relationship42STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
106NWANIS-H: Bad Debt Parties20STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
107NWLMIS-H: Absences From Waiting List13STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPPatient Transport Service
108N1FATIS-H*MED: Transport Orders24STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPPlanning
109N1APPLANIS-H*MED: Plan13STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
110N1PGPRINTSETTINGi.s.h.med: Planning Grid Print Settings21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
111N1WPLACE_PGIS-H*MED: Spezialization for Planning Grid Display Variant11STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
112N1WVIEW_PG_CLIS-H*MED: Planning Grid Settings of Planning Objects15STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
113N1WVIEW_PG_DTIS-H*MED: Planning Grid Tab Page for Date View Type19STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
114N1WVIEW_PG_DT_OUIS-H*MED: PG Org. Unit Setting for DT and PO View Type14STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
115N1WVIEW_PG_OUIS-H*MED: Planning Grid Tab Page for OU View Type21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
116N1WVIEW_PG_POIS-H*MED: Planning Grid Tab Page for Plan. Object View Type21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
117NAKR2IS-H AT: LKF - Scoring Leistungen (MELs)17STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
118NAPXIS-H: Appendix Main Data11STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
119NEO_NFALIS-H: External Orders - Order Data29STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
120NLBSNBurgerservice nummer22STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
121NNLEKIS-H NL: Data for treatment certificates19STUSRIS-H: Naam van gebruiker die het document storneertnvarchar120
122NSRVPProvisional Services in Service-Based Appointment Search20STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
123NWATINTENSIS-H AT: Intensivdokumentation - Patientenadministration22STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
124NWATPHYSIS-H AT: Intensivdokumentation - Physiologische Daten45STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
125NWATTISS28Intensivdoku. - Pflege- u. Therapiedoku. (TISS-28 / TISS-A )44STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
126NWATTRISSIS-H AT: Intensivdoku. - Erfass. traumatologischer Patienten28STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
127NWAT_EDI_KOMIS-H AT: EDI Kommentar (K12)31STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
128NWAT_GIN_ERSStatus der e-Überweisung12STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
129NWAT_SCO_KALLKF - amb. Scoring Leistungen (KALs)16STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
130NWAT_SCO_MELLKF - Scoring Leistungen (MELs)16STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
131NWAT_SCO_WIKRAFIS-H AT: Scoring - manuelle Eingabe der V01-Daten18STUSRIS-H: Name des stornierenden Sachbearbeitersnvarchar120
132NWCH150IS-H CH: Zeitmarken zur Leistung (ALT => wird gelöscht !)14STUSRIS-H: nome dell'autore della cancellazionenvarchar120
133NWCH70IS-H CH: Insurance Verification35STUSRIS-H: Name of User who Canceled Data Recordnvarchar120
134NWCHLS_NFALIS-H CH: ALIS-Fehlerhandlung - Falldaten (für Fall-API)16STUSRIS-H: nome dell'autore della cancellazionenvarchar120
135NWCHLS_RETURNIS-H CH: ALIS-Fehlerhandlung - Fehlermeldungen von APIs22STUSRIS-H: nome dell'autore della cancellazionenvarchar120
136NWCHLS_RNDIAFLAGIS-H CH: ALIS-Fehlerhandlung - Diagnose zum Fall (RNDIAFLAG)14STUSRIS-H: nome dell'autore della cancellazionenvarchar120
137NWCHLS_RNLRGIS-H CH: ALIS-Fehlerhandlung - Arztzuordnungen (RNLRG)29STUSRIS-H: nome dell'autore della cancellazionenvarchar120
138NWCHLS_RNLRZIS-H CH: ALIS-Fehlerhandlung - Leistungszuordnungen (RNLRZ)18STUSRIS-H: nome dell'autore della cancellazionenvarchar120
139NWCHLS_RNLRZEIS-H CH: ALIS-Fehlerhandlung - externes System (RNLRZE_CH)12STUSRIS-H: nome dell'autore della cancellazionenvarchar120
140NWCHLS_RNLRZMIS-H CH: ALIS-Fehlerhandlung - Zeitmarken (RNLRZM)28STUSRIS-H: nome dell'autore della cancellazionenvarchar120
141NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)215STUSRIS-H: nome dell'autore della cancellazionenvarchar120
142NWCHPAKLZIS-H CH: Patientenabrechnung - LstVerteilung Nachträge16STUSRIS-H: nome dell'autore della cancellazionenvarchar120
143NWCHZMIS-H CH: Zeitmarken zur Bewegung/Leistung16STUSRIS-H: nome dell'autore della cancellazionenvarchar120
144NWCHZMEIS-H CH: Zeit- /Maßangaben zur Bewegung/Leistung17STUSRIS-H: nome dell'autore della cancellazionenvarchar120
TOPVital Signs
145N1VPVital Sign Movement Data21STUSRIS-H: Name of User who Canceled Data Recordnvarchar120