Read a Charecteristic which is a part of a Key from a DSO in Fox

[former_member1349988]

Hi,

We have a Planning DSO which stores a Characteristic as part of Key fields for that DSO and a nominal counter KF as a Data field. But we need this characteristic in a planning function for checking a condition. We tried to use Infoprovider statement for an external read by creating an agg. level - but getting an error as it seems to be only applicable of reading Key figures. We can load this DSO into an Infoobject and use ATTRV - but we would not like to introduce more objects. Please let us know if we are missing any thing here or there is a way to achieve in the Fox code of the planning function to read an characteristic from an external provider. We are on BW 7.5

thanks,

vaas

[RafkeMagic]

I can confirm that you can only read KF's from (old) DSO objects via the InfoProvider statement (we're on 7.5 SP11 and tried the same a while back). You can either read from a characteristic as you stated or try to read from another aggregation level (make sure you're on SP11 or higher in that case and that you're DB revision is high enough).

[sheldon_piao]

Hi,

Can you provide some more information about what the error is? Maybe you can provide both DSO definition and the aggregation level definition which is used in FOX. Also specify the 'field to be changed' and fox code so that we can understand the issue better.

Best Regards,

Sheldon

[former_member1349988]

Hi Sheldon,

Created the agg level with the same structure of the DSO:

DSO and Agg. level Structure:

Material

Salesorg

Plant Counter - Keyfigure

I am trying to read Plant from this DSO in my fox. I have all these fields to be changed in addition to few more chars which are part of other objects and this look is only a partial function.

Infoprovider Agglevel1. 
foreach material,salesorg in agglevel1. 
NPLANT = Agglevel1{Plant,0material=material,0salesorg=salesorg} 
endfor.

Syntax error: Key Figure Name was expected.