Show TOC

DSM Program Data Locate this document in the navigation structure

DataSource Attributes DataSource Attributes: 0CRM_IU_DSM_PRG_ATTR

 

This DataSource contains the data for programs in SAP Energy Demand-Side Management for Utilities. The following data is loaded:

  • DSM program header GUID

  • DSM program header object type

  • DSM program header status

  • DSM program header administration data

  • DSM program header data

  • DSM program item data

  • DSM program goal data

  • DSM program BW status

  • DSM program equipment category

This DataSource supports the full load extraction of DSM program data.

Technical Data

Application Component

Demand Side Management (0CRM_UC_DSM)

Available as of Release

SAP CRM 7.0 EHP3

Shipment

BI Content 747 SP06

Content Versions

CRM713

RemoteCube-Capable

No

Delta-Capable

No

Extraction from Archives

No

Verifiable

No

Data Modeling

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

GUID

GUID

CRMD_IUDSM_PHEAD

GUID

OBJECT_TYPE

Trans. Category

n/a

n/a

STAT

Status

CRM_JEST

STAT

CREATED_BY

Created By

CRMD_IUDSM_PHEAD

CREATED_BY

CREATED_AT

Created At

DSM Program Header Table

CREATED_AT

CHANGED_BY

Changed By

DSM Program Header Table

CHANGED_BY

CHANGED_AT

Changed At

DSM Program Header Table

CHANGED_AT

OBJECT_ID

Program ID

DSM Program Header Table

OBJECT_ID

PROG_TYPE

Program Type

DSM Program Header Table

PROG_TYPE

BUAG_CLASS

Bus. Agreement Class

DSM Program Header Table

PROG_TYPE

AUTH_GROUP

Auth. Group

DSM Program Header Table

AUTH_GROUP

SERV_ORG

Service Organization

DSM Program Header Table

SERV_ORG

PROG_MGMT_AREA

Prog. Mgmt Area

DSM Program Header Table

PROG_MGMT_AREA

TIME_ZONE

Time Zone

DSM Program Header Table

TIME_ZONE

CURRENCY

Currency

DSM Program Header Table

CURRENCY

PROFILE_ID

Prog. Prof. ID

DSM Program Header Table

PROFILE_ID

PROG_START_DATE

Start Date

DSM Program Header Table

PROG_START_DATE

PROG_FINISH_DATE

End Date

DSM Program Header Table

PROG_FINISH_DATE

PREMISE_REQUIRED

Premise Reqd

DSM Program Header Table

PREMISE_REQUIRED

PROG_DESC_TEXT

Program Desc.

DSM Program Header Table

PROG_DESC_TEXT

AP_SUB_FROM_DATE

Start Date

DSM Program Header Table

AP_SUB_FROM_DATE

AP_SUB_TO_DATE

End Date

DSM Program Header Table

AP_SUB_TO_DATE

AG_SUB_FROM_DATE

Start Date

DSM Program Header Table

AG_SUB_FROM_DATE

AG_SUB_TO_DATE

End Date

DSM Program Header Table

AG_SUB_TO_DATE

AG_SUB_PER_TYPE

Sub. Per. Type

DSM Program Header Table

AG_SUB_PER_TYPE

AP_SUB_PER_TYPE

Sub. Per. Type

DSM Program Header Table

AP_SUB_PER_TYPE

BRF_FUNCTION_ID

Universal Unique ID

CRMD_IUDSM_PINCT

BRF_FUNCTION_ID

CATEGORY

Incent. Cat.

CRMD_IUDSM_PINCT

CATEGORY

PROCESS_TYPEID

Incent. Proc. Type

CRMD_IUDSM_PINCT

PROCESS_TYPEID

FLAG_MANDATORY

Mandatory Incent.

CRMD_IUDSM_PINCT

FLAG_MANDATORY

FLAG_DEFAULT

Default Incent.

CRMD_IUDSM_PINCT

FLAG_DEFAULT

FLAG_FIXED

Fixed Incentive

CRMD_IUDSM_PINCT

FLAG_FIXED

ACCTGRP_PROD

Accnt Ass. Grp

CRMD_IUDSM_PINCT

ACCTGRP_PROD

ITEM_GUID

GUID

CRMD_IUDSM_PINCT

ITEM_GUID

PRODUCT_GUID

GUID

CRMD_IUDSM_PMEAS

PRODUCT_GUID

ITEM_ID

Item Number

CRMD_IUDSM_PMEAS

ITEM_ID

ITEM_DESC

Description

CRMD_IUDSM_PMEAS

ITEM_DESC

BASE_UOM

Unit of Measure

CRMD_IUDSM_PMEAS

BASE_UOM

ITEM_VALID_FROM

Start Date

CRMD_IUDSM_PMEAS

VALID_FROM

ITEM_VALID_TO

End Date

CRMD_IUDSM_PMEAS

VALID_TO

ACTIVE

Activation State

CRMD_IUDSM_PMEAS

ACTIVE

WAS_ACTIVATED

Activated Measure

CRMD_IUDSM_PMEAS

WAS_ACTIVATED

PROCESS_ID

Object Type ID

CRMD_IUDSM_PPASG

PROCESS_ID

BUS_TRANS_TYPE

Transaction Type

CRMD_IUDSM_PPASG

BUS_TRANS_TYPE

REQUEST_TYPE

Request Cat.

CRMD_IUDSM_PPASG

REQUEST_TYPE

SURVEY_ID

Survey ID

CRMD_IUDSM_PPASG

SURVEY_ID

ITEM_CREATED_BY

Created By

CRMD_IUDSM_PMEAS

CREATED_BY

ITEM_CREATED_AT

Created At

CRMD_IUDSM_PMEAS

CREATED_AT

ITEM_CHANGED_BY

Last Changed By

CRMD_IUDSM_PMEAS

CHANGED_BY

ITEM_CHANGED_AT

Changed At

CRMD_IUDSM_PMEAS

CHANGED_AT

PARENT

GUID

CRMD_IUDSM_PHEAD

GUID

ITEM_OBJ_TYPE

Trans. Category

CRMD_IUDSM_PINCT

OBJ_TYPE

AMOUNT

Amount

CRMD_IUDSM_PINCT

AMOUNT

GOAL_ID

Goal ID

CRMD_IUDSM_PGOCO

GOAL_ID

UOM

Unit of Measure

CRMD_IUDSM_PGOCO

UOM

QUANTITY

Goal Quantity

CRMD_IUDSM_PGOCO

QUANTITY

BWSTUDPSYS0

BW Status

n/a

n/a

BWSTUDPSYS1

BW Status

n/a

n/a

EQUIP_CAT_GUID

Category GUID as CHAR32

CRMD_IUDSM_PMEAS

CATEGORY_GUID

EQUIP_CAT_ID

Category ID

CRMD_IUDSM_PMEAS

CATEGORY_GUID