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
Page 1 / 1
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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.