topic Re: smartform data passing in Application Development and Automation Discussions

smartform data passing

Former Member — Tue, 24 Feb 2009 06:23:38 GMT

hi ,

I am trying to use 4 tables for smartform instead of one but ,if i use nested loop it is not giving me results . the four tables used are :-

header - po no

Details - po details

address

and shipping address

when i define the tables in the form Interface ii have given associated type as like. .what might be the reason as the data is populated in the tables but not bieng passed .

Re: smartform data passing

Former Member — Tue, 24 Feb 2009 06:29:23 GMT

Why you are using nested loops, you can simple use work area for Header details and Loop for Item details. You can get Shipping address from Header details itself. First question are u getting data into smartform. Put break point in the smartform programming lines and debug where it is going wrong.

Re: smartform data passing

Former Member — Tue, 24 Feb 2009 07:03:44 GMT

hi,

Make use of joins on the tables and write the select query.

This will resolve ur issue.

Re: smartform data passing

Former Member — Tue, 24 Feb 2009 07:16:58 GMT

But if i want One purchase Order on one page how do i apply PAge break?

Re: smartform data passing

Former Member — Tue, 24 Feb 2009 07:18:28 GMT

Hi,

check the internal table before for initial .dont use nested loop instead use join statement .

Re: smartform data passing

Former Member — Tue, 24 Feb 2009 07:29:05 GMT

Phanindra please elaborate . i am passing tables using function m,odule in following way.

CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'

EXPORTING

formname = 'Z9MSK_SMARTFORMS1'

VARIANT = ' '
DIRECT_CALL = ' '

IMPORTING

fm_name = fm_name

EXCEPTIONS

no_form = 1

no_function_module = 2

IF sy-subrc <> 0.

WRITE : 'Smart form name not recognised'.

ENDIF.

"'/1BCDWB/SF00000709'

CALL FUNCTION fm_name

EXPORTING

ARCHIVE_INDEX = ARCHIVE_INDEX
ARCHIVE_INDEX_TAB = ARCHIVE_INDEX_TAB
ARCHIVE_PARAMETERS = ARCHIVE_PARAMETERS
CONTROL_PARAMETERS = CONTROL_PARAMETERS
MAIL_APPL_OBJ = MAIL_APPL_OBJ
MAIL_RECIPIENT = MAIL_RECIPIENT
MAIL_SENDER = MAIL_SENDER
OUTPUT_OPTIONS = OUTPUT_OPTIONS

USER_SETTINGS = 'X'

IMPORTING
DOCUMENT_OUTPUT_INFO = DOCUMENT_OUTPUT_INFO
JOB_OUTPUT_INFO = JOB_OUTPUT_INFO
JOB_OUTPUT_OPTIONS = JOB_OUTPUT_OPTIONS

TABLES

po_header = po_header

po_details = po_details

it_address = it_address

it_t001w = it_t001w

EXCEPTIONS

FORMATTING_ERROR = 1

INTERNAL_ERROR = 2

SEND_ERROR = 3

USER_CANCELED = 4

Then in the smartform

loop (loop at po_header)

i into

wa_po_header

Then using flow logic one more loop

loop (loop at po_details )

using where condition

where ebeln = wa_po_header-ebeln

Edited by: MSK on Feb 24, 2009 8:30 AM

Re: smartform data passing

Former Member — Tue, 24 Feb 2009 09:07:22 GMT

Hi,

Create Two Structures in SE11 based on the fields ie for all header data keep one structure and item data keep one structure. So it is very esay to pass data and no need to use nested loop in the samrtforms.

Thanks

Srilatha

Re: smartform data passing

Former Member — Tue, 03 Mar 2009 11:35:04 GMT

hi shrilata,

IF no looping is required how to pass the data in import parameter ? please elaborate .Secondly i am having query regarding the tow page formate

i have two pages

Page1

Page2

I want first purchase orde ron first page of smartform and next one on page 2

But when i give condition on table 1

where i have looped on it_Final containing all the data . NExt page is displayed as blank . i have given condiotion in command as

if wa_final-flag = 'x'

Got to NExt page.

kindly help as to how to pass data and can the main window of the page1 be same as that of page2 .i.e i have made copy of main window from page1 to page2