topic Re: Table Maintainance Problem in Application Development and Automation Discussions

Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 18:25:09 GMT

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.

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 18:35:07 GMT

you have to use the events

check the thread

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 18:38:18 GMT

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

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 19:07:54 GMT

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.

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 19:21:26 GMT

i think you can use event 21 , to fill hidden fields

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 19:24:18 GMT

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

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 19:33:46 GMT

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

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 20:13:59 GMT

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

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 20:29:19 GMT

Naren,

it is asking for access Key.

Regards,

Vijaya.

Re: Table Maintainance Problem

Former Member — Tue, 07 Oct 2008 20:50:47 GMT

Hi,

is it a Z or Y function group?...Go to SE80...give the function group..

Go to the screen...Press change...

Thanks

Naren

Re: Table Maintainance Problem

Former Member — Wed, 08 Oct 2008 05:55:53 GMT

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

Re: Table Maintainance Problem

Former Member — Fri, 10 Oct 2008 18:24:10 GMT

Requirement Changed

But any give solutions if you get.