Program for actual sales customer material period week month wise.

[Former Member]

Hi all,

I want to create a report for displaying actual sales for customer material salesorg distributionchnl and division wise on period, weeekly and daily basis.

I don't have functional logic or flow of data.

Can any one please help.

[Former Member]

Take help from the following code:

DATA: BEGIN OF i_temp1 OCCURS 0,

werks LIKE vbrp-werks,

matnr like vbrp~matnr,

vkorg like vbrk~vkorg,

vtweg like vbrk~vtweg,

spart like vbrk~spart,

kdgrp LIKE vbrk-kdgrp,

bzirk LIKE vbrk-bzirk,

kunrg like vbrk~kunrg,

fkart LIKE vbrk-fkart,

kzwi1 LIKE vbrp-kzwi1,

END OF i_temp1.

SELECT

vbrk~vkorg

vbrk~vtweg

vbrk~spart

vbrk~kdgrp

vbrk~bzirk

vbrk~fkart

vbrk~kunrg

vbrp~werks

vbrp~matnr

vbrp~kzwi1

INTO CORRESPONDING FIELDS OF TABLE i_temp1

FROM vbrk INNER JOIN vbrp

ON vbrk_{vbeln = vbrp}vbeln

WHERE vbrp~werks LIKE 'XY%'

AND vbrk~fksto NE 'X'

AND vbrp~fkimg NE 0.

SORT i_temp1 BY werks kdgrp.

LOOP AT i_temp1 WHERE fkart = 'RE'.

i_temp1-kzwi1 = i_temp1-kzwi1 * -1.

MODIFY i_temp1 INDEX sy-tabix TRANSPORTING kzwi1.

ENDLOOP.

here KZWI1 is the net sales.....

also use vbrk~fkdat for the date field....

reward if useful

anju

Message was edited by:

anju sinha