SAP ABAP Table CRMS_BW_IU_DSM_PGM (Extraction Structure for DSM Program Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-DSM (Application Component) Demand Side Management
     ⤷ CRM_IU_DSM_BW (Package) Utilities DSM (Demand Side management) BW package

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_BW_IU_DSM_PGM	Table Relationship Diagram
Short Description	Extraction Structure for DSM Program Data

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
3	REF_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	APPLICATION	☐	LOY_FRW_APPLICATION	LOY_FRW_APPLICATION	CHAR	4	0	Application
5	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
6	.INCLUDE	☐				0	0	LOY FRW : Administrative Include
7	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
8	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
9	CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
10	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
11	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
12	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
13	.INCLUDE	☐				0	0	DSM Program Header
14	OBJECT_ID	☐	CRM_IU_DSM_PRG_EXTERNAL_ID	CRM_IU_DSM_PRG_EXTERNAL_ID	CHAR	20	0	DSM Program External Identifier
15	PROG_TYPE	☐	CRM_IU_DSM_PRG_PROGRAM_TYPE	CRM_IU_DSM_PRG_PROGRAM_TYPE	CHAR	4	0	Program Type	*
16	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
17	AUTH_GROUP	☐	CRM_IU_DSM_AUTH_GROUP	CRM_IU_DSM_AUTH_GROUP	CHAR	4	0	Authorization Group	*
18	SERV_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
19	PROG_MGMT_AREA	☐	CRM_IU_DSM_PRG_MGMT_AREA		CHAR	18	0	Program Management Area
20	TIME_ZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
21	CURRENCY	☐	CRM_IU_DSM_CURRENCY	WAERS	CUKY	5	0	Currency	*
22	PROFILE_ID	☐	CRM_IU_DSM_PRG_PROFILE_ID		CHAR	10	0	Program Profile ID
23	PROG_START_DATE	☐	CRM_IU_DSM_PRG_START_DATE	SYDATS	DATS	8	0	Validity Start Date
24	PROG_START_TIME	☐	CRM_IU_DSM_PRG_START_TIME	SYTIME	TIMS	6	0	Validity Start Time
25	PROG_FINISH_DATE	☐	CRM_IU_DSM_PRG_FINISH_DATE	SYDATS	DATS	8	0	Validity End Date
26	PROG_FINISH_TIME	☐	CRM_IU_DSM_PRG_FINISH_TIME	SYTIME	TIMS	6	0	Validity End Time
27	PREMISE_REQUIRED	☐	CRM_IU_DSM_PREMISE_REQUIRED		CHAR	1	0	Premise Required
28	PROG_DESC_TEXT	☐	CRM_IU_DSM_PRG_DESC_TEXT	TEXT40	CHAR	40	0	Description of program
29	PROG_DESC_UP	☐	CRM_IU_DSM_PRG_DESC_TEXT_UP	CHAR40	CHAR	40	0	Description of program
30	AP_SUB_FROM_DATE	☐	CRM_IU_DSM_PRG_APFR_START_DATE	SYDATS	DATS	8	0	Application Submission Start Date
31	AP_SUB_TO_DATE	☐	CRM_IU_DSM_PRG_APFR_END_DATE	SYDATS	DATS	8	0	Application Submission End Date
32	AG_SUB_FROM_DATE	☐	CRM_IU_DSM_PRG_AGFR_START_DATE	SYDATS	DATS	8	0	Enrollment Period Start Date
33	AG_SUB_TO_DATE	☐	CRM_IU_DSM_PRG_AGFR_END_DATE	SYDATS	DATS	8	0	Enrollment Period End Date
34	AG_SUB_PER_TYPE	☐	CRM_IU_DSM_PRG_HEAD_SUB_TYPE	CRM_IU_DSM_PRG_SUB_PER_TYPE	CHAR	2	0	Program submission period type
35	AP_SUB_PER_TYPE	☐	CRM_IU_DSM_PRG_HEAD_SUB_TYPE	CRM_IU_DSM_PRG_SUB_PER_TYPE	CHAR	2	0	Program submission period type
36	BRF_FUNCTION_ID	☐	CRM_IU_DSM_PRG_SYSUUID	SYSUUID_C	CHAR	32	0	BRFplus Function Identifier
37	.INCLUDE	☐				0	0	DSM Program Item Data
38	CATEGORY	☐	CRM_IU_DSM_PRG_INCT_CATEGORY	CRM_IU_DSM_PRG_INCT_CATEGORY	CHAR	2	0	Incentive Category
39	PROCESS_TYPEID	☐	CRM_IU_DSM_PRG_INCT_PROCESS_TY		CHAR	5	0	Incentive Process Type
40	FLAG_MANDATORY	☐	CRM_IU_DSM_PRG_INCT_MANDATORY	FLAG	CHAR	1	0	Mandatory Program Incentive
41	FLAG_DEFAULT	☐	CRM_IU_DSM_PRG_INCT_DEFAULT	FLAG	CHAR	1	0	Default Program Incentive
42	FLAG_FIXED	☐	CRM_IU_DSM_PRG_INCT_FIXED	FLAG	CHAR	1	0	Fixed Program Incentive
43	ACCTGRP_PROD	☐	CRM_ACCTGRPPROD	CRM_ACCTGRPPROD	CHAR	2	0	Account Assignment Group for Product	*
44	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
45	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
46	ITEM_ID	☐	CRM_IU_DSM_PRG_MEASURE_ITEM_NR	CRM_IU_DSM_PRG_ITEM_ID	NUMC	10	0	Measure Item Number
47	ITEM_DESC	☐	CRM_IU_DSM_PRG_MEASURE_DSCR	TEXT40	CHAR	40	0	Measure Description
48	BASE_UOM	☐	COMT_UNIT	MEINS	UNIT	3	0	Units of Measure of Product	*
49	ITEM_VALID_FROM	☐	CRM_IU_DSM_PRG_START_DATE	SYDATS	DATS	8	0	Validity Start Date
50	ITEM_VALID_TO	☐	CRM_IU_DSM_PRG_FINISH_DATE	SYDATS	DATS	8	0	Validity End Date
51	ACTIVE	☐	CRM_IU_DSM_PRG_MEAS_ACTIVE	CRM_IU_DSM_PRG_MEAS_ACTIVE	CHAR	1	0	Current activation state of measure
52	WAS_ACTIVATED	☐	CRM_IU_DSM_PRG_MEAS_ACTIVED	FLAG	CHAR	1	0	Previously activated measure
53	PROCESS_ID	☐	CRM_IU_DSM_PROCESS_ID	CRM_IU_DSM_PROCESS	CHAR	2	0	ID of allowed object type	*
54	BUS_TRANS_TYPE	☐	CRM_IU_DSM_PRG_ASGN_PROC_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	DSM Program Business Transaction Type	*
55	REQUEST_TYPE	☐	CRM_IU_DSM_PRG_ASGN_REQ_TYPE	CRM_IU_DSM_PRG_REQ_TYPE	CHAR	10	0	DSM Program Web Request Category
56	SURVEY_ID	☐	CRM_IU_DSM_PRG_ASGN_SURVEY_ID	CHAR32	CHAR	32	0	DSM Program Survey ID
57	ITEM_CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
58	ITEM_CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
59	ITEM_CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
60	ITEM_CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
61	PARENT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
62	ITEM_OBJ_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
63	AMOUNT	☐	CRM_IU_DSM_PRG_INCT_AMOUNT		CURR	15	2	Amount
64	.INCLUDE	☐				0	0	DSM Program Goals
65	GOAL_ID	☐	CRM_IU_DSM_PRG_GOALS_ID	CRM_IU_DSM_PRG_GOAL_ID	CHAR	10	0	Program Goal ID
66	UOM	☐	CRM_IU_DSM_PRG_UOM	MEINS	UNIT	3	0	Unit of measure for product	*
67	QUANTITY	☐	CRM_IU_DSM_PRG_GOAL_QUANTITY	CRM_IU_DSM_PRG_QUANTITY	DEC	17	3	Quantity associated with the goal

History

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