ABAP CDS view join condition error

[former_member261348]

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

[former_member261348]

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

[Florian]

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

[former_member1716]

venkat.petru,

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

THREAD

Regards!

[Sathya_Gunasekaran]

Hi,

Your code complies and works fine for me!

Sathya