Skip to Content
0
Jul 31, 2023 at 01:36 PM

Signavio PI - Issue convertion date

221 Views Last edit Jul 31, 2023 at 03:21 PM 2 rev

Hello everybody,

We are working with Signavio PI and we have a problem with date conversion. We use the same syntax to convert the date in another client but in this one we have some problems. For context, we extract the data using an ABAP extractor in the SAP client. The return is the tables in CSV format.

Below is the syntax:

SELECT

BELNR,

CPUDT,

CPUTM,

CAST(parse_datetime((BKPF.cpudt||' '||BKPF.cputm), 'yyyyMMDD HHmmSS') AS TIMESTAMP) AS "CPUDT_TRANSFORMADO"

FROM BKPF

WHERE AWKEY = '51071021632022'

Return:

BELNR - CPUDT - CPUTM - CPUDT_TRANSFORMADO

5107102163 - 20221230 - 133625 - 2022-01-30 13:36:00.250

The issue is that the trasnformed CPUDT is not the one that we need.

Thanks, best regards.