topic Re: Write Statement in Application Development and Automation Discussions

Write Statement

Former Member — Fri, 22 Aug 2008 12:54:59 GMT

Hi Experts,

I want to write on the top of my report(under Top-of-page event), the description of the taxcode when I fetch particular Taxcode in the selection-screen.

Suppose in my selection screen I fetch Taxcode A0, I want that in the output of the report I want the deecription of the Taxcode A0 i.e. Zero Output Taxcode.

Is it possible.

Savita

Re: Write Statement

Former Member — Fri, 22 Aug 2008 12:56:44 GMT

Use TOP-OF-PAGE Event...

Re: Write Statement

Former Member — Fri, 22 Aug 2008 12:58:35 GMT

In the event TOP-OF-PAGE select from the table of TAX codes descriptions the one you need and write it.

Regards

Re: Write Statement

Former Member — Fri, 22 Aug 2008 13:03:04 GMT

Hello Mahesh ,

Can u tell when the user select Tacode suppose A0 in the selection screen , I want to write its description in the report.

How can I do this.

Savita

Re: Write Statement

Former Member — Fri, 22 Aug 2008 13:09:27 GMT

Savita,

Do you want to write it into the report or in selection screen itself before you run the report option.

If you want to write it in report output after you run report with tax code in selection option, then you have to write the write statement into top-of-page event.

You have to select the tax description into top-of-page event and write it, example table T007S for tax description...

if you want to write it on screen immediately, you have to write it in at selection screen event and use modify screen option to put tax code into corresponding field.

I hope this will solve your issue.

If you need detail help, please let me know.

Regards,

Mahesh

Re: Write Statement

Former Member — Fri, 22 Aug 2008 13:15:16 GMT

Hello Mahesh,

I want in the output of the report, when the user select taxcode, I want its description in the o/p of the report on the top of the report.

Plz tell me some more detail.

Savita

Re: Write Statement

Former Member — Fri, 22 Aug 2008 13:28:58 GMT

Savita,

To get the output tax displayed into the output of the report then you it is definite you have to write it in top-of-page event.

Make sure top-of-page event gets triggered, ie you should have atleast one runtime write statement into your code.

top-of-page.

Select * from t007s

where spras = sy-langu

and mwskz = <input parameter field>.

Write:/ t007s-text1.

Regards,

Mahesh

Re: Write Statement

Former Member — Sat, 23 Aug 2008 04:50:09 GMT

Hi experts,

I want in the output of the report the description of the taxcode, as per user selection of taxcode in the selection screen, not all the taxcode.

Savita

Re: Write Statement

lijisusan_mathews — Sat, 23 Aug 2008 04:58:06 GMT

hi,

i believe u have the taxcode from the selection screen when u enter the top-of-page event.. In top-of-page, write a select statement to get the desciption of that taxcode into some field of type c. and write that field in the top-of-page event.

. if u do not know which is the table which contains the desciption of the tax code..

goto the data element of taxcode and double click on it to get its domain. in the domain, there will be table name in the field 'value table'.This u will find in the tab , value range..This will be the table from which u can get the description.

Re: Write Statement

Former Member — Sat, 23 Aug 2008 08:16:57 GMT

Hi Savita,

Try this :

PARAMETERS :

p_carrid LIKE spfli-carrid,

p_connid LIKE spfli-connid.

DATA :

t_spfli LIKE STANDARD TABLE OF spfli,

fs_spfli LIKE LINE OF t_spfli.

START-OF-SELECTION.

SELECT carrid

connid

cityfrom

cityto

FROM spfli

INTO CORRESPONDING FIELDS OF TABLE t_spfli

WHERE carrid EQ p_carrid

AND connid EQ p_connid.

LOOP AT t_spfli INTO fs_spfli.

WRITE 😕 fs_spfli-cityfrom,

fs_spfli-cityto.

ENDLOOP.

TOP-OF-PAGE.

LOOP AT t_spfli INTO fs_spfli.

WRITE 😕 fs_spfli-carrid,

fs_spfli-connid.

ENDLOOP.

Regards,

Swapna.