I habe to filter the current E-Mail adress out of the table in the SAP (even after it changed to a new one).

Hi Nihat,

You should include an ORDER BY statement in your formula, otherwise it won't know what the last record is for your use case, currently if the last record in the table is the "old record", you'll get this value. I suggest using the valid-from field.

Cheers,

Lucas

I thought about that, but the problem is that I don't get any outputs if I use order by with the valid-form field as:

PU_LAST(DOMAIN_TABLE("ADR6"."SMTP_ADDR"), "ADR6"."SMTP_ADDR", order by "ADR6"."VALID_FROM")

So it's very strange bc PU_Last should give me the right output..

The output with the order by is:

Another problem is that when I use only the code like: "ADR6"."STMP_ADDR"

I only get the old E-mail-Adress and not also the updated one. Isn't that a problem?

Maybe the Data Model isn't correct..

That sounds like a problem indeed, if there is just old data in the table the PU function won't solve anything. I'd check if the data is available in data integration, if so check at which stage the new record gets lost.

I did more research and made a table with:

1. Row : "LFA1"."LIFNR"
2. Row: PU_LAST(DOMAIN_TABLE("ADR6"."_CELONIS_CHANGE_DATE"), "ADR6"."_CELONIS_CHANGE_DATE")
3. Row: "ADR6"."STMP_ADDR

But I still only see the old E-mail adress. Logicalwise it should output the last change made for the E-mail.. So I asume that the problem is bc of the record connection.

FIrst of all, does the new email address appear in your analysis at all? Second, to me your PU statement doesn't make sense to me, why don't you use PU_LAST(LFA1,"ADR6"."STMP_ADDR" ORDER BY "ADR6"."VALID_FROM" ASC)?

I would also recommend checking some examples on PU functions in the documentation, good luck!

Thanks. My PU-Function should be correct like:

PU_LAST(DOMAIN_TABLE("ADR6"."SMTP_ADDR"), "ADR6"."SMTP_ADDR", order by "ADR6"."VALID_FROM")

But I've found out that there is a problem with the backend. Bc we don't even have the input of the new adress. So we'll try to fix it. Still thank you for your time.

the DOMAIN_TABLE will contain all unique values of the specified column, so if you use that your PU function won't get you the right insight according to my understanding of your reqest. That is why I suggested LFA1 (so you'll get the last email address per vendor master record)

I tried that out. The problem is really on the backend. The connection doesn't deliver the updated input. I can't read the data of "VALID_FROM" it's empty (bc of the connection to the SAP). I'm trying to fix it. But I'm glad that I've found the real problem. Thank you for your help and good insights.