Table maintainance

[Former Member]

Hi,

I am creating Custom table , i am maintaining username, G/L Accounts and it's description in the table.

I have created table maintainace for the table, but i will enter username and G/l account only in the table,

as soon as i enter g/l account, it descriptions should be picked from the standard table.

For this, how to write the code in table maintainance events .

Let me know If anybody is having an idea.

Points will be rewarded.

Regards

(YUGANDHAR.P)

[Former Member]

Creat text table for this table and ur problem will slove.

[Former Member]

Hi,

The Text description is stored in the table SKAT. For the GL account entered and the system language you can go to this table and ftech the GL Text. You can put the code in Event 01.

Regards

Saket Sharma

[vinod_vemuru2]

Hi Yugandhar,

For this u have to write the code in table maintenance events.

It is not possible to get the description as soon as u enter

the G/L account. At least u have to press enter

Check the table SKAT,TSAKR for short texts of G/L accounts

Put ur logic in appropriate event to populate the text

Thanks,

Vinod.

Edited by: Vinod Kumar Vemuru on Jun 13, 2008 7:25 PM

[Former Member]

Hi Pokala,

For the table maintenace, do the following steps.

1. Go to SE11 and enter your table name (ZTEST)(Go to change or create mode).

2. once complete your table creation than active the table, go to step 3.

3. go to the menu Utilities-->Table Maintenance Generator

4. Environment>Modification> Events.

5. Click 'New Entry Button'.

6. enter event= 21 and form name is F_hidden_fieldfil, it will propose one include name and

press enter and enter.

write your requirement in the form endform of f_hidden_fieldfill.

for example,

select ztext into ztest-ztext from ztext1 where code = ztest-code.

7. active the include which is created in step6.

Reward if found helpful.

Regards,

Boobalan Suburaj

[ThomasZloch]

You can solve this without custom events. Just create a maintenance view linking your Z-Table to SKAT via keys KTOPL, SPRAS and SAKNR and create the maintenance dialog based on this view. The account texts TXT50 will appear automatically. Make sure you define TXT50 as "read only" in the view definition.

Thomas