Master Data Mass Maintenance
Master Data Mass Maintenance
Master Data Mass Maintenance
Such an operation can save you a lot of efforts comparing to updating those
records manually but you need to be extremely careful while making mass
changes because SAP system directly updates the tables behind the master
records and you need to have a good knowledge of tables and fields of
master records to make the necessary changes
[email protected]
BUSINESS SCENARIO
Sometime data entry operator fail to enter some data/wrong data entered
in master record or in purchase order
Now he can’t have that much time to open each record and enter or
change the details.
To change/add all record for specific function you can use mass
maintaince
To perform above this you should have good knowledge of table and
structure so it is basically performed by sap mm consultant
MATERIAL GROUP
NUMBER IS 002
I WANT TO
CHANGE ALL
MATERIAL GROUP
FOR ALL MATERIAL
[email protected]
STEP 2 : GO TO MM17 AND SELECT TABLE AND FIELD
SELECT TABLE
SELECT FIELD
[email protected]
STEP 3 : SELECT MATERIAL RANGE
SELECT NUMBER
RANGE
I WANT TO ADD
MATERIAL GROUP
FOR ALL MATERIAL
OLD DETAIL
[email protected]
STEP 5 : CHECK TEST CHANGES
ADOPT THE
CHANGES
SAVE THE
CHANGES
[email protected]
RESULT
NEW MATERIAL
GROUP ADDED
NEW MATERIAL
GROUP ADDED
[email protected]
Sometime purchase team get updated vedor list with updated field we have to
update excel sheet to maintain master record.
Below example I have show in vendor master record. You can follow same
procedure for material master record,infor record contract and other item also
MY SOME VENDOR
ADDRESS CHANGE
I WANT TO
CHANGE DISTRICT
I COPIED TO
NOTEPAD
[email protected]
STEP 3 : GO TO XK99 AND SELECT TABLE
SELECT TABLE
SELECT TO
IMPORT FILE
SEECT FIELD
[email protected]
STEP 3 : IMPORT FILE (NOTEPAD)
SELECT NOTEPAD
FILE
SELECT DELIMITER
AS TAB
[email protected]
STEP 3 : SELECT HEADER IN DATA
SELECT HEADE
CHECK THE
CHANGES
ADOPT THE
CHANGES
[email protected]
STEP 4 : CHECK AND SAVE THE TEST CHANGES
SAVE THE
CHANGES
RESULT
DISTRICT IS ADDED
IN VENDOR
MASTER
[email protected]
You can carry out following mass maintainance by using tcode mass