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

124 columns | Print definition?ERP 6.0  | MODTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BTP_DL_OBJECTBTP Object19MODTIMEBTP Time of Modificationnvarchar60
2BTP_DL_PPHITABTP Project Composed IT Approaches in Phases12MODTIMEBTP Time of Modificationnvarchar60
3BTP_DL_PSTEPUPDBTP Reported Updates on Steps by external Applications6MODTIMEBTP Time of Modificationnvarchar60
4BWSD_CONFH8MODTIMEdecimal150
5BWSD_DATAData Store for Scenario Objects14MODTIMELast Change to Definitiondecimal150
6BWSD_TRANSName Replacements of Object Transformation10MODTIMELast Change to Definitiondecimal150
7BWSD_TRANSHHeader Data for Object Transformation3MODTIMELast Change to Definitiondecimal150
8ICFSRV4ADMIN_LOGICF Services, which only have to be used for administration6MODTIMESystem Timenvarchar60
9ICFSRV4ADM_LOLOGLocal Log table for ICFSRV4ADMIN_LOG6MODTIMESystem Timenvarchar60
10RFC_TT_ACL_HISTHistory for Access Control of Trust Relationships6MODTIMEnvarchar60
11SACF_ALERTCollector for Failed Calls6MODTIMEModification timenvarchar60
12SLDW_ALERTCollector for Failed Calls6MODTIMEModification timenvarchar60
13SLDW_ELEMENTSElements of Whitelists (Design)6MODTIMEModification timenvarchar60
14SLDW_ELEMENTS_RTElements of Whitelists (Runtime)6MODTIMEModification timenvarchar60
15SLDW_HEADERHeader Attributes for Whitelists10MODTIMEModification timenvarchar60
16SLDW_HEADER_RTHeader Attributes for Whitelists8MODTIMEModification timenvarchar60
17TCDCOUPLES_SCheck at Call Transaction (Modification Memory)5MODTIMEModification timenvarchar60
18TOBJ_CHK_CTRL_DScenario for Switchable Authorization Check (Design Phase)6MODTIMEModification timenvarchar60
19TOBJ_CHK_CTRL_DHScenario for Switchable Authorization Check (Design Phase)7MODTIMEModification timenvarchar60
20TOBJ_CHK_CTRL_RActive Scenario for Switchable Authorization Check6MODTIMEModification timenvarchar60
21TOBJ_CHK_CTRL_RHActive Scenario for Switchable Authorization Check6MODTIMEModification timenvarchar60
TOPABAP Authorization and Role Management
22AUSOBTRelation transaction > authorization object9MODTIMEModification timenvarchar60
23AUSOBT_CRelation Transaction > Auth. Object (Customer)9MODTIMEModification timenvarchar60
24TBRG_OBJObjects with Cross-Client Authorization Groups8MODTIMEModification timenvarchar60
25TCDCOUPLESCheck on S_TCODE at call transaction5MODTIMEModification timenvarchar60
26TOBJVORSAP_NEW Release-Dependent Data for Authorization Objects5MODTIMESystem Timenvarchar60
27TOBJ_TPODefinition table for global templates4MODTIMESystem Timenvarchar60
28TPRVORTemplates Profile Generator: Entity Table4MODTIMESystem Timenvarchar60
29TSTC_SMControl table SU22: Auth.obj.maint. for transactions5MODTIMELast changed atnvarchar60
30USOBTRelation transaction > authorization object9MODTIMEModification timenvarchar60
31USOBT_BACKBackup Table USOBT for Modified SU259MODTIMEModification timenvarchar60
32USOBT_CRelation Transaction > Auth. Object (Customer)9MODTIMEModification timenvarchar60
33USOBT_CDChange History for Field Values9MODTIMEModification timenvarchar60
34USOBT_C_BACKBackup Table USOBT_C for Modified SU259MODTIMEModification timenvarchar60
35USOBT_DUPModification log for table USOBT. For SAP only11MODTIMEModification timenvarchar60
36USOBT_TSTMPLocal Time Stamp of Last SAP Change (USOBT)8MODTIMEModification timenvarchar60
37USOBXCheck table for table USOBT6MODTIMEModification timenvarchar60
38USOBX_BACKBackup Table USOBX for Modified SU256MODTIMEModification timenvarchar60
39USOBX_CCheck Table for Table USOBT_C6MODTIMEModification timenvarchar60
40USOBX_CDChange History for Check Indicator6MODTIMEModification timenvarchar60
41USOBX_C_BACKBackup Table USOBX_C for Modified SU256MODTIMEModification timenvarchar60
42USOBX_DUPModification log for table USOBX. Only for SAP8MODTIMEModification timenvarchar60
43USOBX_MODCheck table for table USOBT7MODTIMEModification timenvarchar60
44USOBX_REVContains Incorrect Traces from USOBX6MODTIMEModification timenvarchar60
45USOBX_TSTMPLocal Time Stamp of Last SAP Change (USOBX)6MODTIMEModification timenvarchar60
46USOB_AUTHVALTRCAuthorization Trace Result: Objects and Values23MODTIMEModification timenvarchar60
47USOB_SMControl Table SU22: Auth. Obj. Maint. for Transact./Service5MODTIMEModification timenvarchar60
48USOB_TIMESTAMPApplication Time Stamp for Default Data8MODTIMEModification timenvarchar60
TOPBusiness Configuration Sets
49SCPRACTPBC Set: Activated in local system5MODTIMEBC Set: Last changed atnvarchar60
50SCPRACTRBC Set: Active records in Local System9MODTIMEBC Set: Last changed atnvarchar60
51SCPRACTXBC Set: Activated in local system4MODTIMEBC Set: Last changed atnvarchar60
52SCPRACTXLBC Sets: Language-Dependent Activation Links for Variable4MODTIMEBC Set: Last changed atnvarchar60
53SCPRATTRBC Set: Attributes4MODTIMEBC Set: Last changed atnvarchar60
54SCPRCOBJBC Set: Manually maintained cust. object tables6MODTIMEBC Set: Last changed atnvarchar60
55SCPRSACTBCBC Sets: Assignment of Switch BC Sets to Activation Process6MODTIMEBC Set: Last changed atnvarchar60
56SCPRSALDBC Sets: Client-Dependent Switch Activation Links6MODTIMEBC Set: Last changed atnvarchar60
57SCPRSALIBC Sets: Client-Independent Switch Activation Links5MODTIMEBC Set: Last changed atnvarchar60
58SCPRSATTRSwitch BC Set: Attributes4MODTIMEBC Set: Last changed atnvarchar60
59SCPRSMLDBC Sets: Client-Dependent Switch Modification Links5MODTIMEBC Set: Last changed atnvarchar60
60SCPRSMLIBC Sets: Client-Independent Switch Modification Links4MODTIMEBC Set: Last changed atnvarchar60
TOPChange Transport System
61GTADIRAGlobal Object List (Change and Transport System)15MODTIMETimenvarchar60
62TPSTATStatus of tp Calls14MODTIMETIME Data Element for SYSTnvarchar60
TOPDatabase Interface, Database Platforms
63DB6AUDITDTDB6: Audit log for maintenance actions2MODTIMESystem Timenvarchar60
64DB6AUDITHDDB6: Audit log for maintenance actions2MODTIMESystem Timenvarchar60
65DB6SCRIPTDB6: SQL Script Source4MODTIMESystem Timenvarchar60
TOPDatabase Monitors
66INFCFGRESDDetail result table for Informix/OS check program12MODTIMEModification (or inserting) timestamp (YYYYMMDDHHMMSS)nvarchar140
67INFCFGTHRE'Thresholds' for Informix/OS configuration check program5MODTIMEModification (or inserting) timestamp (YYYYMMDDHHMMSS)nvarchar140
TOPDB2 for OS39
68DBCHECKDB2Configuration of DB2/390 System Check Parameters9MODTIMETime of last modificationnvarchar60
TOPEnd User Technology
69RSIX_DATABW: Cluster table backup data5MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
70RSRREPORTNodes with URLs, links, etc.8MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPGRC Access Control Plug-In
71/VIRSA/TCDCOUPLECheck on S_TCODE at call transaction5MODTIMEModification timenvarchar60
TOPIntegration Engine
72SXMSPCONFXMB: Administrative Data for Pipeline Configuration3MODTIMESystem Timenvarchar60
TOPInteractive Drilldown Reporting
73RSTHIXCluster Table for Hierarchy Interface8MODTIMEDate and time in short form (YYYYMMDDhhmmss)decimal150
TOPLanguage Transport
74TLSY8Language import client data4MODTIMESystem Timenvarchar60
TOPMicrosoft SQL Server
75MSSPROCSMS SQL Server: Stored Procedures8MODTIMEnvarchar60
TOPOLAP Technology
76RSBBSIXBW: Cluster Table Info. System4MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
77RSIXBW: Cluster table info. system5MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
78RSIX_MANDTINDEPBW: Cluster table info. system4MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
79RSRREPDIRDirectory of all reports18MODTIMELast Change to Definitiondecimal150
80RSRREPDIR_STATGeneration Status for Non Client-Specific Queries10MODTIMELast Change to Definitiondecimal150
81RSRREPDIR_STATUSStatus of Query Generation9MODTIMELast Change to Definitiondecimal150
TOPOperational Data Provisioning ODP
82RODPSCLUSTERShared memory5MODTIMEdecimal150
TOPPlanning
83RSPLS_RECOVERYBW-IP Blobs for Recovery6MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSAP Support Services
84IDEFIXCluster Table for Automatic Notes Search5MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSystem Administration Assistant
85SAACONTCCustomizing for System Administration Assistant3MODTIMESystem Timenvarchar60
TOPTransaction Variant and Table Control Settings
86SHDIPICATRImage attributes9MODTIMETIME Data Element for SYSTnvarchar60
TOPTransport Management System
87LISCOMDESLIS: Destination Table46MODTIMESystem Timenvarchar60
88LISCOMDESCLIS: Characteristic Central Systems9MODTIMESystem Timenvarchar60
89LISCOMDESPLIS: User Profiles10MODTIMESystem Timenvarchar60
90LISCOMDESULIS: Users for Generation11MODTIMESystem Timenvarchar60
TOPTransport Organizer
91TLOCKCIOLock Table for CheckOut-CheckIn9MODTIMESystem Timenvarchar60
TOPUser and Authorization Management
92USOTTRelation transaction > authorization object7MODTIMEModification timenvarchar60
93USRSTAMPTime Stamp for all Changes to the User6MODTIMEModification timenvarchar60
94USZBVSYSCUA: Assignment of Systems to Users7MODTIMETimenvarchar60
95USZBVSYSCCUA: Assignment of Systems to Company Addresses7MODTIMETimenvarchar60
TOPWithout Description
96RSRVAPPLLOGIXCluster Table for Detail Data from RSRV Application Log4MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
97RSTTIXBW: Cluster table info. system5MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
98RSTT_CMNTComment Archive7MODTIMELast Change to Definitiondecimal150
99RSTT_DLTADelta Entry of Released Report Data6MODTIMELast Change to Definitiondecimal150
100RSTT_DLTAEDelta Entry of Released Report Data Elements7MODTIMELast Change to Definitiondecimal150
101RSTT_ERRORError Archive32MODTIMELast Change to Definitiondecimal150
102RSTT_ERRSTATError Status5MODTIMELast Change to Definitiondecimal150
103RSTT_LOGDLTAExtraction Logs of Test Results3MODTIMELast Change to Definitiondecimal150
104RSTT_LOGRUNArchive for Test Runs20MODTIMELast Change to Definitiondecimal150
105RSTT_LOGTEMPTemporary Store for Test Results6MODTIMELast Change to Definitiondecimal150
106RSTT_OBJHISTTrace Tool: History for Trace Objects5MODTIMELast Change to Definitiondecimal150
107RSTT_OBJRESPResponsibility for Test Objects7MODTIMELast Change to Definitiondecimal150
108RSTT_REFVARTrace Tool: Variant Table of Reference Data4MODTIMELast Change to Definitiondecimal150
109RSTT_TDATATest Data Archive10MODTIMELast Change to Definitiondecimal150
110RSTT_TDATABBlock-by-Block Data Packages of the Test Data Archive10MODTIMELast Change to Definitiondecimal150
111RSTT_TDATALData Transfer Logs9MODTIMELast Change to Definitiondecimal150
112RSTT_TDMAPName Transformations for Test Objects9MODTIMELast Change to Definitiondecimal150
113RSTT_TESTStore of Existing Test Sequences13MODTIMELast Change to Definitiondecimal150
114RSTT_TJOBTrace Tool: Trace Job/Test Job Table11MODTIMELast Change to Definitiondecimal150
115RSTT_TOBJREPTest Object Replacements8MODTIMELast Change to Definitiondecimal150
116RSTT_TPACKAGETrace Tool: Basis Info About Trace Packages11MODTIMELast Change to Definitiondecimal150
117RSTT_TPATStore for Test Result Patterns6MODTIMELast Change to Definitiondecimal150
118RSTT_TRACETrace Tool: Table Trace Attribute12MODTIMELast Change to Definitiondecimal150
119RSTT_TRANSHeader Data of Object Transformations8MODTIMELast Change to Definitiondecimal150
120RSTT_TREQArchive for Test Requests14MODTIMELast Change to Definitiondecimal150
121RSTT_TREQSTAStatus Buffer for Test Requests15MODTIMELast Change to Definitiondecimal150
122RSTT_USERAREATrace Tool: Test Area Assignment to User in Trace Tool3MODTIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
123RSTT_VARIANTTrace Tool: Variants Table7MODTIMELast Change to Definitiondecimal150
124RSTT_VARIANT2Trace Tool: Variants Table5MODTIMELast Change to Definitiondecimal150