SAP ABAP Table CRMS_IU_DSM_PRG_DATA (DSM program incl. measures, incentives, goals, processes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-DSM-PRG (Application Component) DSM - Program
     ⤷ CRM_IU_DSM_PRG_APP (Package) Utilities DSM (Demand Side management) Program

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_IU_DSM_PRG_DATA	Table Relationship Diagram
Short Description	DSM program incl. measures, incentives, goals, processes

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	.INCLUDE	☐				0	0	DSM Program Header and Extension Include (for API)
2	PROGRAM_GUID	☐	SYSUUID_X16	SYSUUID_X16	RAW	16	0	16 Byte UUID in 16 Bytes (Raw Format)
3	.INCLUDE	☐				0	0	LOY FRW : Administrative Include
4	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
5	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
6	CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
7	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
8	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
9	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
10	.INCLUDE	☐				0	0	DSM Program Header
11	OBJECT_ID	☐	CRM_IU_DSM_PRG_EXTERNAL_ID	CRM_IU_DSM_PRG_EXTERNAL_ID	CHAR	20	0	DSM Program External Identifier
12	PROG_TYPE	☐	CRM_IU_DSM_PRG_PROGRAM_TYPE	CRM_IU_DSM_PRG_PROGRAM_TYPE	CHAR	4	0	Program Type	*
13	BUAG_CLASS	☐	CRMT_BUAG_CLASS	CRMT_BUAG_CLASS	CHAR	10	0	Business Agreement Class	*
14	AUTH_GROUP	☐	CRM_IU_DSM_AUTH_GROUP	CRM_IU_DSM_AUTH_GROUP	CHAR	4	0	Authorization Group	*
15	SERV_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
16	PROG_MGMT_AREA	☐	CRM_IU_DSM_PRG_MGMT_AREA		CHAR	18	0	Program Management Area
17	TIME_ZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
18	CURRENCY	☐	CRM_IU_DSM_CURRENCY	WAERS	CUKY	5	0	Currency	*
19	PROFILE_ID	☐	CRM_IU_DSM_PRG_PROFILE_ID		CHAR	10	0	Program Profile ID
20	PROG_START_DATE	☐	CRM_IU_DSM_PRG_START_DATE	SYDATS	DATS	8	0	Validity Start Date
21	PROG_START_TIME	☐	CRM_IU_DSM_PRG_START_TIME	SYTIME	TIMS	6	0	Validity Start Time
22	PROG_FINISH_DATE	☐	CRM_IU_DSM_PRG_FINISH_DATE	SYDATS	DATS	8	0	Validity End Date
23	PROG_FINISH_TIME	☐	CRM_IU_DSM_PRG_FINISH_TIME	SYTIME	TIMS	6	0	Validity End Time
24	PREMISE_REQUIRED	☐	CRM_IU_DSM_PREMISE_REQUIRED		CHAR	1	0	Premise Required
25	PROG_DESC_TEXT	☐	CRM_IU_DSM_PRG_DESC_TEXT	TEXT40	CHAR	40	0	Description of program
26	PROG_DESC_UP	☐	CRM_IU_DSM_PRG_DESC_TEXT_UP	CHAR40	CHAR	40	0	Description of program
27	AP_SUB_FROM_DATE	☐	CRM_IU_DSM_PRG_APFR_START_DATE	SYDATS	DATS	8	0	Application Submission Start Date
28	AP_SUB_TO_DATE	☐	CRM_IU_DSM_PRG_APFR_END_DATE	SYDATS	DATS	8	0	Application Submission End Date
29	AG_SUB_FROM_DATE	☐	CRM_IU_DSM_PRG_AGFR_START_DATE	SYDATS	DATS	8	0	Enrollment Period Start Date
30	AG_SUB_TO_DATE	☐	CRM_IU_DSM_PRG_AGFR_END_DATE	SYDATS	DATS	8	0	Enrollment Period End Date
31	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
32	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
33	BRF_FUNCTION_ID	☐	CRM_IU_DSM_PRG_SYSUUID	SYSUUID_C	CHAR	32	0	BRFplus Function Identifier
34	.INCLUDE	☐				0	0	Extension Include for DSM Program Header
35	HEADER_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
36	MEASURES_INCENTIVES	☐	CRMT_IU_DSM_PRG_MEAS_INCT		TTYP	0	0
37	GOALS	☐	CRMT_IU_DSM_PRG_GOAL_AND_EXT		TTYP	0	0
38	PROCESS_ASSIGNMENTS	☐	CRMT_IU_DSM_PRG_PASG_AND_EXT		TTYP	0	0

History

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