I want to do some master data check. For certain fields check if they are used within 3 years (we have 3 year of data in Celonis).
E.g. I want to mark all Incoterms from the master table (TINC) which are not used in EKKO.INCO1.
First problem was the join of the mastertable. We did it via
EKPO <-> T001 <-> TINC
With case key SID, BUKRS and MANDT. Dont know if there is a better way.
The idea was now to store the distinct values of EKKO.INC01 in a static variable
like the following (there is no parent table between TINC & EKKO)
static_var = distinct EKKO.INC01
CASE WHEN TINC.INCO1 in <%=static_var%> then ‘USED’ ELSE ‘NOT USED’ END
Any ideas how to do this?
Thanks in advance