Standard LIS report for finding the sales value happened in month

[former_member185462]

Hi,

I am looking for standard LIS report which would help me in finding total sales value like below,

Input Parameters

Sales Org	Distribution channel	Division	From Date	To Date

Output Parameter

Billing document no	Net Value	Billing Value	Article no	Quantity

I am trying to create LIS report also but i could not do it based on article/material number.

[Jelena]

You will not get a report at the Billing Document level from any standard LIS. LIS is meant to store cumulative information (e.g. by Sold-to or Material), why would you need another table to store the same exact information that is already available in VBRK/VBRP?

Use VF05 or create a custom query, it's not that hard.

[former_member185462]

Hi,

I did the report with the help of Custom  Query.

Was looking for a standard report which would meet my requirement

[Jelena]

There is no other standard billing report than VF05, similar questions have already been asked very many times on SCN. If this is resolved then kindly close the discussion.

[former_member586471]

Hello

  Sorry if i am not getting your point exactly , you want the report of billing document with some data to extract sales org, dist channel  division etc..that you can make with quick view..in testing server i have just roughly tried to make this, it came like that..

Regards,

Learner

[shyamsumar]

Hi Pradeep,

Please check below reports :

MC+E	SIS: Customer Analysis: Invoiced Sales
MC+Q	SIS: Material Analysis: Invoiced Sales

Regards,

Shyam