Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from ramanujamsrinivasan1969 on Jul 9 at 10:30 AM Check document flow table VBFA, pass delivery numbers and you will fetch the corresponding Invoices.
| | | ---------------Original Message--------------- From: kum_suresh Sent: Wednesday, July 05, 2017 2:08 PM Subject: SAP Standard Report to Show Delivery Number With Invoice Number and Sale Order Number Chris, First try creating a query using SQVI by joining tables (VBAP-VBELN ,LIPS-VGBEL, VBRP-AUBEL). If you can get the desired results, then you can either convert this to a query via SQ01 so all users can use or give it to a ABAPER to develop something on these lines. The common field that will join the three tables is the sales order number. Fields VGBEL and AUBEL is the sales order reference coming from VBAP-VBELN). By joining the item level tables it will pull if there are multiple sales orders in one delivery and billing document. Hope this helps. Thanks Suresh | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |