This website is not affiliated with, sponsored by, or approved by SAP AG.

Plz Help to write a code to add the column values

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Plz Help to write a code to add the column values

Postby venkatrsv » Sat Mar 21, 2015 12:11 pm

Hi Friends,

In SAP BW. please help me to write a code in the "Start Routine" to achieve as shown below in the Target.

If the purchasing document(Example:- 2000000000) has two entries, then it should add the columns ("PO quantity" and "Outstanding Invoice amount") and "Final Invoice" should be set as 'X'.

Example:-

The source is as below:-

Purchasing document | Final | Invoice vendor | PO date | PO quantity | Outstanding Invoice amount
2000000000 | X | 9900000000 | 02.03.2013 | 2 | 20,000.00
2000000000 | # | 9900000000 | 02.03.2013 | 3 | -5,000.00
3333333333 | # | 9900000200 | 05.05.2013 | 1 | 200.00
4444444444 | X | 9900000300 | 07.08.2013 | 1 | 300.00

Target should be as below:-

Purchasing document | Final Invoice | vendor | PO date | PO quantity | Outstanding Invoice amount
2000000000 | X | 9900000000 | 02.03.2013 | 5 | 15,000.00
3333333333 | # | 9900000200 | 05.05.2013 | 1 | 200.00
4444444444 | X | 9900000300 | 07.08.2013 | 1 | 300.00

Thank you very much in advance...

Regards,
venkatrsv
 
Posts: 1
Joined: Sat Mar 21, 2015 11:34 am

Re: Plz Help to write a code to add the column values

Postby Snowy » Wed Mar 25, 2015 1:03 pm

I charge 120$ per hour.

Do you have a PayPal account? :roll:
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28768
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: Plz Help to write a code to add the column values

Postby Rich » Tue May 26, 2015 3:59 am

Snowy wrote:I charge 120$ per hour.

Do you have a PayPal account? :roll:



<chuckles>
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com
Rich
 
Posts: 7112
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool


Return to ABAP

Who is online

Users browsing this forum: No registered users and 8 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.