topic Re: Sq02 ABAP coding for extra field in Application Development and Automation Discussions

Sq02 ABAP coding for extra field

Former Member — Thu, 05 Feb 2015 15:00:29 GMT

Hi experts ,

I have created a Query to find the difference in PO value and Invoice Value . I have defined a Extra field named " Difference" and got the value but I am unable to code the below cases

where one PO line has more than one Invoice . I want to code so that System add all Invoices posted on PO line .

So for example

PO line 100

Invoice 1 50

Invoice 2 50

Total of Invoice for Line iten is 100 so difference is 0 . Right now I am getting 2 separted line and -50 each in difference Field .

Many Thanks

Regards

PreetI Agarwal

Re: Sq02 ABAP coding for extra field

jogeswararao_kavala — Thu, 05 Feb 2015 15:16:50 GMT

Hello Preeti,

I am afraid this is not possible with query. You need to go for ABAP program for this. (With Query route, at the most you will be able to get the invoice totals by sub-totalling on POs in the ALV screen, but you will not be able to compute the difference.)

KJogeswaraRao

Re: Sq02 ABAP coding for extra field

Former Member — Thu, 05 Feb 2015 15:21:44 GMT

Is it possible for me to get the total of all Invoice posted on PO for one line Item.

As I am Thinking of creating Another Field which will have total of Invoice posted on one PO . and then I can do calcuation on that .

Many Thanks for your help.

Regards

Preeti Agarwal

Re: Sq02 ABAP coding for extra field

jogeswararao_kavala — Thu, 05 Feb 2015 15:30:05 GMT

No, That's what I was hinting at. This needs access to internal tables of standard program, which involves use of field-symbols in coding etc. There will be other complexities also.

Re: Sq02 ABAP coding for extra field

Former Member — Thu, 05 Feb 2015 15:33:11 GMT

Thank you

Re: Sq02 ABAP coding for extra field

Former Member — Thu, 05 Feb 2015 15:49:51 GMT

Can you please help me creating one .

I am new to ABAP and learning myself .

Many Thanks

Regards