cancel
Showing results for 
Search instead for 
Did you mean: 

Price group

Former Member
0 Kudos

Hello, I need to assign price group to all of my customers who currently don't have price group. How do i figure out which customers who don't have price group assigned to them. Is there any tabel from where I can fetch this information. Thank you in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

venu_ch8
Active Contributor
0 Kudos

Dear Saila Kh

if you want to know Customers are in Price group OR Not go to se16n-- KNVV Table here mention Customer no now Easily you can find customer price group is maintained or not

And in sales order at Header level and Item level also we can see Price Group so we can check there also if we document nors of customers

Thanks a lot ..Mentors comments welcome

Former Member
0 Kudos

Thank you for your prompt reply. Only problem is I won't be abel to put the cutomer number one by one because I dont know which customers have price group assigned to them already and which dont. I want to pull all the customers which don't have price group assigned to them and then assign the price group. Please advise

venu_ch8
Active Contributor
0 Kudos

Dear saila

in se16n-- We can maintain all Nors of customers at a time ...

Then do one thing take all the list from se16n into excel sheet then do filter then easily we can find

Thanks a lot

Former Member
0 Kudos

Hi Saila,

You can use TCode SE16N and then enter the table KNVV. In the selection parameters, do not provide any customer numbers or other details. Only for the field Price Group (KNVV-KONDA) keep the selection criteria as Equal to BLANK (screenshots below for your reference). This should display all the customers for whom the Price Group field is blank.

Kindly revert if you need more information.

Regards,

Som

Former Member
0 Kudos

Thank you 🙂

Former Member
0 Kudos

Thank you so much for this great clarification. I appreciate your help and time 🙂