SAP Purchase to Pay Accelerator Transformation Error

Hello,

This is SeungHyun Choi.

I recently used the Purchase-to-Pay accelerator from ARIS Gallery, and I encountered the same error again, especially during the transformation step.

The error message says:

"The column names of transformation step 'P2P.ACT_PO' are not unique. 'C.END_TIME' is used more than once."

I have attached the full transformation script (as shown in the image).

===================================================================

select 

-- Activity name

CASE

    WHEN trim(A.BSTYP) = 'F' AND trim(A.RETPO) = '' THEN 'Create purchase order item'

    WHEN trim(A.BSTYP) = 'F' AND trim(A.RETPO) = 'X' THEN 'Create returns order item'

    WHEN trim(A.BSTYP) = 'L' THEN 'Create scheduling agreement'

END AS ACTIVITY_NAME,

--Activity key

CONCAT ("ID#",trim(A.EBELN),"-",trim(A.EBELP)) as ACTIVITY_KEY,

-- Timestamp

CASE 

    WHEN trim(B.VALUE_OLD) is null AND C.END_TIME is not null

        AND to_timestamp(concat(trim(A.AEDAT),'000100'),'yyyyMMddHHmmss') > C.END_TIME

            THEN to_timestamp(concat(trim(A.AEDAT),'000100'),'yyyyMMddHHmmss') 

    WHEN trim(B.VALUE_OLD) is null AND C.END_TIME is not null

        AND to_timestamp(concat(trim(A.AEDAT),'000100'),'yyyyMMddHHmmss') < C.END_TIME       

            THEN C.END_TIME 

    WHEN trim(B.VALUE_OLD) is not null AND C.END_TIME is not null

        AND to_timestamp(concat(trim(B.VALUE_OLD),'000100'),'yyyyMMddHHmmss') < C.END_TIME

            THEN C.END_TIME        

    WHEN trim(B.VALUE_OLD) is not null AND C.END_TIME is not null

        AND to_timestamp(concat(trim(B.VALUE_OLD),'000100'),'yyyyMMddHHmmss') > C.END_TIME        

            THEN to_timestamp(concat(trim(B.VALUE_OLD),'000100'),'yyyyMMddHHmmss')

    WHEN trim(B.VALUE_OLD) is null AND C.END_TIME is null    

        THEN to_timestamp(concat(trim(A.AEDAT),'000100'),'yyyyMMddHHmmss')  

    WHEN trim(B.VALUE_OLD) is not null AND C.END_TIME is null     

        THEN to_timestamp(concat(trim(B.VALUE_OLD),'000100'),'yyyyMMddHHmmss')                                 

END as END_TIME,
 

--Link to process

CASE 

    WHEN trim(A.BANFN) IS NOT null AND trim(A.BANFN) != '' THEN CONCAT ("ID#",trim(A.BANFN),"-",trim(A.BNFPO)) ELSE null

END AS LINK_ID
 

from `PO.EKPO` as A

left join `P2P.TRANSFORM_EKPO_AEDAT` as B on trim(A.EBELN) = trim(B.OBJECTID)  AND trim(A.EBELP) = trim(B.TABKEY)

left join `P2P.ACT_PR_CHANGE` as C on concat ("ID#",trim(A.BANFN),"-",trim(A.BNFPO)) = C.LINK_ID and C.ACTIVITY_NAME = 'Release PR item'

=======================================================================================

I couldn’t find any obvious issues in it. If anyone could help me identify the problem, I would greatly appreciate it.

Thank you in advance.

Best regards,
SeungHyun Choi