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

60 columns | Print definition?ERP 6.0  | CONFIG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UI2/EDM_GADGETUI2: Gadget2CONFIGUI2: Gadget configurationnvarchar2000
2/UI2/EDM_GADG_CUI2: Gadget3CONFIGUI2: Gadget configurationnvarchar2000
3/UI2/EDM_USAGEUI2: page usage4CONFIGntext10737418230
4GRFNORGVIEWOrganization Views Configuration4CONFIGOrganization View Configurationnvarchar10
5T7PIQCONFConfiguration Types2CONFIGConfiguration Typenvarchar40
6T7PIQCONFPARParameters per Configuration2CONFIGConfiguration Typenvarchar40
7T7PIQCONFTConfiguration Type texts3CONFIGConfiguration Typenvarchar40
8T7PIQCONF_VALUEConfiguration Type Activation2CONFIGConfiguration Typenvarchar40
TOPCentral Part of Product Master
9COMC_PR_TEMPLATEProduct Template for Configurable Products3CONFIGDetermines Whether a Product Is Configurablenvarchar10
10COMM_IPRODUCTInactive Product5CONFIGDetermines Whether a Product Is Configurablenvarchar10
11COMM_PRODUCTProduct5CONFIGDetermines Whether a Product Is Configurablenvarchar10
12COMM_PRODUCTHProduct History6CONFIGDetermines Whether a Product Is Configurablenvarchar10
13COMM_PRODUCT_IDXIndex Table for Products7CONFIGDetermines Whether a Product Is Configurablenvarchar10
14COMS_PR_CONFIGType of Configurable Product1CONFIGDetermines Whether a Product Is Configurablenvarchar10
TOPCustomer Interaction Center
15CCMACTIONOBJAssign transactions to object types - usage restriction3CONFIGAction Box configurationnvarchar80
16CCMHTMLCONFCIC HTML configuration2CONFIGCIC HTML configurationnvarchar300
17CCMHTMLCONFTCIC HTML configuration3CONFIGCIC HTML configurationnvarchar300
18CCMHTMLPARCIC HTML configuration: external parameters2CONFIGCIC HTML configurationnvarchar300
19CCMHTMLPARICIC HTML configuration: parameter for internal calls2CONFIGCIC HTML configurationnvarchar300
20CCMHTMLPARITCIC HTML configuration: Text for internal parameters3CONFIGCIC HTML configurationnvarchar300
21CCMHTMLPARTCIC HTML configuration: text for external parameters3CONFIGCIC HTML configurationnvarchar300
22EWFCALFront Office Call3CONFIGAction Box configurationnvarchar80
23EWFCALTFront Office Call: Text4CONFIGAction Box configurationnvarchar80
24EWFCONFront Office Configuration3CONFIGAction Box configurationnvarchar80
25EWFCONTFront Office Configuration: Text4CONFIGAction Box configurationnvarchar80
26EWFFNDFront Office Configuation Determination7CONFIGAction Box configurationnvarchar80
27EWFGRUFront Office Call Group3CONFIGAction Box configurationnvarchar80
28EWFGRUTFront Office Call Group: Text4CONFIGAction Box configurationnvarchar80
29EWFPARFront Office Configuration: Call Parameter3CONFIGAction Box configurationnvarchar80
30EWFPARTFront Office Configuration: Call Parameter: Text4CONFIGAction Box configurationnvarchar80
31EWFTRAFront Office Call: Data Flow3CONFIGAction Box configurationnvarchar80
TOPCustomer Service
32ECNCONFIS-U Navigator: Configuration2CONFIGIS-U navigator configurationnvarchar80
33ECNCONFTIS-U Navigator: Text Table for Configurations3CONFIGIS-U navigator configurationnvarchar80
34ECNFINDIS-U Navigator: Configuration Determination6CONFIGIS-U navigator configurationnvarchar80
35ECNSTRUCIS-U Navigator: Structures2CONFIGIS-U navigator configurationnvarchar80
TOPDocument Builder
36/IPRO/TCONFIGDocument Builder Configuration Parameters3CONFIGConfiguration Parameternvarchar200
37/IPRO/TCONF_TText table for config parameters3CONFIGConfiguration Parameternvarchar200
38/IPRO/TCONF_VALUValue table for config parameters2CONFIGConfiguration Parameternvarchar200
TOPE-Recruiting
39T77RCF_RM_SEQAssignment of Roadmap Step to Roadmap Scenario3CONFIGConfiguration Identifiernvarchar320
40T77RCF_RM_SEQCAssignment of Roadmap Step to Roadmap Scenario4CONFIGConfiguration Identifiernvarchar320
TOPeCATT Extended Computer Aided Test Tool
41ECLOG_EXECExecuted Configuration, Variant, Script, Version3CONFIGTest Configurationnvarchar300
TOPFront Office
42EBDMARKCONFCIC components BDD marking function configuration2CONFIGBDD component marker function configuration CICnvarchar80
43ECVCONFIS-U customer overview: configuration3CONFIGCustomer overview configurationnvarchar80
44ECVCONFTIS-U customer overview: configuration texts4CONFIGCustomer overview configurationnvarchar80
45ECVHTMLIS-U customer overview: HTML pages3CONFIGCustomer overview configurationnvarchar80
46ECVHTMLTIS-U customer overview: configuration texts4CONFIGCustomer overview configurationnvarchar80
47ECVNODEIS-U customer overview: tree nodes3CONFIGCustomer overview configurationnvarchar80
48ECVNODETIS-U customer overview: configuration texts4CONFIGCustomer overview configurationnvarchar80
TOPMaxDB
49DBANBuffer for dban_state7CONFIGSAP DB: Response line from DBM commandnvarchar2550
TOPSAP Records Management
50RCMCONFIGWDCustomizing Table WD Configuration2CONFIGnvarchar100
TOPSyntax, Compiler, Runtime
51TIDYVERIhtml tidy verification data3CONFIGntext10737418230
52VER_TIDY_HTMLTIDY VERIFICATION DATA3CONFIGKonfigurationnvarchar800
TOPTransport Management System
53LISUCONFTMS User Interface: Configuration3CONFIGShort Description of Repository Objectsnvarchar600
54TMSUCONFTMS User Interface: Configuration3CONFIGShort Description of Repository Objectsnvarchar600
TOPUI Configuration Design Layer
55BSPC_DL_PERSSTORStoragetable for XML personalized layout descriptions11CONFIGXString for XML Storageimage21474836470
56BSPC_DL_XMLSTORXStoragetable for XML layout descriptions6CONFIGXString for XML Storageimage21474836470
57BSPC_DL_XMLSTRX2Storagetable for XML layout descriptions11CONFIGXString for XML Storageimage21474836470
58BSP_DDLC_XMLSTORStoragetable for delivered XML layout descriptions5CONFIGXString for XML Storageimage21474836470
59BSP_DL_XMLSTRX2Storagetable for delivered XML layout descriptions10CONFIGXString for XML Storageimage21474836470
60BSP_DL_XMLST_PRProcessed Standdard Configuration (switch related handling)11CONFIGXString for XML Storageimage21474836470