How to check the Customer wise Stock

[Former Member]

How to check the Customer wise Stock

means cumulative of all Sales Orders Quantity booked under his name for the specific dates

Any possible way to do

Points are to be rewarded

[Former Member]

Statistic Group:

Purpose – To capture data for Standard Reports, we require to activate Statistic Group as under:

--> Item category (Configuration)

--> Sales document type (Configuration)

--> Customer (Maintain in Master data)

--> Material (Maintain in Master data)

When you generate statistics in the logistics information system, the system uses the combination of specified statistics groups to determine the appropriate update sequence. The update sequence in turn determines for exactly which fields the statistics are generated.

Configuration:

IMG --> Logistics Information System (LIS) --> Logistics Data Warehouse --> Updating --> Updating Control --> Settings: Sales --> Statistics Groups -->

1. Maintain Statistics Groups for Customers

2. Maintain Statistics Groups for Material

3. Maintain Statistics Groups for Sales Documents

4. Assign Statistics Groups for Each Sales Document Type

5. Assign Statistics Groups for each Sales Document Item Type .....

All Standard Reports which are available are as under:

SAP Easy Access: Information Systems -> Logistics -> Sales and distribution ->

1. Customer -> Incoming orders / Returns / Sales / Credit memos / Sales activities / Customer master / Conditions / Credit Master Sheet

2. Material -> Incoming orders / Returns / Sales / Credit memos / Material master / ...

3. Sales organization -> Sales organization / Sales office / Sales employee

4. Shipping point -> Deliveries / Returns

5. SD documents -> Orders / Deliveries / Billing documents ...

& so on.

Regards,

Rajesh Banka

[Lakshmipathi]

Dear chakri

You have to run SQVI by table joining VBAK (for customer code - KUNNR, sale order ref - VBELN), VBAP (for material code - MATWA) and MARD (for stock - LABST).

thanks

G. Lakshmipathi

[Former Member]

hi

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.

Hope this will help u

[Former Member]

SE16N - VBAK give customer number and dates and execute - you will get the list. Else SE16N - VBAP - Item details.

rgds

Sai