Skip to main content
Question

Vendor Master Data Analysis

  • August 13, 2020
  • 1 reply
  • 7 views
.
Level 2
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

1 reply

C
Level 0
  • celonis.ds_se
  • Level 0
  • 68 replies
  • August 26, 2020
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


Community Code of ConductAccessibility statement