SAP ABAP Table RSDDK_SX_AGGRCAT (Description of an Aggregate)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDDK (Package) BW Aggregates

Basic Data

Table Category	INTTAB	Structure
Structure	RSDDK_SX_AGGRCAT	Table Relationship Diagram
Short Description	Description of an Aggregate

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	AGGRUID	☐	RSDDAGGRUID	RSDDAGGRUID_SYSUUID_25	CHAR	25	0	Technical UID for aggregates
2	OBJVERS	☐	RSOBJVERS	RSOBJVERS	CHAR	1	0	Object version
3	INFOCUBE	☐	RSINFOCUBE	RSINFOCUBE	CHAR	30	0	InfoCube
4	AGGRCUBE	☐	RSINFOCUBE	RSINFOCUBE	CHAR	30	0	InfoCube
5	PARTITIONING	☐	RSDDKAGGRPARTITION	RSDDKAGGRPARTITION	CHAR	1	0	Aggregate: Partitioning Property
6	RNSID_TO	☐	RSDRNSID	RSSID	INT4	10	0	SID of a request
7	CNSID_TO	☐	RSDCNSID	RSDCNSID	INT4	10	0	SID of the change
8	MODFL	☐	RSDDMODFL	RSBOOL	CHAR	1	0	Flag: Aggregate has been modified
9	MODNEWFL	☐	RSDDMODNEWFL	RSBOOL	CHAR	1	0	Flag: Change by reconstructing
10	MODCNSID	☐	RSDDMODCNSID	RSSID	INT4	10	0	Change Run ID, That Made Change
11	NEXT_BETTERUID	☐	RSDDAGGRUID	RSDDAGGRUID_SYSUUID_25	CHAR	25	0	Technical UID for aggregates
12	NEXTUID	☐	RSDDAGGRUID	RSDDAGGRUID_SYSUUID_25	CHAR	25	0	Technical UID for aggregates
13	PARENTUID	☐	RSDDAGGRUID	RSDDAGGRUID_SYSUUID_25	CHAR	25	0	Technical UID for aggregates
14	NUM_AGGR	☐	RSDDNUMAGGR	INT4	INT4	10	0	Number of components of the aggregate
15	.INCLUDE	☐				0	0	Include: Statistical fields for aggregates
16	NUM_ENTRIES	☐	RSDDNUMENTRIES		INT4	10	0	Number of records in the aggregate table
17	CALLS	☐	RSDDCALLS		INT4	10	0	Number of call-ups of an aggregate
18	LASTCALL	☐	RSDDLASTCALL	TZNTSTMPS	DEC	15	0	Last call-up
19	LASTUPDATE	☐	RSDDLASTUPDATE	TZNTSTMPS	DEC	15	0	Date and time of the last roll up
20	LASTUPDATEUSER	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	*
21	AVGFACTREDUCE	☐	RSDDAVGFACTREDUCE		INT4	10	0	Average no. of summarizations in an aggregate
22	.INCLUDE	☐				0	0	Include: Last changed by, time stamp in internal format
23	TSTPNM	☐	RSTSTPNM	XUBNAME	CHAR	12	0	Last changed by	USR02
24	TIMESTMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25	EXPERTMODE	☐	RSDDEXPTMODE	RSBOOL	CHAR	1	0	Flag: Whether aggregate definition created in expert mode
26	.INCLUDE	☐				0	0	Properties TLOGO object (available in A and M versions)
27	.INCLUDE	☐				0	0	Properties TLOGO object (only available in A version)
28	OBJSTAT	☐	RSOBJSTAT	RSOBJSTAT	CHAR	3	0	Object Status
29	CONTREL	☐	RSCONTREL	CHAR6	CHAR	6	0	Content release
30	CONTTIMESTMP	☐	RSCONTTIMESTMP	TZNTSTMPS	DEC	15	0	Content time stamp: Last modification to the object by SAP
31	OWNER	☐	RSOWNER	XUBNAME	CHAR	12	0	Owner (Person Responsible)	*
32	BWAPPL	☐	RSBWAPPL		CHAR	10	0	BW Application (Namespace)
33	ACTIVFL	☐	RSACTIVFL	XFELD	CHAR	1	0	Active and revised version do not agree
34	DIRECT_FILL	☐	RSDDDIRECTFILL	RSBOOL	CHAR	1	0	Flag: Fill aggregate iwth database means
35	DIMSHARE	☐	RSDDAGGRDIMSHARE	CHAR16	CHAR	16	0	Character String for Non-Shared Dimensions
36	SRDATE_VAR	☐	RSUNIIDC25	RSUNIIDC25	CHAR	25	0	BW: Unequivocal ID in room and time (numbers and letters)
37	VARFL	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
38	SRDATE	☐	RRSRDATE	RSDATE	DATS	8	0	Date with which texts, attributes and hierarchies are read
39	LAST_CHECK	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
40	CHECKAGGR	☐	RSDDAGGRCHECK	RS_BOOL	CHAR	1	0	Is CheckAggr (= 'A')
41	TECH_SET	☐	RS_BOOL	RS_BOOL	CHAR	1	0	Boolean
42	AGGROBJ	☐	RSDDK_TH_AGGROBJ		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RSDDK_SX_AGGRCAT	TSTPNM	USR02	BNAME	KEY	C	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in	400