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

24 columns | Print definition?ERP 6.0  | DEVTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPClinical System
1N2DDEVICEIS-H*MED RAD: Description of the modality, workstation5DEVTYPEType of device systemnvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
2SXADMINTABSAPconnect and SAPphone: Administration9DEVTYPESpool: Device type namenvarchar80
3SXDEVTYPESAPconnect: Device Types for Format Conversion3DEVTYPESAPconnect: Device typenvarchar80
4SXDEVTYPLSAPconnect: Device Types for Language-Dependent Conversion5DEVTYPESAPconnect: Device typenvarchar80
5SXSERVSAPconnect: Node capabilities5DEVTYPESAPconnect: Device typenvarchar80
TOPCorporate Performance Monitor
6UMR_RI114RMS: Measure Selection and Attributes5DEVTYPEType of Plan Deviationnvarchar10
TOPDB2 for OS39
7DB2COPYIDB2 copy information from SYSIBM.SYSCOPY10DEVTYPEColumn DEVTYPE of table SYSIBM.SYSCOPY (DB2 on OS/390)nvarchar80
TOPIndustrial Hygiene and Safety
8CCIHC_METDVTYPEEHS: Assignment Measurement Method to Device Type3DEVTYPEMeasuring Device Typenvarchar30
TOPPrint and Output Management
9TSP06POTPrint options texts1DEVTYPESpool: Device type namenvarchar80
10TSP0TAssignment of local printer type to terminal2DEVTYPESpool: Device type namenvarchar80
11TSPOPIPPrinter / device type repations6DEVTYPESpool: Device type namenvarchar80
12TSPOPIPRNPrinter / device type relations6DEVTYPESpool: Device type namenvarchar80
13TSPOPIPRN_WORKPrinter / device type relations6DEVTYPESpool: Device type namenvarchar80
TOPSAP NetWeaver Mobile - Use subcomponents
14BWAFDEPLMobile Engine4DEVTYPEDevice Typenvarchar300
TOPSmart Forms
15TSFDEVTYSmart Forms: Device Types for Languages3DEVTYPESpool: Device type namenvarchar80
TOPTransport Management System
16TCESYSTSystem List4DEVTYPEDevelopment system type (SAP internal use)nvarchar10
TOPTransport Organizer
17TSYSTOBSOLETE: Do not use (see TCESYST)3DEVTYPEDevelopment system type (SAP internal use)nvarchar10
TOPURL Generation
18TWPSRVDEVIWP Runtime: Dependencies of Services on End Devices1DEVTYPEDevice Typenvarchar300
TOPWeb Application Builder
19W3DEVAPPRelationship Between Application and Device Type3DEVTYPEDevice Typenvarchar300
20W3DEVTYPEDevice types1DEVTYPEDevice Typenvarchar300
21W3DEVTYPTDevice Types Short Text1DEVTYPEDevice Typenvarchar300
TOPWorkbench Tools Editors, Painters, Modelers
22W3DEVAPPXRelationship Between Application and Device Type3DEVTYPEDevice Typenvarchar300
23W3DEVTYPTXDevice Types Short Text1DEVTYPEDevice Typenvarchar300
24W3DEVTYPXDevice Types1DEVTYPEDevice Typenvarchar300