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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

80 columns | Print definition?ERP 6.0  | TXT20

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/GL1TIndex master Description4TXT20Text (20 Characters)nvarchar200
2/ATL/GL2TCalculation Method Descriptions3TXT20Text (20 Characters)nvarchar200
3CNV_20100_SKATCNV backup copy for implementation of country-spec. CoA - ID6TXT20G/L account short textnvarchar200
4T028EText Table for T028D4TXT20Text, length 40nvarchar400
5T082EDescription asset views4TXT20View namenvarchar200
6T241EText to sort reports into report portfolio7TXT20Short text for hierarchy nodenvarchar200
7T241HText for report portfolio hierarchy5TXT20Short text for hierarchy nodenvarchar200
8T241SSender field description5TXT20Description of objectnvarchar200
9TSAKRCreate G/L account with reference4TXT20G/L account short textnvarchar200
10ZSAFIZuordnung Sako-Fipo4TXT20Sachkontenkurztextnvarchar200
TOPAnalyzer
11I82NNRM texts for characteristics: &4TXT20Descriptionnvarchar200
TOPBank Accounting
12TCCLGTPayment cards: Settlement run log (texts)4TXT20Payment Cards: Short Text for a Settlement Runnvarchar200
TOPBasic Functions
13GLACCREFIG/L Account Master Record: Create with Reference6TXT20G/L account short textnvarchar200
14T028IText Table for T028H6TXT20Text, length 40nvarchar400
15T082TNames For Field Groups4TXT20Field group namenvarchar200
TOPConsolidation
16/1SAP1/FC_TFG300Master Data Table: Type of ConsUnit4TXT20Descriptionnvarchar200
17/1SAP1/FC_TFG301Master Data Texts: Tax Equal. Indicator4TXT20Descriptionnvarchar200
18TF9N2Master Data Texts: &4TXT20Descriptionnvarchar200
TOPData Collection
19T241BDescription of Characteristic Values6TXT20Description of objectnvarchar200
20T2800Master data texts: Region4TXT20Descriptionnvarchar200
21T2801Master data texts: Brand4TXT20Descriptionnvarchar200
22T2802Master data texts: Production group4TXT20Descriptionnvarchar200
23T2803Master data texts: Manufacturer4TXT20Descriptionnvarchar200
24T2804Master data texts: Region4TXT20Descriptionnvarchar200
25T2805Master data texts: Area4TXT20Descriptionnvarchar200
26T2806Master data texts: Trade channel4TXT20Descriptionnvarchar200
27T2807Master data texts: Area4TXT20Descriptionnvarchar200
28T2808Master data texts: Country4TXT20Descriptionnvarchar200
29T2809Master data texts: Plant4TXT20Descriptionnvarchar200
30T280AMaster data texts: Division4TXT20Descriptionnvarchar200
31T280BMaster data texts: Product Group4TXT20Descriptionnvarchar200
32T280CMaster data texts: Customer Group4TXT20Descriptionnvarchar200
33T280DMaster data texts: Distribution Channel4TXT20Descriptionnvarchar200
34T280EMaster data texts: Company4TXT20Descriptionnvarchar200
35T280FMaster data texts: Month4TXT20Descriptionnvarchar200
36T280GMaster data texts: Division4TXT20Descriptionnvarchar200
37T280HMaster data texts: Region4TXT20Descriptionnvarchar200
38T280IMaster data texts: Product type4TXT20Descriptionnvarchar200
39T280JMaster data texts: Source of data4TXT20Descriptionnvarchar200
40T2810Master data texts: Area (Countries)4TXT20Descriptionnvarchar200
41T2811Master data texts: continents4TXT20Descriptionnvarchar200
42T2812Master data texts: countries4TXT20Descriptionnvarchar200
43T2813Master data texts: regions4TXT20Descriptionnvarchar200
44T2814Master data texts: product groups4TXT20Descriptionnvarchar200
45T2815Master data texts: Continent4TXT20Descriptionnvarchar200
46T2816Master data texts: Land4TXT20Descriptionnvarchar200
47T2817Master data texts: State4TXT20Descriptionnvarchar200
48T2818Master data texts: Prod. Group4TXT20Descriptionnvarchar200
49T2819Master data texts: Sales Channel4TXT20Descriptionnvarchar200
50T281AMaster Data Table: Company4TXT20Descriptionnvarchar200
51T281BMaster Data Table: Strategic Business U4TXT20Descriptionnvarchar200
52T281CMaster Data Texts: demo4TXT20Descriptionnvarchar200
53T281DMaster Data Table: xxrk14TXT20Descriptionnvarchar200
54T281EStammdatentexte: T-Segment4TXT20Bedeutungnvarchar200
55T281FStammdatentexte: T-Business Unit4TXT20Bedeutungnvarchar200
56T281GStammdatentexte: T-Division4TXT20Bedeutungnvarchar200
57T281HStammdatentexte: T-Product Line4TXT20Bedeutungnvarchar200
58T281IMaster data texts: town xx4TXT20Descriptionnvarchar200
59T2820Master data texts: xarea (Description)4TXT20Descriptionnvarchar200
60T2821Master data texts: CITY (X)4TXT20Descriptionnvarchar200
61T2822Master data texts: PRODUCTS (X)4TXT20Descriptionnvarchar200
62T2823Master data texts: MAYOR (X)4TXT20Descriptionnvarchar200
63T2837Master Data Texts: Customer Group 004TXT20Descriptionnvarchar200
64T2838Master Data Texts: Customer 004TXT20Descriptionnvarchar200
65T28NNMaster Data Texts: &4TXT20Descriptionnvarchar200
66TKCHNTSAP-EIS: Hierarchy node texts7TXT20Descriptionnvarchar200
67TKCODTSAP-EIS: Texts for object types in object list3TXT20Text (20 Characters)nvarchar200
TOPData Retention Tool
68TXW_S_BSEGRetrieve BSEG from archive121TXT20Account short textnvarchar200
TOPFinancial Accounting
69SKATG/L Account Master Record (Chart of Accounts: Description)5TXT20G/L account short textnvarchar200
70T053BSelection Rules for Payment Advices (Texts)4TXT20Textnvarchar250
71T053SClassification of Payment Differences (Texts)5TXT20Reason Code Short Textnvarchar200
TOPGeneral status management
72TBO01Language-specific values for object type6TXT20Text, length 20nvarchar200
TOPGL transfer
73TBKKC_GLACC_TEXTGL-ACCOUNT-TEXT5TXT20G/L account short textnvarchar200
TOPInformation system
74PSOBKFIBestände Kassenbuch-Tagesabschluss11TXT20Text in Länge 20nvarchar200
TOPInvestment Programs
75TAIGSKey figure key for scale (language-dependent)6TXT20Text (20 Characters)nvarchar200
TOPLocalization
76IDCN_GLACCATTRTG/L account time-depen.attributes-texts(CN)6TXT20G/L account short textnvarchar200
77IDCN_ZJFSKIPACCTSkip G/L Account from P&L Account Closing Posting (Text)5TXT20G/L account short textnvarchar200
TOPMarket Risk Analysis
78I8200IS-B: RM Characteristics : Organisation INT/EXT4TXT20Descriptionnvarchar200
TOPOverhead Cost Orders
79TRFBTLanguage-dep. values for reference document type4TXT20Text (20 Characters)nvarchar200
TOPRisk Analysis
80I82NNKIS-B: RM Texts for Characteristics : &4TXT20Descriptionnvarchar200