I need to perform something like the VLOOKUP in PQL.
In particular, in my O2C_VBAK table I added a column EDIPartner, that pulls the EDI Partner number (EDPAR.KUNNR) for the concerned VBAK.KUNNR.
Now, I want to make a drop down filter in my analysis, so that user can choose different EDI Partners, and I want him to see not only the number, but also the name of that partner.
If I just write “VBAK”.“EDIPartner”|| ’ - ’ || “KNA1”.“NAME1”, then it will take the NAME1 of the VBAK.KUNNR.
How do I make it take the NAME1 of the VBAK.EDIPartner?