Show TOC

DSM Agreement Item Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0CRM_IU_DSM_AGR_I

 

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

  • DSM agreement header GUID

  • DSM agreement header object ID

  • DSM agreement item data

  • DSM agreement item partners

  • DSM agreement item organization data

  • DSM agreement item product

  • DSM agreement item status

  • DSM agreement item dates

  • DSM agreement item document flow data

  • DSM agreement 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 agreement 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

AMOUNT

Amount

PRICING_I

NET_VALUE_MAN

BILL_DATE

Date

BILLPLAN_D

BILL_DATE

BILLPLAN_TYPE

BillingPlanType

BILLPLAN

BILLPLAN_TYPE

BILL_TO_PARTY

Bill-To Party

PARTNER

PARTNER_NO

BILL_VALUE

Billing Value

BILLPLAN_D

BILL_VALUE

BWSTLOCSYS0

BW Status

STATUS

STATUS

BWSTONESYS0

BW Status

STATUS

STATUS

BWSTONESYS8

BW Status

STATUS

STATUS

BWSTONESYSD

BW Status

STATUS

STATUS

BWSTTECSYS0

BW Status

STATUS

STATUS

BWSTTECSYS2

BW Status

STATUS

STATUS

CONTACT_PERSON

Contact Pers.

PARTNER

PARTNER_NO

CURRENCY

Currency

PRICING

CURRENCY

DIS_CHANNEL

Distribution Channel

ORGMAN

DIS_CHANNEL

DIVISION

Division

ORGMAN

DIVISION

DSM_ITM_REF_GUID

GUID

DOC_FLOW

OBJKEY_A

DSM_VAL_FROM

From Date

APPOINTMENT

TIMESTAMP_FROM

DSM_VAL_TO

End Date

APPOINTMENT

TIMESTAMP_FROM

HEADER_GUID

GUID

ORDERADM_H

ORDERADM_H_GUID

ITEM_CHANGED_AT

Changed on

ORDERADM_I

CHANGED_AT

ITEM_CHANGED_BY

Changed By

ORDERADM_I

CHANGED_BY

ITEM_CREATED_AT

Created on

ORDERADM_I

CREATED_AT

ITEM_CREATED_BY

Created By

ORDERADM_I

CREATED_BY

ITEM_GUID

GUID

ORDERADM_I

GUID

ITEM_OBJECT_TYPE

CRM Item Object Type

ORDERADM_I

OBJECT_TYPE

ITM_TYPE

Item Category

ORDERADM_I

ITM_TYPE

ITM_TYPE_USAGE

Item Cat. Usage

ORDERADM_I

ITM_TYPE_USAGE

ITM_USAGE

Usage HL Item

ORDERADM_I

ITM_USAGE

NUMBER_INT

Item

ORDERADM_I

NUMBER_INT

OBJECT_ID

ID

ORDERADM_H

OBJECT_ID

PARENT

GUID

ORDERADM_I

PARENT

PAYER

Payer

PARTNER

PARTNER_NO

PAYMENT_RECIPT

Payment Recip.

PARTNER

PARTNER_NO

PERCENTAGE

InvoicePercentg

BILLPLAN_D

PERCENTAGE

PERSON_RESP

Employee Resp.

PARTNER

PARTNER_NO

PRODUCT_GUID

GUID

ORDERADM_I

PRODUCT

PRODUCT_ID

Product ID

ORDERADM_I

PRODUCT

QUANTITY

Quantity

SCHEDLIN_I

ORDER_QTY

SALES_OFFICE

Object ID

ORGMAN

SALES_OFFICE

SALES_ORG

Object ID

ORGMAN

SALES_ORG

SALES_ORG_RESP

Object ID

ORGMAN

SALES_ORG_RESP

SERVICE_ORG

Object ID

ORGMAN

SERVICE_ORG

SERVICE_ORG_RESP

Object ID

ORGMAN

SERVICE_ORG_RESP

SOLD_TO_PARTY

Customer

PARTNER

PARTNER_NO

UNIT

Sales Unit

PRODUCT_I

PROCESS_QTY_UNIT

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

Business Agreement Number

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