DB2ACCOR SAP (Parameters of Control Center stored procedure DSNACCOR) Structure details

Dictionary Type: Structure
Description: Parameters of Control Center stored procedure DSNACCOR




ABAP Code to SELECT data from DB2ACCOR
Related tables to DB2ACCOR
Access table DB2ACCOR




Structure field list including key, data, relationships and ABAP select examples

DB2ACCOR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Parameters of Control Center stored procedure DSNACCOR" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB2ACCOR TYPE DB2ACCOR.

The DB2ACCOR table consists of various fields, each holding specific information or linking keys about Parameters of Control Center stored procedure DSNACCOR data available in SAP. These include OBJECTTYPE (Types of objects who are considered for recommendation), ICTYPE (Types of image copies to be considered for recommendation), STATSSCHEM (Schema name to qualify tables (statistics, catalog, created)), CATLGSCHEM (Schema name to qualify tables (statistics, catalog, created)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DB2ACCOR structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
QUERYTYPEType of the Stored Procedure to run DB2CCQUERYCHAR40CHAR40
OBJECTTYPETypes of objects who are considered for recommendation DB2CCOTYPECHAR3CHAR3
ICTYPETypes of image copies to be considered for recommendation DB2CCICTYPCHAR1CHAR1
STATSSCHEMSchema name to qualify tables (statistics, catalog, created) DB2CCSCHEMCHAR128CHAR128
CATLGSCHEMSchema name to qualify tables (statistics, catalog, created) DB2CCSCHEMCHAR128CHAR128
LOCALSCHEMSchema name to qualify tables (statistics, catalog, created) DB2CCSCHEMCHAR128CHAR128
CHKLVLDegree of checking before invocation of stored procedure DB2CCCHECKINT410
CRITERIAWhere clause for the Control Center stored procedures DB2CCWHERECHAR4096CHAR4096
UNUSED Not used yet, specify NULL value0
FCUPDPGSFull/Inc. Copy: Updated pages in percent of preformatted pag DB2CCUPDPGINT410
FCCHGPCTFull/Inc. Copy: Changed rows in percent DB2CCCCHGSINT410
FCDAYSCOPYFull Copy: Number of days since last COPY DB2CCCDAYSINT410
ICUPDPGSFull/Inc. Copy: Updated pages in percent of preformatted pag DB2CCUPDPGINT410
ICCHGPCTFull/Inc. Copy: Changed rows in percent DB2CCCCHGSINT410
FCINDEXSIZFull Copy: Minimum size of index in pages (NACTIVE) DB2CCISIZEINT410
RTINSDELUPREORG TS/IX: Changed rows in percent DB2CCRCHGSINT410
RTUNCLUSTREORG TS: Unclustered inserts in percent DB2CCUNCLUINT410
RTLOBPCTREORG TS: Disorganized LOBs in percent DB2CCLOBINT410
RTMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASSINT410
RTINDREFREORG TS: Indirect references (overflow records) in percent DB2CCINDINT410
RIINSDELREORG TS/IX: Changed rows in percent DB2CCRCHGSINT410
RIAPPINSREORG Index: Appended rows (with greater key) in percent DB2CCAPPINT410
RIPSEUDODEREORG Index: Pseudo deletes in percent DB2CCPSEUDINT410
RIMASSDELREORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCRMASSINT410
RILEAFLIMREORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent DB2CCLEAFINT410
RINUMLEVELREORG Index: Change to number of index tree levels absolute DB2CCLEVELINT410
STINSDELPRUNSTATS TS/IX: Changed rows in percent DB2CCSCHGSINT410
STINSDELARUN.:Changed rows (insert, delete or update) absolute number DB2CCCHGAFLTP16(16) FLTP
STMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASSINT410
SIINSDELPRUNSTATS TS/IX: Changed rows in percent DB2CCSCHGSINT410
SIINSDELARUN.:Changed rows (insert, delete or update) absolute number DB2CCCHGAFLTP16(16) FLTP
SIMASSDELRUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) DB2CCSMASSINT410
EXTENTSNumber of allowable dataset extents DB2CCEXTINT410
L_STATEMNTLast statement executed by DSNACCAV stored procedures DB2CCLSTCHAR8012
RETURNCODEReturn code of stored procedure DB2CCRETURNINT410
ERRORMSGArea of the CC stored procedures output values DB2CCMTXTCHAR1331
IFCRETCODEReturn code for the IFI call DB2CCIRETINT410
IFCRESCODEReason code for the IFI call DB2CCIRESINT410
XSBYTESNumber of bytes that did not fit in the IFI return area DB2CCXSBINT410
RTINSDELUPABSREO.:Changed rows (insert, delete or update) absolute number DB2CCRCHGAINT410
RTACTIVEPAGESREORG TS/IX: Number of active pages DB2CCRROWSINT410

Key field Non-key field



How do I retrieve data from SAP structure DB2ACCOR using ABAP code?

As DB2ACCOR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2ACCOR as there is no data to select.

How to access SAP table DB2ACCOR

Within an ECC or HANA version of SAP you can also view further information about DB2ACCOR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!