Regarding DATABASE table updation when transaction

[former_member242166]

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

[Former Member]

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.

[former_member242166]

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

[Former Member]

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.