List of Active Vendors

[Former Member]

Hi ,

Is there any table or report where in I can get the details of all the Vendors that are active based on the time criterion I specify . I know we can get it from the table LFB1 but there is nothing to check the active status . Any help on this would be appreciated.

Regards,

Kalyan

[former_member183819]

Hi

BUT000 table XBLCK field to block the vendor in EBP. so you can extract report from the table.

Moreover you can go web -Administartor->Monitor business partner -> Status select LOCKED.

regards

Muthu

[Former Member]

Hi,

I had to get the extract from R/3 and not SRM. I was able to do so by extracting data from the logical database for vendors in the transaction SQVI.

Thanks all for your valuable time.

Regards,

Kalya

[Former Member]

hey hai,

can you guide me how you did?

Thanks,

Ravi