10-07-2008 7:25 PM
Hi Gurus,
I have Created a Table maintainance generator for my Ztable,here my problem comes
when i want to made a new enrty in my ztable, say i seleted one cutomer through F4 help and when i press enter it should get the coresponding customer name,(my ztable has customer and name fields etc..) instead i enter customer name Manually.
how can solve this issue.
Regards,
Vijaya.
10-07-2008 7:35 PM
10-07-2008 7:35 PM
10-07-2008 8:07 PM
Thank you Vijay,
But for my requirement which event i need to select,how i need to proceed once i selected the event.
Regards,
Vijaya.
10-07-2008 8:21 PM
10-07-2008 8:33 PM
Check the following link for the available events in Table Maintenance:
http://help.sap.com/saphelp_nw2004s/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/content.htm
You can write a select statement in the event 01 to extract the customer name using the entered customer.
You can use the code mentioned by Vijay in his first reply of this post to accomplish this.
Hope this helps.
Thanks,
Vivek Myadam
10-07-2008 7:38 PM
Hi, Did you give the right reference table and fields in our table fields? if not give the correct references and regenerate your table maintainence. Thanks.
Regards,
Jey
10-07-2008 8:24 PM
Hi,
If it is a Z table..you create a module in the PAI event...and get the data and display it..
Go to SE51..Give the program...SAPL + function group name..Give the screen number..and press change..
Thanks
Naren
10-07-2008 9:29 PM
10-07-2008 9:13 PM
Hi,
i am waiting plz tell me Exactly which event i need to select and how to proceed,
i have tried with event 21,and when i write select query it is giving errors,plz suggest me with sample code how to proceed.
Regards,
Vijaya
10-07-2008 9:50 PM
Hi,
is it a Z or Y function group?...Go to SE80...give the function group..
Go to the screen...Press change...
Thanks
Naren
10-08-2008 6:55 AM
Hi,
You add/create a module for the FIELD KUNNR in PAI and implement the logic to fetch the name for the customer entered while creating entries in table.
For this goto SE80, select your function group which you used for table maintenace generator.
select the screen number under the node SCREENS
FIELD ZTEST1-ZCUSTOMER. MODULE f_populate_zname.
FIELD ZTEST1-ZNAME .
(Here ZTEST1 is the table name and ZCUSTOMER and ZNAME are the fields)
&----
*& Module F_POPULATE_ZNAME INPUT
&----
text
----
module F_POPULATE_ZNAME input.
DATA : gv_name1 TYPE name1.
IF NOT ztest1-zcustomer IS INITIAL.
SELECT SINGLE name1 FROM kna1
INTO gv_name1
WHERE kunnr = ztest1-zcustomer.
ztest1-zname = gv_name1.
ENDIF.
endmodule. " F_POPULATE_ZNAME INPUT
With Regards,
Dwarakanath.S
Edited by: Dwarakanath Sankarayogi on Oct 8, 2008 7:59 AM
10-10-2008 7:24 PM