topic Re: Fetching value from Table in Application Development and Automation Discussions

Fetching value from Table

Former Member — Thu, 24 Jan 2008 12:59:17 GMT

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?

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:02:36 GMT

Hi,

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

Regards,

Satish

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:02:50 GMT

Hi Santo,

> Select seller

> from table

> where seller ne 'OTHER_1000::LEVEL3'.

Plzz reward if it is useful,

Mahi.

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:05:29 GMT

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.

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

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:05:58 GMT

Wrong response. Its a blind reply

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:07:29 GMT

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.

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:07:40 GMT

Wrong response. Its a blind reply

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:08:48 GMT

I have already mentioned its not an internal table

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:10:36 GMT

select vbeln

max ( shipno )

where vbeln = <condition>.

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:10:43 GMT

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

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:14:44 GMT

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

Re: Fetching value from Table

RoySayak — Thu, 24 Jan 2008 13:15:31 GMT

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

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:16:55 GMT

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

Re: Fetching value from Table

RaymondGiuseppi — Thu, 24 Jan 2008 13:19:37 GMT

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

Re: Fetching value from Table

Former Member — Thu, 24 Jan 2008 13:33:23 GMT

Re: Fetching value from Table

RaymondGiuseppi — Thu, 24 Jan 2008 13:53:14 GMT

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