topic Re: abap help needed (select) in Application Development and Automation Discussions

abap help needed (select)

Former Member — Mon, 24 Sep 2007 12:40:57 GMT

Hi,

I would like to read from table where more than one entry for each material is. I would like to get just the higher one. How to maintain the code?

Example:

***

SELECT SINGLE * FROM AUSP WHERE ( OBJEK = MVKE-MATNR ) AND

( ATWRT IN ATWRT ) AND

( ATZHL ?????????????? ).

In the field ATZHL are numbers from 1-4. How can I write the code, that the program will give to me the higher entry?

Saso

Re: abap help needed (select)

Former Member — Mon, 24 Sep 2007 12:47:43 GMT

There will be multiple characteristics(ATINN) for a same single material

and the characteristic values (ATWRT) are stored in this table.

So which characteristci value you need

decide and use this table

So pass Material number and as well as ATINN field also to take a particular value.

you can use the BAPI or fun module

BAPI_OBJCL_GETDETAIL

or use the fun module:

CLAF_CLASSIFICATION_OF_OBJECTS.

for this purpose.

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: abap help needed (select)

Former Member — Mon, 24 Sep 2007 12:51:23 GMT

Use aggregate functions , in below format

select MAX(x)

from tab1

where....

Re: abap help needed (select)

Former Member — Mon, 24 Sep 2007 12:58:57 GMT

Uf , sorry I don't understand ) Can you change my select ?

SELECT SINGLE * FROM AUSP WHERE ( OBJEK = MVKE-MATNR ) AND

( ATWRT IN ATWRT ) AND

( ATZHL = MAX *******).

thanks a lot

saso

Re: abap help needed (select)

Former Member — Mon, 24 Sep 2007 13:15:00 GMT

try this

SELECT * FROM AUSP

into wa_ausp

up to 1 rows

WHERE ( OBJEK = MVKE-MATNR ) AND

( ATWRT IN ATWRT )

order descending by atzhl.

endselect.

reward if solved**

Re: abap help needed (select)

Former Member — Mon, 24 Sep 2007 13:22:00 GMT

Hi Saso, depending on the use of the program you are planning to write and your level of comfort with the values of ATZHL you could always try a while loop. It may be faster than reading the BAPI. Using a temporary value for ATZHL you could use the following code.



data: t_atzhl type ausp-atzhl.

t_atzhl = 4.

while t_atzhl > 0.

SELECT SINGLE * FROM AUSP WHERE ( OBJEK = MVKE-MATNR ) AND
( ATWRT IN ATWRT ) AND
( ATZHL = t_atzhl ).

  if sy-subrc = 0.

    t_atzhl = 0.

  else.

    t_atzhl = t_atzhl - 1.

  endif.


endwhile.

Kevin

Re: abap help needed (select)

Former Member — Mon, 24 Sep 2007 13:35:59 GMT

Hi Saso,

Check the query below, this should give you the total idea

how to get the desired result...


tables : ausp.

select  * from ausp into ausp up to 1 rows
where OBJEK = '000000000000000001'
order BY ATINN DESCENDING.
endselect.

Hope this worked for u..

Happy coding .......

Regards,