Account Group

[Former Member]

Hi All,

Is there any STD REPORT to generate a report based on Account Group.

Rgds,

Raj..

[Former Member]

Hii,

There is no standard report to get sales figure based on account group. However you can download all the customers in a particular account group from table KNA1, and with those customers you can get the sales figures as required.

Regards

Ritam

[Former Member]

Dear Friend,

There are many ways you can get the report

1. In any report : you enter the customer code:

Hope you have maintained the Number ranges as per the account group.

Select the arrow option from and to range : Give the upper and lower limit for that particular number range account group.

Entire report will be as per that account group.

2. you can do a info set query by TCs: SQ02> Sq03>Sq01

and using tables KNA1 and Knvv join them create feild groups.

the Customer Account group feilds is KONTR use that in the query .

3.or design a report by your ABAP er .

award points if helpful.

edited by...,

SAP SD

[Former Member]

Hi,

Go to SE16 and try table BUT000, i am sure this will help you.

If it does dont forget to reward points for contribution.

Regards

Ravi

[Lakshmipathi]

Dear Rajashekar

Based on Account Group, can you please let me know what data you want to generate??

[Former Member]

Say i want to generate a report for the total sales value for a particular period for a particular a/c group.

[Former Member]

This requirement cannot be met through Standard SAP, but can be met through development for the same.

Regards,

Rajesh Banka

[Former Member]

generating a sales report based on account group???

Is it a customer requirement??

SAP standard not provided any standard report based on account group.

U can write ur Z program and u can generate ur desired report...!!

Thanks & regards,

Shaik Hussain

[Lakshmipathi]

Dear Rajeshekar

You have to try in SQVI by Table Joining M_DEBIK, VBRK & VBRP +(In this sequence only).+

Though through M_DEBIK and VBRP, you can get the required data, in Table Join, it wont work. Hence you need to include a Header table and through which you have to link VBRP.

thanks

G. Lakshmipathi

[Former Member]

The main functionality of the Account group is that determines the data which is relevant for the master record and the number range from which the numbers are selected at the time of creation of master records and not for grouping the accounts for reporting.

[Former Member]

Check in menupath as under:

SAP Menu --> Information System --> It should ideally be in Accounting

Try F.20

Regards,

Rajesh Banka

Edited by: Rajesh Banka on Feb 28, 2008 7:35 AM

[Former Member]

Go to SAP menu>> Accounting>>financial accounting>>>Cusotmers>>>Information system>>> Check out under this.

seems to be there is not standard SAP report beased on customer account group.

Thanks & Regards,

Shaik Hussain