Skip to Content
0
Feb 08, 2008 at 10:42 PM

SAP SQL question

12 Views

Hi,

in one of the OSS notes it is suggested to use this code:

SELECT * FROM BKPF

WHERE AWTYP = COBK-AWTYP

AND AWKEY = (COBK-REFBN + COBK-AWORG)

AND BUKRS = COBK-REFBK.

It doesn't work with error: Field "(COBK-REFBN + COBK-AWORG)" is unknown.

When I tried to use this: AWKEY CS COBK-REFBN

AND AWKEY CS COBK-AWORG it did not work either.

AWKEY(10) = COBK-REFBN did not work as well.

Do you know any other tricks to solvve this problem?

Thank you,

Vitaly