on ‎2011 Mar 16 4:50 AM
Hi,
I have a requirement in billing invoice to refer table
VBFA-vbeln = is_bil_invoice-hd_gen-bil_number AND
vbtyp_n = 'M'.
then go VBAK table VBAK vbeln = wa_vbfa-vbelv AND
auart = 'FD'.
if successful then print the Title as Proforma Invoice else just print Invoice .
My query is that while selecting data from VBFA it is taking a lot of time , how to reduce this time and secondly how to show the o/p as "Proforma Invoice" or "Invoice"
Thank You,
SB.
Request clarification before answering.
HI,
In addition to the document number and document category, you could also pass the document category of the preceding sales document VBTYP_V, while fetching data from VBFA. If there is an entry in VBAK, then you can assign your title to a variable, say "gv_title", based on the condition and pass this to the Import parameters of the Form Interface in Smartforms. If you are coding in the smartforms itself, then declare the variable in the Global data of the Global Definitions node and populate it and call it in the appropriate window.
Best Regards,
Sharmila
Edited by: Sharmila Subramanian on Mar 16, 2011 7:35 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 6 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.