topic Re: Transaction code description in Application Development and Automation Discussions

Transaction code description

Former Member — Mon, 23 Jun 2008 01:00:54 GMT

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

Re: Transaction code description

Former Member — Mon, 23 Jun 2008 04:27:16 GMT

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,

Re: Transaction code description

Former Member — Mon, 23 Jun 2008 04:59:30 GMT

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****************&

Re: Transaction code description

Former Member — Mon, 23 Jun 2008 05:08:29 GMT

Hi Guys

Thanks ...It all works smoothly

regards

Piroz

Re: Transaction code description

Former Member — Fri, 05 Feb 2010 03:42:25 GMT

Thanks thread closed

Piroz