Show TOC

DSM Application Item Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0CRM_IU_DSM_APL_I

 

This DataSource contains the data for SAP Energy Demand-Side Management for Utilities application item.

The following data is loaded:

  • DSM application header GUID

  • DSM application header object ID

  • DSM application item data

  • DSM application item partners

  • DSM application item organization data

  • DSM application item product

  • DSM application item status

  • DSM application item dates

  • DSM application item document flow data

  • DSM application item measure configuration

  • DSM application item Key Figures

  • DSM application equipment attribute

  • DSM business agreement

  • DSM program equipment category

This DataSource supports the full load extraction and delta load extraction of demand-side management application item 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

Yes (AIMD)

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

HEADER_GUI

GUID

ORDERADM_H

ORDERADM_H_GUID

OBJECT_ID

ID

ORDERADM_H

OBJECT_ID

ITEM_GUID

GUID

ORDERADM_I

GUID

ITEM_CREATED_AT

Created on

ORDERADM_I

CREATED_AT

ITEM_CREATED_BY

Created By

ORDERADM_I

CREATED_BY

ITEM_CHANGED_AT

Changed On

ORDERADM_I

CHANGED_AT

ITEM_CHANGED_BY

Changed By

ORDERADM_I

CHANGED_BY

NUMBER_INT

Item

ORDERADM_I

NUMBER_INT

ITEM_OBJECT_TYPE

Object Type

ORDERADM_I

OBJECT_TYPE

ITM_TYPE

Item Category

ORDERADM_I

ITM_TYPE

ITM_USAGE

Usage HL Item

ORDERADM_I

ITM_USAGE

ITM_TYPE_USAGE

Item Cat. Usage

ORDERADM_I

ITM_TYPE_USAGE

PARENT

GUID

ORDERADM_I

PARENT

SOLD_TO_PARTY

Customer

PARTNER

PARTNER_NO

BILL_TO_PARTY

Bill-To Party

PARTNER

PARTNER_NO

PAYER

Payer

PARTNER

PARTNER_NO

PERSON_RESP

Employee Resp.

PARTNER

PARTNER_NO

CONTACT_PERSON

Contact Pers.

PARTNER

PARTNER_NO

PAYMENT_RECIPT

Payment Recip.

PARTNER

PARTNER_NO

SALES_ORG_RESP

Object ID

ORGMAN

SALES_ORG_RESP

SALES_ORG

Object ID

ORGMAN

SALES_ORG

SALES_OFFICE

Object ID

ORGMAN

SALES_OFFICE

DIS_CHANNEL

Distribution Channel

ORGMAN

DIS_CHANNEL

DIVISION

Division

ORGMAN

DIVISION

SERVICE_ORG_RESP

Object ID

ORGMAN

SERVICE_ORG_RESP

SERVICE_ORG

Object ID

ORGMAN

SERVICE_ORG

PRODUCT_ID

Product ID

ORDERADM_I

PRODUCT

PRODUCT_GUID

GUID

ORDERADM_I

PRODUCT

SHORT_TEXT_UC

Description

ORDERADM_I

DESCRIPTION_UC

BWSTONESYS0

BW Status

STATUS

STATUS

BWSTONESYS8

BW Status

STATUS

STATUS

BWSTTECSYS2

BW Status

STATUS

STATUS

BWSTLOCSYS2

BW Status

STATUS

STATUS

BWSTONESYSD

BW Status

STATUS

STATUS

SRV_RREADY

Date

APPOINTMENT

TIMESTAMP_FROM

SRV_RFIRST

Date

APPOINTMENT

TIMESTAMP_FROM

SRV_START

From Date

APPOINTMENT

TIMESTAMP_FROM

SETTL_TO

End Date

APPOINTMENT

TIMESTAMP_FROM

SETTL_FROM

From Date

APPOINTMENT

TIMESTAMP_FROM

BILL_DATE

Date

APPOINTMENT

TIMESTAMP_FROM

INVCR_DATE

Date

APPOINTMENT

TIMESTAMP_FROM

DSM_VAL_TO

End Date

APPOINTMENT

TIMESTAMP_FROM

DSM_VAL_FROM

From Date

APPOINTMENT

TIMESTAMP_FROM

DSM_REL

Date

APPOINTMENT

TIMESTAMP_FROM

START_DATE

Date

APPOINTMENT

TIMESTAMP_FROM

END_DATE

Date

APPOINTMENT

TIMESTAMP_FROM

DATE_FROM

Date

APPOINTMENT

TIMESTAMP_FROM

DATE_TO

Date

APPOINTMENT

TIMESTAMP_FROM

ADD_BP_USAGE

Bill Plan Usage

APPOINTMENT

TIMESTAMP_FROM

DSM_ITM_REF_GUID

GUID

DOC_FLOW

OBJKEY_A

DSM_ITM_REF_ID

ID

APPOINTMENT

TIMESTAMP_FROM

QUANTITY

Quantity

SCHEDLIN_I

ORDER_QTY

UNIT

Sales Unit

PRODUCT_I

PROCESS_QTY_UNIT

AMOUNT

Amount

PRICING_I

NET_VALUE_MAN

CURRENCY

Currency

PRICING

CURRENCY

MANUFACTURER

Manufacturer

ORDERADM_I

PRODUCT

MODEL_NUMBER

Model Number

ORDERADM_I

PRODUCT

SERIAL_NO

Manufacturer Serial Number

ORDERADM_I

PRODUCT

BUAG_GUID

GUID of the Business Agreement

BILLING

BUAG_GUID

BUAG_ID

Number of Business Agreement

BILLING

BUAG_ID

BUAG_CLASS

Business Agreement Class

BILLING

BUAG_CLASS

EQUIP_CAT_GUID

Category GUID as CHAR32

ORDERADM_I

PRODUCT

EQUIP_CAT_ID

Category ID

ORDERADM_I

PRODUCT

DSM_PREMISE_ID

Premise

DOC_FLOW

OBJKEY_A

DSM_ADDR_LINE1

Address line 1

DOC_FLOW

OBJKEY_A

DSM_ADDR_LINE2

Address line 2

DOC_FLOW

OBJKEY_A

DSM_PREMISE_DESC

Address description

DOC_FLOW

OBJKEY_A