topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 10 Jul 2008 09:39:34 GMT

hi frndz,

could u plz give the syntax of submit and return?

Re: report

Former Member — Thu, 10 Jul 2008 09:41:58 GMT

hi try this,

SUBMIT prog(field) AND RETURN.

Regards,

Rajasekhar Reddy.

Re: report

Former Member — Thu, 10 Jul 2008 09:42:06 GMT

hi,

jus type SUBMIT in se38 , and press F1, u'll get enough details.

Jus fyi...

SUBMIT report1 AND RETURN.

Re: report

Former Member — Thu, 10 Jul 2008 09:42:28 GMT

HI,

Please refer the link below :

http://www.sapdev.co.uk/reporting/rep_submit.htm

Thanks,

Sriram Ponna.

Re: report

Former Member — Thu, 10 Jul 2008 09:43:10 GMT

Hello

Example

SUBMIT REPORT01

VIA SELECTION-SCREEN

USING SELECTION-SET 'VARIANT1'

USING SELECTION-SETS OF PROGRAM 'REPORT00'

AND RETURN.

Effect

Executes the program REPORT01 with the variant VARIANT1 of the program REPORT00.

Re: report

Former Member — Thu, 10 Jul 2008 09:44:14 GMT

HERE IT IS

SUBMIT <PROGRAM NAME> VIA SELECTION-SCREEN

WITH SELECTION-TABLE <TABLE-NAME>

AND RETURN.

CHEERS

SNEHI

Re: report

GauthamV — Thu, 10 Jul 2008 09:44:19 GMT

hi,

SUBMIT <program name>

VIA SELECTION-SCREEN

EXPORTING LIST TO MEMORY AND RETURN.

Re: report

venkatasriram_mygapula — Thu, 10 Jul 2008 09:48:23 GMT

Hi,

SUBMIT 'PROGRAM NAME' VIA SELECTION SCREEN AND RETURN.

regards.

sriram.

Re: report

Former Member — Thu, 10 Jul 2008 09:48:58 GMT

example for submit

SUBMIT <reportname> WITH h_1 EQ vkorg

WITH h_2 EQ vtweg

WITH l_1 EQ waerk

WITH l_2 EQ kondm

WITH l_3 EQ zzkvgr1

WITH l_4 EQ matnr

WITH l_5 EQ kunnr

WITH l_6 EQ konda

WITH datum BETWEEN date_from AND date_to

AND RETURN.

SUBMIT... [VIA SELECTION-SCREEN]

[USING SELECTION-SET <var>]

[WITH <sel> <criterion>]

[WITH FREE SELECTIONS <freesel>]

[WITH SELECTION-TABLE <rspar>].

Re: report

Former Member — Thu, 10 Jul 2008 09:51:27 GMT

Hi Venkat,

Program accessed

REPORT report1.

DATA text TYPE c LENGTH 10.

SELECTION-SCREEN BEGIN OF SCREEN 1100.

SELECT-OPTIONS: selcrit1 FOR text,

selcrit2 FOR text.

SELECTION-SCREEN END OF SCREEN 1100.

...

Calling program

REPORT report2.

DATA: text TYPE c LENGTH 10,

rspar_tab TYPE TABLE OF rsparams,

rspar_line LIKE LINE OF rspar_tab,

range_tab LIKE RANGE OF text,

range_line LIKE LINE OF range_tab.

...

rspar_line-selname = 'SELCRIT1'.

rspar_line-kind = 'S'.

rspar_line-sign = 'I'.

rspar_line-option = 'EQ'.

rspar_line-low = 'ABAP'.

APPEND rspar_line TO rspar_tab.

range_line-sign = 'E'.

range_line-option = 'EQ'.

range_line-low = 'H'.

APPEND range_line TO range_tab.

range_line-sign = 'E'.

range_line-option = 'EQ'.

range_line-low = 'K'.

APPEND range_line TO range_tab.

SUBMIT report1 USING SELECTION-SCREEN '1100'

WITH SELECTION-TABLE rspar_tab

WITH selcrit2 BETWEEN 'H' AND 'K'

WITH selcrit2 IN range_tab

AND RETURN.

<removed_by_moderator>

Regards.

Eshwar.

Edited by: Julius Bussche on Jul 10, 2008 11:59 AM

Re: report

Former Member — Thu, 10 Jul 2008 10:23:13 GMT

hi,

syntax of SUBMIT is...

{SUBMIT {rep|(name)} [selscreen_options]

[ list_options ]

[ job_options]

[AND RETURN]. }

The SUBMIT statement accesses an executable program rep. The executable program is executed as described under Calling Executable Reports.

The program name rep can either be specified directly or as the content of a character-like data object name. The data object name must contain the name of the program to be accessed in block capitals. If the program specified in name is not found, an irretrievable exception is generated.

The selscreen_options additions can be used to determine the selection screen for the program accessed and to supply it with values.

The list_options additions allow you to influence the output medium and the page size in the basic list for the program accessed.

You can schedule the program for background processing by specifying job_options.

While Return statement immediately ends the current processing block. It can appear in any area of a processing block and ends this block regardless of which statement block or control structure the statement is in.

*Usually, the user exits a program you called using SUBMIT... AND RETURN by choosing F3 or F15 on list level 0 of the called program. *

{REPORT demo_programm_leave NO STANDARD PAGE HEADING.

DATA: itab TYPE TABLE OF i,

num TYPE i.

SUBMIT demo_program_rep3 AND RETURN.

IMPORT itab FROM MEMORY ID 'HK'.

LOOP AT itab INTO num.

WRITE / num.

ENDLOOP.

TOP-OF-PAGE.

WRITE 'Report 1'.

ULINE.

}

hope this will clear your doubt.

Please reward if it helps.

thanks.

Re: report

Former Member — Thu, 10 Jul 2008 11:10:10 GMT

Hi try this,

Report1:

data: begin of itab occurs 0,

num type i,

end of itab.

Parameters: p_count type i.

start-of-selection.

do p_count times.

itab-num = sy-index.

append itab.

enddo.

loop at itab.

write:/ itab-num.

endloop.

Report2:

data: g_count type i value '15'.

data: p_count type i.

data: list_tab like table of ABAPLIST.

break vreddy.

submit ztests14 using selection-screen '1000'

with p_count = g_count exporting list to memory and return.

CALL FUNCTION 'LIST_FROM_MEMORY'

TABLES

listobject = list_tab

EXCEPTIONS

not_found = 1

OTHERS = 2.

IF sy-subrc = 0.

CALL FUNCTION 'WRITE_LIST'

TABLES

listobject = list_tab.

ENDIF.

write: g_count.

Re: report

Former Member — Thu, 10 Jul 2008 11:27:01 GMT

Hi Venkat,

Try this.

Report1:

data: begin of itab occurs 0,

num type i,

end of itab.

data: p_count type i.

start-of-selection.

import p_count from memory id 'M1'.

p_count = p_count + 15.

export p_count to memory id 'M2'.

Report2:

data: g_count type i value '15'.

parameters: p_count type i.

data: list_tab like table of ABAPLIST.

export p_count to memory id 'M1'.

submit ztests19 and return.

import g_count from memory id 'M2'.

write: g_count.

Thanks&Regards,

Sravan

Re: report

Former Member — Thu, 10 Jul 2008 11:41:44 GMT

Hi venkat,

http://help.sap.com/saphelp_nw04/helpdata/en/9f/db9dd035c111d1829f0000e829fbfe/content.htm

Regards,

Sravanthi.