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.
- Faster data change.
- Huge volume of data can be changed in less time.
- Ease of processing/uploading.
- Ease of Use and less expertise required.
- Fixed templates can be created for each Object.
- Multiple objects covered in MASS processing.
- End user can also use this transaction.
- Templates can be shared with end users.
- 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-any... |
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... |
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 Scen... |
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 Blo... |
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=1... |