Updating co code & bus area from excel to database

[Former Member]

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

[Former Member]

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