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

48 columns | Print definition?ERP 6.0  | SQLTAB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_INDFR/3 S_SECINDEX: secondary indexes, fields (CMIS Table)4SQLTABTable Namenvarchar300
2CNVCMIS_A_1_INDXIndx Table(CMIS)4SQLTABTable Namenvarchar300
3CNVCMIS_A_1_SHLDSearch Help Data (Parameters)18SQLTABTable Namenvarchar300
4CNVCMIS_A_1_TABDSelection of Object Type TABLE (TABD) Master information9SQLTABName of an SQL table or an appended tablenvarchar300
5CNVCMIS_A_20_WLWork list table for Cross-Client Customizing Comparison8SQLTABSQL Tablenvarchar300
6CNVCMIS_A_SIZEtable to store result of the table size analysis8SQLTABName of an SQL table or an appended tablenvarchar300
7CNVMBTCLUSTTABCluster tables DDIC for de-clustered systems1SQLTABName of an SQL table or an appended tablenvarchar300
8CNVMBTDELPARAMSParameter for the generic deletion program4SQLTABTable Namenvarchar160
9CNVTDMS_02_SIZEtable to store result of the table size analysis8SQLTABName of an SQL table or an appended tablenvarchar300
10CNVTDMS_02_STEMPTable to store current view on CNVTDMS_02_SIZE_STRUCT6SQLTABName of an SQL table or an appended tablenvarchar300
11CNVTDMS_04_TABTable Pool for TDMS MD&C11SQLTABName of an SQL table or an appended tablenvarchar300
12CNVTDMS_09_PROGTable for generated programs4SQLTABSQL table namenvarchar160
13CNVTDMS_BP_STEMPTable to store result of activity Analyze table sizes6SQLTABName of an SQL table or an appended tablenvarchar300
14CNVTDMS_EC_STMPCTable to store copy of CNVTDMS_02_STEMP data with Table Desc6SQLTABName of an SQL table or an appended tablenvarchar300
15CNV_20551_POOLList of the pool tables and related table pools4SQLTABSQL table namenvarchar100
16CNV_CMIS_A_SIZETABLE TO STORE WORKLIST TABLES FOR SIZE CALCULATIONS6SQLTABName of an SQL table or an appended tablenvarchar300
17CNV_MBT_DEL_TABSDMIS: Table for Data Deletion13SQLTABTable Namenvarchar160
18DMC_MT_TABLESDMC: Tables for a Mass Data Transfer11SQLTABName of an SQL table or an appended tablenvarchar300
19IUUC_RL_MEDATACLRepl logging -> meta data of data cluster5SQLTABTable Namenvarchar300
20IUUC_TABCL_MAPMapping: TABCLASS sender to TABCLASS receiver5SQLTABName of an SQL table or an appended tablenvarchar300
21IUUC_TABLEStables to be processed by IUUC5SQLTABName of an SQL table or an appended tablenvarchar300
22IUUC_TABLESVtables to be processed by IUUC - version table6SQLTABName of an SQL table or an appended tablenvarchar300
23IUUC_TABLE_EVALIUUC Table analysis: evaluation of table usage (SAP)7SQLTABName of an SQL table or an appended tablenvarchar300
24IUUC_TABLE_EVALCIUUC Table analysis: evaluation of table usage (customer)4SQLTABName of an SQL table or an appended tablenvarchar300
25IUUC_TAB_EVALCVIUUC Table analysis: evaluation of table usage (customer)5SQLTABName of an SQL table or an appended tablenvarchar300
26IUUC_TAB_EVALUATIUUC Table analysis: evaluation of table usage - OBSOLETE6SQLTABName of an SQL table or an appended tablenvarchar300
27IUUC_TAB_EVALVIUUC Table analysis: evaluation of table usage (SAP)8SQLTABName of an SQL table or an appended tablenvarchar300
28TKEA1CO-PA: Control tab. for managing generated derivation tab.3SQLTABSQL table namenvarchar100
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
29DD02LSAP Tables5SQLTABName of an SQL table or an appended tablenvarchar300
30DD06LPool/cluster structures1SQLTABName of Pool/Cluster in the Databasenvarchar100
31DD06TR/3 DD: texts on SQL tables1SQLTABName of Pool/Cluster in the Databasenvarchar100
32DD12LR/3 S_SECINDEX: secondary indexes, header;1SQLTABTable Namenvarchar300
33DD12TText Table for DD12L (Short Descriptions of Sec. Indexes)2SQLTABTable Namenvarchar300
34DD15LR/3 DD: SAP objects5SQLTABSQL table namenvarchar100
35DD16SR/3 DD: SQL table fields1SQLTABName of Pool/Cluster in the Databasenvarchar100
36DD17SR/3 S_SECINDEX: secondary indexes, fields1SQLTABTable Namenvarchar300
TOPBusiness Application Support
37CNVSUBSTEPSConversion: procedure-related functions for cluster tables3SQLTABTable Namenvarchar300
38CNVSUBSTEPSCConversion: Steps for cluster tables with conflicts4SQLTABTable Namenvarchar300
39CNVSUBSTEPSTConversion: procedure-related functions for cluster tables4SQLTABTable Namenvarchar300
40CNVSUBSTEPSTCConversion: Steps with conflicts for cluster tables5SQLTABTable Namenvarchar300
41CNVSUBSTPARSConversion: Parameters for procedure-related functions3SQLTABTable Namenvarchar300
42CNVSUBSTPARSCConversion: Param. for SUBSTEPS with conflicts in blending4SQLTABTable Namenvarchar300
TOPClient Copy
43CCSELTABParallel Client Copy Worklist: Objects5SQLTABName of an SQL table or an appended tablenvarchar300
TOPF4 Help
44DD32SSearch Help Parameter14SQLTABTable Namenvarchar300
TOPIncentive and Commission Management ICM
45TCACS_REG1Template Tables and Template Structures for Generating14SQLTABName of an SQL table or an appended tablenvarchar300
TOPOnline Correction Support Support Package and Add-On Tools
46OCS_TESTFREE_INFTable for testing CHECK_FREESPACE under Informix10SQLTABName of an SQL table or an appended tablenvarchar300
TOPUpgrade Tools
47UPG_DD12LICNV: Secondary Indexes - Header1SQLTABTable for incremental conversionnvarchar300
48UPG_DD17SICNV: Secondary Indexes - Fields1SQLTABTable for incremental conversionnvarchar300