Make a simple ALV Report to check Material Master. It really is a very important problem that i collect experiences from some projects take part in.
When any project pre go-live or go-live, Consultants & Master Data team will must work with Key User and End-User to collect and check data. At the beginning, consultant have to help user in controlling master data. User who will use system in the future everyday don’t check carefully about this problem. They don’t care a lot about it, because they thinking all data convert into new system is match and correct. However, when project ended, they feel difficult and waste time to fix issues that main reason is Material Master be miss or wrong.
Realize this problem, i decided make a report from SAP Query Tool to support User check Material Master.
( Some problems can be solve by changing in configuration to require field but not all )
Remember choose Standard Area – Client Specific
1. Create Infoset:
ZMM_DATA – Material Master Report
Use Table Join : MARA , MARC
Text: Material Number –> This is Material Description ; Text: Material Type, Text: Base Unit of Measure, etc …
Insert code into Infoset if you need …
2. Role Assignment into User Group:
Recommend: Create ZMM user group and assign all infoset relate MM module.
3. Create Query
List all fields need check to layout report, check on checkbox List Field column and checkbox Selection Field comlumn ( Parameter of Report ).
Test Report >> Save >> Assign into Transaction Code.
Enjoy with your report.
Result of Query
If you need change or insert Z-field or insert code to report … , you need ensure Infoset must re-generate. Because SAP Query really be a flexible program, it need to be checked, active. Finally, i can say that SAP Query helped me make all simple report quickly and fully a long time.