Skip to Content
Product Information
Author's profile photo CA Zunaid Hingora

Mass Upload Functionality – SAP

Manual to use MASS transaction code with Import functionality.

For videos of all my blogs, please click on below link.

https://www.youtube.com/channel/UCx5F7mhmIYye8ETY3cM5zQQ

Benefits of MASS transaction code.

  1. Faster data change.
  2. Huge volume of data can be changed in less time.
  3. Ease of processing/uploading.
  4. Ease of Use and less expertise required.
  5. Fixed templates can be created for each Object.
  6. Multiple objects covered in MASS processing.
  7. End user can also use this transaction.
  8. Templates can be shared with end users.
  9. Best tool during master data upload.

Process Steps

User wants to modify the existing User responsible for 1000 cost centre. This can be achieved in minutes by Import functionality of Mass Tcode.

1. Go to Excel. For e.g. you have excel in below format. This file is received from user. This is just example. You can have less or more column. In below column you can delete valid to column and proceed further.

2. Go to Transaction code Mass. Select as shown in below screenshot. Click on execute button.

3. Click on Import Data from file.

4. Select file name. Click on open.

5. Below screen will appear. Click on execute button.

6. Now if you observe below screenshot, icons are in grey. Means items are unassigned. See below Alphabet A B C D.

7. Click on grey icon.

8. Below screen will appear. Assign the appropriate field. Do this for all column. After assigning. Field should be green.

9. All columns are green. Means ready to execute.

10. After execution, below screen will appear. Click on SAVE button. The one with error are shown in below screen.

11. Below message will be displayed. Means changes are done.

 

Data are uploaded in the system.

Benefits of using Mass Upload functionality through excel is that it saves lot of time for copy the data on the screen. If data are uploaded regularly, Model template for each object should be created and saved for uploads. For eg. cost centre, Profit centre etc.

CA Zunaid Hingora

Other Blogs

LTMC Process LTMC Process SAP S/4HANA – Simple Steps | SAP Blogs
Why choosing SAP Profile as a career could be best decision for anyone? https://blogs.sap.com/2021/08/18/why-choosing-sap-profile-as-a-career-could-be-best-decision-for-anyone/
Fiori App List /blogs.sap.com/2021/11/25/fiori-app-list-s-4hana/
FI – SD Integration – VKOA – Understanding Flow – SAP ECC https://blogs.sap.com/2020/11/12/fi-sd-integration-understanding-concept-sap-ecc/
IDOC Management – Mass Change – WLF_IDOC, Foreground Processing and other IDOC Activities. https://blogs.sap.com/2020/08/04/idoc-mass-change-mass-processing-wlf_idoc/
SAP ‘ Z Process Re-Engineering’ – Enhance the productivity of the implemented solution https://blogs.sap.com/2020/08/03/enhance-the-productivity-of-the-implemented-solution-sap-process-re-engineering./
S/4 Hana – House Bank, Bank Account and Account ID Overview https://blogs.sap.com/2019/10/18/s4-hana-house-bank-bank-account-and-account-id-overview./
AUC Automatic Creation from WBS – S/4 HANA https://blogs.sap.com/2019/09/27/auc-automatic-creation-from-wbs-s4-hana/
S/4HANA Finance – New vs Old transaction code https://blogs.sap.com/2019/09/23/sap-hana-new-vs-old-transaction-code./
Profit Center – Assignment/Removal of Company code and Activation https://blogs.sap.com/2019/07/17/profit-center-assignmentremoval-of-company-code-and-activation/
AS91 – Asset Master Upload https://blogs.sap.com/2019/03/25/as91-asset-master-upload./
Asset Reconciliation Account Posting ABF1L- No OAMK, OASV https://blogs.sap.com/2019/03/13/asset-reconciliation-account-posting/
Mass Upload Functionality – SAP https://blogs.sap.com/2019/03/12/mass-upload-functionality-sap/
Data Migration Learning https://blogs.sap.com/2021/12/29/data-migration-learnings/
SAP Interface Development Process – Detailed Guide https://blogs.sap.com/2022/01/13/sap-interface-development/
Fiori Apps Learning https://blogs.sap.com/2022/02/22/fiori-apps-learning/
Screen Recordings Screen Recordings, Video Export, GIF, Save as Show using PowerPoint Presentation – SAP Business Scenarios, Training Documents, End user Videos etc. | SAP Blogs
SAP S/4HANA Finance – New Additions, Features and Functionality https://blogs.sap.com/2019/03/26/sap-s4-hana-features/
Automatic Idoc Generation while Creating Purchase Order, Nace Config – Material Management Automatic Idoc Generation while Creating Purchase Order, Nace Config – Material Management | SAP Blogs
Transport of Copies – SAP Transport of Copies – SAP | SAP Blogs
Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision Fiori vs LTMC vs ACDOCA – Benefits, Value addition Comparision | SAP Blogs
Terms of Payment for Installment – SAP Finance Terms of Payment for Installment – SAP Finance | SAP Blogs
SAP Project Knowledge Transfer Guide/Checklist (KT) SAP Project Knowledge Transfer Guide/Checklist (KT) | SAP Blogs
Vendor Ageing Report Vendor Ageing Report – S_ALR_87012085 SAP FICO
SAP Important Tcodes SAP Important Tcodes – FICO MM SD PM BODS
LSMW Recording for Transaction Data – FB01 LSMW Recording for Transaction Data – FB01
SAP FICO Data Migration – Global Execution, Planning and Approach SAP FICO Data Migration – Global Execution, Planning and Approach
FBZP Configuration template https://blogs.sap.com/2023/08/01/fbzp-configuration-ready-to-use-template-fico-banking/?preview_id=1813070

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Carlos Alberto Valentini
      Carlos Alberto Valentini

      Good Morning
      Excellent post.

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Thank you so much.

      Author's profile photo helen salas
      helen salas

       

      Hi, is there a form to update withholding tax as the same form like de SAP versión before hanna, with Mass transaction

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Need more clarity on this. When you say withholding tax means check box for activating tax in vendor master. Please clarify

      Author's profile photo Nujood NR
      Nujood NR

      Hello,

      Can anyone advise if we can do the Mass Uploading for subjects? like a bilk uploading !

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Please give more details. Also please check all options in MASS tcode.

      Author's profile photo Md. Ansar
      Md. Ansar

      Good one and time saver trick........could you please share more like this info( blog links) on my mail id - ansar.sss@yahoo.com

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Hi Md. Ansar,

      Thank you. Please check my profit and in blog section you will find all links.

      Please check below link for all blogs.

      https://people.sap.com/#content:blogposts

      Regards

      Zunaid

      Author's profile photo Fred Griffin
      Fred Griffin

      Hi Zunaid -  In MASS transaction, there is no option for Import data from file......is this an authorization issue or SAP Component  Issue?

       

      Thanks!

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Hi Fred,

      It Must be there. Please check screen 2 above in your system again. You can share screenshot here.

      Regards

      Zunaid

      Author's profile photo Fred Griffin
      Fred Griffin

      Hi Zunaid - Here you go.....

       

      Thanks!

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Hi Fred,

      Seen you screenshot. I or any of my counterparts haven't experience this kind of scenario. But below things i can suggest you.

      1. Run SU53.
      2. Check in another system. DEV, Quality.
      3. Request other users to check with their login.
      4. Request basis team to make one id with SAP all and try to check this.
      5. Write to SAP if above do not work.

      Hope this may help you.

      Regards

      Zunaid

      Author's profile photo Oscar Del Castillo
      Oscar Del Castillo

      I'm always shocked by folks not knowing about the MASS functionality and creating a bunch of LSMWs or custom programs when this is quite straight forward and standard !

      Thanks

      Author's profile photo CA Zunaid Hingora
      CA Zunaid Hingora
      Blog Post Author

      Thank you