Customer Group wise report

[Former Member]

Dear all,

Can any one told me the Standard report with reference to Customer Group wise?

Plz send me the solution for the same.

Thanks & Regards,

PM

[former_member204513 · Accepted solution]

Dear PM,

I think there is no Standard report Available for your requirement, so you can get that through this way, you can try this

Go to SE16 enter table VBAK excute it will take you to selection screen there you go to settings -->format list -->choose fields then it eill take you to all fields avail in VBAK table there you deselect all and select only what you require like Sales doc number (VBELN) then Customer group 1,2,3,4 and 5 (KVGR) then you click on copy icon, it will take you to the previous screen there you enter the duration which you want then you execute data will come.

I hope it will full fill your requirement

Regards,

Murali.

[Former Member]

for list of sales docs with customer Group as a filed in the report

1. VA15 - List of Inquiries

2. VA25 - List of Quotations

3. VA05 - List of Sales Orders

Also you can create your own report by using t.code: SQVI - ABAP quick viewer by joining one or more tables.

Important Tables for SAP SD

Sales and Distribution:

Table Description

Customers KNA1 General Data

KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master – Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Sales Documents

VBUK Header Status and Administrative Data

VBAK Sales Document - Header Data

VBKD Sales Document - Business Data

VBUP Item Status

VBAP Sales Document - Item Data

VBPA Partners

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

SD Delivery Documents

LIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document

VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit

VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header

[Lakshmipathi]

Dear PM

There is NO standard report with reference to Customer Group wise. However, you can make use of Query SQVI and Table Join VBRK (to get Customer Group - Field Name KDGRP) and VBRP (to get despatch details).

If you have any further clarifications on how to generate SQVI, please let me know.

Thanks

G. Lakshmipathi

[Former Member]

hello, friend.

you can execute queries using SQVI or SQ01/SQ02/SQ03. choose table VBKD, field KDGRP for customer group. you can join tables with VBAK and VBAP to generate your required data output.

regards.