Query To Extract PO Specific Condition Type

I often got this request from users to assist them to extract a specific condition type in the purchase order.  Normally, it will be the freight condition.

In this example it is assume you have some table and SAP Query knowledge.

We will use the standard SAP Query (tcode SQ01) to do the extraction.

Extraction Steps:

First get the purchase number and condition type the user wish to extract.

Here, the purchase order item condition type is store in the cluster table KONV

The problem is Cluster table cannot be used in SAP Query but there is a way to over this.

So, we found the key fields linkage:

EKKO-KNUMV - Number of the document condition

KONV-KNUMV - Number of the document condition

We can now proceed to the query tcode SQ01

Condition type is store in the cluster table KONV

SQ01 Environment Info Set

Create a Join table:

EKKO-EBELN Purchasing Document Number

EKPO-EBELN  - Purchasing Document Number

Now for Cluster table KONV, click Extras button and then Create

KONV-STUNR and KONV-ZAEHK is taken based on the user condition type where each of them is assigned with a unique number.

SELECT SINGLE * FROM KONV

WHERE KNUMV          = EKKO-KNUMV

   AND KPOSN                = EKPO-EBELP

   AND STUNR                = 31

   AND ZAEHK                = 1

Create the query together with the Cluster table KONV

Save and now you can create the query together with the Cluster table KONV

Read Also
Abap Statements To Be Avoided

Get help for your ABAP problems
Do you have a ABAP Question?

ABAP Books
ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books

More ABAP Tips

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.