BDC

[Former Member]

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

[Former Member]

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

[Former Member]

Hi K.P,

Best way is use BDC.Its is better to never

insert/delete data from mastert tables directly.

Thanks&Regards.

Siri.

[hymavathi_oruganti]

with BDC u can just mark for deletion.

after marking, u can write

DELETE FROM <DBTAB>

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

Thanku to all

regards,

K P