I'm trying to join table BKPF with table CDHDR, the link I choose between them is OBJECTID (CDHDR) = BELNR (BKPF), but the problem is OBJECTID consists of Mandant + company code + BELNR, eg. 400+1010+BELNR, therefore Query considers this link (OBJECTID = BELNR) as illegal.
Is it possible to modify the link, so I can just use the third part of the OBJETCTID and connect it with the BELNR?