Vendor Master Data Analysis

Hi everyone!
I would like to build an analysis focused on the vendor master data
I would like to show the vendors who are NOT flagged for deletion but at the same time had NO activity in the last 24 months (no invoices)
Any ideas how to pt together this data?

Thank you very much
Tatiana

Hi Tatiana,

what you could do is filter on the criteria if there was an Invoice receipt of the vendors in the last 2 Years.

For example, you could create a OLAP with the Vendor Name for example as a Dimension to show all Vendors:

“LFA1.NAME1”

Then you need the following component filter to get only the ones which are fulfilling the criteria:

FILTER “LFA1”.“LOEVM” NOT IN (‘X’);
FILTER EKBE.VGABE NOT IN (‘2’) AND YEAR(EKBE.BUDAT) > 2018;

The first one is your deletion flag and the second one filters on no invoice receipt in the last 2 Years

Best regards,

Data Science Team