Hi @douglas.henri,

I'm not sure what format "T056P"."DATAB" has, but in case it is a Unix timestamp ((milli)seconds since Epoch time): I think you are doing good by using the ADD_MILLIS operator.

It looks like however your column is formatted as string and not as integer. Therefore you need to convert this, in PQL this would be:

ADD_MILLIS({t 0 }, TO_INT("T056P"."DATAB")).

Let me know if this works.

Hi Jan-peter, Thank's for the response, I tested it here and this was my results:

I don't understand why the date comes in this format (79808971), could it be something specific in this table T

tks again for help

Hi Douglas,

T056P.DATAB is stored as epoch timestamp.

You can convert it to a timestamp in a similar way as it was / is done with TCURR table which is used for currency conversion e.g.:

CAST(RIGHT('00000000'|| CAST((99999999-DATAB) AS VARCHAR(10)),8) || ' ' || '00:00:00' AS DATETIME)

BR

Dennis

Hello Dennis, veryyy thank's, it worked out !

Have nice day !

Perfect.

You're welcome.

Have a great day.

Hi Dennis,can you clear my doubts?

I needed to take this table to BSEG level, could you tell me how to do this? The only key column is MANDT. It's possible?

In PQL I could BIND it, but I can't to connect it in my model

Hi douglas,

honest answer: I don't know how to link T056P (Reference interest rate) with BSEG.

I am not aware of any direct link by using REFERENCE field from T056P with BSEG.

What I can tell you is that using MANDT will not work as you will not have any unique identifier and DM load will crash due to duplicates.

BR

Dennis

Tks for help Dennis