SAP BLOG Import data from buffer in MASS transaction code

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,367
Tepki puanı
7
Puanları
6
Introduction

We can change material master, vendor master, cost center, profit center etc. in mass just copying data from excel (Recommended) or notepad or any other file but data should be arranged in correct format.

Solution

Before you change master data or transaction data arrange the data in correct format which data you want to change. For example you want change material description you should arrange data with language key in below format.

Column A–> Material number.

Column B–> Language key.

Column C–> Material description.



1-41.png


If you want to change purchase group of material master you should mention suitable organization data.

Column A–> Material number.

Column B–> Plant.

Column C–> Purchase group.

2-26.png


Here I explain how to change material description in mass without header and with header in copied data. Run the transaction code MASS, enter object type BUS1001 and click on Execute button (F8).

3-24.png


First I explain without header.

Copy data without header.

4-25.png


Select table MAKT and click on Import Data from Buffer.

5-21.png


Select Tab radio button, without header line and Execute.

6-19.png


Assign suitable fields.

7-13.png


8-16.png


Repeat same steps for remaining two columns and click on Execute (F8).

9-13.png


Note- You can also deselect which entry you don’t want to change.

Now save.
10-16.png


11-14.png


Copy data with header.

12-15.png


13-15.png


SAP automatically assigned fields.

14-11.png


Repeat the above explained step and save the data.

Conclusion

This mass change functionality helps to users to change data immediately. Now understood copy function also changes data and mass change function with header and without header.

Okumaya devam et...
 
Üst