Locked Master Data Records

[Former Member]

Is there a SAP Standard report for pulling all Locked Master Data Records in IT 14, 15 and all HR infotypes instead of going to SE16 and individually running for each table

[AFS · Accepted solution]

Hi,

if you want to use the query to get the locked records, take into account the following info: by default, locked records are not considered by the query!!

But extensive options are available to configure the new Query Generator.For more details, see the PDF document attached to the note administration of note 305118, which may be displayed using the Adobe AcrobaReader. Regarding processing locked records, I´d like to stress switchPROCESS_LOCKED_RECORDS, which is also documented there.

You need to activate this switch (SQ02, edit, GOTO ->CODE->DATA) by storing the following coding within the infoset in the area of DATAcoding (SQ02, edit, GOTO->CODE->DATA):

*$HR$

*$HR$ PROCESS_LOCKED_RECORDS = 'X'

These commentary lines configure the generator to process also lockedinfotype records.

Regards,

Ana

[Former Member]

Hi,

A Query can be prepared in SQ01 or ADHOC Query if you do not want to use the SE16 option.

Easiest will be to make a SQ01 Query and use that to check locked entries in system.

Regards,

Jailakshmi

[Former Member]

You may use the field 'Lock indicator for HR master record' (e.g.for infotype 14 it is P0014-SPRPS) in adhoc query, tcode PQAH.

Add this to infoset in transaction SQ02.