on 03-13-2007 6:48 AM
Hi All,
Problem Statement: To fetch data from SNP Planning Area for reporting in SAP BW.
Approach: Followed the standard SAP Help Document. Link:http://help.sap.com/saphelp_scm40/helpdata/en/e0/9088392b385f6be10000000a11402f/content.htm
First Step: To create a DataSource on the Planning Area (Z9ASNP02) and Aggregate(9AMALO).
For that
Go to SAP Easy Access>Click on /SAPAPO/MSDP_ADMIN/ you are on S&DP Administration>Select the planning Area Z9ASNP02 double click on it
You are on Change Planning Area Screen>Go to Extras left click>DP/SNP Data Extraction Tool-->Click on Generate Data Source, Provide the
Data Source Name & Select the Aggregate 9AMALO and click on continue. Data Source is generated.
But now when i go for Test Data Source-->Extractor Checker Screen and then providing the version 000 and then when i click on extraction Button
It gives a Message "0 data records selected".
Thanks in Advance,
rahul
Also try replicating the datasource again
you can do this in RSA1 (RSA1OLD if in scm 5)
go to source system from the left menu--> choose your APO client --->right click and choose replicate data source. relevant
or choose datasource overview and right click on the relevant datasource to go to replicate
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul ,
Pls check OSS note Note 960602 if this helps ..
Regds // Digs....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
Not sure if this is relevant but you can try.
The SNP data you try to extract from OrderSeries keyfigure is not working.
Copy the data from OrderSeries keyfigure to Timeseries keyfigure (you need add them in the SNP Planning Area) and then try extarcting the data from the TimesSeries keyfigure instead from the OrderSeries keyfigure.
Thanks,
somnath
Hi Somnath,
Please correct me if my understanding is wrong; you are saying that, we cannot extract data from order series keyfigures. In that case how many key figures you maintain for time series, performance miight come down for planning area if you maintain huge no of keyfigures.
Is there any way to extract data from Order series Planning area?
Thanks & Regards,
Jagadeesh.
What aggregates did u choose while creating the extraction? Was it 9ASNPBAS? if so it might be the problem
have you also replicated as mentioned in my post above?
am not sure if it is because it is order series live cache
also see notes
428147 - Extraction of data from an SNP planning area
and 549184 - FAQ: What is important for extraction
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.