help with BAPI_SALESORDER_GETLIST

[Former Member]

this function give me a lot of data'how i can arrange this data by material and per month ,jan,feb ....

like this:

material name 01 02 03 04 05

12345677 test 10 2 3 5 62 56

[Former Member]

this function give me a lot of data'how i can arrange this data by material and per month ,jan,feb ....

like this:

material name 01 02 03 04 05

12345677 test 10 2 3 5 62 56

[christian_wohlfahrt]

Hi!

You make a (internal) table with article, date(, amount, ...) and a month field (char2). Fill this field with date+4(2).

Sort by article and month, build up the sums and print your output (/ make a final table for ALV display).

Regards,

Christian

[Former Member]

Hi,

If you are Generating the report from it, then you can

Build the sort table based on material,month

and pass it to alv function module, and you can see the output according to your requirement.

Thanks

vijay

[Former Member]

Hi yehiel,

1. There is no direct way to achieve what u want.

(ie. sorting just by MONTH)

2. If u are using directly the data provided

the BAPI, then we cannot do so

by using SORT etc and showing in ALV.

3. Hence,

u need to have ONE EXTRA COLUMN

in your some INTERNAL TABLE.

This extra column

should be populated (in a loop)

with the MONTH Name.

4. Only there after , can we use

this extra column, for sorting or

any other purpose.

5 ABAP Syntax / ALV does not provide

any facility for using Part Value

of any column .

regards,

amit m.