on 06-19-2015 11:58 AM
Dear All,
I want to create a query report that to list the deliveries of which Proforma Invoice had not been created.
How to Create a query report with the tables of likp and vbfa ? please explain in detail
the output should list of deliveries that should be displayed only which doesnot contain or not created the proforma invoice.
thank you in advance
BNM
Using a query you can easily get a list of the deliveries that do have a proforma but not the other way around. You could, hypothetically, add some ABAP code to the infoset to check if proforma exists, but depending on your data volume it could have a rather bad performance, so I would recommend a custom ABAP report instead where this could be programmed better.
Since proformas don't update statuses, there is no quick check for this, unfortunately.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Take in account the recommendations by SAP in Note 185530 - Performance: Customer developments in SD
I hope this helps you
Regards
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.