Compare data in info cube with SNP master data

[Former Member]

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

[Former Member]

Thank you guys!

///Sakis

[Former Member]

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.

[srinivas_krishnamoorthy]

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.