Skip to Content
0
Aug 15, 2023 at 07:26 PM

SAP Query - Applying join in Custom field of the Infoset SQ02

63 Views

Hello,I need to display the sales order base condition type price in the custom field of my query. The Infoset has VBAK and VBAP join created. I am planning to add a custom field that will fetch Doc condition number KNUMV from VBAK and then get Condition rate KBETR from KONV where VBAK-KNUMV=KONV-KNUMV. The problem is that it has to iterate through all the line items which I need to get item numbers from VBAP and feed in KONV-KPOSN to get correct line item data. The below code is just displaying the first line item price in all line items. Please suggest how to fix it.

image.png

Attachments

image.png (21.6 kB)