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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

69 columns | Print definition?ERP 6.0  | LNRLS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NBMI_SRV_UPLOADKeep the upload status2LNRLSIS-H: Service Sequence Numbernvarchar100
2NNLREFER_REF_ACTKopplung Verweisungsnummer und Leistung4LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
3NNL_FYSIOTabelle Physiotherapie5LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
4NNL_MED_MESSLBZ medizinische Meldungen8LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
5NNL_ZH308_V9_R04ZH308 V09 Record04 Soll Daten58LNRLSnvarchar150
TOPClinical System
6N1BEZYIS-H*MED: Cycles with NLEI reference6LNRLSIS-H: Service Sequence Numbernvarchar100
7N1DWSWL_WRKSURSurgery: Situation - Surgery Assignment3LNRLSIS-H: Service Sequence Numbernvarchar100
8N1DYLMZUOIS-H*MED: Dynamic material proposal3LNRLSIS-H: Service Sequence Numbernvarchar100
9N1GENCY_01IS-H*MED: Cycle - Nursing Service Assignment3LNRLSIS-H: Service Sequence Numbernvarchar100
10N1GENCY_02IS-H*MED: Cycle - Medical Service Assignment3LNRLSIS-H: Service Sequence Numbernvarchar100
11N1IPBAIS-H*MED: Asnmt. of Indiv. Nurs. Plan to Basic HospCat.Entry2LNRLSIS-H: Service Sequence Numbernvarchar100
12N1IPLEIS-H*MED:Assignmt of Nursing Anchor Service to the ntpk3LNRLSIS-H: Service Sequence Numbernvarchar100
13N1IPSTIS-H*MED: Asgmt of Stnd. Nursing Plans to Ind. Nursing Plans2LNRLSIS-H: Service Sequence Numbernvarchar100
14N1LSMAZIS-H*MED: Service/employee assign. (delete after 3.03!)2LNRLSIS-H: Service Sequence Numbernvarchar100
15N1LSSTZISHMED: Service-Svce Status-Employee Assignment3LNRLSIS-H: Service Sequence Numbernvarchar100
16N1LSTEAMIS-H*MED: Tasks/Employees for a Service2LNRLSIS-H: Service Sequence Numbernvarchar100
17N1MEOSRVAIS-H*MED: Order - Service - Assignment3LNRLSIS-H: Service Sequence Numbernvarchar100
18N1NURSPALMPCIS-H*MED: Log Table for Communication with Palm-PC2LNRLSIS-H: Service Sequence Numbernvarchar100
19N1POPAKTEIS-H*Med: Patient Organizer - Redundant Structure15LNRLSIS-H: Service Sequence Numbernvarchar100
20N1PRDOCIS-H*MED: PATREG: Dokumente37LNRLSIS-H: Hizmet sira numarasinvarchar100
21N1PREFETCHSPOOLIS-H*MED: RAD Prefetching Tasks3LNRLSIS-H: Service Sequence Numbernvarchar100
22N1PRLEMIS-H*MED: PATREG: Leistungen3LNRLSIS-H: Hizmet sira numarasinvarchar100
23N1TMSTPDURi.s.h..med: Duration for Time Stamps5LNRLSIS-H: Service Sequence Numbernvarchar100
24N2ANKERIS-H*MED Information for OR Documentation (Anchor Service)3LNRLSIS-H: Service Sequence Numbernvarchar100
25N2DGAILEMISH*MED : Kontrolltabelle Überleitung med. Leist -> DGAI3LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
26N2DOCBEWLEIIS-H*MED: Movement and Service Data for Archived Documents12LNRLSIS-H: Service Sequence Numbernvarchar100
27N2DOCREFSERVIS-H*MED: Empty Table for Lock Object Service Ref. Level5LNRLSIS-H: Service Sequence Numbernvarchar100
28N2DSDEVICE_ARCHISHMED: Archive Transfer Data from Interfaces16LNRLSIS-H: Service Sequence Numbernvarchar100
29N2DSDEVICE_DATAISHMED: Transfer Data from Interface16LNRLSIS-H: Service Sequence Numbernvarchar100
30N2MATREFIS-H*MED: Reference table for material external data (N2FM)6LNRLSIS-H: Service Sequence Numbernvarchar100
31N2OPDIAGNOSENIS-H*MED: Diagnoses for Surgeries3LNRLSIS-H: Service Sequence Numbernvarchar100
32N2TEAMREFIS-H*MED: Ref table for team ext. data modules (N2F2)6LNRLSIS-H: Service Sequence Numbernvarchar100
33N2TICZIS-H*MED: Assignment Table Surgery Team - Surgery Code2LNRLSIS-H: Service Sequence Numbernvarchar100
34NDOCAIS-H*MED: Document Management Data for Archived Documents19LNRLSIS-H: Service Sequence Numbernvarchar100
35NDOCSTORNOIS-H*MED: Canceled Documents20LNRLSIS-H: Service Sequence Numbernvarchar100
36NLEMIS-H*MED: Medical Service2LNRLSIS-H: Service Sequence Numbernvarchar100
TOPDocuments
37N1IM_STUDYMeta Data of Image Study7LNRLSIS-H: Service Sequence Numbernvarchar100
TOPPatient Accounting
38NGLTIS-H: Intermediate table for service statistics5LNRLSIS-H: Service Sequence Numbernvarchar100
39NLCOIS-HCO: Transfer information2LNRLSIS-H: Service Sequence Numbernvarchar100
40NLICZIS-H: Table of Service-to-Surgical Procedures Code Asgmts2LNRLSIS-H: Service Sequence Numbernvarchar100
41NLOPIS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis4LNRLSIS-H: Service Sequence Numbernvarchar100
42NMATPIS-H: Material planned for case5LNRLSIS-H: Service Sequence Numbernvarchar100
43NMATVIS-H: Material Entered for Case6LNRLSIS-H: Service Sequence Numbernvarchar100
44NNLZIS-H: Service <-> Business Partner Assignment2LNRLSIS-H: Service Sequence Numbernvarchar100
45NSL2IS-H: Online error records of service statistics5LNRLSIS-H: Service Sequence Numbernvarchar100
46NSLFIS-H: Error records of service statistics5LNRLSIS-H: Service Sequence Numbernvarchar100
47NVVQIS-H: Individual Payment Distribution (per Service)5LNRLSIS-H: Service Sequence Numbernvarchar100
TOPPatient Management
48NDOCIS-H: Assignment of IS-H Objects to Documents in DMS19LNRLSIS-H: Service Sequence Numbernvarchar100
49NLEIIS-H: Services Performed6LNRLSIS-H: Service Sequence Numbernvarchar100
50NLKZIS-H: Assignment table service SC <-> insur. verification BC2LNRLSIS-H: Service Sequence Numbernvarchar100
TOPRadiology
51N1PREFSPOOLIS-H*MED: RAD Prefetching Tasks3LNRLSIS-H: Service Sequence Numbernvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
52/ISHFR/COSTCOVIS-H FR: Coverage2LNRLSIS-H: Service Sequence Numbernvarchar100
53NAKR2IS-H AT: LKF - Scoring Leistungen (MELs)4LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
54NLGGZ_SERVICE_CPGeisteskrankheit leistungen Leistungsgruppe kopie6LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
55NLVERPRechnungregister-position9LNRLSIS-H: Volgnummer van de verrichtingnvarchar100
56NNLRAIS-H NL: Auf Leistungen angewendete Regeln2LNRLSIS-H: Volgnummer van de verrichtingnvarchar100
57NNRLIS-H NL: Calculation Rules Log File3LNRLSIS-H: Service Sequence Numbernvarchar100
58NWAT_SCO_KALLKF - amb. Scoring Leistungen (KALs)4LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
59NWAT_SCO_MELLKF - Scoring Leistungen (MELs)4LNRLSIS-H: Laufende Nummer der Leistungnvarchar100
60NWCH150IS-H CH: Zeitmarken zur Leistung (ALT => wird gelöscht !)4LNRLSIS-H: numero progressivo prestazionenvarchar100
61NWCH90Fee-Based Services5LNRLSIS-H: Service Sequence Numbernvarchar100
62NWCH93Fees: Transfer Information for Services (NLEI)3LNRLSIS-H: Service Sequence Numbernvarchar100
63NWCHEXTREFIS-H CH: Referenzschlüssel zur Leistung aus externem System4LNRLSIS-H: numero progressivo prestazionenvarchar100
64NWCHLCOEAIS-HCO: Überleitungsinformationen5LNRLSIS-H: numero progressivo prestazionenvarchar100
65NWCHLS_RNLRZMIS-H CH: ALIS-Fehlerhandlung - Zeitmarken (RNLRZM)15LNRLSIS-H: numero progressivo prestazionenvarchar100
66NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)9LNRLSIS-H: numero progressivo prestazionenvarchar100
67NWCHPAKLZIS-H CH: Patientenabrechnung - LstVerteilung Nachträge5LNRLSIS-H: numero progressivo prestazionenvarchar100
68NWCHZMIS-H CH: Zeitmarken zur Bewegung/Leistung7LNRLSIS-H: numero progressivo prestazionenvarchar100
69NWCHZMEIS-H CH: Zeit- /Maßangaben zur Bewegung/Leistung6LNRLSIS-H: numero progressivo prestazionenvarchar100