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
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
Basis Components :: ABAP Workbench, Java IDE and Infrastructure :: Workbench Tools Editors, Painters, Modelers :: ABAP Test Frameworks ATC, CheckMan, Code Inspector
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SATC_AC_RESULTVT304Transaction data: 'Display Load' findingsABAP Test Frameworks ATC, CheckMan, Code Inspector
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT DISPLAY_ID, OBJ_NAME, OBJ_TYPE, MODULE_ID, MODULE_MSG_KEY, CHECKSUM, RESP1, PRIORITY, PACKAGE_NAME, COUNT_PRIO1, COUNT_PRIO2, COUNT_PRIO3, COUNT_PRIO4, ERROR_OBJ_TYPE, ERROR_OBJ_NAME, TIMESTAMP, HOST, EXCSTATE_CHKTIME, EXCSTATE_ASSTIME, EXC_KIND, EXC_VALIDITY, EXC_APPROVAL, EXC_GRANULARITY, QUALITY_STANDARD, SINCE, COMPLETION_STATE, SUB_INDEX, NAVIGATION_DATA, DESCRIPTION_DATA, IS_IMPORTED FROM SATC_AC_RESULTVT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1DISPLAY_IDID for 'Display Load' - overall result of 'ABAP Check Layer'varbinary160RAWNoSATC_D_AC_DISPLAY_ID
2OBJ_NAMEObject Name in Object Directorynvarchar400CHAR(N' ')NoSOBJ_NAME Allow NULL? 
3OBJ_TYPEObject Typenvarchar40CHAR(N' ')NoTROBJTYPE Allow NULL? 
4MODULE_IDModule key / IDvarbinary160RAWNoSATC_D_AC_MODULE_ID
5MODULE_MSG_KEYModule message keynvarchar120CHAR(N' ')NoSATC_D_AC_MODULE_MESSAGE_KEY Allow NULL? 
6CHECKSUMChecksum based on CRC32int100INT4((0))NoSATC_D_CRC32 Allow NULL? 
7RESP1Contact personnvarchar120CHAR(N' ')NoSATC_D_AC_OBJECT_CONTACT Allow NULL? 
8PRIORITYSeverity of findingstinyint30INT1((0))NoSATC_D_MESSAGE_PRIORITY
9PACKAGE_NAMEDevelopment package - as stringnvarchar300(N'')NoSATC_D_AC_DEVCLASS Allow NULL? 
10COUNT_PRIO1tinyint30((0))Yes
11COUNT_PRIO2tinyint30((0))Yes
12COUNT_PRIO3tinyint30((0))Yes
13COUNT_PRIO4tinyint30((0))Yes
14ERROR_OBJ_TYPEObject Typenvarchar40CHAR(N' ')NoTROBJTYPE Allow NULL? 
15ERROR_OBJ_NAMEName of a development object in the ABAP repositorynvarchar400(N'')NoSATC_D_AC_R3TR_OBJ_NAME Allow NULL? 
16TIMESTAMPCreated on .. timestampdecimal150DEC((0))NoSATC_D_CREATED_ON
17HOSTHost where execution was carried outnvarchar320(N'')NoSATC_D_EXECUTION_HOST Allow NULL? 
18EXCSTATE_CHKTIMEExemption timechar10CHAR(N' ')NoSATC_D_AC_RSLT_XMPT_TIME Allow NULL? 
19EXCSTATE_ASSTIMEExemption processing statechar10CHAR(N' ')NoSATC_D_AC_RSLT_XMPT_STATE Allow NULL? 
20EXC_KINDExemption kindchar10CHAR(N' ')NoSATC_D_AC_RSLT_XMPT_KIND Allow NULL? 
21EXC_VALIDITYValidity of exemptionchar10CHAR(N' ')NoSATC_D_AC_RSLT_XMPT_VALIDITY Allow NULL? 
22EXC_APPROVALExemption approval statechar10CHAR(N' ')NoSATC_D_AC_RSLT_XMPT_APPROVAL Allow NULL? 
23EXC_GRANULARITYExemption granularitychar10CHAR(N' ')NoSATC_D_AC_RSLT_XMPT_GRANULRTY Allow NULL? 
24QUALITY_STANDARDQuality standardnvarchar20CHAR(N' ')NoSATC_D_QUALITY_STANDARD Allow NULL? 
25SINCESince .. timestampdecimal150DEC((0))NoSATC_D_SINCE
26COMPLETION_STATEProcessing statechar10CHAR(N' ')NoSATC_D_AC_PROCESSING_STATE Allow NULL? 
27SUB_INDEXIndex of partial result within overall resulttinyint30INT1((0))NoSATC_D_AC_RSLT_SUB_NDX
28NAVIGATION_DATASerialized Data (Export or Call Transformation)image21474836470NoSABP_D_SERIALIZED_DATA
29DESCRIPTION_DATASerialized Data (Export or Call Transformation)image21474836470NoSABP_D_SERIALIZED_DATA
30IS_IMPORTEDIs imported result / findingchar10CHAR(N' ')NoSATC_D_AC_RSLT_IS_IMPORTED Allow NULL? 
NamePrimaryUniqueTypeColumns
SATC_AC_RESULTVT~0YesYesCLUSTEREDCHECKSUM, MODULE_MSG_KEY, MODULE_ID, OBJ_TYPE, OBJ_NAME, DISPLAY_ID
SATC_AC_RESULTVT~MNoNoNONCLUSTEREDMODULE_MSG_KEY, MODULE_ID, DISPLAY_ID
SATC_AC_RESULTVT~PNoNoNONCLUSTEREDPACKAGE_NAME, DISPLAY_ID
SATC_AC_RESULTVT~UNoNoNONCLUSTEREDRESP1, DISPLAY_ID