2014 Aug 11 11:27 AM
Dear experts,
I hv created a TMC for customize table with field lifnr and name1. I am getting F4 for lifnr field and the requirement is
when i enter vendor code and press enter, the name field should be populated automatically from LFA1 table.
When I go in edit mode in TMC, it ask for access key. Can anyone guide me how to resolve above???
Regards,
Jasapl
2014 Aug 11 12:03 PM
Dear Jaspal,
To fetch the NAME1 automatically, you need to write the logic in the Table Maintenance Generator.
Goto -> Utilities -> Table Maintenance Generator.
Inside TMG,
Goto -> Environment -> Modification -> Events.
Click -> New Entries. Create a Form Routine.
Inside the Form Routine,
Write the select Statement as,
Select single name1 from Lfa1
into name1.
save activate and execute the TMG,
2014 Aug 11 11:41 AM
Hi,
i dont know what you want to know... in headline you ask for table maintenance generator. what has your issue to do with this?
as long as you defined your CU-Table as z-Table, you should be able to edit without access key...
Better add some screenshots, what you want to do and what is not working.
regards
Stefan Seeburger
2014 Aug 11 11:47 AM
You will not be able to change anything of the standard tables. However you may try to create a maintenance view starting with 'Z' and create a TMG against the same and try to do what you want.
2014 Aug 11 11:51 AM
hi,
Thanks for your reply.
I am working with Ztable and hv created a TMC for the same.
regards,
Jaspal
2014 Aug 11 11:50 AM
The reason you are being asked for an access key is because you are trying to modify sap standard dictionary object. I would not advise this... ever.
2014 Aug 11 12:03 PM
Dear Jaspal,
To fetch the NAME1 automatically, you need to write the logic in the Table Maintenance Generator.
Goto -> Utilities -> Table Maintenance Generator.
Inside TMG,
Goto -> Environment -> Modification -> Events.
Click -> New Entries. Create a Form Routine.
Inside the Form Routine,
Write the select Statement as,
Select single name1 from Lfa1
into name1.
save activate and execute the TMG,
2014 Aug 11 12:25 PM
Hi Jaspal,
Whenever you create a Table maintenance generator (TMG) for any table, internally a program/report will be generated by the system. Even though it is generated for the custom table system will not give access to change the code.
If ever you want to add any validations the SAP System has provided some Events in TMG. Please refere the following link to know how to handle the Events in TMG
http://wiki.scn.sap.com/wiki/x/EQGSBQ
Regards,
Vijay