In query SQVI unable to join the table konv
I have a requirement from the user, extract the Open PO's with INCO TERMS and CONDITION TYPES.
1. what is the process to extract the OPEN PO's from table EKKO.
In normal process I can extract Open PO's from ME2L and for a perticular Open PO number i can get the INCO TERMS and DOC CONDITION number from table EKKO and by taking the DOC CONDITION number I can get the condition type from table KONV.
But I want to do this process in SQ01 how is it possible?