RECEIPT AND ISSUE FIELDS

[Albatross]

Hi there!

Recently i gone through this post...

"In the table MSEG, Quantity field doesn't contain any sign. By seeing Quantity filed, you can't tell whether it is receipt or issue (-). If the quantity field is having 100, it may be + (receipt) or - (issue).

This can be identified by another field Debit/Credit (MSEG - SHKZG).

If that field (MSEG - SHKZG) is H - Credit means issue (

Quantity - 100 )

If that field (MSEG - SHKZG) is S - Dedit means receit ( Quantity 100 ).

So Using Debit/Credit (MSEG - SHKZG) field, you can tell whether it is Receipt or Issue."

Now i'm having the same issue. I need receipt and issue fields in my sql output and i have quantity, bal.amount, bal.quantity and amount fields in my tables. But not receipt and issue as mentioned in the above post.

What i understood form that post is...Here i have a field named D/C which is the Debit/Credit Indicator where  (S = debit, H = credit) . If the value is S then it falls under Receipt and if the value is H then it indicates Issue. So we need to take the field MENGE from MSEG for both the receipt and issue based on the D/C indicator field. Now my doubt is how can i make these calculations in a query by creating a new table with these 2 fields (Receipt and Issue) and include it in my existing query? Any suggestions plz.

Calculations in the sense:  

Amount = Balance quantity * Price/unit  if issue is 0 then Amount=Balance amount if issue happens then Balance quantity-issue *price/unit = Balance amount.