Skip to Content
0

XK99 Updation of Vendor master data with contact person

Jan 12, 2017 at 04:45 PM

172

avatar image
Former Member

hi all,

Business requirement is to mass update contact details for vendors using XK99. however I see that the records are getting duplicated for each vendor and contact person in XK99 even before we save the transaction.

Did any one successfully complete this activity. any pointers will be of great help

10 |10000 characters needed characters left characters exceeded

Can you be more precise what you actually do in XK99.

there are various ways to carry out changes, e.g. by upload from Excel or from clipboard or the old way by executing a selection and distributing a value to all selected records.

XK99 has the option of change and also the option of create.

So it would be very important to know the exact steps that you do, best with screenshots to enable us to help you further.

Also the potential helpers might just be a small group since contacts in vendor master came with version 617. Many are not yet on this version.

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Jan 13, 2017 at 05:02 AM
0

hi,

I am trying to create contact details, first name and last name of the contact for vendors. so I m using "data records to be created".

i have selected table MASSVENDORKNVK and fields MASSVENDORKNVK-NAMEV and MASSVENDORKNVK-NAME1.

when there are more than one vendor and contact number, each vendor is getting linked to every contact number mentioned. This is resulting in duplication. Please let me know if you will be able to help

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 13, 2017 at 05:03 AM
0

Also i am manually inputting the data as import functionality doesnot work for create data. It works only for change data.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

can you add a screenshot from the selection screen (after you filled it) of Create Records, and also the next screen after execution of the selection

0
avatar image
Former Member Jan 13, 2017 at 07:33 AM
0

please see the steps that i am following -

the above screenshot is the problem one, why there are 4 entries instead of 2.

yuwxv.png (15.3 kB)
s3lua.png (23.1 kB)
ezxgh.jpeg (45.1 kB)
wd3fx.png (16.3 kB)
spwqj.jpeg (24.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jürgen L Jan 13, 2017 at 10:43 AM
0

Simply because you have 2 vendors in your selection and 2 contact persons - there is no relation from a vendor to a contact in the selection itself, these are just 2 individual fields and SAP does a n:n linkage as proposal.

Remember this is about creation, contrary to a change where a selection would happen based on existing table entries in KVNK you have nothing in KNVK when you create, so the selection screen has only values that you want to add.

If you would want to add for example 200 contacts to 1 vendor, then XK99 would be the right way to go.

XK99 would also be a good choice if you want add 1 contact to 200 vendors.

But for 200 contacts to 200 vendors the system would all all 200 contacts to all 200 vendors in XK99, no other way around than executing it 200 times (vendor by vendor) if you want always just a certain partner for a certain vendor.

Share
10 |10000 characters needed characters left characters exceeded