Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Foreach in Refdata

Dear All,

I am not able to read data,through FOREACH IN REFDATA.As per my information Reference data is the one, which is not present in your current filter selection but it can be used for reading.

In my infoprovider i have the data with two versions(version1 and version5). I have two layouts,each is restricted with individual versions. In my cube I've data as follows:-

Project1, WBS1, VERSION1.

Project1, WBS1, VERSION5.

Project2, WBS2, VERSION5.

Now I want to copy all the data from version5 to version1,irrespective of all the characteristics combination,if the characteristics combination exist in version1 ,it should overwrite the keyfigures,

else

it should append the rest of the records.

1)My First Observation is:-

I have restricted the filter with version1,but not able to read version5 with foreach in refdata.

2)My Second Observation is:-

If i'll restrict the filter with both the versions or remove the version from filter ,I'll be able to read data for both versions with foreach in refdata but if i'll open my both layouts at the same time,there is no lock but as soon as i'll use the planning function to copy i'll get the lock.

I want to restrict my filter with one version and read the data for another version using refdata,so i'll not get lock.

Rgds,

Indu

Not what you were looking for? View more on this topic or Ask a question