SAP ABAP Table ALPFCOLLREORGSCH (Collection/Reorganization Schemata for PerfDB)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON (Application Component) Monitoring
     ⤷ SMOI (Package) CCMS: Monitoring Architecture

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ALPFCOLLREORGSCH	Table Relationship Diagram
Short Description	Collection/Reorganization Schemata for PerfDB

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	POLICYID	☑	ALPFPOLKEY	CHAR40	CHAR	40	0	Name of a CPH Collection and Reorganization Schema
2	MIN_DAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
3	MIN_DAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
4	MIN_WEEK_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
5	MIN_WEEK_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
6	MIN_XDAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
7	MIN_XDAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
8	MIN_MONTH_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
9	MIN_MONTH_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
10	MIN_QUART_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
11	MIN_QUART_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
12	MIN_YEAR_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
13	MIN_YEAR_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
14	QTR_DAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
15	QTR_DAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
16	QTR_WEEK_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
17	QTR_WEEK_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
18	QTR_XDAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
19	QTR_XDAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
20	QTR_MONTH_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
21	QTR_MONTH_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
22	QTR_QUART_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
23	QTR_QUART_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
24	QTR_YEAR_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
25	QTR_YEAR_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
26	HR_DAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
27	HR_DAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
28	HR_WEEK_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
29	HR_WEEK_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
30	HR_XDAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
31	HR_XDAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
32	HR_MONTH_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
33	HR_MONTH_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
34	HR_QUART_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
35	HR_QUART_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
36	HR_YEAR_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
37	HR_YEAR_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
38	DAY_DAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
39	DAY_DAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
40	DAY_WEEK_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
41	DAY_WEEK_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
42	DAY_XDAY_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
43	DAY_XDAY_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
44	DAY_MONTH_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
45	DAY_MONTH_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
46	DAY_QUART_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
47	DAY_QUART_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
48	DAY_YEAR_K	☐	ALPFKEEPCNT		INT4	10	0	Keep Value for PerfDB Reorganization
49	DAY_YEAR_D	☐	ALPFDELCNT		INT4	10	0	Delete Value for PerfDB Reorganization
50	X_VALUE	☐	INT4	INT4	INT4	10	0	Natural number
51	COLLPERIOD	☐	ALPFDBNUM		INT4	10	0	Alert: integer used in performance DB
52	AVGMETHOD	☐	ALAVGTYP	CHAR4	CHAR	4	0	Alert: type of average
53	WEIGHTSCHEM	☐	ALPFPOLKEY	CHAR40	CHAR	40	0	Name of a CPH Collection and Reorganization Schema
54	SFTNAME	☐	ALPFPOLKEY	CHAR40	CHAR	40	0	Name of a CPH Collection and Reorganization Schema
55	COLL_METHOD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
56	COLL_TIMEZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
57	REORG_TIMEZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*

History

Last changed by/on	SAP	20130604
SAP Release Created in	630