How to get Plant wise customer list in SAP

[Former Member]

Dear All,

My client require a Plant Wise customer detail.

Please guide how i can generate it.

[Lakshmipathi · Accepted solution]

Goto IMG - Sales & Distribution --> Sales - Lists --> Define Selection Criteria

In the screen - goto New Entries and add the following details..

1. Program Name - SAPMV75A
2. TRG (Transaction Group) - 0
3. Display Group - K
4. Event - SELK
5. It - 8
6. Field Name - WERKS

Enter the details and save the changes. Goto VA05 and you can see the field PLANT in the Fur Sel Criteria.  Select the required plant and execute so that you will get plant-wise sale order report where you can filter customer code.  On the other hand, if delivering plant is maintained in customer master, then you can take in table KNVV.

G. Lakshmipathi

[Former Member · Accepted solution]

Dear sir very good information you have given

thanks a lot for ur help

[Former Member · Accepted solution]

Thanks Sir,

Its full filled my requirement.

Actually i dont want to share Table authorization with my USER.

Its gud option.

[Former Member · Accepted solution]

Hi Lakshmipathi

This is why I  am good Fan of yours.:)

Regards

[siva_vasireddy2 · Accepted solution]

Dear Lakshmipathi Sir,

            Thank you for the wonderful information.

Sivavasireddy

[jignesh_mehta3]

Hello Azeem,

ARe you refereing to Delivering Plant in Customer Master - Sales Area Data?

If yes then follow as below:

1. If it is required one time then go to T-Code SE16N & exlplore Table KNVV & generate list based on required Plant (Field - VWERK)

2. If this report is required regularly then you can generate a simple Query (SQ00 / SQ01) & generate the list as & when required.

Hope this helps,

Thanks,

Jignesh Mehta

[Former Member]

Dear Jignesh,

Actually i dont want to share Table authorization with my USER.

[jignesh_mehta3]

Hello Azeem,

That is why I suggested to create a Query, assign a T-code to the same & give authorization to Users.

By this was they will not be able to access the Table, but just pull the required data out of it through Query.

Thanks,

Jignesh Mehta

[Former Member]

Dear Jignesh,

Thanks for your reply. It is the correct way to solve this issue.

[Former Member]

Dear Azeem

Yes this is the only correct way to do such things and you can achieve without coding.

While doing please take following points into consideration:

1. Make the query directly on Production client and from there note down the program name:

     Run SQVI

     

Select your Query and Click Execute Button

System >> Status

Copy the Program name from here.Now go to your workbench client and Run SE93 (take the help of ABAPER) nd create you Zee code and assign this Program(Program of Production Client) to this Transaction Code.

And Transport it to Production Client.

Last but not the least, you can also authorize users with this TCODE.

Thanking you!

Ashish Mishra

[suman_sardar2]

Hi Md,

In SAP Customer Master we are maintaining the Delivering Plant.

Are you talking about the same or something else.

Please provide the exact requirement also tell us the mapping of plant with Customer master in your system.

Thanks,

Suman

[Former Member]

Yes,

I am talking the Same Customer in specific Plant

[Former Member]

go to table knvv