topic Re: Structure query in Application Development and Automation Discussions

Structure query

Former Member — Tue, 05 Dec 2006 10:18:39 GMT

Dear all

I have taken activity unit based on activity type

throuh CSLA table

SELECT SINGLE leinh FROM csla INTO (eenheid)

WHERE lstar EQ zorg_product.

so based on the unit i have to take the text

how can do that

the text is in structure CSLAZ

Can u anybody help me out the query

thanx n advance

senthil

Re: Structure query

athavanraja — Tue, 05 Dec 2006 10:24:57 GMT

leinh text can be taken from table T006A

Regards

Raja

Re: Structure query

Former Member — Tue, 05 Dec 2006 10:25:39 GMT

REPORT ychatest LINE-SIZE 350.

TABLES : csla , t006a.

DATA : v_unit LIKE csla-leinh,
       v_text LIKE t006a-msehl.

SELECT SINGLE leinh FROM csla INTO v_unit
WHERE lstar EQ zorg_product.

IF sy-subrc EQ 0.
  SELECT SINGLE msehl FROM t006a INTO v_text WHERE msehi EQ v_unit.
ENDIF.

Re: Structure query

Former Member — Tue, 05 Dec 2006 10:31:29 GMT

HI Senthil,

The text will be stored in table <b>T006A</b>

SELECT SINGLE leinh FROM csla INTO (eenheid)

WHERE lstar EQ zorg_product.

IF sy-subrc EQ 0.

SELECT SINGLE MSEHL FROM T))6A INTO TEXT

WHERE MSEHI EQ EENHEID.

ENDIF.

Regards

Sudheer

Re: Structure query

jayanthi_jayaraman — Tue, 05 Dec 2006 10:35:38 GMT

Hi,

select csla_{leinh t006a}msehl from leinh inner join msehl on csla_{leinh = t006a}leinh where csla~lstar eq zorg_product.

This above will work only if leinh is primary key in both the tables.

Re: Structure query

Former Member — Tue, 05 Dec 2006 10:36:56 GMT

Hi Senthil,

I hope the following code will helps you.

<b>* We are not using full key - so please change select...single to select ... upto 1 rows.

select leinh

from csla

into lv_eenheid

where lstar EQ zorg_product

upto 1 rows.

endselect.

select *

from t006A

into wa_t006A

where spras eq 'EN and

MSEHI eq lv_eenheid.

if sy-subrc eq 0.

write wa_t006 -MSEHT,wa_t006-MSEHL.

endif.</b>

Regards

Bhupal Reddy

Re: Structure query

Former Member — Tue, 05 Dec 2006 11:22:40 GMT

thanx for all your replies

senthil