reports

Former Member — Fri, 25 Jan 2008 09:46:08 GMT

hi,

can any one explain what is late payment and how to develop an interactive report for late payments.

urgent plz.

what is the use of ssf_function_module_name.

where do we define authority check in a program.

what is cluster table and is main usage.

Re: reports

Former Member — Fri, 25 Jan 2008 10:00:12 GMT

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

2.what is the use of ssf_function_module_name in smart forms

A function module is generated whenever a Smart Form is activated. This Smart Form could be called from the driver program by calling this function module as shown below:

REPORT Zcall_smartform.CALL FUNCTION '/1BCDWB/SF00000359'

EXPORTING

ARCHIVE_INDEX =

ARCHIVE_INDEX_TAB =

ARCHIVE_PARAMETERS =

CONTROL_PARAMETERS =

MAIL_APPL_OBJ =

MAIL_RECIPIENT =

MAIL_SENDER =

OUTPUT_OPTIONS =

USER_SETTINGS = 'X'

IMPORTING

DOCUMENT_OUTPUT_INFO =

JOB_OUTPUT_INFO =

JOB_OUTPUT_OPTIONS =

EXCEPTIONS

FORMATTING_ERROR = 1

INTERNAL_ERROR = 2

SEND_ERROR = 3

USER_CANCELED = 4

OTHERS = 5

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.But this is not an efficient way of calling Smart Form for the following reason:

Whenever a Smart Form is generated, a function module is generated and the naming convention for that Smart Form is done internally by using Number range object or something similar. In the above case, the function module name is /1BCDWB/SF00000359. The function module for the next new and activated Smart Form would be /1BCDWB/SF00000360.

So when this Smart Form is transported from the development to Quality or Production system, a new function module name is generated according to the number series available in that system. If the above program is transported to either quality or production system, the program might go for a dump as the function module is not available in that system. To handle this situation, we use the function module SSF_FUNCTION_MODULE_NAME to get the name of the function module for a Smart Form dynamically. If the form is not active, the function module SSF_FUNCTION_MODULE_NAME raises the exception NO_FORM.

Look at the modified program below:

REPORT zcall_smartform.

DATA:

fname TYPE rs38l_fnam.call function 'SSF_FUNCTION_MODULE_NAME'

exporting

formname = 'ZSMARTFORMS_TRAINING2'

VARIANT = ' '

DIRECT_CALL = ' '

importing

fm_name = fname

EXCEPTIONS

NO_FORM = 1

NO_FUNCTION_MODULE = 2

OTHERS = 3

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.* Now replace the function module name '/1BCDWB/SF00000359'

with the variable FNAME

CALL FUNCTION FNAME

EXPORTING

ARCHIVE_INDEX =

ARCHIVE_INDEX_TAB =

ARCHIVE_PARAMETERS =

CONTROL_PARAMETERS =

MAIL_APPL_OBJ =

MAIL_RECIPIENT =

MAIL_SENDER =

OUTPUT_OPTIONS =

USER_SETTINGS = 'X'

IMPORTING

DOCUMENT_OUTPUT_INFO =

JOB_OUTPUT_INFO =

JOB_OUTPUT_OPTIONS =

EXCEPTIONS

FORMATTING_ERROR = 1

INTERNAL_ERROR = 2

SEND_ERROR = 3

USER_CANCELED = 4

OTHERS = 5

IF sy-subrc 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

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

REPORT demo_authorithy_check.

PARAMETERS pa_carr LIKE sflight-carrid.

DATA wa_flights LIKE demo_focc.

AT SELECTION-SCREEN.

AUTHORITY-CHECK OBJECT 'S_CARRID'

ID 'CARRID' FIELD pa_carr

ID 'ACTVT' FIELD '03'.

IF sy-subrc = 4.

MESSAGE e045(sabapdocu) WITH pa_carr.

ELSEIF sy-subrc 0.

MESSAGE e184(sabapdocu) WITH text-010.

ENDIF.

START-OF-SELECTION.

SELECT carrid connid fldate seatsmax seatsocc

FROM sflight

INTO CORRESPONDING FIELDS OF wa_flights

WHERE carrid = pa_carr.

WRITE: / wa_flights-carrid,

wa_flights-connid,

wa_flights-fldate,

wa_flights-seatsmax,

wa_flights-seatsocc.

ENDSELECT.

In this example, the system checks with the authorization object S_CARRID whether or not the user has a display authorization (03) for the airline entered on a selection screen. If this is not the case, or a different error occurs, the Selection Screen Processing goes back to the display of the selection screen.

http://help.sap.com/saphelp_nw70/helpdata/en/9f/dbaccb35c111d1829f0000e829fbfe/content.htm

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

4. A table cluster combines several logical tables in the ABAP/4 Dictionary. Several logical rows from different cluster tables are brought together in a single physical record. The records from the cluster tables assigned to a cluster are thus stored in a single common table in the database.

Re: reports

Former Member — Fri, 25 Jan 2008 10:00:35 GMT

Hi tulasi muvva

Right now i can answer two questions out of your 4.

1) Define authority check in AT SELECTION-SCREEN event

2) Cluster Table : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

Reward me if it helps you.

Re: reports

Former Member — Fri, 25 Jan 2008 11:11:41 GMT

Interactive list:

For Classic list:

First generate the basic list.

Under the AT LINE-SELECTION event make use of the GET PARAMETER-ID & SET PARAMETER-ID statements to capture a record and field which is chosen from the basic list. Based on the the captured record, generate the Secondary list.

We can generate to a maximum of 20 Secondary lists in the same way.

For ALV list:

Make use of the FM REUSE_ALV_EVENTS_GET to do this..

topic Re: reports in Application Development and Automation Discussions

reports

Re: reports

Re: reports

Re: reports