solve1

[Former Member]

hi guru's,

see the issu below.

Calculate the Customer wise Sales orders Totals for the given period and for the given materials and for the given sales area.

Use the tables KNA1,VBAK and VBAP and VBEP tables.

in aboue issue i put several control break statements for displaying totals as per customer wise ,meterial wise ans sales group wise .but it is showing only customer wise totals.plz.. solve and send urgent.

thanks in advance.

[Former Member]

HI,

i think the problem is in select statement. use joins or for all entries.

try like this

data: flag type c.

select a_{vbeln a}vbelp ...........

from vbak as a join vbap as b on a_{vbeln = b}vbeln join

kna1 as c on ..........................

vbep as d on ..................... into table itab.

if sy-subrc eq 0.

sort itab by vbeln.

loop at itab.

at first.

write:/10 'vbeln'.

................

at new vbeln.

flag = 'X'.

if flag = 'X'.

write:/ itab-vbelp.

...........

at end of.

sum.

at last.

sum.

endloop.

if useful reward some points.

with rewards,

suresh.A

[Former Member]

Hi suresh,

can u send me the report totally to me, so that i can understand properly.

with regards,

surendraa