cancel
Showing results for 
Search instead for 
Did you mean: 

Executable query showing wrong data

former_member232093
Participant
0 Kudos
46

Hi,

The opening quantity of an item is 0.08.Its showing right figure in the table. but when i run the executable query it shows 8.00 instead of 0.08. its happening in particular one item. but others all items are okay.

Please help me .

Regards,

Mizan

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member232093
Participant
0 Kudos

This thread is closed.

former_member206488
Active Contributor
0 Kudos

Hi,

check query document with modified query at http://www.sendspace.com/file/9kdp68

Thanks,

Neetu

former_member232093
Participant
0 Kudos

Hi Neetu,

Thank you very much. its is working now.

Again thanks for your king cooperation

Regards,

Mizan

former_member206488
Active Contributor
0 Kudos

Hi Mizan,

If query is working fine,close this thread.

Thanks,

Neetu

former_member541807
Active Contributor
0 Kudos

hi,

if you mind please post your slq sentence so we can take a look.

regards,

fidel

former_member232093
Participant
0 Kudos

please see all attachment from the below link

http://www.sendspace.com/file/6s2a57

http://www.sendspace.com/file/8w095l

http://www.sendspace.com/file/hbkfpc

i hope you can understand.

Regards,

Mizan

Former Member
0 Kudos

Hi,

Can you run the query from Query Manager:

select * from Temp_Recon

Try to display the inqty and outqty in query might in the problem in computation.

Lest isolate the problem.

Thanks.

Clint

former_member232093
Participant
0 Kudos

Hi Clint,

I have run this query in SAP its showing same data 8.00 instead of 0.08. but the same query if i run in sql then the figure shows correct.

please help me how can i solve the problem.

Regards

Mizan

Former Member
0 Kudos

Hi,

When I looked at your query the Opening Balance Inqty-Outqty.

Can we show or display during running the query this two fields (Inqty and Outqty) by not subracting this.

Lets isolate the problem

Thanks.

Clint

former_member232093
Participant
0 Kudos

yes i have done this. its showing correct figure.

here is the query

select isnull(sum(inqty),0)-isnull(sum(outqty),0) from OINM where Docdate <  '20110830' and Itemcode='0215003'

and the result showing 0.08.

if i run this query in SAP query manager its also showing correct figure.

Mizan

Former Member
0 Kudos

Hi,

Run the query one at time lets try to detect where the error is coming.

Thanks.

Clint