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-dev] Code at Infoset SQ02 - Use the Current Line When Processing

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

Reply from soufiane669 on Dec 11 at 11:12 AM
Hello, I don't want to do 2 selects, only one to catch the sum of the quantity reserved in a reservation where the movement type = 911.

My query is as following:
Select sum(mseg~menge) into calculated_field from mseg where movement_typ = '911' group by mseg~matnr.

Is this query going to populate correctly my calculated field, because when i test it dump for space overflow issue.

Thanks by advance,

Soufiane

---------------Original Message---------------
From: soufiane669
Sent: Tuesday, December 11, 2012 10:06 AM
Subject: Code at Infoset SQ02 - Use the Current Line When Processing

Hello every one,

I want to add some abap code in infoset SQ02 to calculate an additional field:

In the infoset i'm joining the 2 tables RESB and MSEG and i want to calculate for each reservation of material => sum(reserved quantity) where movement type = 911 MINUS sum(reserved quantity) where movement type = 912 where the material = current line.

That's why i want to use the value of the current line material otherwise the select will populate the additional field with the same result for all the records.

Please to help me

Regards,

Soufiane

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2012 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
soufiane669  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App

_.____.__

0 comments:

Post a Comment

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