on 01-12-2017 4:45 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Also i am manually inputting the data as import functionality doesnot work for create data. It works only for change data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
12 | |
11 | |
6 | |
6 | |
4 | |
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.