Skip to Content
avatar image
Former Member

In query SQVI unable to join the table konv

Hi Guru's

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?

please help

Regards

ISM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 31, 2011 at 03:20 AM

    use table

    EKKO

    KONV

    select field EKKO-inco temr,condition number(KNUMV) and deliverd qty ,invoiced qty,

    both tables can be joined on the basis of KNUMV field

    selection critera for report will be delived qty , invoice qty and its value wlll be still to be deliverd qty not equal to 0

    invoiced qty not equal to 0

    objective

    1. identify the open po (for this we are using delived qty and invoice qty fields)

    2. join the table on KNUMV field.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 31, 2011 at 04:00 AM

    Hi,

    I think you can not use table KONV in Query for reporting.

    You will have to write ABAP Program.

    Reards,

    Prashant

    Add comment
    10|10000 characters needed characters exceeded