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

Updating Master data attributes through BPS

Hi All,

Can we modify master data attributes via BPS? Like we have some Attribute characteristics for 'vendor' say 'class(good/bad/ok)' and we want that to be updated via BPS (not from R/3) then how it can be achived?

Please help by explaining this.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 11:27 AM

    Hello Ruchi,

    your question depend on BPS version you have.

    1. SAP BI-IP

    In this case there will be a new funtionallity, which allows to modify / create master data directly in the query / layout. But as far as I know this is planned for the second part of the year 2007 in the version "New York" of BI-IP

    2. BPS0

    In this case you can do this using an User-Exit-Planning function. There is an how to paper "Update Master Data during an upload of transactional data". In this paper you will find functions like RSDMD_WRITE_ATTRIBUTES_TEXTS and other.

    So for the meantime as far as I know there is no other possibility for today. But maybe someone else has another input.

    regards

    Eckhard Lewin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your kind reply Eckhard.

      Could you please explain me that can this be done in web also?

      And that How to paper is for updating master data while loading transaction data, so how to use it in BPS?

      Waiting for your reply...

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 04:10 PM

    Ruchi

    In dont understand the line in your reply.

    " mean in master maintainance of Vendor characteristic, vendor A has status 'ok'. But in BPS0 we assign the status 'good' to vendor A, so how this changed value will be refleted to the reports involving these characterisics".

    Can you please explain the requirement.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Create two variables one for vendor and other for status (variable of type attribute), give both the variables in the folder. User will select the vendor and the attribute status value in selections. Create an exit planning function to update the attribute.

      Import parameters

      i_area type upc_y_area

      i_variable type upc_y_variable

      i_chanm type upc_y_chanm

      Export parameters

      eto_charsel type upc_yto_charsel

      tables

      i_t_attributes structure rsd_s_iobjnm optional

      i_t_data structure rsndi_s_chavl optional

      In the code, Read the above two variable values selected by user. Then delete the existing entry of MD by calling the function RSNDI_MD_DELETE.

      Now update the master data with the new attribute value selected by the user in the variable by calling the function

      RSNDI_MD_ATTRIBUTES_UPDATE. After this activate the master data by calling RSDMD_MD_ACTIVATE.

      Hope this solves the issue.

      Bindu

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 01:29 PM

    Define characteristics relationship in BPS/ IP, and thats it. When you save the date, the attributes will be updated.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 01:58 PM

    First of all, you must have the characteristic A as an attribute of another characteristoc B in BW. Then only you can define the relatonship in BPS. If you cant maintain the attributes, then you can do this by an exit.

    In Planning area, there will be a tab called "charateristics relationship". Open that and it is very easy.

    Ravi Thotahdri

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Ruchi,

      you can not get all the steps here in the forum, it would make the corresponding very long 😉

      did you try help.sap.com

      The soloution by characteristic rel. is restricted to the usage but it is of course easier compared to programming.

      Another soloution for the Web:

      I have heared that for the Web there is a Webservice available for Updating Masterdata in the Web in BPS (not BI).

      I have never used it, but if anyone has some information about this, I would be interessted too.

      regards

      Eckhard

      Message was edited by:

      Eckhard Lewin

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 03:23 PM

    Ruchi,

    If you want users to select the values for status, then char relationship is not the solution.

    You need to have this in the layout. First of all, if you want the users to input the values for status, then the characteristic status should be physically present in the cube that is assigned to the planning area. This is a MUST.

    Step by step:

    1. Close BPS0 screen and get out of it.

    2. Change your cube to include status as a characteristic and put it inside vendor dimention.

    3. Maintain vaules for status (3 values in the status master data; status info object).

    4. Call BPS0, go to the planning area where this cube is assigned to.

    5. Create a characteritic variable on status; make it fixed value and put all the 3 values.

    6. In layout depending on where you wish to appear status, configure this is header,lead column.

    7. Save the model.

    8. Let us test this in BPS0 before we make a folder.

    Let me know how this works.

    Ravi Thothadri

    RThothadrii@yahoo.com

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Ravi for detailed steps.

      But by doing this how would we ensure that master data attribute is changed.

      I mean in master maintainance of Vendor characteristic, vendor A has status 'ok'. But in BPS0 we assign the status 'good' to vendor A, so how this changed value will be refleted to the reports involving these characterisics?

      Please explain...

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 02:53 PM

    I think you are in wrong tab.

    With the setting i said, you can save the attributes and derive,. But i dont understand what do you mean by changing attributes.

    Can you go to planning area and open the tab characterisrtics relationship. LEt me know from hree i will tell you step-bystep.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am on that Tab only, but not able to achive this.

      Actually we have an attribute of Characteristic Vendor called status (possible values are good, bad and ok). It was loaded through a flat file initially but now user wants to maintain this master data attribute via BPS. So hence forth in reports involving this attribute values should come from input in BPS application (surely in web).

      Hope I am able to explain my problem, basically I need to modify master data via BPS, now could you please give me steps...

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2007 at 06:05 PM

    Yes, you can with a planning function of type exit. Whether you do is thru BPS way or the BW way, the users will not know. So, why do you want to maintain a planning function, just loade the file.

    There is a how to on this. If you are able to search, i can send that to you.

    Ravi Thothadri

    RThothadrii@yahoo.com

    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.