Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Updating co code & bus area from excel to database

Go to solution
Former Member

‎05-02-2006 11:33 AM

0 Kudos

hi friends,

i m uploading co codes & bus area from the excel sheets to the database tables. now i want that before uploading into database tables it should check if Co code exists in table T001 & bus area exists in TGSB, if it does not exists then that particular value should be neglected & others should be updated.

Plz help me in tis as i m not getting the correct way.

reg,

nishu

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎05-02-2006 11:40 AM

0 Kudos

Hi,

You should <b>never ever </b> update the database tables directly, that too the config / base master tables like the company code / business area.

Find a BAPI function for the same, or write a BDC which will run the transaction.

Then the BAPI / BDc will take care of the validations also.

Regards,

Ravi

Note : Please mark the helpful answers

1 REPLY 1

Go to solution
Former Member

‎05-02-2006 11:40 AM

0 Kudos

Hi,

You should <b>never ever </b> update the database tables directly, that too the config / base master tables like the company code / business area.

Find a BAPI function for the same, or write a BDC which will run the transaction.

Then the BAPI / BDc will take care of the validations also.

Regards,

Ravi

Note : Please mark the helpful answers