Update of Master Data Attributes through BPS

[Former Member]

Dear All,

I am working on BW 3.5 and BPS. I want to change the Master data Attributes .

I have a master data Natural Account with Account Group and sub account group as its attributes.

I want the user to have the ability to first of all select the master data (e.g. for natural account the user will select - 0410 ) through web .Once he does this the page should display that particular master data selected with all its attributes.

Once this is done I would like to save the user entry for that particular master data and activate the master data.

What all function modules that I may or might need to incorporated in this?

Could any one please share me there knowledge, how this can be achieved or if any one has already done some work related to this in their projects.

I have found thread on sdn which do gives idea abt how to proceed.Could somebody explain it in detail.

Please suggest.

Thanks and Best Regards,

Ankit Bhandari

[Former Member · Accepted solution]

Hi,

I had a similar problem time ago.

The situation was this.

New datas were loaded trough files and some of them were totally new for BPS and BW

So the scenario was the typical scenario where you load data using the HOW-TO (File in Bps ..SAPGUI). There you have 2 FM.

The first is a INIT and it loads a file from your local PC and put in a Internal Table GT_FILE and the second FM execute other operations + SAVING.

So after I loaded data in the Internal table I checked line by line for one of the char of the table if the master data exists for this carhcteristic (select single...). When I found a new one, I prepared the internal TABLE of NEW ONES.

Then using like the previous thread the RSDMD functions I updated master data passing to this FM the NEW ONES and NEED TO ACTIVATE also.

After I executed the other FM (called EXEC....) and everything was fine because the second FM already find active MASTER DATA.

Use the RSDMD functions, you will find lot of code about them in the forum and examples also on your system. Remember to ACTIVATE the master data.

Regards

[Former Member · Accepted solution]

Dear All,

The recent days that I tried working on changing master data attributes through BPS didn't work out.The Primary reasons was that some of the attributes that I needed to change were not present in the transaction or planning cubes and the characteristics that are not part of your cube on which the planning area is based then you can not do changes on them.

This is my undestanding .Please correct me if I am wrong.

Besides , I was also thinking if we can do the same through portal.i.e retriving the master data infoobject ( based on the value seleceted for that infoobject by the user ) and its attributes in the portal , edit them and save them back so that the updated values goes back to BW master data infoobject data base tables and updates the value.

Eg . I have Natural Account master data infoobject in the BW with attributes fucntional area and expense center.Based on the user selection of any values for the Natural account lets say 01110 , then for 01110 natural account the portal should display the correspoding attributes values of fucntional area and expense center.Lets take this values as 10 , 20 respectively for fucntional area and expense center . What I want to do now is to change these attrbute values to 30 and 40 and I would like to save it back as the changed attribute values for that natural account for 01110 with new attribute values 30 & 40 respectively for fucntional area and expense center .

Is this possible through portal and BW?

Any idea on this would be appriciated.

Regards,

Ankit

Edited by: Ankit Bhandari on Nov 21, 2008 12:21 PM

Edited by: Ankit Bhandari on Nov 21, 2008 12:32 PM