Vendor Report without classification.

[Former Member]

Hi Experts,

My client wants a report to display all those vendors for whom the classification data is not maintained.

Please help..

Thanks in advance

[former_member202528 · Accepted solution]

I believe classification is just an add-on functionality to Vendor, but not vendor master record.

We can view changes to vendor master record via Environment-->Changes and that too no classification is available.

BR,

Krishna

[Former Member · Accepted solution]

Hi,

Thanks for your reply, I agreed with you, however is there any particular transaction for this?,

because we want the list of many vendors for the same.

Thanks

[former_member202528 · Accepted solution]

I guess no report...however u can check the table INOB with object ID from CDPOS for corresponding vendor IDs

[JL23 · Accepted solution]

I dont know a transaction that shows it directly.

I would execute CL30N to get a list of all vendor that have a class assignment.

then I would download all vendor numbers from table LFA1

And then I would compare both e.g. in MS ACCESS or in Excel with VLOOKUP to see which vendor is without classification.

If recurring requirement, then a small ABAP report would do the job.

[Former Member · Accepted solution]

Hello,

Similarly we can use transaction CL6BN also. Enter Class, Class type as 010 and object table 'LFA1'.

Regards,

Milind