‎2009 Mar 20 10:42 AM
Hiii All,
I have a parameter statement in report
in that i want to give a table name,
when i execute the report -
i want to reflect the table name which i have given in the parameter
should reflect the ddic table.
regards,
Sashi
‎2009 Mar 20 10:55 AM
Tables:dd03l.
Parameter : P_tabnm type dd03l-tabname.
data: G_tabnm type dd03l-tabname.
At selection-screen.
select tabname into G_tabnm from dd03l
where tabname = P_tabnm.
endselect.
if sy-subrc ne 0 .
MESSAGE 'No such table' TYPE 'E'.
endif.
END-OF-SELECTION.
write:/ P_tabnm.
Edited by: Sarbajit Majumdar on Mar 20, 2009 4:31 PM
Edited by: Sarbajit Majumdar on Mar 20, 2009 4:33 PM
‎2009 Mar 20 10:55 AM
Tables:dd03l.
Parameter : P_tabnm type dd03l-tabname.
data: G_tabnm type dd03l-tabname.
At selection-screen.
select tabname into G_tabnm from dd03l
where tabname = P_tabnm.
endselect.
if sy-subrc ne 0 .
MESSAGE 'No such table' TYPE 'E'.
endif.
END-OF-SELECTION.
write:/ P_tabnm.
Edited by: Sarbajit Majumdar on Mar 20, 2009 4:31 PM
Edited by: Sarbajit Majumdar on Mar 20, 2009 4:33 PM
‎2009 Mar 20 11:00 AM
Hi,
use like
SET PARAMETER ID '<table name>' FIELD fvalue.
CALL TRANSACTION 'SE11' and skip first screen.
Regards,
jaya
‎2009 Mar 20 11:06 AM
Hi,
data : fnam TYPE TABNAME16,
fval(10) type c.
parameters : tabname(10) type c.
FNAM = 'TBMA_VAL'.
FVAL = TABNAME.
get cursor field fnam value fval.
FVAL = TABNAME.
set parameter id 'DTB' field fval.
call transaction 'SE11'.
Thanks
‎2009 Mar 20 11:48 AM
Hi Sashi,
I think this is the piece of code you require..
Execute and check it yourself.
REPORT ZRAJTEST
NO STANDARD PAGE HEADING LINE-SIZE 255.
DATA: IT_BDCDATA TYPE BDCDATA OCCURS 0 WITH HEADER LINE,
MODE TYPE CTU_MODE.
PARAMETERS: TABNAME TYPE DD03L-TABNAME.
CLEAR IT_BDCDATA.
IT_BDCDATA-PROGRAM = 'SAPMSRD0'.
IT_BDCDATA-DYNPRO = '0102'.
IT_BDCDATA-DYNBEGIN = 'X'.
APPEND IT_BDCDATA.
CLEAR IT_BDCDATA.
IT_BDCDATA-FNAM = 'BDC_OKCODE'.
IT_BDCDATA-FVAL = '=SHOW'.
APPEND IT_BDCDATA.
SET PARAMETER ID 'DTB' FIELD TABNAME. "Had mentioned 'BES' earlier which was wrong
CALL TRANSACTION 'SE11' USING IT_BDCDATA MODE 'E'.Get back to me if you require any clarification.
Regards,
Rajan.
A slight change in the parameter ID. Please Check it. There was a slight mistake.
Edited by: rajan roy on Mar 20, 2009 1:31 PM
‎2009 Mar 20 12:36 PM
Hi Sashi,
With reference to my earlier post, I had wrongly mentioned the Parameter ID. Please change it to 'DTB' and execute. Do get back to me if you are facing any problems.
Regards,
Rajan.