RSDDK_SX_AGGRCAT SAP (Description of an Aggregate) Structure details
Description: Description of an Aggregate
Related tables to RSDDK_SX_AGGRCAT
Access table RSDDK_SX_AGGRCAT
Structure field list including key, data, relationships and ABAP select examples
RSDDK_SX_AGGRCAT 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 "Description of an Aggregate" 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_RSDDK_SX_AGGRCAT TYPE RSDDK_SX_AGGRCAT.
The RSDDK_SX_AGGRCAT table consists of various fields, each holding specific information or linking keys about Description of an Aggregate data available in SAP. These include OBJVERS (Object version), INFOCUBE (InfoCube), AGGRCUBE (InfoCube), PARTITIONING (Aggregate: Partitioning Property).. 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: Cannot Be Enhanced
SAP RSDDK_SX_AGGRCAT 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 |
AGGRUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | RSDDAGGRUID_SYSUUID_25 | ||||
OBJVERS | Object version | RSOBJVERS | CHAR | 1 | RSOBJVERS | ||||
INFOCUBE | InfoCube | RSINFOCUBE | CHAR | 30 | RSINFOCUBE | RSI | |||
AGGRCUBE | InfoCube | RSINFOCUBE | CHAR | 30 | RSINFOCUBE | RSI | |||
PARTITIONING | Aggregate: Partitioning Property | RSDDKAGGRPARTITION | CHAR | 1 | RSDDKAGGRPARTITION | ||||
RNSID_TO | SID of a request | RSDRNSID | INT4 | 10 | RSSID | ||||
CNSID_TO | SID of the change | RSDCNSID | INT4 | 10 | RSDCNSID | ||||
MODFL | Flag: Aggregate has been modified | RSDDMODFL | CHAR | 1 | RSBOOL | ||||
MODNEWFL | Flag: Change by reconstructing | RSDDMODNEWFL | CHAR | 1 | RSBOOL | ||||
MODCNSID | Change Run ID, That Made Change | RSDDMODCNSID | INT4 | 10 | RSSID | ||||
NEXT_BETTERUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | RSDDAGGRUID_SYSUUID_25 | ||||
NEXTUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | RSDDAGGRUID_SYSUUID_25 | ||||
PARENTUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | RSDDAGGRUID_SYSUUID_25 | ||||
NUM_AGGR | Number of components of the aggregate | RSDDNUMAGGR | INT4 | 10 | INT4 | ||||
NUM_ENTRIES | Number of records in the aggregate table | RSDDNUMENTRIES | INT4 | 10 | INT4 | ||||
CALLS | Number of call-ups of an aggregate | RSDDCALLS | INT4 | 10 | INT4 | ||||
LASTCALL | Last call-up | RSDDLASTCALL | DEC | 15 | TZNTSTMPS | ||||
LASTUPDATE | Date and time of the last roll up | RSDDLASTUPDATE | DEC | 15 | TZNTSTMPS | ||||
LASTUPDATEUSER | Last changed by | RSTSTPNM | CHAR | 12 | Assigned to domain | XUBNAME | |||
AVGFACTREDUCE | Average no. of summarizations in an aggregate | RSDDAVGFACTREDUCE | INT4 | 10 | INT4 | ||||
TSTPNM | Last changed by | RSTSTPNM | CHAR | 12 | USR02 | XUBNAME | |||
TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | TZNTSTMPS | ||||
EXPERTMODE | Flag: Whether aggregate definition created in expert mode | RSDDEXPTMODE | CHAR | 1 | RSBOOL | ||||
OBJSTAT | Object Status | RSOBJSTAT | CHAR | 3 | RSOBJSTAT | ||||
CONTREL | Content release | RSCONTREL | CHAR | 6 | CHAR6 | ||||
CONTTIMESTMP | Content time stamp: Last modification to the object by SAP | RSCONTTIMESTMP | DEC | 15 | TZNTSTMPS | ||||
OWNER | Owner (Person Responsible) | RSOWNER | CHAR | 12 | Assigned to domain | XUBNAME | RS_OWNER | ||
BWAPPL | BW Application (Namespace) | RSBWAPPL | CHAR | 10 | |||||
ACTIVFL | Active and revised version do not agree | RSACTIVFL | CHAR | 1 | XFELD | ||||
DIRECT_FILL | Flag: Fill aggregate iwth database means | RSDDDIRECTFILL | CHAR | 1 | RSBOOL | ||||
DIMSHARE | Character String for Non-Shared Dimensions | RSDDAGGRDIMSHARE | CHAR | 16 | CHAR16 | ||||
SRDATE_VAR | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 25 | RSUNIIDC25 | ||||
VARFL | Boolean | RS_BOOL | CHAR | 1 | RS_BOOL | ||||
SRDATE | Date with which texts, attributes and hierarchies are read | RRSRDATE | DATS | 8 | RSDATE | ||||
LAST_CHECK | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 15 | TZNTSTMPS | ||||
CHECKAGGR | Is CheckAggr (= 'A') | RSDDAGGRCHECK | CHAR | 1 | RS_BOOL | ||||
TECH_SET | Boolean | RS_BOOL | CHAR | 1 | RS_BOOL | ||||
AGGROBJ | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure RSDDK_SX_AGGRCAT using ABAP code?
As RSDDK_SX_AGGRCAT 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 RSDDK_SX_AGGRCAT as there is no data to select.How to access SAP table RSDDK_SX_AGGRCAT
Within an ECC or HANA version of SAP you can also view further information about RSDDK_SX_AGGRCAT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects