topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Mon, 19 Jun 2006 10:41:06 GMT

can we provied t code for reports?is it posssible?

any one can help me?

Re: reports

Former Member — Mon, 19 Jun 2006 10:42:27 GMT

Go to se93.

Create a t code

give the program name and select the second radio-button (Report and selection screen).

Give thescreen number as 1000.

Regards,

ravi

Re: reports

Former Member — Mon, 19 Jun 2006 10:46:35 GMT

use<b> SE93</b> to attach a tcode to ur program

Re: reports

Former Member — Mon, 19 Jun 2006 10:46:50 GMT

Hi,

yes you can ,

Go to Se93 -> give your tcode and create. while creating select the radiobutton report program and selection-screen. now give description and etc. and give the program name and screen number as 1000 and save it.

Regards

vijay

Re: reports

Former Member — Mon, 19 Jun 2006 10:47:29 GMT

Hai Vijay

SE38 Tcode for Create a Report Program

go through the following Documents

for writing your own Report

This is the order of execution in Classical/Interactive Report Events

Classical Reports

Reports which are properly formatted (header, footer, page numbers etc.,) with the help of one or more external events like top-of-page,end-of-page etc., are called as CLASSICAL REPORTS.

Standard list.

Output of Report program is nothing but Standard list. It consists of one continuous page of 60,000 lines.

To restrict number of lines per page.

Report Zxxxxx line-count 25.

Report Zxxxxx line-count 25(3).

( In this case 3 lines are reserved for footer)

To restrict Output width.

Report Zxxxx line-size 125.

To suppress standard page heading.

Report Zxxxx no standard page heading

Above all at a time:

Report Zxxxx line-count 25(3)

line-size 125

no standard page heading.

Screen Events List Events

Initialization. Start-of-selection

At selection-screen. Top-of-page.

At selection-screen on <field>. End-of-page.

End-of-selection.

We can initialize the selection-screen with calculated default values under this event.

Initialization.

s_date-high = sy-datum.

s_date-low = sy-datum - 15.

Append s_date.

We can validate all the inputs on selection screen fields under this event.

At selection-screen.

If s_carrid-low is initial or

s_connid-low is initial or

s_date is initial.

< ... code for validation... >.

Endif.

We can validate a particular field input on selection screen under this event.

At selection-screen on s_carrid.

If s_carrid-low < > ‘LH’.

<… code for validation…>

Endif.

If any of the other event comes before

‘Select…Endselect.’ statements, then to break

that event, we require this S-O-S event.

Start-of-selection.

Select * from ……

…………

Endselect.

If we need some portion of the output (like

column headings) to appear in all the pages,

then we use this event.

Top-of-page.

Write:/ ‘Carrier’,10 ‘Connection’ 20 ‘Date’.

If there is no external output statement before

‘Top-of-page’ event, then this event will not

work.

Once the cursor reaches the last line of the

page, automatically this event will be triggered.

Report Zxxx line-count 25(3).

In this case line numbers 23, 24 and 25 are

reserved for footer.

Once the cursor reaches 23rd line, this event

will be triggered.

End-of-page.

Write:/ sy-uline(75).

Write:/ ‘This is end of page:’,sy-pagno.

Write:/ sy-uline(75).

This event is used for concluding part of List.

End-of-selection.

Write:/ ‘This is end of the Report’.

Interactive Report

A simple report or even a classical report displays a clustered list with all the requested output at one go.

What ever it is displayed, it is final. That means, the user can not interact with with that list.

A simple report or even a classical report displays a clustered list with all the requested output at one go.

What ever it is displayed, it is final. That means, the user can not interact with with that list.

In the interactive reports, we can create as many as 21 lists.

The first list is called ‘Basic list’ and all the successive lists are called ‘Secondary lists’. Each list is again an interactive.

The Basic list is not deleted when secondary list is created.

A secondary list may either overlay the basic list or appear in an additional dialog window on the same screen.

The system variable associated with list number is ‘SY-LSIND’.

For basic list SY-LSIND = 0 and for secondary lists, SY-LSIND varies from 1 to 20.

User can interact with the list by the following ways.

Double clicking or single click and pressing F2 (function key) or single click with ‘hotspot on’.

Selecting from menu bar or from application tool bar.

All the events used in classical reports can be used in Basic List.

The event ‘End-of-page’ can be used in Secondary Lists also.(the other six events can not be used in secondary lists)

You can not place ‘select-options’ in secondary lists.

The following additional events are

applicable to secondary lists.

Top-of-page during line-selection.

At line-selection.

At user-command.

When you double click on any field in the basic list, you will be navigating to secondary list with detailed information pertaining to clicked field.

As such we need to store the clicked field information at some variable.

‘Hide’ temporarily stores the content of clicked field for later use.

The default title of the out put is the text what we enter during creation of program.

This title can be changed using:

SET TITLEBAR ‘AAA’.

GUI status includes:

Menu bar

Application tool bar and

Activating standard tool bar

GUI status can be created using

SET PF-STATUS ‘BBB’.

You can have 8 menus ( out of which, 2 menus are reserved for ‘System’ and ‘Help’).

Each menu can have 15 menu items.

Each menu item can have 3 levels of submenus.

You can create 35 items in application tool bar.

Thanks & regards

Sreenivasulu P

Re: reports

Former Member — Mon, 19 Jun 2006 10:49:17 GMT

Hi,

Go to SE93 and giv ur report name.

rgds,

latheesh

Re: reports

Former Member — Mon, 19 Jun 2006 10:51:39 GMT

se38---for report

se93--forn tcode..

goto ur program click on the object directory button their...on the left side it'll have all the objects..write click and say create transaction...

reward points if it helps

Regards

Gunjan

Re: reports

Former Member — Sat, 29 Jul 2006 07:28:00 GMT

Ya we can creat T-Code for our Reports.

Go to Transaction code SE93

Give a transaction code and click on Create.

Give ur Program name, short text and save it.

Re: reports

Former Member — Sat, 29 Jul 2006 08:51:43 GMT

hi,

there is no TCODE for reports, unlike TCODE for SAP scripts as SE71,

will create reports in ABAP EDITOR (SE38),

and, we can create the TCODE for that report in SE93,

-> goto SE93

-> enter the program name

-> select the redio button (REPORT transaction)

continue,just check it out,

but,there are some TCODES for standard reports in SAP,

that you can check from menu,information systems,general report selection,

best of luck,

regards,

kcc

Re: reports

Former Member — Fri, 18 Aug 2006 22:54:52 GMT

yeah u can provide T code just go to se93 give the program name for which u wanna create transaction.

Re: reports

Former Member — Tue, 22 Aug 2006 11:14:02 GMT

Go To <b>SE93</b> and And give the transaction code, wht ur going to creat. then click creat. then give the program name and save.

Now u can use that transaction code for the particular object.

all the best.

Re: reports

Former Member — Tue, 22 Aug 2006 11:30:40 GMT

go to transaction code SE93 , Give some name like ZTEST

Click on create

pop-up will appear , enter some short text

select program and selection screen (report transaction)

press enter

select the report name in program

enter screen 1000

Re: reports

Former Member — Wed, 30 Aug 2006 17:14:05 GMT

Hi,

Yes, we can add the transaction code to your program. These are the steps we need to follow to do this :

First : Go to Transaction Code : SE38 and create any simple program for ex. Take the name of the program and then go to transaction code SE93. Then give there whatever transaction code your require and then click on Create button. Then there will be a selection criteria like Program and Screen(Dialog program), Program and Selection Screen(Report Transaction). You need to select the second option as you are dealing with Reports.

Then it will ask you the program name and the screen number will give you (1000 Default) then click on execute.

You can use this transaction code instead of using the program, whenever you enter this transaction code in the command field, your program output will be appeared.

Thanks.

Ramesh.