topic Re: solve1 in Application Development and Automation Discussions

solve1

Former Member — Thu, 19 Jul 2007 04:14:13 GMT

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.

Re: solve1

Former Member — Thu, 19 Jul 2007 04:43:18 GMT

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

Re: solve1

Former Member — Fri, 20 Jul 2007 05:14:48 GMT

Hi suresh,

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

with regards,

surendraa