Skip to Content
author's profile photo Former Member
Former Member

Compare data in info cube with SNP master data

Hi all,

Does anyone know if there is a easy way comparing the data in a infocube with the SNP master data? The scenario is that we have 2 characteristics (product and location). The product "X" must exist for location "Y". Except this, we have two keyfigures "A" and "B" and the value they must have is >0. If this is fulfilled, we need to check if we have the SNP master data. The SNP master is exactly the same. Product "X" must exist for location "Y". I have an ABAP resource that can help me create a program but I need to tell him how to extract data and do the comparison. After the comparison is done, the program should extend product "X" to the correct location (SNP). Basically, we want to create the SNP data based on the CVCs for product/location combination (the ones that are missing on the SNP side). Has anyone came across this? Is this possible or not?

Thank you!

Regards

Sakis

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Feb 20, 2008 at 02:32 AM

    In your update rules to Infocube, you can check for unique char combinations of Product and location, and run it by the list in /sapapo/matloc table. In the code, you can write into a text file in a certain format the non-existing SNP Location Products. After the writing to Infocube is complete, you can run LSMW job or a batch recording in background to pick up the text file created to create the desired Location Products. I am pretty sure this two step solution can work. However every technical solution should be questioned in terms of actual business requirement. If there are more elegant ways of meeting the requirement outside APO, I would highly recommend you to do so.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2008 at 03:37 AM

    Hi Sakis,

    If I understand your requirement, you have data in Infocube that you are sure that is consistent and you suspect few missing product location combinations in SNP master data. You want to create a report to compare SNP master data with BW cube.

    Couple of options:

    1. As the data is in infocube already. You can create CVCs and that gives you the complete unique combinations of product and location. These CVCsdata wouldbe saved back to BW in a APO generated infocube.

    You can make a report on SNP master data using the tables

    /SAPAPO/MATKEY masterial number table; use GUID

    /SAPAPO/LOC Location details table; use GUID

    /SAPAPO/V_MTLMOD To get MATID and LOCID in APO

    2. Go to LISTCUBE and when you select your data, you can give your condition that your key figures need to be greater than zero.You can also download the infocube data to an excel file and create your own report. If not you can create a BW report. You can use your ABAPer's expertise to write a report on SNP master data. You can also use SQ02 to write reports in master data.

    Other thoughts. As you are getting data from BW, if you got it from a R/3 system you can use those tables and write a report then compare with the report on SNP master data.

    Hope I understood your requirement properly. Please let us know if you have more questions.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2008 at 09:07 AM

    Thank you guys!

    ///Sakis

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.