Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on May 12 at 9:14 AM Zaied - If I am understanding you correctly, you currently have an infoset with two header tables joined together. You want to create a field for that infoset that will be the product of two fields from the line items of the order and delivery.
If that's correct, how do you intend to produce multiple line items of header to handle the multiple lines of the order and delivery without joining the VBAP and LIPS tables in question?
Working in query, your output is going to be one line for each header pair of VBUK and LIKP. If you have 3 lines on the order and 3 on the delivery, you will have 3 combinations of NETPR x LFIMG. You won't be able to add the additional lines because you don't have that kind of control in a query. If you were doing a straight ABAP, you could simply repeat the lines of header in the output, but that won't work here. SAP query will skip to the next record and not put out anything more than the first equation.
Am I missing something?
- Lou
| | | ---------------Original Message---------------
From: Zaiedul Hoque
Sent: Sunday, May 11, 2014 6:21 AM
Subject: Code for Query Report as Additional Field
I need a field in query report which has a simple join of VBUK & LIKP.
Can't increase join of LIPS as the report changes to item level which I don't want.
My additional field formula will be VBAP-NETPR X LIPS-LFIMG
Where
VBAP-VBELN = LIPS-VBELV &
VBAP-POSNR = LIPS-POSNV
Again where
LIPS-VBELN = VBUK-VBELN
Simply to say, my query build to generate Delivery Report which billing not complete. And within that report I want to bring Sales Order Rate * Delivery Qty. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
