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

55 columns | Print definition?ERP 6.0  | PCLPACKID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVA_00555_ANAAnalysis details for Run Time Estimation3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
2CNVA_00555_HDRHeader table for Run Time Estimation package3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
3CNVA_00555_PACKLT Runtime Estimation: Table to store Conversion packages2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
4CNVA_00555_RUNIDHeader Information of Run Time Estimation Id3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
5CNVA_00555_SYSSystem details for Run Time Estimation3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
6CNVA_00555_TABLE50 Largest tables for Run Time Estimation3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
7CNVA_CCD_ANA_CAContolling Area to be partially deleted3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
8CNVA_CCD_ANA_CNTCount table for the scanned objects in CNVA_CCD_ANA packag3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
9CNVA_CCD_ANA_HDRHeader table for CC Deletion Analysis Package3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
10CNVA_CCD_ANA_OBJScanned Objects relevant for deletion by CNVA_CCD_ANA3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
11CNVA_CCD_ANA_RESResult table for CC deletion downtime Analysis3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
12CNVA_CCD_ANA_SHDHeader table for CC Deletion Analysis Package in SolMan3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
13CNVA_PCREA_AA_CPC Reorg Analysis: FI-AA Profit Center assignments2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
14CNVA_PCREA_AA_OLT PC Reorg Analysis: Asset Reconciliation results (Level 2)2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
15CNVA_PCREA_AA_PPC Reorg Analysis: Parameters for Fixed Asset Recon2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
16CNVA_PCREA_AA_RLT PC Reorg Analysis: Asset Reconciliation results (Level 1)2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
17CNVA_PCREA_GRIROGR/IR Items - Results (Level 2)2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
18CNVA_PCREA_GRIRPPC Reorg Analysis: Parameters for GRIR Recon2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
19CNVA_PCREA_GRIRRGR/IR Header - Reconciliation results (Level 1)2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
20CNVA_PCREA_MM_PPC Reorg Analysis: Parameters for MM Recon2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
21CNVA_PCREA_MM_RLT PC Reorg Analysis: MM Reconciliation results Log2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
22CNVA_PCREA_PARAMn LT PC Reorg Analysis: Parameters2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
23CNVA_PCREA_RUNIDHeader Information of Profit Center Reorganization2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
24CNVA_PCREA_WIP_OLT PC Reorg Analysis: WIP Reconciliation results (Level 2)2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
25CNVA_PCREA_WIP_PPC Reorg Analysis: Parameters for WIP/SD Recon2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
26CNVA_PCREA_WIP_RLT PC Reorg Analysis: WIP Reconciliation results (Level 1)2PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
27CNV_10940_CONVSTVariant conversion status3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
28CNV_10940_COUNTCount for all reports and variants3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
29CNV_10940_DOMAINDomain Entries3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
30CNV_10940_FCONSTFinal consistency check status3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
31CNV_10940_FSELStoring free selections3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
32CNV_10940_HEADAnalyze report variants3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
33CNV_10940_PARAStoring parameters and select options3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
34CNV_10940_REPTable for Reports3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
35CNV_10940_REPORTReports relevant for analyse variants3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
36CNV_10940_REPVARReports relevant for analyse variants3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
37CNV_10940_RUNSTRReport Variant String Table3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
38CNV_10940_RUN_IDSearch Run IDs created in Sol Man for RVS3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
39CNV_10940_SRCRSTStoring screen parameters3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
40CNV_10940_VARDETStoring values of variants3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
41CNV_10940_VARHStoring all variants for relevant reports3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
42CNV_10993_FORMRSResult table for Forms4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
43CNV_10993_OBJCNTTable to have count for Objects4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
44CNV_10993_OBJECTCoding Scan 10993 Object Table4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
45CNV_10993_OBJSTSTable for Object Status4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
46CNV_10993_PRORUNCoding Scan 10993 Project Run Table4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
47CNV_10993_RESHDRCoding Scan Result header table4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
48CNV_10993_RESULTCoding Scan 10993 Search Run Result Table4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
49CNV_10993_RUNIDSHC: Search RUn ID Table3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
50CNV_10993_RUNSTRCoding Scan 10993 Search String Table3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
51CNV_10993_RUN_IDCoding Scan 10993 Search Run HeaderTable3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
52CNV_10993_SCNJBSTable for all the jobs in scan.3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
53CNV_10993_SCRPRGObjects For SAP script programs4PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
54CNV_10993_SRCHPACoding Scan 10993 Search Parameter Table3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50
55CNV_10993_SRCRSTCoding Scan 10993 Search Restriction Table3PCLPACKIDPackage Number of Transformation / Analysis Packagenvarchar50