topic Re: simple doubt in Application Development and Automation Discussions

simple doubt

Former Member — Thu, 13 Oct 2005 04:18:44 GMT

i have

btrtl for pa0000-btrtl in selection screen.

(btrtl is personal sub area number)

when i select this range in sel screen., i want to display the personal sub area text in the report output.

sub-area text is in t001p-btext.

can anyone tell me!

Re: simple doubt

Former Member — Thu, 13 Oct 2005 04:28:47 GMT

Here is a sample code.


SELECT-OPTIONS S_BTRTL FOR PA0000-BTRTL.

SELECT BTRTL FIELD1 FIELD2 etc FROM DBTABLE INTO TABLE ITAB WHERE BTRTL IN S_BTRTL AND, OR OTHER CONDITIONS.

SELECT BTRTL BTEXT INTO TABLE ITAB_TEXT FROM T001P
                  WHERE BTRTL IN S_BTRTL
                    AND SPRAS = SY-LANGU.

END-OF-SELECTION.

LOOP AT ITAB.
  WRITE:/ ITAB-BTRTL.
  CLEAR ITAB_TEXT.
  READ TABLE ITAB_TEXT WITH KEY BTRTL = ITAB-BTRTL.
  WRITE: ITAB_TEXT-BTRTL.
ENDDLOOP.

Srinivas

Re: simple doubt

jayanthi_jayaraman — Thu, 13 Oct 2005 04:34:59 GMT

Hi,

I cannot see BTRTL in pa0000.

But you can make the select statement as

types : begin of ty,

btext type t001p-btext,

end of ty.

data : i_btext type standard table of ty,

w_btext type ty.

select btext into table i_btext from t001p where btrtl in s_btrtl.

loop at i_btext into w_btext.

write w_btext-btext.

endloop.

Kindly reward points if it helps.