on 07-01-2009 5:58 AM
i have created a smart form for table VBRP whenever i m executing it,it is not showing data in the printed form but shows all logo address printed person name field name but not field data.. i have declared itab in form interface n and wa in global declaration .. i have done loop in table field in main window after declaring header in main area.. when i used debug mode it is showing is not filling up in se 38 kindly help me out
regards
deejay
in smartform table DATA-----> Give the Internal Table Name as the condition base
by
imuthu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
in structure and selct statement you are not declared vbeln .
tables:vbrp.
TYPES: BEGIN OF YSTR_VBRP,
vbeln like vbrp-vbeln,
POSNR LIKE VBRP-POSNR,
MATNR LIKE VBRP-MATNR,
FKIMG LIKE VBRP-FKIMG,
VRKME LIKE VBRP-VRKME,
NETWR LIKE VBRP-NETWR,
END OF YSTR_VBRP.
PARAMETERS:INVOICE like VBRP-VBELN.
DATA: v_NAME TYPE RS38L_FNAM.
DATA: IT_VBRP TYPE TABLE OF YSTR_VBRP,
WA_VBRP TYPE YSTR_VBRP.
START-OF-SELECTION.
SELECT vbeln POSNR MATNR FKIMG VRKME NETWR FROM VBRP INTO TABLE IT_VBRP WHERE VBELN eq invoice.
Edited by: dharma raj on Jul 1, 2009 4:56 PM
Edited by: dharma raj on Jul 1, 2009 5:00 PM
Edited by: dharma raj on Jul 1, 2009 5:01 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In smartform while you are using table you must also have a structure. And in the loop you must assign values to this structure and you can only write values from structure. If you directly write table parameters like itab-field it won't be processed. It's also possible to debug smartforms table just put a code after one of fields and put break user in it to make sure if your table looped correctly.
hi
in smart form u have declare Internal table and work area
In form interface>tables tab>itab type YSTR_VBRP_tt(in se11 create a same structure and table type)
Global definition-->global data -->wa type YSTR_VBRP
Global definition-->Currency\Quant fields --> specift if u r using curr or quab
In table-->data tab -->tick the check box interna Table
specify the itab into wa.
utilities-->Field list on/off
A screen will come on left side
in that global dat select WA fields
Those procedures are clearly mentioned in the previous i mentioned link
Thanks
Edited by: dharma raj on Jul 1, 2009 5:56 PM
form interface ->tables---> it_vbrp like ystr_vbrp.
global defi.-----> global data ---> wa_vbrp type ystr_vbrp.
main > table created--> data ---> loop declared (it_vbrp into wa_vbrp)
main -> main area -
vbeln isto be taken in selection screen n depending on that .. posnr matnr fkimg and other fields will be displayed
pls help me
thank u in advance
Are you sure table is filled in your program. Put a breakpoint before calling smartform function and check if the table filled.
Check the display and where conditions in the smartform table. Try to write constant characters like "&wa-posnr& test1" to make sure if your table looping or not.
Edited by: Gungor Ozcelebi on Jul 1, 2009 2:22 PM
Edited by: Gungor Ozcelebi on Jul 1, 2009 2:23 PM
hi
Check this
In this structure (ystr_vbrp) u have created in programe itself or in se11 ?
In debugging itab in pgm data will populated or not?
and in smartform chek the data passing or not put a break point .....
Try to give correct (valide) input in vbeln.
Edited by: dharma raj on Jul 1, 2009 6:09 PM
Hi Deejay,
Check your select statement in SE38, whether the select statement fetches the data from VBRP table. If possible send ur code snippet for more clarity.
Regards,
Vanisree G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
&----
*& Report ZIBP1 *
*& *
&----
*& *
*& *
&----
REPORT ZIBP1 .
tables:vbrp.
TYPES: BEGIN OF YSTR_VBRP,
POSNR LIKE VBRP-POSNR,
MATNR LIKE VBRP-MATNR,
FKIMG LIKE VBRP-FKIMG,
VRKME LIKE VBRP-VRKME,
NETWR LIKE VBRP-NETWR,
END OF YSTR_VBRP.
PARAMETERS: INVOICE LIKE VBRP-VBELN.
*
*DATA: v_NAME TYPE RS38L_FNAM.
DATA: IT_VBRP TYPE TABLE OF YSTR_VBRP,
WA_VBRP TYPE YSTR_VBRP.
******DATA: IT_VBRP TYPE TABLE OF VBRP with header line,
WA_VBRP TYPE VBRP.
*SELECT-OPTIONS: invoice for vbeln.
START-OF-SELECTION.
*
SELECT POSNR MATNR FKIMG VRKME NETWR
FROM VBRP INTO
TABLE IT_VBRP
WHERE
VBELN eq invoice.
*******SELECT *
*******FROM VBRP INTO
*******it_vbrp
*******WHERE
*******VBELN eq invoice.
*******endselect.
*******
CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'
EXPORTING
FORMNAME = 'zibm'
VARIANT = ' '
DIRECT_CALL = ' '
IMPORTING
FM_NAME = v_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 '/1BCDWB/SF00000024'
EXPORTING
ARCHIVE_INDEX =
ARCHIVE_INDEX_TAB =
ARCHIVE_PARAMETERS =
CONTROL_PARAMETERS =
MAIL_APPL_OBJ =
MAIL_RECIPIENT =
MAIL_SENDER =
OUTPUT_OPTIONS =
USER_SETTINGS = 'X'
IT_VBRP = it_vbrp
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.
hi
In se38 Please check the program.check the select command and based on the condition the data is there or not check it.
check the link for step by step procedure for smartform
https://wiki.sdn.sap.com/wiki/display/Snippets/Printing+Invoices
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.