Locked records in query

Problem:

When you run a query you receive errors of Locked records.

Solution:

By default, locked infotype records (those ones with field SPRPS equeal to X) are not selected by the query. If you need to report on these infotypes, then you need to activate this switch (SQ02, edit, GOTO ->CODE->DATA) by storing the following coding within the infoset in the area of DATA coding (SQ02, edit, GOTO->CODE->DATA):

*$HR$ [COMMON]
*$HR$ PROCESS_LOCKED_RECORDS = ‘X’

These commentary lines will configure the generator accordingly. Generate the infoset and generate your query as well using function QUERY->MORE_FUNCTIONS->GENERATE_PROGRAM (don’t forget to restart transaction SQ01 before, otherwise, there might be a buffering problem).

This is also explained in the document attached to SAP note 305118.

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.