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

61 columns | Print definition?ERP 6.0  | VIEWTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NWVIEW_019Special View Data for Workflow Tasks2VIEWTYPEView Typenvarchar30
2RSDIPROV_MAPPINGMapping of InfoProvider fields to HANA View / ODP fields4VIEWTYPEType of Viewnvarchar30
TOPClinical System
3N1VIEW_017_PERSi.s.h.med: Personal Setting for View Type 0173VIEWTYPEView Typenvarchar30
4N1VIEW_CTXi.s.h.med: Definition of Functions for Context Menu3VIEWTYPEView Typenvarchar30
5N2XMLFILESIS-H*MED: XML File Management8VIEWTYPEXML: XML File Display Typenvarchar100
6NWVIEW_006IS-H / IS-H*MED: Special View Data Documents2VIEWTYPEView Typenvarchar30
7NWVIEW_011IS-H / IS-H*MED: Special View Data Surgeries2VIEWTYPEView Typenvarchar30
8NWVIEW_012IS-H / IS-H*MED: Special View Data Drug Order2VIEWTYPEView Typenvarchar30
9NWVIEW_013IS-H / IS-H*MED: Special View Data Drug Events2VIEWTYPEView Typenvarchar30
10NWVIEW_015Medication: Medication Order, Cross-Institutional2VIEWTYPEView Typenvarchar30
11NWVIEW_016IS-H / ISHMED: Special View Data Dictations2VIEWTYPEView Typenvarchar30
12NWVIEW_017i.s.h.med: Special View Data Surgery Progress Monitor2VIEWTYPEView Typenvarchar30
13NWVIEW_018IS-H/ISHMED: Special View Data Surgery Planning Work Station2VIEWTYPEView Typenvarchar30
14NWVIEW_P01IS-H / IS-H*MED: Spezialization Table for Patient Organizer2VIEWTYPEView Typenvarchar30
TOPCross-System Tools
15CMPWLCustomizing Comparison: Worklist Items6VIEWTYPEObject typenvarchar10
16CMPWLECustomizing Comparison: Exception List (SAP)2VIEWTYPEObject typenvarchar10
17CMPWLECCustomizing Comparison: Exception List (Customer)2VIEWTYPEObject typenvarchar10
18CMPWLHCustomizing Comparison: Worklist Header38VIEWTYPEObject typenvarchar10
19CMPWLKCustomizing Comparison: Keys of Worklist Items6VIEWTYPEObject typenvarchar10
TOPPatient Accounting
20NWVIEW_L01IS-H: NL10 - View Type L01 - Table Control Settings2VIEWTYPEView Typenvarchar30
21NWVIEW_L02IS-H: NL10 - View Type L02 - Table Control Settings2VIEWTYPEView Typenvarchar30
22NWVIEW_L03IS-H: NL10 - View Type L03 - Table Control Settings2VIEWTYPEView Typenvarchar30
23NWVIEW_L04IS-H: NL10 - View Type L04 - Table Control Settings2VIEWTYPEView Typenvarchar30
24NWVIEW_L07IS-H: Definition of Form Folders2VIEWTYPEView Typenvarchar30
25NWVIEW_L07_FORMSIS-H: Forms Entered for Case3VIEWTYPEView Typenvarchar30
26NWVIEW_W01IS-H: Workplace - View Type W01 - MiniApp Reports2VIEWTYPEView Typenvarchar30
TOPPatient Management
27NLEIIS-H: Services Performed102VIEWTYPEView Typenvarchar30
28NWBUTTONPushbuttons for Function Variants2VIEWTYPEView Typenvarchar30
29NWBUTTONTPushbuttons for Function Variants3VIEWTYPEView Typenvarchar30
30NWFVARFunction Variants (Catalog)2VIEWTYPEView Typenvarchar30
31NWFVARPFunctions below a Pushbutton per Function Variant2VIEWTYPEView Typenvarchar30
32NWFVARPTFunctions below a Pushbutton per Function Variant3VIEWTYPEView Typenvarchar30
33NWFVARTFunction Variants (Texts)3VIEWTYPEView Typenvarchar30
34NWPVZWork Environment-to-View Assignment4VIEWTYPEView Typenvarchar30
35NWPVZTWork Environment-to-View Assignment5VIEWTYPEView Typenvarchar30
36NWPVZ_USZIS-H / IS-H*MED: Work Environment-to-Service View Assignment4VIEWTYPEView Typenvarchar30
37NWVIEWViews in Work Stations2VIEWTYPEView Typenvarchar30
38NWVIEWTViews in Work Stations3VIEWTYPEView Typenvarchar30
39NWVIEWVARView Types in Work Stations2VIEWTYPEView Typenvarchar30
40NWVIEW_001IS-H / IS-H*MED: Speical View Data for Occupancy2VIEWTYPEView Typenvarchar30
41NWVIEW_002IS-H / IS-H*MED: Special View Data for Arrivals2VIEWTYPEView Typenvarchar30
42NWVIEW_003IS-H / IS-H*MED: Special View Data for Departures2VIEWTYPEView Typenvarchar30
43NWVIEW_004IS-H / IS-H*MED: Special View Data for Requests2VIEWTYPEView Typenvarchar30
44NWVIEW_005IS-H / IS-H*MED: Special View Data for Transport Orders2VIEWTYPEView Typenvarchar30
45NWVIEW_007IS-H/IS-H*MED: Special View Data Svce Facility/Outp. Clinic2VIEWTYPEView Typenvarchar30
46NWVIEW_008IS-H/IS-H*MED: Special View Data Medical Controlling2VIEWTYPEView Typenvarchar30
47NWVIEW_009IS-H / IS-H*MED: Special View Data Occupancy Characteristic2VIEWTYPEView Typenvarchar30
48NWVIEW_010IS-H / IS-H*MED: Special View Data Preregistrations2VIEWTYPEView Typenvarchar30
49NWVIEW_A01IS-H: Clinical Process Builder - Additional Data of View2VIEWTYPEView Typenvarchar30
50NWVIEW_A02IS-H: Clinical Process Builder - Modules for View2VIEWTYPEView Typenvarchar30
51NWVIEW_A05IS-H: Clinical Process Builder - Selection for Appt List2VIEWTYPEView Typenvarchar30
52NWVIEW_AP1IS-H: View Type AP1 - Search Variant for Standard Search2VIEWTYPEView Typenvarchar30
53NWVIEW_AP2IS-H: View Type AP2 - Search Variant for Enh. Time Slot Sear2VIEWTYPEView Typenvarchar30
54NWVIEW_FCDFunction Bar: Function Code Data2VIEWTYPEView Typenvarchar30
55NWVIEW_FCDTFunction Bar: Function Code Data3VIEWTYPEView Typenvarchar30
56NWVIEW_PERSPersonalization Information for View3VIEWTYPEView Typenvarchar30
TOPPlanning
57NWVIEW_014IS-H / IS-H*MED: Appointment Planning Special View Data2VIEWTYPEView Typenvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
58NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)152VIEWTYPETipo viewnvarchar30
59NWVIEW_FR1IS-H-FR: Special View Data for Absences2VIEWTYPEView Typenvarchar30
60NWVIEW_NL1Sichtdaten cockpit2VIEWTYPESichttypnvarchar30
61TN2_DWS_WORKAREAWork Area <---> View Type Assignment3VIEWTYPEView Typenvarchar30