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

40 columns | Print definition?ERP 6.0  | MCAPP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TFCSPermissible Source Tables per Application1MCAPPNumber of applicationnvarchar20
2TMCBUpdate groups4MCAPPNumber of applicationnvarchar20
3TMCSBLIS Information Structures2MCAPPNumber of applicationnvarchar20
TOPData Collection
4TFCAPermitted Field Catalogs for Each Application2MCAPPNumber of applicationnvarchar20
5TMC21Application-Specific Parameters for Generating Updates1MCAPPNumber of applicationnvarchar20
6TMC25Valid Hierarchies for Formulas/Conditions1MCAPPNumber of applicationnvarchar20
7TMC26Texts for Valid Hierarchies for Formulas/Requirements2MCAPPNumber of applicationnvarchar20
8TMC4Global Control Elements: LIS Info Structure7MCAPPNumber of applicationnvarchar20
9TMC4UTransport Table for Info Structure Data3MCAPPNumber of applicationnvarchar20
10TMC6UValid Unit Conversion: Source Field/Statistics Field1MCAPPNumber of applicationnvarchar20
11TMC7K_CHECKDefinition of the Char. Chain f. Checking the Info Structure1MCAPPNumber of applicationnvarchar20
12TMCAEFeatures of Application2MCAPPNumber of applicationnvarchar20
13TMCAPApplications: Logistics Information System2MCAPPNumber of applicationnvarchar20
14TMCATApplication Text: Logistics Information System3MCAPPNumber of applicationnvarchar20
15TMCLVBWTransaction Key for SAP BW3MCAPPNumber of applicationnvarchar20
16TMCLVBWTTexts for Transaction Key for SAP BW4MCAPPNumber of applicationnvarchar20
17TMCTCLIS Transaction Code Control4MCAPPNumber of applicationnvarchar20
18TMCUSParameters for Standard Analyses in LIS3MCAPPNumber of applicationnvarchar20
19TMCW3Table for Counter Readings of Info Structures Re-Setup2MCAPPNumber of applicationnvarchar20
TOPInvoice Verification
20TMCW3_06Hold Table Counter Readings BW Recompil. for IV (Appl. '06')2MCAPPNumber of applicationnvarchar20
TOPLogistics Information System LIS
21MCEX_COLLR_INDEXIndex for Executed Logistics Extraction Collective Runs2MCAPPNumber of applicationnvarchar20
22MCEX_DELTA_BACKBackup Table for Logistics Extraction Queues (MCEX*)3MCAPPNumber of applicationnvarchar20
23TMCEXACTLO Data Extraction: Activate Data Sources/Update7MCAPPNumber of applicationnvarchar20
24TMCEXCFSLO Data Extraction: Field Status of Communication Structures5MCAPPNumber of applicationnvarchar20
25TMCEXEVELO Data Extraction: Events/Extract Structures4MCAPPNumber of applicationnvarchar20
26TMCEXLOGLO Data Extraction: Logfile Control of Applications2MCAPPNumber of applicationnvarchar20
27TMCEXMPMultiprocess Modes Logistic Extraction1MCAPPNumber of applicationnvarchar20
28TMCEXMPTMultiprocess Modes Logistic Extraction Texts2MCAPPNumber of applicationnvarchar20
29TMCEXPRAControl Table for LO Extraction-XPRA RMCSBWXP_COM2MCAPPNumber of applicationnvarchar20
30TMCEXUPDLO Data Extraction: Update Control of Applications2MCAPPNumber of applicationnvarchar20
TOPRemaining Beverage - Obsolete Objects
31/BEV1/BWTMCEXCFSLO Data Extraction: Field Status of Communication Structures5MCAPPNumber of applicationnvarchar20
TOPReporting
32MCSIFile for Storage of Selection Versions (INDX)3MCAPPNumber of applicationnvarchar20
33MCSIDIRDirectory of MCSI Entries3MCAPPNumber of applicationnvarchar20
34TMC7Standard Analyses in Logistics Controlling2MCAPPNumber of applicationnvarchar20
35TMC7TAnalysis Descriptions3MCAPPNumber of applicationnvarchar20
36TMC8Predefined Key Figures per Analysis3MCAPPNumber of applicationnvarchar20
37TMC9Standard Drill-Down in Standard Analyses3MCAPPNumber of applicationnvarchar20
38TMCEXNon-Displayable Key Figures per Standard Analysis3MCAPPNumber of applicationnvarchar20
TOPRetail Information System RIS
39TMCWBDo not use!3MCAPPNumber of applicationnvarchar20
40TMCWBTDo not use!3MCAPPNumber of applicationnvarchar20