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

33 columns | Print definition?ERP 6.0  | OBTAB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CMM_FCHAR_OBTABObject Tables for Free Characteristics in Commodity Mgmnt1OBTABName of database table for objectnvarchar300
TOPALE Integration Technology
2TBDMEALE supplement data for EDI message type4OBTABName of database table for objectnvarchar300
TOPCAD Integration
3TCAOObject ID in Product Structure Explosion3OBTABSAP objectnvarchar100
TOPClasses
4CLINDEXOBTABRestriction of Index to Object Types3OBTABName of database table for objectnvarchar300
5CLSELSTATISTICSStatistics for Optimizing Object Search4OBTABName of database table for objectnvarchar300
6CLSELSTATISTICS2Statistical AUSP Information for Characteristics4OBTABName of database table for objectnvarchar300
7INOBLink between Internal Number and Object4OBTABName of database table for objectnvarchar300
8TCLAOSeveral Objects in one Class Type3OBTABName of database table for objectnvarchar300
9TCLAXCLASSIFICATION:4OBTABName of database table for objectnvarchar300
10TCLCATCatalogs for Finding Objects in Classes3OBTABName of database table for objectnvarchar300
11TCLFMControl Table Include Screen Module Pool for Classification1OBTABName of database table for objectnvarchar300
12TCLOKey Fields of Objects1OBTABName of database table for objectnvarchar300
13TCLRObject-Specific Reports and Transactions3OBTABName of database table for objectnvarchar300
14TCLTClassifiable Objects2OBTABName of database table for objectnvarchar300
15TCLTTClassifiable Objects: Texts3OBTABName of database table for objectnvarchar300
TOPClassification
16CLES_CLF_OBTABConversion: Classification and Search objects1OBTABName of database table for objectnvarchar300
17TCLAClass Types3OBTABName of database table for objectnvarchar300
18TCLS_KABCRelationship: Class Type - Object Key (BOR)2OBTABName of database table for objectnvarchar300
19TCL_CUOBJ_IDENTIdentification Table for Object Keys for Data Transfer6OBTABName of database table for objectnvarchar300
TOPConfiguration management
20CMTIB_CLFINT2EXTClassification conversion: internal ID to external key5OBTABName of database table for objectnvarchar300
TOPConfiguration Profile
21CUVCPR_ID_INTConversion: internal ID for configuration profile4OBTABName of database table for objectnvarchar300
TOPConstruction Equipment Management
22J_3GSTLPOSItem Data for Equipment BOMs7OBTABName of database table for objectnvarchar300
TOPDemand Management
23TPHVPHeader: Planning Profile6OBTABName of database table for objectnvarchar300
TOPEnvironment
24CLBWObject types (classes) for info object (BW)2OBTABName of database table for objectnvarchar300
25CLBW_SOURCESData Sources for Classification Data4OBTABName of database table for objectnvarchar300
TOPIPC Adapter
26CUCFGSWConfigurable Objects with IPC as configuration engine2OBTABName of database table for objectnvarchar300
TOPObject Dependencies
27TCUOSStatuses for Configurable Objects2OBTABName of database table for objectnvarchar300
28TCUQDConfiguration Parameter Standard Values2OBTABName of database table for objectnvarchar300
TOPReport Selection for Product Costing
29TCLZMAdministr. of Object Characteristics in Class SAP_KKR_CLASS2OBTABName of database table for objectnvarchar300
TOPTechnical Objects
30EAML_D_AUSP_LFELinear Data for Characteristics - Database table8OBTABName of database table for objectnvarchar300
31EAML_D_TCLSOrganizational area for characteristics with linear data3OBTABName of database table for objectnvarchar300
TOPVariant Configuration
32CUCOAdditional Data for Configurable Objects2OBTABName of database table for objectnvarchar300
TOPVehicle Management System
33CVLC20VELO : Filter Definition iBASE => LiveCache3OBTABObject Table for Objects Relevant to LiveCachenvarchar300