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

39 columns | Print definition?ERP 6.0  | INDEXNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/EPAB_INDDEFIndex Definitions3INDEXNAME/xft/epa_base_indexnamenvarchar640
2CNVCMIS_A_1_INDFR/3 S_SECINDEX: secondary indexes, fields (CMIS Table)5INDEXNAMEUnique Index ID in a Tablenvarchar30
3CNVCMIS_A_1_INDXIndx Table(CMIS)5INDEXNAMEUnique Index ID in a Tablenvarchar30
4CNVCMIS_A_1_SHLDSearch Help Data (Parameters)19INDEXNAMEUnique Index ID in a Tablenvarchar30
5CNVCMIS_M_INDEXSAP LT Store runtime Inforamtion about created Tab. indices4INDEXNAMEUnique Index ID in a Tablenvarchar30
6CNVTDMS_05_INDEXTo store the information of the dropped indices4INDEXNAMEUnique Index ID in a Tablenvarchar30
7DD12BDD: Secondary Index Headers for Structured Objects3INDEXNAMEUnique Index ID in a Tablenvarchar30
8DD12BTText Table for DD12B (Texts for Nodes Indexes)3INDEXNAMEUnique Index ID in a Tablenvarchar30
9DD17BDD: Secondary Indexes Fields for Structured Objects3INDEXNAMEUnique Index ID in a Tablenvarchar30
10sap_dblocks18indexnamesysname1280
11SCI_DCTHDB_TEWA Data for HDB Index Check (Filled via WebService)3INDEXNAMEnvarchar30
12SCI_DCTHDB_WEWA Data for HDB Index Check (Filled via WebService)3INDEXNAMEnvarchar30
13TPINDIndex parameters for DB22INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
14DBDIFFINDXDD: Additional Info on DBDIFF-KEY and INDX Entries2INDEXNAMEUnique Index ID in a Tablenvarchar30
15DD12LR/3 S_SECINDEX: secondary indexes, header;2INDEXNAMEUnique Index ID in a Tablenvarchar30
16DD12TText Table for DD12L (Short Descriptions of Sec. Indexes)3INDEXNAMEUnique Index ID in a Tablenvarchar30
17DD17SR/3 S_SECINDEX: secondary indexes, fields2INDEXNAMEUnique Index ID in a Tablenvarchar30
18DDSPARStorage clause for tables and indexes2INDEXNAMEUnique Index ID in a Tablenvarchar30
19DDSPAR1Storage clause for tables and indexes2INDEXNAMEUnique Index ID in a Tablenvarchar30
20DDSPAR2Storage clause for tables and indexes2INDEXNAMEUnique Index ID in a Tablenvarchar30
21DDSTORAGEStorage clause for tables and indexes3INDEXNAMEUnique Index ID in a Tablenvarchar30
22DDSTORAGE1Storage clause for tables and indexes3INDEXNAMEUnique Index ID in a Tablenvarchar30
23DDSTORAGE2Storage clause for tables and indexes3INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPBusiness Application Support
24CNVINDEXTable for index information4INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPClasses
25CLINDEXIndices of Classification System2INDEXNAMELogical name of an external indexnvarchar300
26CLINDEXATINNCharacteristic - Index Assignment2INDEXNAMELogical name of an external indexnvarchar300
27CLINDEXOBTABRestriction of Index to Object Types2INDEXNAMELogical name of an external indexnvarchar300
TOPF4 Help
28DD32SSearch Help Parameter15INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPMaxDB
29ADATABSIZESAP DB: Table Sizes Including Indexes in KB2INDEXNAMEName of the ABAP Dictionary objectnvarchar300
TOPMicrosoft SQL Server
30MSSSTORAGEMSSQL-Specific Storage Parameters for Tables and Indexes3INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPOrganizational Management
31T77OMATTDBGeneral Attribute Maintenance: Help Indices for Attributes2INDEXNAMESearch Index: Database Namenvarchar300
TOPPeriodical Sales and Distribution
32TJYFAKTUIS-M/SD: Technical Settings for Billing Conversion/Oracle2INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPProfitability Analysis
33TKETRLGXSummarization Levels: Catalog entry, header (generated obj.)2INDEXNAMEIndex name for summarization levelnvarchar30
34TKETRLXSummarization levels: Catalog entry, index descriptions6INDEXNAMEIndex name for summarization levelnvarchar30
TOPSAP Business Partner
35TBZ3RAssign BDT Field Group -> BDT Field8INDEXNAMEUnique Index ID in a Tablenvarchar30
36TBZ3R_CAssign BDT Field Group -> BDT Field7INDEXNAMEUnique Index ID in a Tablenvarchar30
37TBZS4BDT Search Help: Search Fields5INDEXNAMEUnique Index ID in a Tablenvarchar30
TOPUpgrade Tools
38UPG_DD12LICNV: Secondary Indexes - Header2INDEXNAMEnvarchar30
39UPG_DD17SICNV: Secondary Indexes - Fields2INDEXNAMEnvarchar30