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

181 columns | Print definition?ERP 6.0  | FALNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ISHCDP/NBDN002Erweiterung Geburtsdaten für Geburtsanzeige3FALNRIS-H: Fallnummernvarchar100
2N1MCI_MSGMessage Log7FALNRIS-H: Case Numbernvarchar100
3N1ME_THREC_LBMedication: Link Module Data for Therapy Recommendation6FALNRIS-H: Case Numbernvarchar100
4NBMI_SRV_UPLOADKeep the upload status7FALNRIS-H: Case Numbernvarchar100
5NBRKPBilling by Time Intervals3FALNRIS-H: Case Numbernvarchar100
6NNLREFER_REFBeziehung Verweisungsdatei, Fall und Sorgestrecke3FALNRIS-H: Fallnummernvarchar100
7NNLREFER_REF_ACTKopplung Verweisungsnummer und Leistung3FALNRIS-H: Fallnummernvarchar100
8NNL_FYSIOTabelle Physiotherapie4FALNRIS-H: Fallnummernvarchar100
9NNL_MED_MESSLBZ medizinische Meldungen4FALNRIS-H: Fallnummernvarchar100
10NSTREMReasons and Comments for Status of a Case3FALNRIS-H: Case Numbernvarchar100
TOPBasic Data
11NC301IS-HCM: Order Table Data Transmission for EDI4FALNRIS-H: Case Numbernvarchar100
12NC301CEXIS-H: EDI - Cases Excluded From Data Exchange Process4FALNRIS-H: Case Numbernvarchar100
13NC301RIS-H: EDI Other Inbound Data for Misc. Evaluation/Display4FALNRIS-H: Case Numbernvarchar100
14NC301SIS-HCM: EDI Status Management4FALNRIS-H: Case Numbernvarchar100
15NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records4FALNRIS-H: Case Numbernvarchar100
16NCCHRIS-H SG: Change Reasons for Modifications to Case Data4FALNRIS-H: Case Numbernvarchar100
17NCDFIS-H: Logging Data Exchange with DRG Coding System3FALNRIS-H: Case Numbernvarchar100
18NFORIS-H: Form Log3FALNRIS-H: Case Numbernvarchar100
TOPClinical System
19N1BEZYIS-H*MED: Cycles with NLEI reference3FALNRIS-H: Case Numbernvarchar100
20N1DCSCLASSIS-H*MED: Classifications for Services and Diagnoses4FALNRIS-H: Case Numbernvarchar100
21N1MEEVENTIS-H*MED: Medication, Medication Event5FALNRIS-H: Case Numbernvarchar100
22N1MEORDERIS-H*MED: Medication, Medication Order5FALNRIS-H: Case Numbernvarchar100
23N1MEVOOBSOLETE: Prescription of a Medication6FALNRIS-H: Case Numbernvarchar100
24N1PATFALIS-H*MED: Relationship between patient and case3FALNRIS-H: Case Numbernvarchar100
25N1PDDGEBPERINAT: Table of births (assigned case to birth number)3FALNRIS-H: Case Numbernvarchar100
26N1PDDSTPERINAT: Status history3FALNRIS-H: Case Numbernvarchar100
27N1PDDSTATUSPERINAT: Status evaluation for perinatal documentation3FALNRIS-H: Case Numbernvarchar100
28N1POPAKTEIS-H*Med: Patient Organizer - Redundant Structure7FALNRIS-H: Case Numbernvarchar100
29N1PRANFIS-H*MED: PATREG: Anforderungen14FALNRIS-H: Olgu numarasinvarchar100
30N1PRBEWIS-H*MED: PATREG: Bewegungen3FALNRIS-H: Olgu numarasinvarchar100
31N1PRDIAIS-H*MED: PATREG: Diagnosen3FALNRIS-H: Olgu numarasinvarchar100
32N1PRDOCIS-H*MED: PATREG: Dokumente9FALNRIS-H: Olgu numarasinvarchar100
33N1PRFALIS-H*MED: PATREG: Fälle3FALNRIS-H: Olgu numarasinvarchar100
34N1PRLEMIS-H*MED: PATREG: Leistungen6FALNRIS-H: Olgu numarasinvarchar100
35N1PRTMNIS-H*MED: PATREG: Termine5FALNRIS-H: Olgu numarasinvarchar100
36N1PRVKGIS-H*MED: PATREG: Vormerkungen7FALNRIS-H: Olgu numarasinvarchar100
37N1RISMISIS-H*MED: Data transfer error (case - patient)3FALNRIS-H: Case Numbernvarchar100
38N1THERSIS-H*MED: Therapeutic Scheme5FALNRIS-H: Case Numbernvarchar100
39N2BATMPIS-H*MED: Temporary treatment order20FALNRIS-H: Case Numbernvarchar100
40N2CCF_MSGSCCF: Message Table16FALNRIS-H: Case Numbernvarchar100
41N2CLIM_OBSVSVital Signs: Examination14FALNRIS-H: Case Numbernvarchar100
42N2DGAILEMISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI4FALNRIS-H: Fallnummernvarchar100
43N2DOCFALIS-H*MED: Case Data for Archived Documents3FALNRIS-H: Case Numbernvarchar100
44N2DOCREFCASEIS-H*MED: Empty Table for Lock Object Case Reference Level5FALNRIS-H: Case Numbernvarchar100
45N2DOCREFMOVEIS-H*MED: Empty Table for Lock Object Movement Ref. Level5FALNRIS-H: Case Numbernvarchar100
46N2DSDEVICE_ARCHISHMED: Archive Transfer Data from Interfaces18FALNRIS-H: Case Numbernvarchar100
47N2DSDEVICE_DATAISHMED: Transfer Data from Interface18FALNRIS-H: Case Numbernvarchar100
48N2GL_ACTpathways Activity16FALNRIS-H: Case Numbernvarchar100
49N2GL_TM_STEPpathways Step of Patient Pathway5FALNRIS-H: Case Numbernvarchar100
50N2GL_TR_DIATreatment Pathway: Proposal for Patient Pathway4FALNRIS-H: Case Numbernvarchar100
51N2OPDIAGNOSENIS-H*MED: Diagnoses for Surgeries5FALNRIS-H: Case Numbernvarchar100
52N2PHYO_ORDERPhysician Order5FALNRIS-H: Case Numbernvarchar100
53N2REFDIAIS-H*MED: External data ref. table for NDIA (diagnoses)7FALNRIS-H: Case Numbernvarchar100
54NC321IS-H: Table for data exchange of §3214FALNRIS-H: Case Numbernvarchar100
55NDOCAIS-H*MED: Document Management Data for Archived Documents10FALNRIS-H: Case Numbernvarchar100
56NDOCSTORNOIS-H*MED: Canceled Documents11FALNRIS-H: Case Numbernvarchar100
57NLEMIS-H*MED: Medical Service29FALNRIS-H: Case Numbernvarchar100
58NLLZIS-H: Asgmt of Svce to Mat., to Pers. Costs, to Svce12FALNRIS-H: Case Numbernvarchar100
TOPCommunication
59NHCF_EVENTIS-H: HCF: Triggered Unprocessed Events9FALNRIS-H: Case Numbernvarchar100
TOPDocuments
60N1IM_STUDYMeta Data of Image Study5FALNRIS-H: Case Numbernvarchar100
TOPInformation System
61NFALBWIS-H BW: Transfer Information for Cases into BW3FALNRIS-H: Case Numbernvarchar100
TOPPatient Accounting
62NBDTIS-H: Ins. assoc. billing cases transferred - status header3FALNRIS-H: Case Numbernvarchar100
63NBDT02PPA Billing Status for Treatment Certificates3FALNRIS-H: Case Numbernvarchar100
64NBDTEIS-H: BDT cases - status items3FALNRIS-H: Case Numbernvarchar100
65NBRKAZIS-H: Assignmt of downpayment/copayment (FI) to billDoc(SD)8FALNRIS-H: Case Numbernvarchar100
66NCIRIS-H: Insurance Relationships of a Case3FALNRIS-H: Case Numbernvarchar100
67NCOP_MESSIS-H: Copayment - Messages for Posting Back with Partial Pyt3FALNRIS-H: Case Numbernvarchar100
68NCOP_PROTIS-H: Copayment - Log Posting Back with Partial Payment3FALNRIS-H: Case Numbernvarchar100
69NDICZIS-H: Table of Diagnosis-to-Surgical Procedures Code Asgmts5FALNRIS-H: Case Numbernvarchar100
70NFAGIS-H: Case accrual3FALNRIS-H: Case Numbernvarchar100
71NFAGACPIS-H: Daily delimitation: check multiple execution3FALNRIS-H: Case Numbernvarchar100
72NFALACPIS-H: Case Accrual per Day3FALNRIS-H: Case Numbernvarchar100
73NFAMIS-H: Messages for Case Selection - Billing4FALNRIS-H: Case Numbernvarchar100
74NFAPIS-H: Items for CASE selection billing4FALNRIS-H: Case Numbernvarchar100
75NGLTIS-H: Intermediate table for service statistics10FALNRIS-H: Case Numbernvarchar100
76NICPIS-H: Surgical Procedure Codes Performed21FALNRIS-H: Case Numbernvarchar100
77NICP2IS-H: INACTIVE since 4.71 - DO NOT USE !21FALNRIS-H: Case Numbernvarchar100
78NLEVIS-H: Preliminary entered services3FALNRIS-H: Case Numbernvarchar100
79NLICZIS-H: Table of Service-to-Surgical Procedures Code Asgmts5FALNRIS-H: Case Numbernvarchar100
80NLOPIS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis3FALNRIS-H: Case Numbernvarchar100
81NMATPIS-H: Material planned for case3FALNRIS-H: Case Numbernvarchar100
82NMATVIS-H: Material Entered for Case4FALNRIS-H: Case Numbernvarchar100
83NNLZIS-H: Service <-> Business Partner Assignment10FALNRIS-H: Case Numbernvarchar100
84NSL2IS-H: Online error records of service statistics10FALNRIS-H: Case Numbernvarchar100
85NSLFIS-H: Error records of service statistics10FALNRIS-H: Case Numbernvarchar100
86NVBRKIS-H: Billing document header data60FALNRIS-H: Case Number (Required for Billing)nvarchar100
87NVVQIS-H: Individual Payment Distribution (per Service)3FALNRIS-H: Case Numbernvarchar100
88NWVIEW_L07_FORMSIS-H: Forms Entered for Case2FALNRIS-H: Case Numbernvarchar100
TOPPatient Management
89N1ANFIS-H*MED: Request9FALNRIS-H: Case Numbernvarchar100
90N1VKGIS-H: Item of Clinical Order (Preregistration)10FALNRIS-H: Case Numbernvarchar100
91NAMBIS-H: Request for Medical Grounds2FALNRIS-H: Case Numbernvarchar100
92NAPPIS-H: Provisional Appointments for Visit Scheduling4FALNRIS-H: Case Numbernvarchar100
93NBEWIS-H: Movements for Case3FALNRIS-H: Case Numbernvarchar100
94NBEWWPLACEIS-H: History of Work Environments Used for Movement3FALNRIS-H: Case Numbernvarchar100
95NBKZIS-H: Movement assignments for Ins. Verifications/Certific.3FALNRIS-H: Case Numbernvarchar100
96NDIAIS-H: Diagnoses3FALNRIS-H: Case Numbernvarchar100
97NDOCIS-H: Assignment of IS-H Objects to Documents in DMS10FALNRIS-H: Case Numbernvarchar100
98NFALIS-H: Cases3FALNRIS-H: Case Numbernvarchar100
99NFALAIS-H: Archived Cases: Obsolete as of 4.72 (Info via SARI)2FALNRIS-H: Case Number (Archive)nvarchar100
100NFKLIS-H: Case classification3FALNRIS-H: Case Numbernvarchar100
101NFPZIS-H: Assignment of a case to a person3FALNRIS-H: Case Numbernvarchar100
102NKAVISH: Intermediate File Creation/Borrowing/Transfer of Recrds4FALNRIS-H: Case Numbernvarchar100
103NKSKIS-H: Insurance verification/certificate - Header data7FALNRIS-H: Case Numbernvarchar100
104NLEIIS-H: Services Performed3FALNRIS-H: Case Numbernvarchar100
105NLKZIS-H: Assignment table service SC <-> insur. verification BC6FALNRIS-H: Case Numbernvarchar100
106NMBGIS-H: Medical grounds2FALNRIS-H: Case Numbernvarchar100
107NPFOIS-H: Index table for patient list2FALNRIS-H: Case Numbernvarchar100
108NPPRIS-H: Incorrect cases w. data medium exch. for NActyCl.3FALNRIS-H: Case Numbernvarchar100
109NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)7FALNRIS-H: Case Numbernvarchar100
110NTPLNV2000IS-H: Template Subscreen Data2FALNRIS-H: Case Numbernvarchar100
111NTRCIS-H: Trace Log Messages15FALNRIS-H: Case Numbernvarchar100
112NVVFIS-H: Case-Related Insurance Relationships3FALNRIS-H: Case Numbernvarchar100
113NWLPIS-H: Procedures for Waiting List (Internal Use Only)2FALNRIS-H: Case Numbernvarchar100
TOPReuse Services for Country Development
114PA0651HR Master Record Infotype 065159FALNRCase Numbernvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
115/ISHFR/COSTCOVIS-H FR: Coverage5FALNRIS-H: Case Numbernvarchar100
116/ISHFR/NVVW_TDAIndividual Contract Scheme Item Data - Time-Dependent3FALNRIS-H: Case Numbernvarchar100
117ISH_HCF_HEADERHeader for Index Table5FALNRIS-H: Case Numbernvarchar100
118ISH_IDX_HEADERHeader for Index Table6FALNRIS-H: Case Numbernvarchar100
119NAKR1IS-H AT: LKF - Grunddaten3FALNRIS-H: Fallnummernvarchar100
120NAKR2IS-H AT: LKF - Scoring Leistungen (MELs)3FALNRIS-H: Fallnummernvarchar100
121NAPHFIS-H AT: LKF - Punktehistorie zum Fall3FALNRIS-H: Fallnummernvarchar100
122NAPX_FALIS-H: Appendix Case Table3FALNRIS-H: Case Numbernvarchar100
123NCH53IS-H CH: Billing Agreement Per Case3FALNRIS-H: Case Numbernvarchar100
124NCOP_WVRIS-H: Erfassung ambulanter Zahlungsbefreiung3FALNRIS-H: Fallnummernvarchar100
125NCSSNCommunication Table (Item) to SSN2FALNRIS-H: Case Numbernvarchar100
126NCSSNIDCommunication Table (Header) to SSN2FALNRIS-H: Case Numbernvarchar100
127NEHICIS-H: European Health Insurance Card3FALNRIS-H: Case Numbernvarchar100
128NEO_NFALIS-H: External Orders - Order Data3FALNRIS-H: Case Numbernvarchar100
129NKSAIS-H: Insurance verification declaration (Austria)4FALNRIS-H: Case Numbernvarchar100
130NLDBC_006_LOGDBC Beziehung log Tabelle3FALNRIS-H: Fallnummernvarchar100
131NLGGZ_CARE_LOGDBC Beziehung log Tabelle3FALNRIS-H: Fallnummernvarchar100
132NLGGZ_CARE_RELGeisteskrankheit beziehung zwischen Fall und laufende Nr3FALNRIS-H: Fallnummernvarchar100
133NLGGZ_DIS_LOGDIS GGZ protokoltabelle7FALNRIS-H: Fallnummernvarchar100
134NLGGZ_PAT_GRPGeisteskrankheit patient gruppe aktuell6FALNRIS-H: Fallnummernvarchar100
135NLGGZ_SERVICE_CPGeisteskrankheit leistungen Leistungsgruppe kopie4FALNRIS-H: Fallnummernvarchar100
136NLHCO_ORDERNL-HCO: Orders3FALNRIS-H: Nummer ziektegevalnvarchar100
137NLVERKRechnungregister-kopf6FALNRIS-H: Nummer ziektegevalnvarchar100
138NNAUIS-H NL: Confirmation of coverage info from ins. provider4FALNRIS-H: Case Numbernvarchar100
139NNLEKIS-H NL: Data for treatment certificates13FALNRIS-H: Nummer ziektegevalnvarchar100
140NNLRAIS-H NL: Auf Leistungen angewendete Regeln12FALNRIS-H: Nummer ziektegevalnvarchar100
141NNLZPIS-H NL: LAZR Bewegingsgegevens LAZR-interface3FALNRIS-H: Nummer ziektegevalnvarchar100
142NNRLIS-H NL: Calculation Rules Log File7FALNRIS-H: Case Numbernvarchar100
143NPNTCASIS-H: Patient Master Data at Case Level (CV IT)2FALNRIS-H: Case Numbernvarchar100
144NVVNIS-H: Guarantors2FALNRIS-H: Case Numbernvarchar100
145NVVVIS-H: Individual Contract Schemes Header Data3FALNRIS-H: Case Numbernvarchar100
146NVVWIS-H: Individual Contract Schemes Item Data3FALNRIS-H: Case Numbernvarchar100
147NWATFADRIS-H AT: Adressenverwaltung (Fallbezogen)3FALNRIS-H: Fallnummernvarchar100
148NWATINTENSIS-H AT: Intensivdokumentation - Patientenadministration3FALNRIS-H: Fallnummernvarchar100
149NWATLRPRIS-H AT: Protokolltabelle für Fälle mit Leistungsregel A33FALNRIS-H: Fallnummernvarchar100
150NWATPHYSIS-H AT: Intensivdokumentation - Physiologische Daten3FALNRIS-H: Fallnummernvarchar100
151NWATTISS28Intensivdoku. - Pflege- u. Therapiedoku. (TISS-28 / TISS-A )3FALNRIS-H: Fallnummernvarchar100
152NWATTRISSIS-H AT: Intensivdoku. - Erfass. traumatologischer Patienten3FALNRIS-H: Fallnummernvarchar100
153NWAT_EDI_AUF_BEIS-H AT: EDIVKA Aufnahmebegründung zum Fall3FALNRIS-H: Fallnummernvarchar100
154NWAT_EDI_KOMIS-H AT: EDI Kommentar (K12)3FALNRIS-H: Fallnummernvarchar100
155NWAT_GIN_STATIRIS-H AT: Versicherungsstatus des Patienten6FALNRIS-H: Fallnummernvarchar100
156NWAT_SCOEWIS-H AT: Scoring akzeptierte Errors/Warnings3FALNRIS-H: Fallnummernvarchar100
157NWAT_SCOKOMMIS-H AT: Scoring Kommentar3FALNRIS-H: Fallnummernvarchar100
158NWAT_SCOMSGIS-H AT: Scoring Fehlermeldungen3FALNRIS-H: Fallnummernvarchar100
159NWAT_SCO_KALLKF - amb. Scoring Leistungen (KALs)3FALNRIS-H: Fallnummernvarchar100
160NWAT_SCO_MELLKF - Scoring Leistungen (MELs)3FALNRIS-H: Fallnummernvarchar100
161NWAT_SCO_WIKRAFIS-H AT: Scoring - manuelle Eingabe der V01-Daten3FALNRIS-H: Fallnummernvarchar100
162NWCH150IS-H CH: Zeitmarken zur Leistung (ALT => wird gelöscht !)3FALNRIS-H: numero episodionvarchar100
163NWCH70IS-H CH: Insurance Verification3FALNRIS-H: Case Numbernvarchar100
164NWCH80IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise4FALNRIS-H: numero episodionvarchar100
165NWCH90Fee-Based Services4FALNRIS-H: Case Numbernvarchar100
166NWCHBGZIS-H CH: Bewegungen - Geschäftspartner - Zuordnung3FALNRIS-H: numero episodionvarchar100
167NWCHEXTREFIS-H CH: Referenzschlüssel zur Leistung aus externem System8FALNRIS-H: numero episodionvarchar100
168NWCHLS_NFALIS-H CH: ALIS-Fehlerhandlung - Falldaten (für Fall-API)13FALNRIS-H: numero episodionvarchar100
169NWCHLS_RNLRZMIS-H CH: ALIS-Fehlerhandlung - Zeitmarken (RNLRZM)13FALNRIS-H: numero episodionvarchar100
170NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)155FALNRIS-H: numero episodionvarchar100
171NWCHNBEWIS-H CH: Bewegungen zum Fall - Zusatzfelder Schweiz3FALNRIS-H: numero episodionvarchar100
172NWCHPAKLZIS-H CH: Patientenabrechnung - LstVerteilung Nachträge3FALNRIS-H: numero episodionvarchar100
173NWCHPATRECIS-H CH: PATREC - erstellte Statistiksätze11FALNRIS-H: numero episodionvarchar100
174NWCHPATREC_IDIS-H CH: PATREC - künstl. Patienten-, Fall- und Geburtskeys4FALNRIS-H: numero episodionvarchar100
175NWCHPSYIS-H: Tab. für BFS-Statistik um Psychodaten bereitzustelle3FALNRIS-H: numero episodionvarchar100
176NWCHZMIS-H CH: Zeitmarken zur Bewegung/Leistung3FALNRIS-H: numero episodionvarchar100
177NWCHZMEIS-H CH: Zeit- /Maßangaben zur Bewegung/Leistung3FALNRIS-H: numero episodionvarchar100
178NWCH_BOA_ARCHProtokoll-Archiv für die Massendeckungsabfrage13FALNRIS-H: Fallnummernvarchar100
179NWCH_BOA_PROTProtokoll für die Massendeckungsabfrage13FALNRIS-H: Fallnummernvarchar100
180NWCH_NBRK_PROFDruckdaten Pro-forma-Rechnungen an Patienten3FALNRIS-H: Fallnummernvarchar100
181TNWCH76IS-H CH: Zuordnung Kostenübernahme - Rückweisbegründung Code3FALNRIS-H: numero episodionvarchar100