topic Re: urgent smartforms!!!!!! in Application Development and Automation Discussions

urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 05:41:28 GMT

hi,

i hav a table called zborrower which contains 5 fields , one of the field is :"date_of_return" ....i need to display the details of the borrower based on the date range for date_of_return in the smartform using select options.......how could i do this??.......if there is any other method other than the select options do let me knw.......thank you

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:14:39 GMT

Hi Reshma,

As per my understanding you wud be triggering the smartform fro a driver program. In that case Select options is the most efficient way to select data into an internal table which you can pass to the SF interface.

Let me know if you need any more info else pl reward points.

Regards.

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:15:38 GMT

write a driver program and specify ur select options and call ur smart fom in that driver program.I think this would be helpful.

Re: urgent smartforms!!!!!!

former_member189629 — Mon, 24 Sep 2007 06:16:45 GMT

Reshma,

- Use SELECT-OPTIONS or RANGES for date range

- Do a select to ur Z table & populate your itab

- Send it to the Smartform & display (I hope u know how to do it: send it in the tables option of your smartform FM)

- Loop thru the itab in ur smartform

- Display data

Reward points for useful Answers

Regards

Karthik

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:31:20 GMT

i actually hav a report that asks for the date range and displays the reocord based on this date range ...this report conatins a push button "smartform" ...which shud display the same records as that of the report in the smartform

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:32:14 GMT

Re: urgent smartforms!!!!!!

former_member189629 — Mon, 24 Sep 2007 06:34:42 GMT

Do u wanna know how u generate a smartform once that button is clicked?

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:36:43 GMT

i want to knw how to display the record that is displayed wen i execute the report in the smartform.

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:41:57 GMT

hi reshma

pls as follow

TABLES: MKPF.

DATA: FM_NAME TYPE RS38L_FNAM.

DATA: BEGIN OF INT_MKPF OCCURS 0.

INCLUDE STRUCTURE MKPF.

DATA: END OF INT_MKPF.

SELECT-OPTIONS S_MBLNR FOR MKPF-MBLNR MEMORY ID 001.

At the end of your program.
Passing data to SMARTFORMS

START-OF-SELECTION.

PERFORM GET_DATA.

END-OF-SELECTION.

PERFORM TEST_SMARTFORMS USING 'ZSAMP_SSMART' .

&----

*& Form GET_DATA

&----

text

----

--> p1 text
<-- p2 text

----

form GET_DATA .

CLEAR : INT_MKPF , INT_MKPF[] .

SELECT * FROM MKPF WHERE MBLNR IN S_MBLNR.

MOVE-CORRESPONDING MKPF TO INT_MKPF.

APPEND INT_MKPF.

ENDSELECT.

endform. " GET_DATA

&----

*& Form TEST_SMARTFORMS

&----

text

----

-->P_0036 text

----

form TEST_SMARTFORMS using value(p_0036).

CLEAR FM_NAME .

CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'

EXPORTING

FORMNAME = 'ZSAMP_SSMART'

IMPORTING

FM_NAME = FM_NAME

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.

CALL FUNCTION FM_NAME

TABLES

INT_MKPF = INT_MKPF

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.

endform. " TEST_SMARTFORMS

Re: urgent smartforms!!!!!!

former_member189629 — Mon, 24 Sep 2007 06:43:45 GMT

I assume the report output is from a single itab and the there is code already to generate the smartform.

Now pass this itab in the tables section of the Smartform Function Module,

Declare a workarea in the Smartform

Loop the itab into the WA & Display data.

That's it. Lemme know if u need more info...

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 06:56:39 GMT

do i hav to declare that itab in the form interface of the smartform........this itab is of type structure ........how could i do this??

Re: urgent smartforms!!!!!!

former_member189629 — Mon, 24 Sep 2007 06:59:52 GMT

yes, u will have to declare int he form interface. Wat did u mean by TYPE Structure? that's how it will be... Also declare a WA with the same type. In the main window, loop the itab into the work area. Create a report-like template and display your WA fields...

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:01:56 GMT

do as follow

use ur report to fill the itab

and then call the smartform by passing that itab to smartform under TABLES

then create a structure in ddic and give the same fields as it is in ur itab.

now open ur smartform

in the interface->tables->

write itab like structure name u made

then u can use this itab.

the point is

if u r passing an itab to ur smartform

u hav to create a structure in ddic

and then declare an itab with type structure same as structure in ddic

tell me if u want more

reward if useful

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:03:46 GMT

Hi,

First get the data based on ur select-option in the driver program and put it into internal table ( itab1 type zborrower).

after fetching the data into itab1, then in the FORM INTERFACE of SMartform ,

Under TABLES tab, decalre as ITAB like ZBORROWER.

Now inthe Driver Program " call FM SSF_Function_module_name"

after the Call FM 'FMOD" <----Gnerated by smartform.

In this pass ur itab1 (of driver prog) to ITAB (of smartyform).

Rvert back if any issues,

Reward if helpful.

Regards,

Naveen

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:04:19 GMT

TYPES : BEGIN OF struct,

bookid TYPE zbooks-bookid,

bname TYPE zbooks-bname,

bmodule TYPE zbooks-bmodule,

copies TYPE zbooks-copies,

bavailable TYPE zbooks-bavailable,

borrowername TYPE zborrower-borrowername,

dateofborrower TYPE zborrower-dateofborrower,

dateofreturn TYPE zborrower-dateofreturn,

END OF struct.

DATA : itab TYPE TABLE OF struct.

DATA : wa LIKE LINE OF itab.

this is the structure...

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:06:45 GMT

pls send ur code first.after then all r help u

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:09:49 GMT

did u try my idea??crating structure in ddic and then using it in smartform

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:09:59 GMT

&----

*& Report ZREP

&----

REPORT zrep NO STANDARD PAGE HEADING LINE-SIZE 200.

TABLES : zbooks,zborrower.

TYPES : BEGIN OF struct,

bookid TYPE zbooks-bookid,

bname TYPE zbooks-bname,

bmodule TYPE zbooks-bmodule,

copies TYPE zbooks-copies,

bavailable TYPE zbooks-bavailable,

borrowername TYPE zborrower-borrowername,

dateofborrower TYPE zborrower-dateofborrower,

dateofreturn TYPE zborrower-dateofreturn,

END OF struct.

DATA : itab TYPE TABLE OF struct.

DATA : wa LIKE LINE OF itab.

SELECT-OPTIONS : s_dob FOR zborrower-dateofborrower.

PARAMETERS : p_bname TYPE zbooks-bname.

START-OF-SELECTION.

SET PF-STATUS 'SMARTFORMS'.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE itab

FROM zbooks AS a

INNER JOIN zborrower AS b ON a_{bookid = b}bookid

WHERE b~dateofborrower IN s_dob

AND a~bname = p_bname.

LOOP AT itab INTO wa.

WRITE : /10 sy-vline,

15 wa-bookid COLOR 1 INTENSIFIED ON,25 sy-vline,

26 wa-bname COLOR 2 INTENSIFIED OFF,51 sy-vline,

52 wa-borrowername COLOR 4 INTENSIFIED OFF ,77 sy-vline,

78 wa-dateofborrower COLOR 7 INTENSIFIED OFF,95 sy-vline,

96 wa-dateofreturn COLOR 1 INTENSIFIED OFF ,120 sy-vline.

ENDLOOP.

WRITE:/10 sy-uline(111).

AT USER-COMMAND.

CASE sy-ucomm.

WHEN 'SMARTFORM'.

CALL FUNCTION '/1BCDWB/SF00000231'

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.

ENDCASE.

TOP-OF-PAGE.

WRITE: /10 sy-uline(111),

/10 sy-vline ,15 'BOOK ID' COLOR 1 INTENSIFIED OFF,

25 sy-vline, 26 'BOOK NAME' COLOR 2 INTENSIFIED OFF,

51 sy-vline, 52 'BORROWER NAME' COLOR 4 INTENSIFIED OFF,

77 sy-vline, 78 'DATE OF BORROWER' COLOR 7 INTENSIFIED OFF,

95 sy-vline, 96 'DATE OF RETURN' COLOR 1 INTENSIFIED OFF,

120 sy-vline.

WRITE:/10 sy-uline(111).

END-OF-PAGE.

END-OF-SELECTION.

WRITE:/'Current Date:' COLOR 3 INTENSIFIED OFF,sy-datum.

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:15:26 GMT

CALL FUNCTION '/1BCDWB/SF00000231'

EXPORTING
ARCHIVE_INDEX =
ARCHIVE_INDEX_TAB =
ARCHIVE_PARAMETERS =
CONTROL_PARAMETERS =
MAIL_APPL_OBJ =
MAIL_RECIPIENT =
MAIL_SENDER =
OUTPUT_OPTIONS =
USER_SETTINGS = 'X'

<b>TABLES

ITAB = ITAB</b>

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

create same structrue like itab in ddic and then

declare an itab wid that strucute

Re: urgent smartforms!!!!!!

Former Member — Mon, 24 Sep 2007 07:16:17 GMT

hi reshma

first u create 1 smartform goto smartform

and after then u call

AT USER-COMMAND.

CASE sy-ucomm.

WHEN 'SMARTFORM'.

CLEAR FM_NAME .

CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'

EXPORTING

FORMNAME = 'ZSAMP_SSMART'

IMPORTING

FM_NAME = FM_NAME

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.

CALL FUNCTION FM_NAME

TABLES

INT_MKPF = INT_MKPF

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.

so procees like this .

use the this functiom nodule

it will get display in smartform.

regards

kk.