topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 27 Mar 2008 05:56:52 GMT

Hi friends.

This is code used to display comp name.

DATA : v_butxt LIKE t001-butxt.

SELECT SINGLE butxt FROM t001 INTO v_butxt WHERE bukrs EQ '1000'.

fheader-typ = 'H'.

fheader-info = v_butxt.

APPEND fheader.

CLEAR fheader.

But now requirment is diplay company name for different comp code or display name as per comp code entered

Re: report

Former Member — Thu, 27 Mar 2008 06:00:12 GMT

declare a variable BUKRS and get the entered company code into BUKRS and pass that into ur select query like

data: bukrs like t001-bukrs.

bukrs = 'UR Com Code'.

SELECT SINGLE butxt FROM t001 INTO v_butxt WHERE bukrs EQ BUKRS.

Regards

Sugumar G

Edited by: Sugumar Ganesan on Mar 27, 2008 7:01 AM

Re: report

Former Member — Thu, 27 Mar 2008 06:05:23 GMT

HI,

DATA : v_butxt LIKE t001-butxt.

parameters: p_Bukrs like bkpf-bukrs.

SELECT SINGLE butxt FROM t001 INTO v_butxt WHERE bukrs EQ p_bukrs.

write:/ v_butxt.

Regards,

S.Kendi.

Re: report

Former Member — Thu, 27 Mar 2008 06:07:34 GMT

query is answered

Re: report

Former Member — Thu, 27 Mar 2008 06:12:59 GMT

Hai

if u enter a company code as parameter in selection screen

parameter p_bukrs type bukrs.

data: w_butxt type butxt.

u need to write

SELECT SINGLE butxt FROM t001 INTO w_butxt WHERE bukrs EQ p_bukrs.

and write:/ w_butxt.

if u use select-options

select-options: s_bukrs like mara-bukrs.

u need to write

SELECT butxt FROM t001 INTO table it_butxt WHERE bukrs in s_bukrs.

u need to get all the company code text into a table and display them by looping the internal table it_butxt.

pls reward if helpful

raam

Re: report

Former Member — Thu, 27 Mar 2008 06:22:50 GMT

thanks