on 05-06-2008 6:54 AM
hi to all
plz send me a sample program in smartforms which has data taken from two or more tables.plz i need it very urgent.
HI
Can i hav the step by step procedure in creation of the smartform
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
see the below example
DATA: ITAB_T001 like t001 OCCURS 0 with header line,
ITAB_EKKO LIKE EKKO OCCURS 0 WITH HEADER LINE,
ITAB_EKpO LIKE EKKO OCCURS 0 WITH HEADER LINE.
SELECT-OPTIONS: P_O_NO FOR EKKO-EBELN NO INTERVALS.
SELECT ebeln aedat bukrs lifnr FROM EKKO INTO CORRESPONDING FIELDS OF TABLE ITAB_EKKO WHERE EBELN IN P_O_NO.
select butxt ort01 from t001 into corresponding fields of itab_t001 for all entries in itab_ekko where bukrs = itab_ekko-bukrs.
endselect.
append itab_t001.
SELECT EBELP MATNR TXZ01 MENGE NETPR NETWR FROM EKPO INTO CORRESPONDING FIELDS OF TABLE ITAB_EKPO UP TO 5 ROWS FOR ALL ENTRIES IN ITAB_EKKO WHERE EBELN = ITAB_EKKO-EBELN.
call the function module
CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'
EXPORTING
FORMNAME = specify your form name here
IMPORTING
FM_NAME = FM_NAME .
CALL FUNCTION FM_NAME.
reward if useful.
thanks and regards.
Edited by: hema bobbili on May 6, 2008 9:04 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please refer this link:
http://www.saptechnical.com/Tutorials/Smartforms/SFMain.htm
1.If u need refer this:LB_BIL_INVOICE (driver for invoice)
Regards,
Shiva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.