Position Offer Assignment Transactional Data 
: 0TI_RT_PRM_16
The Position Offer Assignment Transactional Data DataSource is used to extract position offer assignment transactional data from the SAP Promotion Management for Retail system. All the position offer assignment transactional for offers that are associated with events with a delivered status are extracted through this DataSource.
Technical Data
Application Component | PRM_BO_EVENT |
|---|---|
Available as of Release | SAP Promotion Management for Retail 7.1 |
Shipment | SAP NetWeaver 7.0 BI Content Add-On 5 |
Content Versions | RET701 |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Delta Update
The delta process used is NEWE, Only New Records (Inserts) via Extractor (Cube-Compatible).
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 |
/PRM/POS_OFR_ASS |
DB_KEY |
MKT_VER_KEY |
Node ID |
/PRM/POS_OFR_ASS |
MKT_VER_KEY |
PARTITION_KEY |
Event ID |
/PRM/POS_OFR_ASS |
PARTITION_KEY |
EXT_OFR_ID |
Name |
/PRM/POS_OFR_ASS |
EXT_OFR_ID |
AREA_KEY |
Block Position |
/PRM/POS_OFR_ASS |
AREA_KEY |
BLOCK_ID |
Partition Key |
/PRM/POS_OFR_ASS |
BLOCK_ID |
PRI_OFR_ASGN_KEY |
Block Key |
/PRM/POS_OFR_ASS |
PRI_OFR_ASGN_KEY |
EVENT_ID |
Checks if Block Is Open |
/PRM/EVENT |
EVENT_ID |
EVENT_NAME |
Time of Last Change to the Transaction |
/PRM/EVENT |
NAME |
EVENT_NAMESEARCH |
BO Name for Search Purposes |
/PRM/EVENT |
NAME_SEARCH |
CHANGED_ON |
Node ID |
/PRM/EVENT |
CHANGED_ON |
Extractor Logic
The Position Offer Assignment extractor is based on the function module. The extractor does not transform the Key Figures. Key figures are transferred 1:1.