Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Karthe,
Is the slow performance in the SELECT on BSEG, or is it in the Smart Form function module? That seems like a well-formed SELECT on BSEG (except for the SELECT * previously mentioned), so I would suspect the Smart Form may be the problem. If it turns out that the SELECT on BSEG is the problem, ask your DBA to rebuild the index on BSEG and see if that helps.
Cheers,
Terry
| | | ---------------Original Message---------------
From: karthe shan
Sent: Tuesday, August 02, 2011 12:35 AM
Subject: Performance Issue - for bank voucher printing
Hi everyone,
1) while taking the first printout alone it taking more time.
2) the second ones are coming quickly.
I have used smart form in my z program as a function.
This is my code.
SELECT * FROM BSEG INTO TABLE IT_BSEG WHERE bukrs = '1000' and BELNR EQ NO and gjahr eq year and SHKZG eq 'H'.
CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'
EXPORTING
FORMNAME = 'ZFI_VOUCHERB'
* VARIANT = ' '
* DIRECT_CALL = ' '
IMPORTING
FM_NAME = V_FMNAME
* 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 V_FMNAME
EXPORTING
TYPE = TYPE
YEAR = year
TABLES
IT_BSEG = IT_BSEG.
IF SY-SUBRC <> 0.
ENDIF.
Help me with the same,
Regards
Karthe |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  TerryB
SAP ABAP Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight  _.____.__ |
