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

40 columns | Print definition?ERP 6.0  | INDEX_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/AT093Real valuated depreciation areas6INDEX_IDIndex IDnvarchar80
2/ATL/GL1Index master2INDEX_IDIndex IDnvarchar80
3/ATL/GL1TIndex master Description3INDEX_IDIndex IDnvarchar80
4/ATL/GL1VIndex Values2INDEX_IDIndex IDnvarchar80
5/ATL/GL4RCalculation Rules4INDEX_IDIndex IDnvarchar80
6/ATL/TKN12_MADADdecision table for teken 12 - madad3INDEX_IDIndex IDnvarchar80
7N1SE_INDEXISHMED: Table for Search Indexes2INDEX_IDIndex Idnvarchar640
8N1SE_INDEX_ATTRISHMED: Search Index Attributes2INDEX_IDIndex Idnvarchar640
9N1SE_INDEX_RUNISHMED: Table for Executing Search Indexes2INDEX_IDIndex Idnvarchar640
10sap_tsize_sample3index_idint100
TOPAnalysis Process Designer
11RSANT_UT_RSLTTInterim Results - Reference to TREX Index2INDEX_IDIndex Idnvarchar640
TOPData Retention Tool
12TXW_INDEXTemporary table for data segment index1INDEX_IDIndex IDnvarchar10
13TXW_INDEX_01Temporary table for data segment index1INDEX_IDIndex IDnvarchar10
14TXW_INDEX_02Temporary table for data segment index1INDEX_IDIndex IDnvarchar10
15TXW_INDEX_03Temporary table for data segment index1INDEX_IDIndex IDnvarchar10
16TXW_INDEX_04Temporary table for data segment index1INDEX_IDIndex IDnvarchar10
17TXW_INDEX_05Temporary table for data segment index1INDEX_IDIndex IDnvarchar10
TOPFast Search Infrastructure
18SFSRFW_TIMESTime Measurement7INDEX_IDCharacter field, length 64nvarchar640
TOPNetWeaver Enterprise Search
19ESH_BOS_INDEXStatus of BOS Search Connectors8INDEX_IDIndex Idnvarchar640
20ESH_CRT_INDEXIndices of Common Runtime Search Object Connectors7INDEX_IDIndex Idnvarchar640
TOPOLAP Technology
21RRAMBIADIRAnalytical Model: Directory for InfoProvider and BIA Index5INDEX_IDIndex Idnvarchar640
TOPRuntime WorkbenchMonitoring
22SXMSMSGINDCUSSAP XI: Configuration for Indexing of Messages2INDEX_IDIndex Idnvarchar640
23SXMSMSGINDSRVSAP XI: Services for Indexing of Messages2INDEX_IDIndex Idnvarchar640
TOPServices
24FINB_PR_TINDIndexes7INDEX_IDUnique Index ID in a Tablenvarchar30
25FINB_PR_TIND_FDSIndex fields7INDEX_IDUnique Index ID in a Tablenvarchar30
TOPStorage and Retention Service
26DAS_COL_INDEXILM SRS: Relationship Between Indices and Collections2INDEX_IDID of an Indexnvarchar190
27DAS_INDEX_COLUMNILM SRS: Index Columns7INDEX_IDID of an Indexnvarchar190
28DAS_INDEX_DICTILM SRS: Directory of Indices and Their Definitions2INDEX_IDID of an Indexnvarchar190
TOPText Retrieval and Information Extraction
29SKWR_IXFCSIndex Folder Classes1INDEX_IDGUID in 'CHAR' Format in Uppercasenvarchar320
30SKWR_IXTXSIndexes with Taxonomies1INDEX_IDGUID in 'CHAR' Format in Uppercasenvarchar320
31STRX_IXDASDocument Attributes for Indexing1INDEX_IDGUID in 'CHAR' Format in Uppercasenvarchar320
32STRX_IXPTSProperties of Logical Index1INDEX_IDGUID in 'CHAR' Format in Uppercasenvarchar320
33STRX_LIXSInformation on Logical Index1INDEX_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPTREX ABAP JAVA API
34TREX_DELTA_QUEUETREX Delta Queue2INDEX_IDIndex Idnvarchar640
35TREX_INDEX_SERVIndex Server Location for Indexing2INDEX_IDIndex Idnvarchar640
36TREX_SEARCH_SERVIndex Server Location for Search4INDEX_IDIndex Idnvarchar640
TOPTREX Enterprise File Search
37SEFS_CRAWLCrawl3INDEX_IDIndex IDnvarchar640
38SEFS_INDEXIndex2INDEX_IDIndex IDnvarchar640
TOPTREX Search Engine Service
39COM_SE_BUSOBJTYSearch Engine Service: Settings for Object Type/Index6INDEX_IDObject Index ID in the Search Enginenvarchar640
40COM_SE_STATUSSearch Engine Service: Status of Indexing2INDEX_IDObject Index ID in the Search Enginenvarchar640