on 03-07-2014 1:41 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.