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

73 columns | Print definition?ERP 6.0  | TXT40

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T241HText for report portfolio hierarchy6TXT40Hierarchy node long textnvarchar400
2T5B62Text Table Collective Agreements (B)4TXT40Text, 40 Characters Longnvarchar400
3T5B63Joint Commissions (B)4TXT40Text, 40 Characters Longnvarchar400
TOPAnalyzer
4I82NNRM texts for characteristics: &5TXT40Long textnvarchar400
TOPBank Accounting
5TCCLGTPayment cards: Settlement run log (texts)5TXT40Payment Cards: Long Text for a Settlement Runnvarchar400
TOPBasic Functions
6TINSOFailed Payment Transactions and Charges17TXT40Document textnvarchar400
TOPBulk Distribution Requirements Planning
7OIIGMMETSGMM: General meter history record type text4TXT40Long textnvarchar400
8OIIGMMTSGMM: General meter type text4TXT40Long textnvarchar400
TOPConsolidation
9/1SAP1/FC_TFG300Master Data Table: Type of ConsUnit5TXT40Long textnvarchar400
10/1SAP1/FC_TFG301Master Data Texts: Tax Equal. Indicator5TXT40Long textnvarchar400
11TF9N2Master Data Texts: &5TXT40Long textnvarchar400
TOPContract Accounts Receivable and Payable
12TFK007XTName of External Tax Type4TXT40Text, length 40nvarchar400
13TFK042AXTPayment Program: Bank Selection - IDs (Texts)4TXT40Text, 40 Characters Longnvarchar400
14TFK043TFI-CA: Tolerances for cash discount and payment differences4TXT40Text, length 40nvarchar400
15TFK055TField Groups for Document Change (Description)4TXT40Text, length 40nvarchar400
16TFK100ITCode of Issuer4TXT40Text for Code of Issuernvarchar400
17TFKFBMTStandard function modules3TXT40Text Field of Length 60nvarchar600
TOPData Collection
18T2800Master data texts: Region5TXT40Long textnvarchar400
19T2807Master data texts: Area5TXT40Long textnvarchar400
20T2808Master data texts: Country5TXT40Long textnvarchar400
21T2809Master data texts: Plant5TXT40Long textnvarchar400
22T280AMaster data texts: Division5TXT40Long textnvarchar400
23T280BMaster data texts: Product Group5TXT40Long textnvarchar400
24T280CMaster data texts: Customer Group5TXT40Long textnvarchar400
25T280DMaster data texts: Distribution Channel5TXT40Long textnvarchar400
26T280EMaster data texts: Company5TXT40Long textnvarchar400
27T280FMaster data texts: Month5TXT40Long textnvarchar400
28T280GMaster data texts: Division5TXT40Long textnvarchar400
29T280HMaster data texts: Region5TXT40Long textnvarchar400
30T280IMaster data texts: Product type5TXT40Long textnvarchar400
31T280JMaster data texts: Source of data5TXT40Long textnvarchar400
32T2810Master data texts: Area (Countries)5TXT40Long textnvarchar400
33T2811Master data texts: continents5TXT40Long textnvarchar400
34T2812Master data texts: countries5TXT40Long textnvarchar400
35T2813Master data texts: regions5TXT40Long textnvarchar400
36T2814Master data texts: product groups5TXT40Long textnvarchar400
37T2815Master data texts: Continent5TXT40Long textnvarchar400
38T2816Master data texts: Land5TXT40Long textnvarchar400
39T2817Master data texts: State5TXT40Long textnvarchar400
40T2818Master data texts: Prod. Group5TXT40Long textnvarchar400
41T2819Master data texts: Sales Channel5TXT40Long textnvarchar400
42T281AMaster Data Table: Company5TXT40Long textnvarchar400
43T281BMaster Data Table: Strategic Business U5TXT40Long textnvarchar400
44T281CMaster Data Texts: demo5TXT40Long textnvarchar400
45T281DMaster Data Table: xxrk15TXT40Long textnvarchar400
46T281EStammdatentexte: T-Segment5TXT40Langtextnvarchar400
47T281FStammdatentexte: T-Business Unit5TXT40Langtextnvarchar400
48T281GStammdatentexte: T-Division5TXT40Langtextnvarchar400
49T281HStammdatentexte: T-Product Line5TXT40Langtextnvarchar400
50T281IMaster data texts: town xx5TXT40Long textnvarchar400
51T2820Master data texts: xarea (Description)5TXT40Long textnvarchar400
52T2821Master data texts: CITY (X)5TXT40Long textnvarchar400
53T2822Master data texts: PRODUCTS (X)5TXT40Long textnvarchar400
54T2823Master data texts: MAYOR (X)5TXT40Long textnvarchar400
55T2837Master Data Texts: Customer Group 005TXT40Long textnvarchar400
56T2838Master Data Texts: Customer 005TXT40Long textnvarchar400
57T28NNMaster Data Texts: &5TXT40Long textnvarchar400
58TKCHNTSAP-EIS: Hierarchy node texts8TXT40Long textnvarchar400
TOPData Transfer
59KCDRULData Transfer: Texts for General Rules4TXT40Data transfer: descriptionnvarchar400
TOPFinancial Accounting
60T041CTReasons for Reverse Posting (Name)4TXT40Text, length 40nvarchar400
61T053BSelection Rules for Payment Advices (Texts)5TXT40Text, length 40nvarchar400
62T053SClassification of Payment Differences (Texts)6TXT40Reason Code Long Textnvarchar400
TOPMarket Risk Analysis
63I8200IS-B: RM Characteristics : Organisation INT/EXT5TXT40Long textnvarchar400
TOPOperative Structures
64TCN04PS Text Types5TXT40Description for PS text type (40 characters)nvarchar400
65TTXPSFORMATTPS Text Format5TXT40Description for PS text type (40 characters)nvarchar400
TOPPayroll
66T5H5GHelp table to infotype p04414TXT40Text, length 40nvarchar400
TOPPersonnel Administration
67P0SUTTexts for Subsystem4TXT40Subsystem namenvarchar400
68T5H4UText table to entries of T5H4V3TXT40Text, length 40nvarchar400
TOPReporting
69TMCTXLIS: Characteristic Texts (external data and R/2)6TXT40Text, 40 Characters Longnvarchar400
TOPRisk Analysis
70I82NNKIS-B: RM Texts for Characteristics : &5TXT40Long textnvarchar400
TOPService Station Retailing
71OIRC_ACCESSTSSR Meters - Access type text4TXT40Long textnvarchar400
TOPTraders and Schedulers Workbench
72OIJWLRCTOIL-TSW: Reason code text5TXT40Long textnvarchar600
TOPUse AP-MD-BP Components
73TB002BP grouping: Texts5TXT40Descriptionnvarchar400