Abap code to get data from table EKKO

[MSadri]

Hi,

I am trying to check supplier purchasing history from table EKKO.

Unfortunately data is too huge to output in Excel or flat file. 

I am trying to write query in SQ02 to sort data in table EKKO according to its creation date and then select one row per supplier with latest PO date.

I am not quite familiar with ABAP so struggling to write the code.

Can someone please help or guide on this ?

SELECT LIFNR FROM EKKO
WHERE LIFNR EQ 'XXXX'.

In above statement its saying INTO is missing but I don't want to insert data I just want to modify selection criteria and output table.

Br,

Murtuza

[Sandra_Rossi]

I don't understand your question: with SELECT, you must store the read data into memory! So, you say that you are writing ABAP code in an infoset, but you don't say where in the infoset... If you have choosen to use a Data reading program as source, you must load the data into memory. Please clarify.

[Sandra_Rossi]

Even if you have modify the initial extracted data, you must load the data into memory. Please clarify what your question is.

[MSadri]

Hi Sandra,

Thanks for replying.

I am writing code inside infoset-- code section -- Free code.

I am just trying to filter selection programmatically as data is too huge to output. I am trying to write select statement in infoset to select only desired data. Goal is to sort table EKKO depending on creation date and then output lastest po date per supplier. So let's say one supplier has 1000 POs so only row with latest PO date is needed for that supplier.

I just felt writing query might help and I am not sure whether this type of requirement can be accommodated here.

Thank you.

[Sandra_Rossi]

Please don't post a solution. Instead, click on Show replies > Comment.