In query SQVI unable to join the table konv

[Former Member]

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

[Former Member]

Hi,

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

You will have to write ABAP Program.

Reards,

Prashant

[Former Member]

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.

[Former Member]

Hi,

I tried to join tables EKKO and KONV but it say..

Table KONV cannot be used in a join

Message no. AQ501

Diagnosis

1. You cannot read the selected table with SELECT statements (because, for example, it is a structure without a database table). Therefore, this table cannot be read within a table join either.

2. The chosen table is a pool or cluster table. These tables may not be used in a table join.

is their any other way to fetch the open PO's with respective condition types and inco term. how can i do it by sq01 by creating infosets in sq02 and user group in sq03could u plz explain me with step by step procedure.

Thanks

ISM

[Former Member]

true as per message you have to prepare a report

[Former Member]

ISM,

I assume that you already know that there are typically multiple condition types per item per purchase order.

True, you can't directly use a join with KONV in SQ02. However, you can create your infoset out of logical database ERM, where all the heavy lifting has already been done for you. SQ02 > enter a name > execute > select Logical database; ERM. Just select the absolute minimum tables you need from the database that meet your requirements. Don't try to get too fancy, unless you fully understand the hierarchical structural relationships of the database. Also, the fewer selection parameters you create, the better.

Your selection screen may have more on it than you want, but you should be able to put together a report that gives you all the output info you want, without engaging a developer.

Best Regards,

DB49

[Former Member]

Hi,

Could you explain me details like step by step procedure.

How can I fetch the data like Open PO's Inco Term and Conditoin types for a particular plant using SQ01, SQ02 & SQ03

Thanks in advance

ISM

[Former Member]

ISM,

No. Such instructions are beyond the scope of these forums, or at least beyond the scope that I would be willing to cover. FYI SAP provides a class [BC407 Reporting|http://www.sap.com/usa/services/education/tabbedcourse.epx?context=%5b%5b%7cBC407%7c%7c%7c063%7cUS%7c%5d%5d%7c] to cover such topics. The class lasts for 2 days.

I can say that I have created a query that meets requirements that are similar to yours. It took me a couple of hours to rough out the original version for user testing, and a couple more hours to finalize for production. It is do-able.

Following is a link to the Query Help doc. This was the doc from which I learned SAP Query (I did have previous experience with other report writers) http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

I have already given you the general methodology to obtain your data within SAP Query. If these guidelines are not adequate, then you would probably be better off engaging the services of a programmer to write a custom report.

Best Regards,

DB49