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

74 columns | Print definition?ERP 6.0  | VERSIO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMC_CNTRLPARAMMWB: Control Parameters6VERSIOVersion Number of Objectsnvarchar40
2DMC_CNTRLPARAMCCustomizing Control Parameters2VERSIOVersion Number of Objectsnvarchar40
3DMC_FIXEDVALUEMWB: Fixed Values9VERSIOVersion Number of Objectsnvarchar40
4DMC_FIXEDVALUECCustomizing Fixed Values2VERSIOVersion Number of Objectsnvarchar40
5DMC_RULECMWB: Customizing of rules2VERSIOVersion Number of Objectsnvarchar40
6DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE12VERSIOVersion Number of Objectsnvarchar40
7DMC_VARIABLEMWB: Variables13VERSIOVersion Number of Objectsnvarchar40
TOPALE Integration Technology
8EDIPOTable for description of ports for EDI18VERSIOVersion of control recordnvarchar10
9EDIPO2Table for R/2 Port Definitions12VERSIOVersion of control recordnvarchar10
10EDIPOATable for ALE Port Definitions4VERSIOVersion of control recordnvarchar10
11EDIPODTable for File Port Definitions16VERSIOVersion of control recordnvarchar10
12EDIPOFPorts for ABAP programming interface4VERSIOVersion of control recordnvarchar10
13EDIPOITable for describing Internet ports15VERSIOVersion of control recordnvarchar10
14EDIPOXTable for Description of XML Port6VERSIOVersion of control recordnvarchar10
15EDIPOXHTable for XML HTTP Port Description4VERSIOVersion of control recordnvarchar10
TOPCapacity and Resource Planning
16/MRSS/CF999Broadcast Targets2VERSIOVersionnvarchar30
TOPData Collection
17CF001Profitability Analysis2VERSIOVersionnvarchar30
18CF050Balance sheet/P&L (FI/FILC)2VERSIOVersionnvarchar30
19CF500IDES Investment2VERSIOVersionnvarchar30
20CF501Test HGK2VERSIOVersionnvarchar30
21CF600HR Aspect2VERSIOVersionnvarchar30
22CF650Profitability 12VERSIOVersionnvarchar30
23CF665Attributes2VERSIOVersionnvarchar30
24CF701IDES Marketing2VERSIOVersionnvarchar30
25CF703IDES Profitability2VERSIOVersionnvarchar30
26CF704IDES Sales Info Sys.2VERSIOVersionnvarchar30
27CF705IDES Personnel Info2VERSIOVersionnvarchar30
28CF706IDES Legal Cons.2VERSIOVersionnvarchar30
29CF707IDES Insight2VERSIOVersionnvarchar30
30CF709Consolidation Basic2VERSIOVersionnvarchar30
31CF710IDES FPI2VERSIOVersionnvarchar30
32CF711KPI2VERSIOVersionnvarchar30
33CF712EC Integration: EVA2VERSIOVersionnvarchar30
34CF714Strategic Planning2VERSIOVersionnvarchar30
35CF715IDES:PCA-Integration2VERSIOVersionnvarchar30
36CF720Top EIS Aspect2VERSIOVersionnvarchar30
37CF752MCBlack2VERSIOVersionnvarchar30
38CF760MC Black SAP Belgium2VERSIOVersionnvarchar30
39CF7702VERSIOVersionnvarchar30
40CF800Aspekt Übung2VERSIOVersionnvarchar30
41CF880EC-BP2VERSIOVersionnvarchar30
42CF899aspect 8992VERSIOVersionnvarchar30
43CF9902VERSIOVersionnvarchar30
44CF994archive example2VERSIOVersionnvarchar30
45CF995profitab: customers2VERSIOVersionnvarchar30
46CF996profitability (rep.)2VERSIOVersionnvarchar30
47CF998example aspect 9982VERSIOVersionnvarchar30
48CF999example aspect 9992VERSIOVersionnvarchar30
49CFNNNReference structure for aspect tables SAP-EIS2VERSIOVersionnvarchar30
50KCK710Comments for FPI3VERSIOVersionnvarchar30
51KCK770Kommentar 7703VERSIOVersionnvarchar30
52KCK880EC-BP3VERSIOVersionnvarchar30
53KCK899comments for 8993VERSIOVersionnvarchar30
54KCK996comments for 9963VERSIOVersionnvarchar30
55KCK999comment table 9993VERSIOVersionnvarchar30
56TKCUMEIS: Conversion table of new fixed fields 4.05VERSIOVersionnvarchar30
57TKCVSVersion table (EC-EIS)2VERSIOVersionnvarchar30
58TKCVSTVersion texts (EC-EIS)3VERSIOVersionnvarchar30
TOPData Conversion
59DMC_ACTPDMC: Actual Parameters from Rule Call or Operator Call3VERSIOVersion Number of Objectsnvarchar40
60DMC_CNTNContainer Type for Sender Structure Name Administration8VERSIOVersion Number of Objectsnvarchar40
61DMC_COBJDMC: Conversion Object8VERSIOVersion Number of Objectsnvarchar40
62DMC_FIELDDMC: Data Field of a Structure11VERSIOVersion Number of Objectsnvarchar40
63DMC_IRULEDMC: Installed Rules4VERSIOVersion Number of Objectsnvarchar40
64DMC_OPDMC: Rule Implementation Type5VERSIOVersion Number of Objectsnvarchar40
65DMC_PARAMDMC: Formal Parameters in Rule and Operation Calls7VERSIOVersion Number of Objectsnvarchar40
66DMC_PRJCTProject Management4VERSIOVersion Number of Objectsnvarchar40
67DMC_RCALLDMC: Representation of Rule or Operator Calls6VERSIOVersion Number of Objectsnvarchar40
68DMC_RSRELDMC: Relations Between Sender/Recipient Structures6VERSIOVersion Number of Objectsnvarchar40
69DMC_RULEMapping Rules in DMC Tool3VERSIOVersion Number of Objectsnvarchar40
70DMC_SPRJCTSub-Projects (Conversion Object Administration)4VERSIOVersion Number of Objectsnvarchar40
71DMC_STREEDMC: Tree Structure for Administration of Structures9VERSIOVersion Number of Objectsnvarchar40
72DMC_STRUCTSender Structure or Recipient Structure9VERSIOVersion Number of Objectsnvarchar40
73DMC_TROBJDMC: Recoding Object Definition10VERSIOVersion Number of Objectsnvarchar40
TOPProfitability Analysis
74TKEPPLMEPARDPlanning Parameters - Reference Data13VERSIOPlan version (CO-PA)nvarchar30