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

History

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