QUERY for Sales Report

[Former Member]

Hello,

I am facing a problem, that I need to create some report where I can see sales by customer, materials in some period.

My idea is to use QUERY for this, but I am not sure which logic DB use.

I am trying various but without succesful results.

Can anyone give me some advice?

thanks

D.

Edited by: Dylan N on Feb 11, 2009 4:39 PM

[Lakshmipathi · Accepted solution]

Apart from the standard TCodes which has already been suggested here, have you also tried with VF05 or VF05N ??

thanks

G. Lakshmipathi

[Former Member]

Hello Amit,

thank you, now I understand it.

I am a little bit afraid, that I cannot use it, because of some corporate restriction, but still you have gave me a lot useful info and I really appreciate it:-)

Regards

T.

[Former Member]

Dear Dylan,

Here, in SDN, we try to understand the root-cause of the error and not just the text of the error.

I am pleased, that my efforts have provided some assistance, to understand the issue.

Very Best Regards,

Amit

[Former Member]

Dear Amit,

I know that you are not a fresher, I believe that you are an very experienced guru and I really appreciate your help...really!!! ... and thanks once again for it.

I tried all these reports:

Customer Returns-Analysis - MC+A

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Customer Analysis-Basic List - MCTA

Material Analysis(SIS) - MCTC

Material Analysis-Incoming orders - MC(E

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

And each of these report is giving me message "No data exists for chosen selection".

And I think that my selection is not wrong and I am sure that there is a lot of data.

So what could be a problem? .... me?

D.

[Former Member]

Dear Dylan,

"No data exists for chosen selection"

If, above-said error is coiming for all the standard Reports, as mentione by You:

I suggest to Check/ Activate your LIS/ SIS Configuration in to your SAP System.

The settings have already suggested by me, so many times. Refer:

[LIS Activation|]

For SIS-related settings:

• In material master (MM02), under View: "Sales: sales org.2" --> Field: "Matl Statistics grp",

, maintain 1

• In customer master (XD02), under Tab: Sales Area Data --> Sub-Tab: Sales --> Field: "Cust Stats.Grp", maintain X

Best Regards,

Amit

[Former Member]

Dear ALL,

thank you .... really a lot of very useful informations.

to Amit Yadav & sri nath: these analysis look very interesting, but somehow most of them don't work properly, because they give me no data.

to Arnel Adordioni: yes, from this Logical DB I can get data, which I need.

D.

[Former Member]

Dear Dylan,

Please consider me a fresher, by curiosity, I am just asking:

to Amit Yadav & sri nath: these analysis look very interesting, but somehow most of them don't work properly, because they give me no data.

What are the Data, not getting from Standard Reports?

I really intersted to know, how these reports are not working properly?

Best Regards,

Amit

[Former Member]

ok,

I need to create report as I described, and I think that use QUERY is good option, but I am not very experienced with creating querie, so I am not sure with logical DB should I choose during creating Info Set. I need some sales report with customers and materials, ...

I tried to create InfoSet by table e.g. VBMTV, but is there any Logical DB for this purpose?

Generally how can I know, which logical DB use for creating InfoSets.

thanks

D.

[Former Member]

Dear Dylan,

What are all requirements, you need to capture, which are not coming in Standard Reports:

Customer Returns-Analysis - MC+A

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Customer Analysis-Basic List - MCTA

Material Analysis(SIS) - MCTC

Material Analysis-Incoming orders - MC(E

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

Best Regards,

Amit

[former_member217082]

Hi Dylan

Check the following reports which may help you

MCTA Customer Analysis

MCTC Material Analysis

MC(A Customer Incoming Orders

MC+A Customer Returns

MC+E Customer Sales Volume

MC+I Customer Credit Memos

MC(E Material, Incoming Orders

MC+M Material Returns

MC+Q Material, Sales Volume

MC+U Material Credit Memos

S_ALR_87012186 Customer Sales

S_ALR_87012197 List of Customer Line Items

Regards

Srinath

[Former Member]

Hi Dylan,

I have used logical database VAV for sales reporting from my previous projects long time ago. This logical database joins the following tables.

VBAK

VBUK

VBKD

VBPA

VBUV

VBAP

VBUP

VBEP

VBFA

KONV

Be careful with the way you run queries as it normally takes toll to your system. You can also consider using LIS/SIS for your real-time reporting.

Let me know if this helps.

Regards,

Arnel Adordionicio

[former_member217082]

Hi Dylan

What is the problem you are facing in sales report ? what configuration you have done and where you are facing problem ? If you tell then we can help you out to solve the issue

Regards

Srinath