RSDDAGGRDIR - Directory of the aggregates
Directory of the aggregates information is stored in SAP table RSDDAGGRDIR.
It is part of development package RSDDK in software component BW-BEX-OT. This development package consists of objects that can be grouped under "BW Aggregates".
It is part of development package RSDDK in software component BW-BEX-OT. This development package consists of objects that can be grouped under "BW Aggregates".
Fields for table RSDDAGGRDIR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| AGGRUID | Technical UID for aggregates | X | RSDDAGGRUID | CHAR | 25 | |
| OBJVERS | Object version | X | RSOBJVERS | CHAR | 1 | |
| INFOCUBE | InfoCube | RSINFOCUBE | CHAR | 30 | ||
| AGGRCUBE | InfoCube | RSINFOCUBE | CHAR | 30 | ||
| PARTITIONING | Aggregate: Partitioning Property | RSDDKAGGRPARTITION | CHAR | 1 | ||
| RNSID_TO | SID of a request | RSDRNSID | INT4 | 4 | ||
| CNSID_TO | SID of the change | RSDCNSID | INT4 | 4 | ||
| MODFL | Flag: Aggregate has been modified | RSDDMODFL | CHAR | 1 | ||
| MODNEWFL | Flag: Change by reconstructing | RSDDMODNEWFL | CHAR | 1 | ||
| MODCNSID | Change Run ID, That Made Change | RSDDMODCNSID | INT4 | 4 | ||
| NEXT_BETTERUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | ||
| NEXTUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | ||
| PARENTUID | Technical UID for aggregates | RSDDAGGRUID | CHAR | 25 | ||
| NUM_AGGR | Number of components of the aggregate | RSDDNUMAGGR | INT4 | 4 | ||
| .INCLUDE | RSDDAGGRSTATISTIC | 0 | ||||
| NUM_ENTRIES | Number of records in the aggregate table | RSDDNUMENTRIES | INT4 | 4 | ||
| CALLS | Number of call-ups of an aggregate | RSDDCALLS | INT4 | 4 | ||
| LASTCALL | Last call-up | RSDDLASTCALL | DEC | 8 | ||
| LASTUPDATE | Date and time of the last roll up | RSDDLASTUPDATE | DEC | 8 | ||
| LASTUPDATEUSER | Last Changed By | RSTSTPNM | CHAR | 12 | * | |
| AVGFACTREDUCE | Average no. of summarizations in an aggregate | RSDDAVGFACTREDUCE | INT4 | 4 | ||
| .INCLUDE | RSTSTPINT | 0 | ||||
| TSTPNM | Last Changed By | RSTSTPNM | CHAR | 12 | USR02 | |
| TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 8 | ||
| EXPERTMODE | Flag: Whether aggregate definition created in expert mode | RSDDEXPTMODE | CHAR | 1 | ||
| .INCLUDE | RSTLOGO_AM | 0 | ||||
| .INCLUDE | RSTLOGO_A | 0 | ||||
| OBJSTAT | Object Status | RSOBJSTAT | CHAR | 3 | ||
| CONTREL | Content release | RSCONTREL | CHAR | 6 | ||
| CONTTIMESTMP | Content time stamp: Last modification to the object by SAP | RSCONTTIMESTMP | DEC | 8 | ||
| OWNER | Owner (Person Responsible) | RSOWNER | CHAR | 12 | * | |
| BWAPPL | BW Application (Namespace) | RSBWAPPL | CHAR | 10 | ||
| ACTIVFL | Active and revised version do not agree | RSACTIVFL | CHAR | 1 | ||
| DIRECT_FILL | Flag: Fill aggregate iwth database means | RSDDDIRECTFILL | CHAR | 1 | ||
| DIMSHARE | Character String for Non-Shared Dimensions | RSDDAGGRDIMSHARE | CHAR | 16 | ||
| SRDATE_VAR | BW: Unequivocal ID in room and time (numbers and letters) | RSUNIIDC25 | CHAR | 25 | ||
| VARFL | Boolean | RS_BOOL | CHAR | 1 | ||
| SRDATE | Date with which texts, attributes and hierarchies are read | RRSRDATE | DATS | 8 | ||
| LAST_CHECK | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC | 8 | ||
| CHECKAGGR | Is CheckAggr (= 'A') | RSDDAGGRCHECK | CHAR | 1 | ||
| TECH_SET | Boolean | RS_BOOL | CHAR | 1 |