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

SEM-BPS - "Reference Data Char RelShip" Or "EXIT funciton"?


I've a need to derive characteristic values from reference data.

reason for this is, end user don't need this information so these characteristics are not included in the level.

As these characteristics are not included in the level, these are left with blank when user saves planning data to planning cube.

Should I write an exit funciton or can I achieve this using "Reference Data : Characteristic Relationship".

This is what am trying to do..

let's say following data already exists in the planning cube for version 001.



MATERAL1 001 1234

MATERAL2 001 7890

where VER = Version & SGRP = Sales Group

let's say following data is being planned for version 002 without Sales Group.





I expect the following records be stored into planning cube by deriving Sales Group from version 001.



MATERAL1 002 1234

MATERAL2 002 7890

Can I achieve this using reference data characteristic relationship or should I go for exit function?

Is there any documentation for Char Relationship? Can someone share your experience on this?

Appreciate your help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jun 15, 2005 at 03:39 PM

    Hello Hari,

    this is exactly what char.relationships of type reference data are used for.



    SAP NetWeaver RIG

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      Thanks for your reply.

      I did go the following link on CHAR RELATIONSHIPS documentation.

      It doesn't give any example for "reference data CHAR RELATIONSHIP".

      Appreciate if you can give some examples.

      I created a "reference data CHAR RELATIONSHIP".

      system prompted to select KEYFIGURE NAME. (I selected 1 key figure) then, restricted Version with 001 in "Sel. Conditions for Ref. Data".

      In the Target Char(s), I selected "Sales Group".

      In the Source Char(s), I selected Material?

      & where should I mention this derivation is only for "Version 002".

      I didn't get any option to restrict version with 002 as I have a need to derive Sales Group only for version 002.

      Also, when I quickly tried to save data with this relationship, I received an error :

      " Reference data is not unique. Reference data is read for the derivation.

      Characteristic combinations of source fields occur several times in the reference data.


      Check the reference data."

      Could you suggest ways of doing this scenario using "reference data CHAR RELATIONSHIP"?

      Appreciate any help.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2005 at 03:47 PM

    Hi Hari79,

    Just curious, did you find a way to deal with your problem? if there no one-one relationship between Material-Sales Group,it's not going to work with Charateristic relationship

    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.