reports in SAPScripts

Sultanuddin — Mon, 05 Feb 2007 15:58:56 GMT

Please anybody tell me how to call reports in SAP Scripts?

Re: reports in SAPScripts

Former Member — Mon, 05 Feb 2007 16:24:57 GMT

HI,

Using PEFORM....ENDPERFORM

u can call a report to execute a subroutine in the report.

report fetches a matnr from the script and modify by supressing zeroes in the matnr

ex: ltap-matnr = 00000000000000034

gv_matnr = 34

<b>/: perform TEST in program ZPROGRAM

/: using &ltap-matnr&

/: changing &gv_matnr&

/: endform

***********************************

REPORT ZPROGRAM.

FORM TEST TABLES tab_in STRUCTURE itcsy

tab_out STRUCTURE itcsy.

DATA : gv_matnr(18).

CLEAR gv_matnr.

READ TABLE tab_in WITH KEY 'ITAP_MATNR'.

IF sy-subrc = 0.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

input = tab_in-value

IMPORTING

output = gv_matnr.

ENDIF.

READ TABLE tab_out WITH KEY 'GV_MATNR'.

IF sy-subrc = 0.

tab_out-value = gv_matnr.

ENDIF.

MODIFY tab_out INDEX sy-tabix.

ENDFORM.

*************************************************</b>

If u want to run another report then use SUBMIT command in subroutine.

Regards

SAB

Re: reports in SAPScripts

Former Member — Mon, 05 Feb 2007 18:40:56 GMT

Hi,

You can use the PERFORM command to call an ABAP subroutine (form) from any program, subject to the normal ABAP runtime authorization checking. You can use such calls to subroutines for carrying out calculations, for obtaining data from the database that is needed at display or print time, for formatting data, and so on.

PERFORM commands, like all control commands, are executed when a document is formatted for display or printing. Communication between a subroutine that you call and the document is by way of symbols whose values are set in the subroutine.

The system does not execute the PERFORM command within SAPscript replace modules, such as TEXT_SYMBOL_REPLACE or TEXT_INCLUDE_REPLACE. The replace modules can only replace symbol values or resolve include texts, but not interpret SAPscript control commands.

Syntax in a form window:

/: PERFORM <form> IN PROGRAM <prog>

/: USING &INVAR1&

/: USING &INVAR2&

......

/: CHANGING &OUTVAR1&

/: CHANGING &OUTVAR2&

......

/: ENDPERFORM

INVAR1 and INVAR2 are variable symbols and may be of any of the four SAPscript symbol types.

OUTVAR1 and OUTVAR2 are local text symbols and must therefore be character strings.

The ABAP subroutine called via the command line stated above must be defined in the ABAP report prog as follows:

FORM <form> TABLES IN_TAB STRUCTURE ITCSY

OUT_TAB STRUCTURE ITCSY.

...

ENDFORM.

The values of the SAPscript symbols passed with /: USING... are now stored in the internal table IN_TAB . Note that the system passes the values as character string to the subroutine, since the field Feld VALUE in structure ITCSY has the domain TDSYMVALUE (CHAR 80). See the example below on how to access the variables.

The internal table OUT_TAB contains names and values of the CHANGING parameters in the PERFORM statement. These parameters are local text symbols, that is, character fields. See the example below on how to return the variables within the subroutine.

From within a SAPscript form, a subroutine GET_BARCODE in the ABAP program QCJPERFO is called. Then the simple barcode contained there (‘First page’, ‘Next page’, ‘Last page’) is printed as local variable symbol.

Definition in the SAPscript form:

/: PERFORM GET_BARCODE IN PROGRAM QCJPERFO

/: USING &PAGE&

/: USING &NEXTPAGE&

/: CHANGING &BARCODE&

/: ENDPERFORM

/ &BARCODE&

Coding of the calling ABAP program:

REPORT QCJPERFO.

FORM GET_BARCODE TABLES IN_PAR STUCTURE ITCSY

OUT_PAR STRUCTURE ITCSY.

DATA: PAGNUM LIKE SY-TABIX, "page number

NEXTPAGE LIKE SY-TABIX. "number of next page

READ TABLE IN_PAR WITH KEY ‘PAGE’.

CHECK SY-SUBRC = 0.

PAGNUM = IN_PAR-VALUE.

READ TABLE IN_PAR WITH KEY ‘NEXTPAGE’.

CHECK SY-SUBRC = 0.

NEXTPAGE = IN_PAR-VALUE.

READ TABLE OUT_PAR WITH KEY ‘BARCODE’.

CHECK SY-SUBRC = 0.

IF PAGNUM = 1.

OUT_PAR-VALUE = ‘|’. "First page

ELSE.

OUT_PAR-VALUE = ‘||’. "Next page

ENDIF.

IF NEXTPAGE = 0.

OUT_PAR-VALUE+2 = ‘L’. "Flag: last page

ENDIF.

MODIFY OUT_PAR INDEX SY-TABIX.

ENDFORM.

Regards,

Vara

topic Re: reports in SAPScripts in Application Development and Automation Discussions

reports in SAPScripts

Re: reports in SAPScripts

Re: reports in SAPScripts