topic Re: help with BAPI_SALESORDER_GETLIST in Application Development and Automation Discussions

help with BAPI_SALESORDER_GETLIST

Former Member — Sun, 01 Jan 2006 13:45:28 GMT

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 — Sun, 01 Jan 2006 18:10:38 GMT

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 — Mon, 02 Jan 2006 05:50:37 GMT

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 — Mon, 02 Jan 2006 05:54:34 GMT

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.