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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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

77 columns | Print definition?ERP 6.0  | TFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TBVZCO-PA report library (no longer used)17TFLAGFlag to connect text in the CO-PA Information Systemnvarchar10
TOPAnalyzer
2AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics45TFLAGFlag: Textnvarchar10
TOPConsolidation
3TF90FActive Field Catalog, Consolidation45TFLAGFlag: Textnvarchar10
4TF90SBasis Field Catalog Consolidation (Fixed Fields)45TFLAGFlag: Textnvarchar10
5TF91FField Catalog, Consolidation45TFLAGFlag: Textnvarchar10
6TF9N1Master Data Table: &4TFLAGFlag to indicate textnvarchar10
TOPData Collection
7T242BCharacteristic values per characteristic5TFLAGFlag to indicate textnvarchar10
8T242PWindow management12TFLAGFlag to indicate textnvarchar10
9T2700Master data table: Region4TFLAGFlag to indicate textnvarchar10
10T2701Master data table: Brand4TFLAGFlag to indicate textnvarchar10
11T2702Master data table: Production group4TFLAGFlag to indicate textnvarchar10
12T2703Master data table: Manufacturer4TFLAGFlag to indicate textnvarchar10
13T2704Master data table: Region4TFLAGFlag to indicate textnvarchar10
14T2705Master data table: Area4TFLAGFlag to indicate textnvarchar10
15T2706Master data table: Trade channel4TFLAGFlag to indicate textnvarchar10
16T2707Master data table: Area4TFLAGFlag to indicate textnvarchar10
17T2708Master data table: Country4TFLAGFlag to indicate textnvarchar10
18T2709Master data table: Plant4TFLAGFlag to indicate textnvarchar10
19T270AMaster data table: Division4TFLAGFlag to indicate textnvarchar10
20T270BMaster data table: Product Group4TFLAGFlag to indicate textnvarchar10
21T270CMaster data table: Customer Group4TFLAGFlag to indicate textnvarchar10
22T270DMaster data table: Distribution Channel4TFLAGFlag to indicate textnvarchar10
23T270EMaster data table: Company4TFLAGFlag to indicate textnvarchar10
24T270FMaster data table: Month4TFLAGFlag to indicate textnvarchar10
25T270GMaster data table: Division4TFLAGFlag to indicate textnvarchar10
26T270HMaster data table: Region4TFLAGFlag to indicate textnvarchar10
27T270IMaster data table: Product type4TFLAGFlag to indicate textnvarchar10
28T270JMaster data table: Source of data4TFLAGFlag to indicate textnvarchar10
29T2710Master data table: Area (Countries)4TFLAGFlag to indicate textnvarchar10
30T2711Master data table: Continent4TFLAGFlag to indicate textnvarchar10
31T2712Master data table: countries4TFLAGFlag to indicate textnvarchar10
32T2713Master data table: regions4TFLAGFlag to indicate textnvarchar10
33T2714Master data table: product groups4TFLAGFlag to indicate textnvarchar10
34T2715Master data table: Continent4TFLAGFlag to indicate textnvarchar10
35T2716Master data table: Land4TFLAGFlag to indicate textnvarchar10
36T2717Master data table: State4TFLAGFlag to indicate textnvarchar10
37T2718Master data table: Prod. Group4TFLAGFlag to indicate textnvarchar10
38T2719Master data table: Sales Channel4TFLAGFlag to indicate textnvarchar10
39T271AMaster Data Table: Company4TFLAGFlag to indicate textnvarchar10
40T271BMaster Data Table: Strategic Business U4TFLAGFlag to indicate textnvarchar10
41T271CMaster Data Table: demo4TFLAGFlag to indicate textnvarchar10
42T271DMaster Data Table: xxrk14TFLAGFlag to indicate textnvarchar10
43T271EStammdatentabelle: T-Segment4TFLAGFlag für Textanbindungnvarchar10
44T271FStammdatentabelle: T-Business Unit5TFLAGFlag für Textanbindungnvarchar10
45T271GStammdatentabelle: T-Division5TFLAGFlag für Textanbindungnvarchar10
46T271HStammdatentabelle: T-Product Line5TFLAGFlag für Textanbindungnvarchar10
47T271IMaster data table: town xx5TFLAGFlag to indicate textnvarchar10
48T2720Master data table: xarea (Description)4TFLAGFlag to indicate textnvarchar10
49T2721Master data table: CITY (X)5TFLAGFlag to indicate textnvarchar10
50T2722Master data table: PRODUCTS (X)7TFLAGFlag to indicate textnvarchar10
51T2723Master data table: MAYOR (X)5TFLAGFlag to indicate textnvarchar10
52T2737Master Data Table: Customer Group 004TFLAGFlag to indicate textnvarchar10
53T2738Master Data Table: Customer 005TFLAGFlag to indicate textnvarchar10
54T27NNMaster Data Table: &4TFLAGFlag to indicate textnvarchar10
55TKAFField catalog for Accounting46TFLAGFlag: Textnvarchar10
56TKCFSAP-EIS Field Catalog45TFLAGFlag: Textnvarchar10
57TKCHWSAP-EIS: Hierarchy data12TFLAGFlag to indicate textnvarchar10
58TKCKKey figures16TFLAGFlag: Textnvarchar10
59TKCSBasic field catalog SAP-EIS (fixed fields)45TFLAGFlag: Textnvarchar10
TOPData Transfer
60T2420System control parameters4TFLAGFlag to indicate textnvarchar10
TOPIncentive and Commission Management ICM
61TCACSFCommissions: Field Catalog Search46TFLAGFlag: Textnvarchar10
TOPInformation System
62T804CReport Writer: Special Fields7TFLAGIndicator: Field is required for text routinenvarchar10
TOPInvestment Programs
63TAIFIM Drilldown: Characteristic Catalog46TFLAGFlag: Textnvarchar10
TOPPerformance Assessment Workbench
64SLS_PRESPAW - Person Results Structure36TFLAGPAW - 'Transfered to HR' Flag - as checkbox ('X' = yes)nvarchar10
TOPProfitability Analysis
65TJBFField Catalog IS-B-PA45TFLAGFlag: Textnvarchar10
66TJBSBase Field Catalog IS-B-PA (Fixed Fields)45TFLAGFlag: Textnvarchar10
67TKEB1Report Management6TFLAGFlag to indicate textnvarchar10
68TKEFCO-PA field catalog45TFLAGFlag: Textnvarchar10
69TKESCO-PA Basis Field Catalog (fixed fields)45TFLAGFlag: Textnvarchar10
70TKES1Row/column structures8TFLAGIndicator: Field is required for text routinenvarchar10
TOPRisk Analysis
71JBRRMTKEFRM: Copy of CO-PA Field Catalog45TFLAGFlag: Textnvarchar10
72JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures45TFLAGFlag: Textnvarchar10
73JBRTKCHABKRM: Backup Table for Characteristic Hierarchies11TFLAGFlag to indicate textnvarchar10
TOPText Retrieval and Information Extraction
74SRETIDLACDIndexes of client-specific applications13TFLAGTransport flag (import flag)nvarchar10
75SRETIDLACIIndexes of cross-client applications12TFLAGTransport flag (import flag)nvarchar10
TOPTreasury
76TTMRFField catalog for Risk Management45TFLAGFlag: Textnvarchar10
77TTMRSBasis field catalog Risk Management (fixed fields)45TFLAGFlag: Textnvarchar10