Skip to Content
Oct 19, 2021 at 01:27 PM

SQ01 Wrong result when using workorder LDB AFI (DAUFK, DIAFVC and DIKBEDS)

166 Views Last edit Oct 19, 2021 at 01:52 PM 3 rev

Hi all,

when i create a sapquery with the LDB( logical database) AFI (workorders) and i want a result with order, operation and the split persons in the operations (DIKBEDS) i only see result if there are split persons involved in a workorder operation. I do not see other orders and operations that are not having split persons.


i thought there where all left outer joins, but the joins between DIAUFK ->DIAFVC is left outer join and DIAFVC -> DIKBEDS is not?

Can anybody exlain how i get the order, operation and split persons in one query ?

and the result are complete list with or without split persons depending on selection that is used.