Fetching value from Table

[Former Member]

In my table (not internal table), I have the records

VBELN SHIPNO ATPDOC SELLER

1100000197 0000000471 0000000476 IFX::LEVEL1

1100000197 0000000472 0000000476 IFX::LEVEL1

1100000197 0000000473 0000000476 IFX::LEVEL1

1100000197 0000000474 0000000476 IFX::LEVEL1

1100000197 0000000475 0000000476 OTHER_1000::LEVEL3

I want to fetch the SELLER Value “OTHER_1000::LEVEL3” . Also I want to use the VBELN and SHIPNO as the fields in WHERE clause. Means, the last seller value from the set. How can I write the query?

[Former Member]

Hi,

Fetch the record based on SHIPNO, because that is the only field value which is not varying.

Regards,

Satish

[Former Member]

Wrong response. Its a blind reply

[Former Member]

Hi Santo,

> Select seller

> from table

> where seller ne 'OTHER_1000::LEVEL3'.

Plzz reward if it is useful,

Mahi.

[Former Member]

Wrong response. Its a blind reply

[Former Member]

select vbeln shipno atpdoc seller from dbtab into table itab.

if sy-subrc = 0.

sort itab by vbeln shipno descending.

read table itab index 1.

if sy-subrc = 0.

*-- itab-seller = OTHER_1000::LEVEL3

endif.

endif.

first u have to know the criteria for considering a record as last record....!!!! then sort itab accordingly to fetch it.....!!!

[Former Member]

I think u tried to understand what is my problem unlike others responded blindly w/o reading query. Thx

[Former Member]

Hi Santo,

I think it is not possible to get the last record from the database table. So first pass the values into internal table.

and write like this

DESCRIBE TABLE IT_TAB LINES COUNT.

COUNT = COUNT - 1.

**Then u know the last record.then write read statement

READ TABLE IT_TAB INTO WA_TAB INDEX COUNT.

Hope it may helpful,

regards,

ravi shankar reddy

[Former Member]

Hi Santo,

Use describe statment.

data: lv_line type i.

Describe table itab lines lv_line.

read table itab into wa_itab index lv_line.

cheers,

Hema.

[Former Member]

I have already mentioned its not an internal table

[Former Member]

select vbeln

max ( shipno )

<other fields>

where vbeln = <condition>.

[Former Member]

if it works assign points and close the thread...

[RoySayak]

Hi Santo,

It may be helpful to u...

SELECT SELLER FROM <TABLE NAME> WHERE

VBELN = '1100000197' AND SHIPNO = '0000000475'.

************************************************************reward points if it works****************************

THANKS,

SAYAK

[RaymondGiuseppi]

Try something like :

> SELECT seller FROM <ztable> UP TO 1 ROWS

> WHERE vbeln IN <range> AND shipno IN <range>

> ORDER BY VBELN ascending SHIPNO descending.

But if there is no adequate index, it would be better to read all records, sort them and get the last.

Regards

[RaymondGiuseppi]

You can also use subquery, something like

> SELECT seller

> FROM ztable

> INTO wa

> WHERE vbeln = value AND shipno = ( SELECT MAX( shipno ) FROM ztable WHERE vebln = value ).

Regards

[Former Member]

Tx