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

39 columns | Print definition?ERP 6.0  | CHGTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SOMO/JOBMON11Job schedule information21CHGTIMEnvarchar60
2CNVCMIS_A_20MAILTable to check mail information for CMIS CCCC7CHGTIMEModification Timenvarchar60
3CNVCMIS_A_20_RESAnalysis results of Cross-Client Customizing Comparison26CHGTIMEModification Timenvarchar60
4CNVCMIS_A_20_WLWork list table for Cross-Client Customizing Comparison22CHGTIMEModification Timenvarchar60
5CNVCMIS_A_20_WLHHeader data for Cross-Client Customizing Comparison9CHGTIMEModification Timenvarchar60
6DD02BDD: Header for Structured Objects5CHGTIMELast Changed Atnvarchar60
7FMBASOBJNR_TRACETrace for table FMBASOBJNR17CHGTIMETime at which the object was changednvarchar60
8FMPEP_ADM_SVSession Variants administration14CHGTIMETime at which the object was changednvarchar60
TOPAdditional Material Functions
9WSD_INDXSystem Table INDX8CHGTIMETIME Data Element for SYSTnvarchar60
TOPBRFplus - ABAP-Based Business Rules
10SFBMHDRFormula Builder Methods: Header9CHGTIMELast changed atnvarchar60
TOPBudgeting
11BUCC_LIBConsistency Checks - Library10CHGTIMETime at which the object was changednvarchar60
12BUCC_RULEConsistency Checks - Rules11CHGTIMETime at which the object was changednvarchar60
13BUKF_KFKey Figures - Key Figure9CHGTIMETime at which the object was changednvarchar60
14FMBHFunds management budget header (entry documents)38CHGTIMETime at which the object was changednvarchar60
15FMBS_BSBudget structures10CHGTIMETime at which the object was changednvarchar60
16FMBUDTXTBudget texts register19CHGTIMETime at which the object was changednvarchar60
17FMCECVGRPCover Groups16CHGTIMETime at which the object was changednvarchar60
18FMHIESETTINGSSettings for Budget Hierarchies25CHGTIMETime at which the object was changednvarchar60
19FMPEPLAYFMPEP - Layout Customizing Settings - Basic Data9CHGTIMETime at which the object was changednvarchar60
20FMRBBOBJECTSMaster Data For Revenue Increasing the Budget: RIB Objects12CHGTIMETime at which the object was changednvarchar60
TOPBudgeting and Availability Control
21GMRBBOBJECTSMaster Data For Revenue Increasing the Budget: RIB Objects8CHGTIMETime at which the object was changednvarchar60
TOPBusiness Accounting
22URCORD0CRealignment Requests11CHGTIMETime of Last Changenvarchar60
23URCRUN0CRealignment Runs18CHGTIMETime of Last Changenvarchar60
TOPCondition
24BKK81Bank Condition35CHGTIMETime Changednvarchar60
25BKK82Bank Condition Item36CHGTIMETime Changednvarchar60
26BKK84Bank Account - Individual Condition37CHGTIMETime Changednvarchar60
27BKK85Bank Account - Individual Condition Position39CHGTIMETime Changednvarchar60
TOPDownstream
28TOI0_BCSETSBC-Sets to be activated externally / log for activated9CHGTIMESystem Timenvarchar60
TOPEvent Management
29/SAPTRX/AOTREFReference between application objects and event handlers18CHGTIMETime of Last Changenvarchar60
TOPGRC Access Control Plug-In
30/VIRSA/FUNCCHGLGFunction Change Log7CHGTIMEChange Timenvarchar60
31/VIRSA/RISKCHGLGRisk Change Log7CHGTIMEChange Timenvarchar60
32/VIRSA/TCDCHGLOGTransaction Change Log6CHGTIMEChange Timenvarchar60
TOPProfitability Analysis
33TKENC1CO-PA Realignments: Realignment Runs8CHGTIMETime last changednvarchar60
TOPSCM Basis
34CIF_MD_CHANGESChanges to BOM, Routing and Production Version16CHGTIMETime of Last Changenvarchar60
35CIF_PPM_CHANGEDPPM: Change Transfer - Changed Production Versions7CHGTIMETime of Last Changenvarchar60
TOPService Data Download
36/SOMO/JOSCHEDLJob scheduling table for business process monitoring41CHGTIMEnvarchar60
TOPTransport Management System
37TSYREQUESTCorrelation of Transport Requests Between Systems9CHGTIMETime Stamp in CTSnvarchar140
TOPWithout Description
38CCMSBICONFRepository for Configuration Data11CHGTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
39CCMSBICONFTYPESConfiguration Types5CHGTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150