IP-how to enter new record that includes a new value of the characteristic?

[Former Member]

Dear IP Experts:

In a WAD, I can enter new data records for the characteristic combinations that do not yet exist or change posted data records, but when I enter a value of a characteristic that not exists in master table or text table, even the characteristic I have not check the master data and text flag, just a characteristic, it is not work! There is a error message ,"invalid value xxx" and so on.

For example:

0calmonth 0material Zquantity

200711 100001 1000

200711 100002 2000

When I enter the value combination "200711 100003 500" and refresh data , It is a error message, "invalid value 100003" . 100003 is a new value of 0MATERAIL that is not exist previously.

But when I run the "manual enter template" in the planning sequence, it works fine! I can enter any value of a characteristic, even the value is not exists in the characterstic previously.

So I confused with this, was I have some setting not set in WAD template? I have use the same filter in query as in planning sequence.

Thanks a lot for your answers!

[Former Member · Accepted solution]

Hi,

I have also tried this. Unfortunately this does not work in Web but the same works in excel. You can enter values not present in master-data there.

[Former Member]

It is possible to enter new master data in the WAD, it must however be a new line. The master data is only verified that it has not previously been entered. If it does not already exists it is created while saving, the master data really becomes free text.

So anything can be entered.

A special conversion routine must be used on the required characteristic.

This cannot really be used for a standard char such as 0Material, it would be really risky to add any values to 0Material. But if free text is required is works fine.

Hope this helps

Jean-Marc

[Former Member]

Hi Jean-Marc,

Could you please provide some more information / a step-by-step solution on that? Thanks!

Michael

[Former Member]

Hi, Michael Henkel

Follow this link

this ia the answer for you question.

just implement class which describe in this link.

Anton.

[Former Member]

Thanks all.

SAP havn't give me any reply.

I think it is a very serious problem about BI-IP. If this did not work, it means IP does not have the basic functionality. I think customer will not choose IP.

If SAP have any suggestion, I will post it on this.

[Former Member]

SAP still havn't give me any reply. any suggestion ?

[Former Member]

say reply:

Unfortunately Web runtime works differently and only possible to get

data from what is existing in the tables, you cannot create new data

using web runtime.

If you really need or want insert values as decribed in this message

using web runtime, please read note 11 and open a developer request

asking to implement that feature in a future BW release.

[Former Member]

So do i understand correctly that with the WAD application and BI-IP it is not possible to create new masterdata in runtime?

If you can (e.g. by function module) does anybody knows which module is the best, cause I found several?

Regards

Bart

[former_member237965]

Hi,

Small correction BEX can as well be multiple lines.

See one of the replies of Mayank Gupta "More lines in plan query".

Best Regards

Rik

[former_member237965]

Hi all,

We had or rather have the same problem, bellow you can find the answer I received from OSS:

"I have recived inputs from concerned experts on this issue. If you checkthe sid table entries, the value entered manually does not have flags

"chkfl datafl incfl" associated. This is inconsistent master data and

not relevant for transanction data associated if you need to report on

it.

The fact that you can input values manually and able to choose in F4

for analyzer is kind of gap in functionality. This could be developed

Master data planning in future. The value inserted manully creates

SIDs during Bex runtime. This is not possible through WEB. It is

better to select values through F4 selection rather than input it

manully. The wrong values generated are of no use due to master data

inconsistency."

=> so in the BEX you can 'create' new values for characteristics BUT ONLY one line at the time (this is a major issue for us). In the WEB apparently you can only work with already known values. (there you can have multiple new rows).

If somebody has a solution please let us know.

Hope this helps a bit

Best Regards

Rik

[Former Member]

But in my case, customer ask to use web inteface to input value.

I confused that I use the standard webdynpro "Planning Modeler" , with the planning sequence, I can enter any value. So I ask my colleague to send a meeage to SAP.

[Former Member]

Hello,

Please do update the reply from SAP on this thread. This will be very helpful to a lot of people.

[Former Member]

Hi Mayank,

are you saying that, we can enter new records for the masterdata that does not exists in system and that means system creates a new masterdata value (SID) for the entered value..

please let me know if we can achieve this and if yes in Excel do i need to do any extra setting.

because so far i am able to plan for only the masterdat exists in the system.

Regards