Skip to Content

Invoiced material list for particular period

Greeting,

I am looking for a report which just need to input particular period, then system show the detail about all billing documents with line items in this period, I have tried to run VF05/VF05N, but both of them cannot fulfill this request, is there any standard report in SD could be used?

Thanks & Best Regards

Roger

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 02, 2019 at 04:04 AM

    Yes you need to configure to activate info structures in ovro and ovrp. Subsequently, you need to execute oli7, oli8 & oli9 respectively to update the info structures for the old orders.

    During the execution of these three transactions, you have to check the flags 'Redetermine update group' and 'Update documents'. Please note that you have to run the jobs with sequence 'Sales orders (transaction OLI7) > Deliveries (OLI8) > Invoices (OLI9). Once you complete this exercise, you can find the field STAFO would get updated both in VBRK and VBRP.

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Laskshmipathi,

      May I consult with you one thing? after all steps have been done, I can get data from MC+2 and MC+E, however, I cannot get data for June of 2019, is it caused by the termination date/time I inputted in OLI7/OLI8/OLI9? but I couldn't input pass time when executing t-codes.

      Thanks & Best Regards

      Roger

  • Posted on Jul 01, 2019 at 11:23 AM

    Not sure, whether you have activated Info Structures in which case, yes, there are standard transaction codes like MC+2 and MC+E you can input the period and execute so that system would fetch the desired result. If the info structure is not activated and would like to have this functionality, please search in SCN / Goole how to activate that.

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Laskshmipathi,

      We don't have maintain customer/material statistics group in customer/material master, therefore, in configuration of LIS , both of them have been set as blank, we always get information 'No data exists for chosen selection', is it necessary to maintain both of them?

      Thanks & Best Regards

      Roger

  • Posted on Jul 03, 2019 at 01:28 AM

    Since you used the S/4HANA tag - you'd better not rely on LIS in S/4HANA. It exists in S/4HANA, but it is not considered strategic. When you have the CDS available you don not really need LIS to get a decent billing report, in 20 minutes you can build a custom analytical query with fancy graphs, grid view, export to Excel etc. which your end users will actually like.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.