Moving Average Price at Product Location Level 
: 0RT_MBEW_ATTR
This DataSource transfers the moving average price from the ERP system to the connected BI system. Based on table MBEW, which contains the moving average price (VERPR field), the system uses delta transfer to transfer the value to SAP NetWeaver Business Intelligence (SAP NetWeaver BI). The changed records are determined using a newly-added timestamp.
Technical Data
Application Component | Retail master data (IS-R-IO) |
|---|---|
Available as of Release | ERP2005 EhP2 |
Shipment | BI Content 7.03 Support Pack 6 |
Content Versions | ISR601 |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Prerequisites
To be able to use the DataSource, the TIMESTAMP field must exist in table MBEW.
Data Modeling
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
| MANDT | Client | MBEW | MANDT |
| MATNR | Article Number | MBEW | MATNR |
| BWKEY | Valuation Area | MBEW | BWKEY |
| BWTAR | Valuation Type | MBEW | BWTAR |
| VERPR | Moving Average Price | MBEW | VERPR |
| PEINH | Price Unit | MBEW | PEINH |
| BUKRS | Company Code | MBEW | BUKRS |
| WAERS | Currency Key | MBEW | WAERS |
| TIMESTAMP | UTC Time Stamp | MBEW | TIMESTAMP |
Extractor Logic
Use extraction method V (transparent table) or DB view for data extraction to avoid the need to use additional program logic to transfer the data.
Verification of Key Figures
You can verify the extracted data only by checking it manually against the entries in table MBEW.