Reply from LCC352 on Jan 20 at 2:56 PM Ashutosh is correct, but if you're using an ABAP Query, then you've turned on "short fields" and you've assigned a name to the DMBTR and MENGE fields. You would create two new fields, one based on DMBTR and one based on MENGE, and use the code Ashutosh sent, substituting your new field names for his DMBTR.
The code given by Ashutosh would work if you were in pure ABAP, but in query, it would be slightly different.
- Lou
| | | ---------------Original Message---------------
From: Zaiedul Hoque
Sent: Sunday, January 19, 2014 3:05 PM
Subject: Code for fetching MSEG-DUBMTR data positive/negative in Query
Dear Experts,
I've made a query where the main table is MSEG and join with MKPF.
But I need to fetch data from DUBMTR (Amount in Local Currency) and MENGE_D (Quantity) as positive/negative value depends on following movement type.
101, 918, 919, 262, 602 as positive
102, 917, 920, 261, 601 as negative.
Would you please advice to make coding for this.
Thanks in advance
Zaied |
| Reply to this email to post your response. __.____._ |   _.____.__ |
