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

35 columns | Print definition?ERP 6.0  | LONG_TEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BA1/TF4_SCNSETTText Table for Scenario Sets5LONG_TEXTDescription of Scenario Set (Long Text)nvarchar600
2FSH_COLLECTION_TText Table For Collections7LONG_TEXTText Linenvarchar1320
3FSH_SEASONS_TText Table for Seasons6LONG_TEXTText Linenvarchar1320
4FSH_THEMES_TText Table for Themes8LONG_TEXTText Linenvarchar1320
5IUUC_KB_BUF_INVBuffer Tables and Invalidations4LONG_TEXTVariable fieldnvarchar300
6J_3RJ_CNTRY_TCountry Conversion text5LONG_TEXTLong Textnvarchar600
7J_3RJ_CURR_TCurrency conversion Text5LONG_TEXTLong Textnvarchar600
8T77ANAKPIMD_TKPI Metadata (Texts)8LONG_TEXTKPI Long Textnvarchar2550
9TREAC_ATTR_DESCDescription Of Free Position Account Attributes6LONG_TEXTLong Descriptionnvarchar400
TOPAdvertising Management
10TJJPCCKTPackage Check/Search Strategy: Texts6LONG_TEXTIS-M: Long Textnvarchar500
11TJJPCCYTPackage Category: Texts5LONG_TEXTIS-M: Long Textnvarchar500
TOPAuto-ID Infrastructure
12/AIN/TU_FLD_NAMTTag field name text descriptions4LONG_TEXTLong descriptionnvarchar400
TOPBack Office
13TRFC_ATTR_DESCDescription Of Free Position Account Attributes6LONG_TEXTLong Descriptionnvarchar400
14TRFT_ATTR_DESCDescription Of Free Position Account Attributes6LONG_TEXTLong Descriptionnvarchar400
TOPBank Customer Accounts
15BKK_PRENOTEPrenotes21LONG_TEXTLong Textnvarchar500
TOPBasic Market Data
16/BA1/TF4_VOLAIDTVolatility Structures that Are Not Based on Underlying4LONG_TEXTLong Textnvarchar600
TOPBusiness Partner
17RATCE_AGENCY_TXTDescription of Rating Agency5LONG_TEXTLong Text for Agencynvarchar2550
18RATCE_OWNER_TXTDescription of Owner5LONG_TEXTLong Text for Ownernvarchar600
19RATCE_PROC_TXTDescription of Rating Procedure7LONG_TEXTLong Text for Rating Procedurenvarchar2550
20RATCE_RATING_TXTTexts for Ratings7LONG_TEXTLong Text for Ratingnvarchar600
21RATCE_SET_TXTRating Sets6LONG_TEXTLong Text for Rating Setnvarchar600
TOPCondition
22TBKK92TPooling Method Text4LONG_TEXTInterest Compensation Methodnvarchar300
TOPE-Recruiting
23/ERPSOLUT/EQTRANeQuest Translation Table10LONG_TEXTLong Text of 241 bytesnvarchar2410
TOPGL Account Posting
24TCJ_TRANS_NAMESCash Journal Business Transaction Names6LONG_TEXTCash Journal Business Transaction Long Textnvarchar500
TOPMaster Data
25TBKK60TAccount Hierarchy: Hierarchy Type Texts4LONG_TEXTAccount Hierarchy: Long Text for Hierarchy Typesnvarchar300
TOPPosition Budgeting and Control
26T77HRFPMFINEXC1TReason for Alternative Financing Requirement (Texts)5LONG_TEXTDescription - Reason for Alternative Financing Requirementnvarchar500
TOPSAP NetWeaver Mobile - Use subcomponents
27MEMGMT_TYPE_VALTypes for Device Configuration4LONG_TEXTPlatform Long Textnvarchar500
28MEPLATFORM_TEXTLong Text Assignment4LONG_TEXTPlatform Long Textnvarchar500
TOPService Data Download
29/BDL/TASKSControl Table of Task Manager6LONG_TEXTText (80 Characters)nvarchar800
TOPTransaction Manager
30TEMC_ATTRD_TTexts for Attribute Fields6LONG_TEXTText, 40 Characters Longnvarchar400
31TEXC_ATTRD_TDescription of free attributes6LONG_TEXTText, 40 Characters Longnvarchar400
TOPTransfer to Financial Accounting
32TRLTC_POSATT_D_Tposition attributes6LONG_TEXTLong Field Labelnvarchar400
TOPTreasury
33VWPT_ATTR_DESCDescription of Free Security Attribute6LONG_TEXTLong Namenvarchar400
TOPWeb Service and SOAP - ABAP
34SRT_SR_VW_HEADERHeader table for views4LONG_TEXTnvarchar2550
TOPWithout Description
35KAP_PSR_TEXTSTexts for Language-Dependent User Guide5LONG_TEXTLong text (language-dependent user guide)nvarchar600