topic Insert in Database table (Is this advisable). in Application Development and Automation Discussions

Insert in Database table (Is this advisable).

Former Member — Wed, 04 Jul 2007 06:19:21 GMT

Can we insert directly in a databse table in a report?

e.g. Insert into EKPO...

IS this Advisable...Instead we go for BAPI or BDC ?

regards

Message was edited by:

Madan Gopal Sharma

Re: Insert in Database table (Is this advisable).

amit_khare — Wed, 04 Jul 2007 06:21:33 GMT

Using BAPI is more advicable then Insert.

But depends on the requirement.

Regards,

Amit

Reward all helpful replies.

Re: Insert in Database table (Is this advisable).

sridevi_p — Wed, 04 Jul 2007 06:22:53 GMT

Hi,

It is not advisable to insert directly to any SAP tables, coz there will be too many dependencies, which u may not be aware of.

Certain table updation may result in flow of data across modules.

Regards,

Sridevi

<b><i>* Pls. assign points, if useful</i></b>

Re: Insert in Database table (Is this advisable).

Former Member — Wed, 04 Jul 2007 06:25:21 GMT

Hi,

We can directly insert in the database table,but it is not advicable to directly reflect thevalues with the database...

There will not be a big problem if you did tht also..But for the standard table you dont know all the field values..So only we are concentratng the concept of internal tables

REWARD IF USEFUL

Re: Insert in Database table (Is this advisable).

Former Member — Wed, 04 Jul 2007 06:29:12 GMT

no it is ot advisable at all and u cannot make changes to SAP database table as it will ask u for the access key

regards

ravish

plz reward if useful

Re: Insert in Database table (Is this advisable).

Former Member — Wed, 04 Jul 2007 06:37:28 GMT

HI,

no it is ot advisable at all and u cannot make changes to SAP database table as it will ask u for the access key. WHEN IF U HAVE ACCESS KEY ALSO DONT INESRT DATA AS that table fields are related to so many tables which ultimately results in data inconsistency which is not advisiable.

if u wanna update a database table do it with transactions with helps in maintaining data consistency.

if helpful reward some points.

regards

Suresh.A