Problem when select data from S992 infostructure

former_member508729 — Tue, 03 Nov 2009 11:15:41 GMT

Hi All,

I am getting one strange issue when I select data from S992 infostructure.

I maintain the quota allocation for product on weekly basis in MC94 which adds the data in S992 structure.

Suppose I create three entries for particular product from week 45.2009 to 47.2009 and for all week I put in same quantity as 10.

but when i run the select query it returns only one record instead of 3 records for three weeks 45,46 and 47.

but on other end when i maintain three different quantlty say 10,11,12 for three weeks then select query works correctly and returns three records.

Is this something related to the S992 configuration for key figure of structure S992.

Please provide your inputs.

Regards

Ashutosh

Re: Problem when select data from S992 infostructure

Former Member — Tue, 03 Nov 2009 11:26:16 GMT

Are you using a "for all entries" clause in your where?

It looks like the system is removing duplicate lines from your result tab. You can avoid this by including the whole key of your table in your result field list.

SELECT <all key fields + your required fields> FROM s992 ...

Hope it helps

Best Regards

topic Problem when select data from S992 infostructure in Application Development and Automation Discussions

Problem when select data from S992 infostructure

Re: Problem when select data from S992 infostructure