Offer Term Product

: 0TI_RT_PRM_28

The Offer Term Product DataSource is used to extract offer term product data from the SAP Promotion Management for Retail system. All the offer term product data for offers that are associated with events with the Delivered status is extracted through this DataSource. It uses a function module to fetch the offer term product data for all the offers associated with delivered events. The function module calls a Business Add-In to read offer term product data from SAP Demand Management Foundation.

Technical Data

Application Component	PRM_BO_EVENT
Available as of Release	SAP Promotion Management for Retail 7.0 SP01
Shipment	SAP NetWeaver 7.0 BI Content Add-On 5
Content Versions	RET700
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

When the status of an event is changed to Delivered, all offer term product data for the offers associated with the delivered event is written to the delta queue.

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
DB_KEY	Node ID	/DMF/OFR_TRM_PRD	DB_KEY
OFR_TRM_KEY	Node ID	/DMF/OFR_TRM_DTL	PARENT_KEY
OFR_TRM_DTL_KEY	Node ID	/DMF/OFR_TRM_PRD	PARENT_KEY
EXT_OFFER_ID	External System Offer Identifier	/PRM/OFR_EVT_XR	EXT_OFFER_ID
UPDMOD	BW Delta Process: Record Mode		UPDMOD
DISC_TCD	Discount Type Code	/DMF/OFR_TRM_PRD	DISC_TCD
DISC_VAL	Amount of Discount Applied in an Offer	/DMF/OFR_TRM_PRD	DISC_VAL
PROD_ID	Unique Identifier for Product	/DMF/OFR_TRM_PRD	PROD_ID

Extractor Logic

The Offer Term Incentives extractor is based on the function module. The extractor does not transform the Key Figures. Key figures are transferred 1:1.