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

41 columns | Print definition?ERP 6.0  | SAPRELEASE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_AODSMAPMap AOF package versions to valid DS versions1SAPRELEASESAP R/3 Releasenvarchar100
2CNVMBTDESTVERSMBT: RFC destination versions and settings16SAPRELEASERelease of SAP Systemnvarchar40
3CNVMBTVERS_CTRLMBT: RFC destination versions and settings16SAPRELEASERelease of SAP Systemnvarchar40
4CNV_LM_BLACKLISTCritical generation errors in DMIS components7SAPRELEASESAP Releasenvarchar100
5CNV_LM_WHITELISTWhitelist for generation errors in DMIS components6SAPRELEASESAP Releasenvarchar100
6LAW2D_SYSTEMLAW 2.0 system table11SAPRELEASELAW 2.0 System Releasenvarchar120
7LAW2D_USMM_SYSTLAW 2.0 USMM result systems9SAPRELEASELAW 2.0 System Releasenvarchar120
TOPBusiness Consolidation
8UCD0000User-definable Data Types: Generated Programs5SAPRELEASESAP Releasenvarchar100
TOPBusiness Framework Architecture
9TERPFORMLISTList of New Forms8SAPRELEASESAP Releasenvarchar100
10TERPSOFTSWITCHESSoft Switches for PDF-based Forms6SAPRELEASESAP Releasenvarchar100
TOPBusiness Partner
11TPZ41Use of Protected Applications5SAPRELEASESAP Releasenvarchar100
TOPClientServer Technology
12PATCHHISTHistory of Kernel Patch2SAPRELEASESAP Releasenvarchar100
TOPCondition Technique
13/SAPCND/R3COMPATR/3 Compatibility Settings6SAPRELEASESAP Releasenvarchar100
TOPContent Activation
14BSANLY_BCCREP_HBCC Repository Content Bundles3SAPRELEASESAP Releasenvarchar100
TOPCustom Development Management Cockpit
15CNVCDMC_SPLEVELSSP levels2SAPRELEASESAP Releasenvarchar100
TOPCustomizing Tools Techniques
16TCTM_LCVALValidity Limits and Component Priorities4SAPRELEASESAP Releasenvarchar100
17TCTM_PCRComponent and Release Values for Physical Objects4SAPRELEASESAP Releasenvarchar100
TOPData Conversion
18DMC_CNTNContainer Type for Sender Structure Name Administration13SAPRELEASERelease of SAP Systemnvarchar40
TOPDatabase Monitors
19INFCFGRESMMaster result table for Informix/OS check program3SAPRELEASERelease of SAP Systemnvarchar40
20INFCFGTHRE'Thresholds' for Informix/OS configuration check program1SAPRELEASERelease of SAP Systemnvarchar40
TOPFinancial Accounting
21FERC_R0Execution history32SAPRELEASESAP Releasenvarchar100
TOPIndustry Solution Catch Weight Management
22/CWM/FUNC_EXCLDeactivated Function Modules in Catch Weight Management3SAPRELEASESAP Releasenvarchar100
23/CWM/REPO_EXCLDeactivated Reports in Catch Weight Management5SAPRELEASESAP Releasenvarchar100
24/CWM/TRAN_EXCLDeactivated Transactions in Catch Weight Management4SAPRELEASESAP Releasenvarchar100
25/CWM/TREE_EXCLDeactivated Structures in Catch-Weight/OIL (IMG and S000)5SAPRELEASESAP Releasenvarchar100
TOPMaterial Master
26WER_SAPRELEASE_SSap Release2SAPRELEASESAP Releasenvarchar100
TOPMonitoring
27ARCH_OHEADArchive File Overhead2SAPRELEASESAP Releasenvarchar40
TOPSAP Business Workflow
28SWBRULEHDRWF: Header Table for Managing a Rule System13SAPRELEASERelease of SAP Systemnvarchar40
TOPService Data Download
29/SDF/SWCM_CVERSDRelease status of software components (CVERS) for DEV2SAPRELEASESAP Releasenvarchar100
30/SDF/SWCM_CVERSPRelease status of software components (CVERS) for PRD2SAPRELEASESAP Releasenvarchar100
31/SDF/SWCM_CVERSQRelease status of software components (CVERS) for QAS2SAPRELEASESAP Releasenvarchar100
TOPSmart Forms
32STXFVARISmart Forms: Variants - Internal Information3SAPRELEASERelease of SAP Systemnvarchar40
TOPSwitch Framework Tools
33SFW_BFSDEPDependent Software Components of a Business Function Set3SAPRELEASESAP Releasenvarchar100
34SFW_COMPONENTMapping Software Component <-> Business Function Set3SAPRELEASESAP Releasenvarchar100
TOPUpgrade - General
35MERGEHRequest List of the Transport Merger (Header)5SAPRELEASESAP Releasenvarchar100
36PUTTBSubstituted Tables of a Release1SAPRELEASESAP Releasenvarchar100
37PUTTBCExchange Tables for Each SAP Release and Component1SAPRELEASESAP Releasenvarchar100
38PUTTBHHistory of PUTTB Generation (from PUTTBC)4SAPRELEASESAP Releasenvarchar100
39PUTTBXExtension of Puttb1SAPRELEASESAP Releasenvarchar100
40RELCOMPMAPExtend Table RELEASEMAP by Components2SAPRELEASESAP Releasenvarchar100
41RELEASEMAPMapping Table for Bit Field: (G)TODIR-RELMAP2SAPRELEASESAP Releasenvarchar100