Auto populate values in the the database table

[former_member235717]

Hi All,

I have a requirement where user enter values in one of the ZTransaction. This will update a Ztable. So the new requirement is to add two new columns in the fields, which is completed. Now this two new fields are supposed to auto populate values based upon the key field .

The transaction code is defined with Transaction as SM30 and Default values as

Name of the screen field     value

Update                               X

VIEWNAME                      "table name which the values are updated".

Please let me know how to do this.

Thank you!!

[former_member235717]

Hi All,

I have a requirement where user enter values in one of the ZTransaction. This will update a Ztable. So the new requirement is to add two new columns in the fields, which is completed. Now this two new fields are supposed to auto populate values based upon the key field .

The transaction code is defined with Transaction as SM30 and Default values as

Name of the screen field     value

Update                               X

VIEWNAME                      "table name which the values are updated".

Please let me know how to do this.

Thank you!!

[former_member235717]

The Transaction code is the Parameter transaction

[Former Member]

Hi Swetha,

I am unsure of what you are trying to accomplish so I will make a few assumption and perhaps you can find some benefit in it.

I suppose you are trying to add new fields to a custom (Z) database table.

If so then use SE11 to add the two new columns.

After this is complete then rebuild the table maintenance by using the following path: SE11-> Utilities->Table Maintenance Generator.  (Remember to double check the Recording Routine Radio button.)

If the user needs fields automatically populated then check the following link.  It describes how to use table maintenance events.  I suppose you need to use Event 01 and Event 05.

http://help.sap.com/saphelp_nw04/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm

Good luck and reward points if helpful,

AK

Moderator message -  Asking for points is against the Forum's RoE

Message was edited by: Suhas Saha

[ThangaPrakash]

This message was moderated.