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

47 columns | Print definition?ERP 6.0  | LASTUSER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/NEWDEVPROJSAIF development projects2LASTUSERUser Namenvarchar400
2/AIF/NEWDEV_IDSAIF new development IDs5LASTUSERUser Namenvarchar400
3/AIF/TOPIC_STTopic status4LASTUSERUser Namenvarchar400
4/AIF/TOPIC_ST_HTopic status (history table)5LASTUSERUser Namenvarchar400
5/AIF/T_TOPICTopic definition6LASTUSERUser Namenvarchar400
6/AIF/T_TOPIC_TRTopic definition3LASTUSERUser Namenvarchar400
7BWSD_CONFH7LASTUSERnvarchar120
8BWSD_DATAData Store for Scenario Objects12LASTUSERTrace Tool: Trace Usernvarchar120
9BWSD_TRANSName Replacements of Object Transformation12LASTUSERUser Namenvarchar120
10BWSD_TRANSHHeader Data for Object Transformation5LASTUSERUser Namenvarchar120
11CNVCMIS_A_1_MSAGMessage IDs for T1009LASTUSERLast Changed bynvarchar120
12RSCRMMONRSCRM: Monitoring for Batch5LASTUSERUser Namenvarchar120
13RSCRMREPTABRSCRM: Report Table Catalog7LASTUSERUser Namenvarchar120
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
14T100AMessage IDs for T1005LASTUSERLast Changed bynvarchar120
TOPBSI
15BTXEGRP_OBSI: Employee Group5LASTUSERBSI: Last changed bynvarchar80
16BTXPURGEBSI: Purge Retention Periods4LASTUSERBSI: Last changed bynvarchar80
TOPEnd User Technology
17RSRREPORTNodes with URLs, links, etc.7LASTUSERLast Changed Bynvarchar120
TOPForms Processing
18FPCONTEXTForm Objects: Context9LASTUSERLast Changed bynvarchar120
19FPINTERFACEForm Objects: Interface7LASTUSERLast Changed bynvarchar120
20FPLAYOUTForm Objects: Layout6LASTUSERLast Changed bynvarchar120
TOPInternationalization I18N
21TCP0IParameter table for i18n system configuration5LASTUSERLast Changed Bynvarchar120
TOPLocal Currency Changeover
22EWUARCHIVCritical archiving objects10LASTUSERUser Namenvarchar120
TOPOLAP Technology
23RSRREPDIRDirectory of all reports17LASTUSERLast changed bynvarchar120
24RSRREPDIR_STATGeneration Status for Non Client-Specific Queries9LASTUSERLast changed bynvarchar120
25RSRREPDIR_STATUSStatus of Query Generation8LASTUSERLast changed bynvarchar120
TOPSmart Forms
26STXFADMSmart Forms: Administration8LASTUSERLast changed bynvarchar120
27STXSADMSmart Styles: Administration7LASTUSERLast changed bynvarchar120
TOPTransport Organizer
28GTABKEY_MAILGTABKEY Mail Recipient7LASTUSERLast Changed bynvarchar120
29GTABKEY_TABEXCLTables Excluded from Conflict Check6LASTUSERLast Changed bynvarchar120
TOPWithout Description
30RSDMTU_AWB_MONMonitoring AWB5LASTUSERUser Namenvarchar120
31RSTT_CMNTComment Archive5LASTUSERTrace Tool: Trace Usernvarchar120
32RSTT_DLTADelta Entry of Released Report Data5LASTUSERTrace Tool: Trace Usernvarchar120
33RSTT_DLTAEDelta Entry of Released Report Data Elements6LASTUSERTrace Tool: Trace Usernvarchar120
34RSTT_ERRORError Archive31LASTUSERTrace Tool: Trace Usernvarchar120
35RSTT_OBJRESPResponsibility for Test Objects6LASTUSERTrace Tool: Trace Usernvarchar120
36RSTT_REFVARTrace Tool: Variant Table of Reference Data3LASTUSERTrace Tool: Trace Usernvarchar120
37RSTT_TDMAPName Transformations for Test Objects10LASTUSERTrace Tool: Trace Usernvarchar120
38RSTT_TESTStore of Existing Test Sequences12LASTUSERTrace Tool: Trace Usernvarchar120
39RSTT_TJOBTrace Tool: Trace Job/Test Job Table10LASTUSERTrace Tool: Trace Usernvarchar120
40RSTT_TOBJREPTest Object Replacements7LASTUSERTrace Tool: Trace Usernvarchar120
41RSTT_TPACKAGETrace Tool: Basis Info About Trace Packages10LASTUSERTrace Tool: Trace Usernvarchar120
42RSTT_TRACETrace Tool: Table Trace Attribute11LASTUSERLast Changed Bynvarchar120
43RSTT_TRANSHeader Data of Object Transformations7LASTUSERTrace Tool: Trace Usernvarchar120
44RSTT_TREQArchive for Test Requests13LASTUSERTrace Tool: Trace Usernvarchar120
45RSTT_TREQSTAStatus Buffer for Test Requests14LASTUSERTrace Tool: Trace Usernvarchar120
46RSTT_VARIANTTrace Tool: Variants Table6LASTUSERTrace Tool: Trace Usernvarchar120
47RSTT_VARIANT2Trace Tool: Variants Table4LASTUSERTrace Tool: Trace Usernvarchar120