topic Regarding DATABASE table updation when transaction in Application Development and Automation Discussions

Regarding DATABASE table updation when transaction

former_member242166 — Mon, 03 Dec 2012 11:03:31 GMT

Hi experts,

I Want to know how the Database tables are updated while transaction. i.e From which transaction screen fields are related with corresponding database tables.

Example

Consider the table J_1IEXCDTL . In that table when the TRNTYP field is inserted , at which transaction screen (particular screen field) .

I asked the table J_1IEXCDTL for example only. Is there any generic method or way for finding from which screen field the database table (table field) is updated.

Thanks and Regards,

Linganathan.K

Re: Regarding DATABASE table updation when transaction

Former Member — Mon, 03 Dec 2012 11:24:01 GMT

Hi,

press on where used list icon . And select programs and screens. You will come to know in which program or screen these fields are used.

thanks.

Re: Regarding DATABASE table updation when transaction

former_member242166 — Mon, 03 Dec 2012 11:47:39 GMT

Dear Aswatha Narayana ,

Thanks for your response. I want from Front-end i.e Screen field.

Example:

in FI01 Tcode ( Create Bank screen).

Bank name is stored to BNKA-banka field.

BNKA- Table name.

Banka-field name.

I dont want program name. I want from which transaction from end.

I want like this for all database table fields.

Thanks and Regards,

Linganathan.K

Re: Regarding DATABASE table updation when transaction

Former Member — Mon, 03 Dec 2012 11:56:52 GMT

Hi,

The transactions which update standard tables mostly will be in same package.

Click on button inside any table for which you want to find the Tcode which updates this table.

Now in the same package transactions section search for transaction related to your table.

Hey this is the way which i know.. there may be better ways than this ... hope somebody gives better solution than this.

thanks.