Invoiced material list for particular period

[former_member595220]

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

[Lakshmipathi · Accepted solution]

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.

[former_member595220 · Accepted solution]

Dear Laskshmipathi,

Many thanks for your information, I got it.

Best Regards

Roger

[former_member595220 · Accepted solution]

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

[VeselinaPeykova]

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.

[former_member595220]

Dear Veselina,

Could you please guide me about CDS? this is first time I got this term.

Thanks & Best Regards

Roger

[VeselinaPeykova]

There are plenty of blogs on the subject. Search with terms s/4hana cds embedded analytics and you will find plenty of information.

There are also nice tutorials on https://developers.sap.com/ like this one Customize CDS Views for Creating Reports in S/4HANA.

If you have access to Learning Hub - there are a few courses on the topic.

[Lakshmipathi]

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.

[former_member595220]

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