Show TOC

 Entitlements: Header/Item

Technical Name: EM_HITEM

Technical Data

DataSource Type

Transactional Data (Transaction Data)

Application Components

CRM Entitlement Management ( /CEM/EM)

Available as from OLTP Release

CRM 5.0

Available as from PlugIn Release

n/a

RemoteCube-Capable

No

Use

This DataSource contains the fields necessary for extracting information from the entitlement header and item to the equivalent BW InfoSource Entitlements: Header/Item .

Delta Update

You can run an initial, complete, and delta upload for this DataSource.

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

CLIENT

Client

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

CLIENT

APPLICATION

Application

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

APPLICATION

H_GUID

Header GUID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_GUID

H_ID

Entitlement ID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_ID

H_CANC_FLAG

Flag

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CANC_FLAG

TYPE

Type

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

TYPE

DEF_FLAG

Deferred Flag

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

DEF_FLAG

IC_FLAG

Intercompany Flag

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

IC_FLAG

H_LOGSYS

Logical System

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_LOGSYS

H_LOGHANDLE

Log Handle

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_LOGHANDLE

H_ARCHIVE_FLAG

Archive Flag

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_ARCHIVE_FLAG

BILL_ORG

Billing Unit

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

BILL_ORG

H_PART_ID

Entitlement Partner ID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_PART_ID

H_PART_GUID

Entitlement Partner GUID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_PART_GUID

COPA_PART_ID

Entitlement Issuer

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

COPA_PART_ID

COPA_PART_GUID

Entitlement Issuer GUID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

COPA_PART_GUID

H_PROD_ID

Entitlement Product ID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_PROD_ID

H_PROD_GUID

Product GUID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_PROD_GUID

H_PROD_CAT

Entitlement Product Category ID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_PROD_CAT

START_DATE

Start Date

//CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

START_DATE

END_DATE

End Date

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

END_DATE

H_STATUS

Entitlement Status

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_STATUS

RATE

Entitlement Rate

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

RATE

RATE_CURR

Entitlement Rate Currency

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

RATE_CURR

RATE_PRCUNT

Entitlement Rate Pricing Unit

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

RATE_PRCUNT

RATE_PRCUOM

Entitlement Rate UOM

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

RATE_PRCUOM

H_CREA_BY

Created By

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CREA_BY

H_CREA_DATE

Creation Date

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CREA_DATE

H_CREA_TIME

Creation Time

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CREA_TIME

H_CHNG_BY

Changed By

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CHNG_BY

H_CHNG_DATE

Changed Date

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CHNG_DATE

H_CHNG_TIME

Changed Time

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

H_CHNG_TIME

ENT_STRATEGY

Entitlement Strategy

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

ENT_STRATEGY

ORD_PROD_ID

Ordered Product Number

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

ORD_PROD_ID

ORD_PROD_GUID

Ordered Product GUID

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

ORD_PROD_GUID

SUMMARY

Summary

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

SUMMARY

SUMMARYTYPE

Summary Type

/CEM/D_H_ENT

/CEM/D_H_RPH

/CEM/D_H_SUMM

SUMMARYTYPE

I_GUID

Item GUID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_GUID

I_ID

Transaction ID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_ID

I_CANC_FLAG

Item Cancellation Flag

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CANC_FLAG

PROCESS_CODE

Process Code

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

PROCESS_CODE

SUB_PROC_CODE

Subsequent Process Code

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

SUB_PROC_CODE

REASON_CODE

Reason Code

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

REASON_CODE

ROLLABLE

Rollable Flag

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

ROLLABLE

I_LOGHANDLE

Item Log Handle

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_LOGHANDLE

I_STATUS

Transaction Status

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_STATUS

TRAN_QTY

Transactional Quantity

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_QTY

TRAN_QTY_UOM

Transactional Quantity UOM

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_QTY_UOM

TRAN_RATE

Transactional Rate

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_RATE

TRAN_RATE_CURR

Transactional Rate Currency

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_RATE_CURR

TRAN_RATE_PRCUNT

Transactional Rate Pricing Unit

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_RATE_PRCUNT

TRAN_RATE_PRCUOM

Transactional Rate Unit of Measure

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_RATE_PRCUOM

TRAN_VAL

Transactional Value

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_VAL

TRAN_VAL_CURR

Transactional Value Currency

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_VAL_CURR

TRAN_DATE

Transaction Date

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_DATE

I_CREA_BY

Created By

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CREA_BY

I_CREA_DATE

Creation Date

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CREA_DATE

I_CREA_TIME

Creation Time

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CREA_TIME

I_CHNG_BY

Changed By

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CHNG_BY

I_CHNG_DATE

Changed Date

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CHNG_DATE

I_CHNG_TIME

Changed Time

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

I_CHNG_TIME

INPA_PART_ID

Invoice Issuer ID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

INPA_PART_ID

INPA_PART_GUID

Invoice Issuer GUID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

INPA_PART_GUID

TRAN_PART_ID

Receiving Partner ID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_PART_ID

TRAN_PART_GUID

Receiving Partner GUID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_PART_GUID

TRAN_PROD_ID

Transactional Product ID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_PROD_ID

TRAN_PROD_GUID

Transactional Product GUID

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_PROD_GUID

TRAN_PROD_CAT

Transactional Product Category

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

TRAN_PROD_CAT

RECORDMODE

BW Delta Process: Update Mode

/CEM/D_I_ENT

/CEM/D_I_RPH

/CEM/D_I_SUMM

RECORDMODE

Particular Features of the Extractor

You can use the following selection criteria for extraction purposes:

  • Application

  • Entitlement ID

  • Entitlement Issuer

  • Entitlement Status

  • Created By

  • Creation Date