topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Tue, 24 Jan 2006 11:05:15 GMT

Hi all,

How can we delete 10 vendors from database?

can we use BDC or directly from database tables?

Or any other method can we follow?

Thanks in advance,

K P

Re: BDC

Former Member — Tue, 24 Jan 2006 11:07:25 GMT

First of all to delete vendors from database you will need archiving program . With BDC of XK02 you can only mark vendor for deletion ( LFA1-LOEVM ) but not delete the lines from LFA1 .

For archiving the tcode is SARA and object for vendor is FI_ACCPAYB.

Cheers.

Sanjay

Re: BDC

Former Member — Tue, 24 Jan 2006 11:08:27 GMT

Hi K.P,

Best way is use BDC.Its is better to never

insert/delete data from mastert tables directly.

Thanks&Regards.

Siri.

Re: BDC

hymavathi_oruganti — Tue, 24 Jan 2006 11:08:40 GMT

with BDC u can just mark for deletion.

after marking, u can write

DELETE FROM <DBTAB>

Re: BDC

Former Member — Tue, 24 Jan 2006 11:09:13 GMT

Use this bapi,

BAPI_VENDOR_DELETE

This BAPI sets Deletion Indicator Online for Vendor Set the delete indicator online for the vendor to be transferred.

Re: BDC

Former Member — Tue, 24 Jan 2006 11:12:40 GMT

Hi,

SAP recommends that data to be inserted or

deleted from table using transacton. Write a bdc

for xk02 and mark the vendor as deleted.

Further selection take records where loevm <> 'X'.

Regards

Amole

Re: BDC

Former Member — Tue, 24 Jan 2006 11:22:28 GMT

Hi,

Thanku to all

regards,

K P