Hello engineers.
Recently I have been playing with ABAP loading into Oracle and everything has been working fine till the moment I needed to include filter on source side.
I have a bi need to filter table by specific date and wanted to use variable but nothing was loaded from SAP system. Then, I'v tried to use hardcoded value and what a supprise, it's not working either, nothing is red from the SAP?!
Why this code would not work (no error, data is there but it wont load anything) I have no idea ?? ;
SELECT BUKRS
BELNR
GJAHR
AEDAT
FROM BKPF
INTO TABLE tt_BKPF
FOR ALL ENTRIES IN tt_BSEG
WHERE BUKRS =
tt_BSEG-D1_BUKRS AND
BELNR =
tt_BSEG-D3_BELNR AND
GJAHR =
tt_BSEG-D5_GJAHR
AND AEDAT >= '20200623'.
.
Without any filter, data is loaded.