Register Login

SAP MM Mass Maintenance Interview Questions and Answer

Updated May 19, 2018

Q1. Why does the mass maintenance select an incorrect number of data records?


Prior to the actual selection, the mass maintenance first carries out a preselection via the leading table of the selection.The logic according to which the leading table is selected from several tables is described in note 325088. If a maximum number of data records, that should be selected and displayed without consultation and that has been defined in mass maintenance by the user, is exceeded in the preselection, the system displays on dialog box 'Processing mode' how many or, in case of a selection of several tables, up to how many records it selects.That is, in case of a selection of several tables the preselection only displays an upper limit.Only when you press pushbutton 'Display all records' or 'Change in background' on dialog box 'Processing mode', the combined selection is made across all selected tables.Consequently, the number of the selected data can deviate heavily from the upper limit displayed on the 'Processing mode' dialog box.

The mass maintenance offers 2 processing modes (you can 'change existing data records' and/or 'create new data records'), which you can execute separately or together (!!!). If both processing modes are activated, all data records that meet the selection conditions for the change plus all data records that correspond to the selection conditions for the new creation are selected.

Q2. Why is the runtime of the selection across several tables in the mass maintenance very long? Why does the selection in the mass maintenance terminate with TIME OUT?

Note 325088 describes the logic of the combined data selection across several tables in the change mode of the mass maintenance.You can solve the problem by choosing the selection condition in a suitable way.

Q3. Which notes reduce the runtime of the mass maintenance.

Note    Short text
178019  MASS maintenance info records
317310  IS-A: Poor ALE performance
333017  Poor performance with ALE and mass maintenance
424635  Long runtime in the mass maintenance customer/vendor
485023  Long runtime with mass maintenance purchase requisition
505585  MEMASSPO:  ABAP runtime error TIME_OUT
544687  Mass maintenance: Long runtime of the data selection
566520  Long runtime mass maintenance MM17, XD99, XK99, MEMASSIN
571729  Long runtime mass maintenance material master MM17

Q4. Why does the selection terminate with ABAP runtime error 'SAPSQL_WHERE_CANT_SCAN'?

Note 330416 describes the cause and solution of the problem.

Q5. Why does the mass maintenance terminate with ABAP runtime error 'TABLEVIEW_DUP_COLUMN_INDEX'?

Note 391449 describes the cause and solution of the problem.

Q6. Why does the saving of a variant terminate with ABAP runtime error 'SAPSQL_ARRAY_INSERT_DUPREC'?

Note 517296 describes the cause and solution of the problem.

Q7. How do I create new data records?

Note 351283 describes the selection logic for the creation of new data records in the mass maintenance.Notes 331364 and 339444 additionally describe the effect of foreign key dependencies of the selection fields on the selection of the new records to be created in mass maintenance.

Q8. Why does the system not save new field values on the database although it displays a success message in the log of the mass maintenance?

Note 357753 describes the correct handling for transferring new field values.

Q9. Why is it not possible to carry out mass maintenance for customer fields/append fields?

Note 414020 describes the cause.

Q10. Why does the system unintentionally initialize field values during background processing?

Note 559856 describes the cause and solution of the problem.

Q11. Why does the mass maintenance not work for calls via 'BDC / CALL TRANSACTION'?

Note 381935 describes the cause and solution of the problem.

Q12. How can new material master views be created with the mass maintenance? How can the maintenance status of a material be extended with the mass maintenance?

Note 581068 describes how materials with the mass maintenance can be extended without template.
Note 581542 describes how the maintenance status of materials can be extended with the mass maintenance.
 


×