SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
Showing results for 
Search instead for 
Did you mean: 

SAP CAR: Historical data & BW

0 Kudos

Hi guys,

I'm currently in a implementation project of SAP Retail with SAP CAR, the customer has also SAP BW on HANA and SAP BO licensed and is part of the project's scope for SD, MM & FI in order to present analytical reports.

1) The customer wish to have his 7 years of historical data available for reporting. I have recommended load the historical data into SAP BW and go live with SAP CAR from the scratch. But if they wants to get some historical data in SAP CAR the way should be load the POS data into CAR using POSDTA and corporate sales into ERP (in order to get replicated to CAR through SLT Server), other option is to use Data Services to load historical sales into SAP HANA DB. It's correct?

2) My position about BW is that only should be used to keep historical data. All the analytical reports of SD, MM and FI should be performed using SAP BO as presentation layer and SAP HANA DB of CAR (with HANA Live) as repository. It's correct?


Ramon M.-


Former Member
0 Kudos

Hi Ramon,

Here i have some input on your raised point.

1. I hope customer using SAP POSDM before SAP CAR ? if yes then you have to get all 7 years historic data migrated in SAP CAR.. once you have historic data in SAP CAR(HANA) then by using task you can send data to BW & BO will pick the data from HANA DB for reporting.

IMP:- about sending data ERP system it's depend on the structure..

2. I think above information will fulfill all your query..

Best Regards,

Ravi Thombre

Former Member
0 Kudos

Hi Ramon,

I am on a project that has similar requirement. The client wants to load Historic POS data into CAR.

Can you tell me what process did you guys follow.