1. Objective and scope

This OP shows how to mass modify some data in SAP which can be performed in PF1_050, PF1_020 and WP1_400.

You are recommended to download existing data before you mass change something inside the system.

2. Mass modification

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-2-6.png

#

Main activities

Tips/Best practices

Key points

1

Double click on the system you want to update data

If you are new for mass update data, please be advised to try on quality system first

QF1 = PF1_050, PF1_020

WQ1 = WP1

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-2-23.png

#	Main activities	Tips/Best practices	Key points
2	Insert T-code “XK99” and press “Enter” on keyboard

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-2-43.png

#	Main activities	Tips/Best practices	Key points
3	Click on the line of table you want to mass change	You can click more than 1 table
4	Click

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-3-18.png

#	Main activities	Tips/Best practices	Key points
5	Click on the field you want to update	You can click more than 1 field
6	Click to execute

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-3-52.png

#

Main activities

Tips/Best practices

Key points

7

Click to insert the reference information

Vendor code is commonly used as the reference information

If you are mass change in company or purchasing view, you might need to specify company code or purchasing organization

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-5-27.png

#	Main activities	Tips/Best practices	Key points
8	Copy information for the template and click to paste all values	You can check how many items you need to change from number in blankets
9	Click to execute

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-7-50.png

#	Main activities	Tips/Best practices	Key points
10	Click to execute

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-8-15.png

#	Main activities	Tips/Best practices	Key points
11	Click on the field you want to clear the old data and make sure the entire column is highlighted	You can select more than 1 field	There are some cases the system already has the existing data inside the particular filed , you need to remove all data before upload new data
12	Click to clear existing data

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-9-4.png

#

Main activities

Tips/Best practices

Key points

13

Copy data and paste them to the field you want to change

The list of reference will be listed in ascending order

You can paste data only what you can see in the window, if you have a long list, please split into 10-20 items at a time

14

Click

If you are working on the large amount of data, it will take some time for the system to finish it

#	Main activities	Tips/Best practices	Key points
15	Click	You may or may not have this message

Data Operations > APAC - Vendor mass modification > image2019-6-11_19-10-11.png

#	Main activities	Tips/Best practices	Key points
16	The successful mass upload status is green	If it is red, it means that there are some errors, please see the reason in ‘Message Text’