cancel
Showing results for 
Search instead for 
Did you mean: 

List Deliveries without Proforma Invoice

bnmurthy_bnm
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Jelena
Active Contributor
0 Kudos

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.

eduardo_hinojosa
Active Contributor
0 Kudos

Hi

Take in account the recommendations by SAP in Note 185530 - Performance: Customer developments in SD

I hope this helps you

Regards

Eduardo