Generate Report that includes Material Document and Billing Document in 1 Layout.

[former_member684342]

How to Generate Reports that includes Material Document number and Billing Document Number, for all Sales Transaction in VA01. if no Tcode or Tcode 2 Different reports is okay.

[VeselinaPeykova]

In reality such report will be unusable.

As a start - access via VBFA is slow. Users will complain.

Second - you can have orders with no delivery and no material documents - take for example credit/debit memos. You can have items form several orders in a single delivery, you can have multiple material documents for a single delivery (if you have cancellations). Even if you create such report and give it to the users, it will be very difficult for them to interpret the report output. A far better option IMHO is some analytical report with drill-down and decent selections, preferably in BW, especially if you are dealing with lots of documents on regular basis.

Other than that, if this was just for me and if this is a one-time thing, I would determine the deliveries for the corresponding sales order items via LIPS and then paste these in S_ALR87014392. Or I would use MKPF and VBRP to get the rest of the required data.

[former_member684342]

Noted your on your comment thank you,

also to clear up my inquiry want to show Link between Material Document number and Invoice number to match two Documents.

In Reports or in multiple tables so I could compare both Documents

[former_member183501]

Hi

If you are an end user and report is needed once a while then contact to an authorized person having authorization of database table SE16N or contact to support team to provide you the required data.

if you are an SD Consultant and if requirement is once a while then provide the data using VBFA etc else, create a Query.

Regards

Kamlesh

[former_member684342]

Hello,

Thank you for your reply,

Yes I'm an end-user but have access to SE16n also.

Well noted on your suggestion but sorry, will clear up my inquiry, want to show Link between Material Document number and Invoice number to match two Documents.