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

38 columns | Print definition?ERP 6.0  | ROLNM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAnalyzer
1AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics3ROLNMData element (semantic domain)nvarchar300
2JBRHISPHBAUMSTree Structure for Deactivated Portfolio Hierarchies23ROLNMData element (semantic domain)nvarchar300
3JBRHISPHTEXTRM: Portfolio Texts for Deactivated Portfolio Hierachy9ROLNMData element (semantic domain)nvarchar300
TOPBusiness Planning and Simulation
4UPF_EXITPPlanning: Data Elements - Exits6ROLNMData element (semantic domain)nvarchar300
TOPConsolidation
5TF90FActive Field Catalog, Consolidation3ROLNMData element (semantic domain)nvarchar300
6TF90QActive Attributes in Consolidation4ROLNMData element (semantic domain)nvarchar300
7TF90QSAttributes Basis Field Catalog Consolidation (Fixed Fields)4ROLNMData element (semantic domain)nvarchar300
8TF90SBasis Field Catalog Consolidation (Fixed Fields)3ROLNMData element (semantic domain)nvarchar300
9TF91FField Catalog, Consolidation3ROLNMData element (semantic domain)nvarchar300
10TF91QAttributes in Consolidation4ROLNMData element (semantic domain)nvarchar300
TOPData Collection
11TKAFField catalog for Accounting4ROLNMData element (semantic domain)nvarchar300
12TKAQGeneral accounting attributes5ROLNMData element (semantic domain)nvarchar300
13TKCBOREC-EIS: Assignment DDIC - Objects in BOR1ROLNMData element (semantic domain)nvarchar300
14TKCFSAP-EIS Field Catalog3ROLNMData element (semantic domain)nvarchar300
15TKCKKey figures3ROLNMData element (semantic domain)nvarchar300
16TKCQAttributes SAP-EIS4ROLNMData element (semantic domain)nvarchar300
17TKCQSAttributes of basic field catalog SAP-EIS (fixed fields)4ROLNMData element (semantic domain)nvarchar300
18TKCSBasic field catalog SAP-EIS (fixed fields)3ROLNMData element (semantic domain)nvarchar300
TOPIncentive and Commission Management ICM
19TCACSFCommissions: Field Catalog Search4ROLNMData element (semantic domain)nvarchar300
TOPInformation System
20TKAF_USER_APPD_KField Catalog for Customer Key Figures3ROLNMData element (semantic domain)nvarchar300
21TKAF_USER_APPD_MField Catalog for Customer Characteristics3ROLNMData element (semantic domain)nvarchar300
TOPInteractive Drilldown Reporting
22TRSTHVBRST directory of hierarchies5ROLNMData element (semantic domain)nvarchar300
23TRSTHVTBRST Texts for hierarchies6ROLNMData element (semantic domain)nvarchar300
24TRSTHV_VPBRST Repository of Hierarchies - Virtual InfoProvider6ROLNMData element (semantic domain)nvarchar300
TOPInvestment Programs
25TAIFIM Drilldown: Characteristic Catalog4ROLNMData element (semantic domain)nvarchar300
TOPProfitability Analysis
26TJBFField Catalog IS-B-PA3ROLNMData element (semantic domain)nvarchar300
27TJBSBase Field Catalog IS-B-PA (Fixed Fields)3ROLNMData element (semantic domain)nvarchar300
28TKEFCO-PA field catalog3ROLNMData element (semantic domain)nvarchar300
29TKEHACO-PA: Fields with Special Handling3ROLNMData element (semantic domain)nvarchar300
30TKESCO-PA Basis Field Catalog (fixed fields)3ROLNMData element (semantic domain)nvarchar300
TOPReporting
31MCSHIERKHeader of general hierarchy5ROLNMData element of the general hierarchynvarchar300
TOPRisk Analysis
32JBRDIFTKEFRM Compared to CO-PA - Fields that are to be changed3ROLNMData element (semantic domain)nvarchar300
33JBRPHBAUMSStorage of Portfolio Hierarchy23ROLNMData element (semantic domain)nvarchar300
34JBRRMTKEFRM: Copy of CO-PA Field Catalog3ROLNMData element (semantic domain)nvarchar300
35JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures3ROLNMData element (semantic domain)nvarchar300
36JBRSVPHTEXTRM: Portfolio Texts for Saved Datasets (Backtesting)8ROLNMData element (semantic domain)nvarchar300
TOPTreasury
37TTMRFField catalog for Risk Management3ROLNMData element (semantic domain)nvarchar300
38TTMRSBasis field catalog Risk Management (fixed fields)3ROLNMData element (semantic domain)nvarchar300