topic Re: Using internal table data in smartform in Application Development and Automation Discussions

Using internal table data in smartform

far_sid210333 — Mon, 16 Jan 2023 11:30:01 GMT

I am extracting data from excel in internal table, now i wanted to use that internal table and display the data in smartform. If anyone can provide me with some document related to this or tell me how should I approach with this requirement. Some help would be fine.

Thanks

Farhan

Re: Using internal table data in smartform

dominik_jacobs — Mon, 16 Jan 2023 11:40:50 GMT

You can use internal table data in a Smartform by creating a table node in the Smartform layout and then binding the internal table data to the table node. Here is an overview of the steps you need to follow:

Create a new Smartform and define the layout for the form.
In the layout, create a new table node and define the structure of the table, including the number of columns and the data types of each column.
In the ABAP program that calls the Smartform, fill the internal table with the data that you want to display in the Smartform.
Use the FILL_TABLE method of the Smartform to bind the internal table data to the table node in the Smartform.
Use the CALL_FORM method of the Smartform to call the Smartform and display the data in the table node.
Here is an example of how to use internal table data in a Smartform:

* Declare internal table
DATA: it_data TYPE TABLE OF ztable.

* Fill internal table with data
SELECT * FROM ztable INTO TABLE it_data.

* Bind internal table to Smartform table node
CALL FUNCTION 'FILL_TABLE'
    EXPORTING
        formname = 'MY_SMARTFORM'
        tablename = 'MY_TABLE'
        it_fields = it_data.

* Call the Smartform
CALL FUNCTION 'CALL_FORM'
    EXPORTING
        formname = 'MY_SMARTFORM'
        output_options = 'X'
    EXCEPTIONS
        form_not_found = 1
        OTHERS = 2.

Re: Using internal table data in smartform

Sandra_Rossi — Mon, 16 Jan 2023 12:04:12 GMT

FILL_TABLE and CALL_FORM are not recommended and supported as far as I know. This is the classic way:

Create a structure in the DDIC which corresponds to the internal table
Define the internal table as parameter of the Smart Form (in the "Interface" block)
Define a LOOP or TABLE node in your Smart Form to output its contents

This below code is taken from the demo program SF_EXAMPLE_01, see the BOOKINGS and CONNECTIONS internal tables defined as parameters:

CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'
  EXPORTING
    formname           = p_form
  IMPORTING
    fm_name            = l_fm_name
  EXCEPTIONS
    no_form            = 1
    no_function_module = 2
    OTHERS             = 3.

ls_output_options-tdcopies = 0.
CALL FUNCTION l_fm_name
  EXPORTING
    control_parameters   = ls_control_parameters
    output_options       = ls_output_options
    user_settings        = space
    customer             = customer
    bookings             = bookings             "<========================= 
    connections          = connections          "<=========================

Re: Using internal table data in smartform

far_sid210333 — Mon, 16 Jan 2023 12:17:01 GMT

I am not uploading that data into a standard table i have to use the data in internal table only.

Re: Using internal table data in smartform

far_sid210333 — Mon, 16 Jan 2023 12:26:53 GMT

ok thanks, I'll see the program once.

Re: Using internal table data in smartform

RaymondGiuseppi — Mon, 16 Jan 2023 12:36:37 GMT

Look at the SAP provided samples (program name starting with SF_) or community's ones
Search online help and forum