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

53 columns | Print definition?ERP 6.0  | AREAID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAccounting Engine
1/EACC/CONFIGS_PLConfigurations for Line Item Persistence23AREAIDRegistration Identificationnvarchar220
2/EACC/TDR_STEPSDerivation Steps6AREAIDRegistration Identificationnvarchar220
TOPApplication Framework
3MDG_MDF0010Area IDs in Master Data Environment2AREAIDMaster Data: Application Areanvarchar220
4MDG_MDF2001Validity of Master Data Characteristics in Application Areas2AREAIDMaster Data: Application Areanvarchar220
5MDG_MDF2002Basis Characteristics in Master Data Environment2AREAIDMaster Data: Application Areanvarchar220
6MDG_MDF2005Properties of Master Data Fields2AREAIDMaster Data: Application Areanvarchar220
7MDG_MDF2006Properties of Master Data Fields (Language-dep. Texts)2AREAIDMaster Data: Application Areanvarchar220
8MDG_MDF2007Compounds of Master Data Fields2AREAIDMaster Data: Application Areanvarchar220
9MDG_MDF2030Restrictions on Master Data Hierarchies2AREAIDMaster Data: Application Areanvarchar220
TOPBusiness Analytics
10UAB_AUDIT_TRAILTable for Audit Trail Function3AREAIDFIN Master Data: Application Areanvarchar220
11UALAYOUTLayout Table2AREAIDFIN Master Data: Application Areanvarchar220
12UALAYOUTTText Table for UALAYOUT2AREAIDFIN Master Data: Application Areanvarchar220
13UAPROJECTTransparent Table to Store Costing Projects11AREAIDFIN Master Data: Application Areanvarchar220
14UAREP_CONFIG1Configuration for UA Reports2AREAIDFIN Master Data: Application Areanvarchar220
15UAWORKSETTransparent Table to Store Working Environments of Costing12AREAIDFIN Master Data: Application Areanvarchar220
TOPClinical System
16N1BCP2URLBasic Cat.: Catalog Item to URL Assignment5AREAIDBasic Catalog: Work Area Keynvarchar40
17N1BCSOBSOLETE: Basic Cat.: Basic Catalog Set4AREAIDBasic Catalog: Work Area Keynvarchar40
18N1BCSHBasic Catalog Set: Header Data4AREAIDBasic Catalog: Work Area Keynvarchar40
19N1BCUFAVHBasic Cat.: User-Specific Favorites - Header Data3AREAIDBasic Catalog: Work Area Keynvarchar40
TOPFinancials Basis
20/EACC/TLI4000Context of Field Name, Info Object, D Elment, D Srce per D B3AREAIDFIN Master Data: Application Areanvarchar220
21ACCAREAIDCOMPArea ID of a Technical Component5AREAIDRegistration Identificationnvarchar220
22ACCDBS0CData Basis3AREAIDRegistration Identificationnvarchar220
23FINB_DMT_CONFIGData Retention, Configuration Object of Totals Persistence5AREAIDRegistration Identificationnvarchar220
24UGCM0010FIN Change Management: Registered Applications3AREAIDFIN Master Data: Application Areanvarchar220
25UGCM0100FIN Change Management: Parameterization of the Generator3AREAIDFIN Master Data: Application Areanvarchar220
26UGMD0010FIN Master Data: Area IDs3AREAIDFIN Master Data: Application Areanvarchar220
27UGMD2001FIN Master Data: Validity of Characteristics in Areas3AREAIDFIN Master Data: Application Areanvarchar220
28UGMD2002FIN Master Data: Basis Characteristics3AREAIDFIN Master Data: Application Areanvarchar220
29UGMD2005FIN Master Data: Field Properties3AREAIDFIN Master Data: Application Areanvarchar220
30UGMD2006FIN Master Data: Field Properties - Language-dep. Texts3AREAIDFIN Master Data: Application Areanvarchar220
31UGMD2007FIN Master Data: Field Compounds3AREAIDFIN Master Data: Application Areanvarchar220
32UGMD2020FIN Master Data: Assignment of RFC Destinations to AREAIDs3AREAIDFIN Master Data: Application Areanvarchar220
33UGMD2030FIN Master Data: Restrictions on Hierarchies3AREAIDFIN Master Data: Application Areanvarchar220
TOPQualifications and Requirements
34T77CSSuitability Ranges for Career and Succession Planning2AREAIDTwo digit numbernvarchar20
TOPServices
35FINB_COND_AREAIDConditions per Area ID3AREAIDRegistration Identificationnvarchar220
36FINB_KF_CHAR_KEYKey Fields Generated Table Types3AREAIDRegistration Identificationnvarchar220
37FINB_KF_CHAR_STRDDIC Structures According to Hash Values of their Components3AREAIDRegistration Identificationnvarchar220
38FINB_KF_CHAR_TBLDDIC Table Types According to Hash Vals of their Components3AREAIDRegistration Identificationnvarchar220
39FINB_PR_TCHILDChild Persistence Objects in Hierarchy3AREAIDRegistration Identificationnvarchar220
40FINB_PR_TFIELDSFields of a Persistence Object3AREAIDRegistration Identificationnvarchar220
41FINB_PR_TINDIndexes3AREAIDRegistration Identificationnvarchar220
42FINB_PR_TIND_FDSIndex fields3AREAIDRegistration Identificationnvarchar220
43FINB_PR_TJOINSJoin conditions3AREAIDRegistration Identificationnvarchar220
44FINB_PR_TMAPField Assignment Read Structure - Persistence Object3AREAIDRegistration Identificationnvarchar220
45FINB_PR_TOBJSPersistence Objects3AREAIDRegistration Identificationnvarchar220
46FINB_PR_TOBJSTBusiness Names in the Persistence Objects3AREAIDRegistration Identificationnvarchar220
47FINB_RP_CONFIG1Customizing by Report4AREAIDRegistration Identificationnvarchar220
48FINB_RP_CONFIG3Technical Structure Assignment <--> Long Text3AREAIDRegistration Identificationnvarchar220
49FINB_RT_TABRuntime Tables3AREAIDRegistration Identificationnvarchar220
50FINB_RT_TAB_FLDRuntime Tables3AREAIDRegistration Identificationnvarchar220
51FINB_RT_TKEYKey of Runtime Tables3AREAIDRegistration Identificationnvarchar220
52FINB_RT_TKEY_FLDKey of Runtime Tables3AREAIDRegistration Identificationnvarchar220
TOPWorkbench Tools Editors, Painters, Modelers
53WBTOOLTYPEVisualization types for tools17AREAIDArea ID in Multi-Area Windownvarchar100