We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-log-mm] Code for fetching MSEG-DUBMTR data positive/negative in Query

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from ashutosh-p on Jan 20 at 9:35 AM
Use SHKZG of message to identify positive -S or negative - H value as below:
if SHKZG eq 'S'.

DMBTR = DMBTR
ELSE.
DMBTR = DMBTR * -1.
ENDIF.

---------------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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
ashutosh-p  

achievement
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language