Transaction code description

[Former Member]

Hi Experts

I know it is stupid question, but how can i get transaction code description TSTCT to link with the following tables

AGR_TCODES

AGR_USERS

AGR_1251

AGR_PROF

AGR_DEFINE

I want to join AGR_TCODES with TSTCT (which contains t codes descriptions) or is there anyother tables

Regards

Piroz

[Former Member]

hi,

try the below code

TYPES: BEGIN OF ty_tcodes,

tcode TYPE tcode,

ttext TYPE ttext_stct,

END OF ty_tcodes,

BEGIN OF ty_agr_tcodes,

agr_name TYPE agr_name,

type TYPE reporttype,

tcode TYPE agxreport,

tcode20 TYPE tcode,

END OF agr_tcodes.

DATA: it_agr_tcodes TYPE STANDARD TABLE OF ty_agr_tcodes,

it_tcode TYPE stard table of ty_tcodes.

START-OF-SELECTION.

SELECT agr_name

type

tcode

tcode AS tcode20

FROM agr_tcodes

INTO TABLE it_agr_tcodes.

IF sy-subrc = 0.

SELECT tcode

ttext

INTO TABLE it_tcode

FOR ALL ENTRIES IN it_agr_tcodes

WHERE sprsl = 'EN'

AND tcode = it_tcode-tcode.

ENDIF.

Reward if found helpful.

Regards,

SB

[Former Member]

Hi Use the below query regarding the Text Description.

SELECT * INTO IT_TSTCT FROM TSTCT 
FOR ALL ENTRIES IN IT_AGR_TCODES
WHERE TCODE = IT_TSTCT-TCODE.

&**************Reward Point if helpful****************&

[Former Member]

Hi Guys

Thanks ...It all works smoothly

regards

Piroz

[Former Member]

Thanks thread closed

Piroz