topic Re: ABAP CDS view join condition error in Application Development and Automation Discussions

ABAP CDS view join condition error

former_member261348 — Tue, 04 Feb 2020 16:05:08 GMT

Hello,

I have issue in ABAP CDS view while joining ACCP data types.

Working on CDS views to create join with 2 tables(Eg : DKKOP join DSKOP) and gives syntax error as

'Data type conflict in a selection condition for DKKOP-BUPER'.

option is to create DB view by joining 2 tables.

I guess CAST cannot be used in the JOIN condition.

Please help me how to fix this issue.

define view ZCDS_DKKOP as select from dkkop
 join dskop
    on dkkop.koart = dskop.koart
    and dkkop.bukrs = dskop.bukrs
    and dkkop.buper = dskop.buper
     {
    dkkop.hkont
}

Thanks,

Venkat

Re: ABAP CDS view join condition error

Florian — Tue, 04 Feb 2020 18:36:45 GMT

If you do not post your coding and joins there won't be help. Either here or elsewhere.

Re: ABAP CDS view join condition error

former_member1716 — Wed, 05 Feb 2020 04:07:22 GMT

venkat.petru,

Recommend you to go through the below thread, the same issue has been discussed already in the forum.

THREAD

Regards!

Re: ABAP CDS view join condition error

Sathya_Gunasekaran — Tue, 11 Feb 2020 13:27:53 GMT

Hi,

Your code complies and works fine for me!

Sathya