Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Collect ( QTY - Cost - Net Value ) per material

Former Member

‎10-27-2014 2:39 PM

0 Kudos

Dear All,

I need to make report to collect QTY - Cost - net value per Material On one week

Example

first week from ( 01.01.2010 ) to ( 07.01.2010 )

second week from ( 08.01.2010) to (14.01.2010 )

01.01.2010      a12345     20   5     1000

04.01.2010     a12345      10    2     15

first week    a12345   material desc    30    7       1015

How can i make this please ?

Thanks

2 REPLIES 2

Former Member

‎10-27-2014 2:41 PM

0 Kudos

Preview file
188 KB

Former Member

‎10-29-2014 3:09 PM

0 Kudos

Hi Eman Elgammal,try this algorithm.

Loop over current Itab_1 into wa_1 .

     loop_counter = Date.   " Lets assume its Date starts with value 1

    

     if ( loop_counter MOD 7 ) EQ 0 && (Sy-tabix NE 1).

          append wa_2 to Itab_2.

          clear wa_2.

     endif.

    

     wa_2 =      wa_2  +   wa_1.

Endloop.

Regards,

NG