Happy 10th Anniversary

Today’s My Beloved Site Anniversary ,I’m so happy and wish i continue blogging for the rest of my life and be helpful to visitors who seeks quality information.



SAP Tricks #2

Hi Guys, 

This is a simple way to streamline searching for employees in SAP HCM PA30/PA20  and all Reports.

* In the Personnel Number Field type these shortcuts to :

  • Search with First Name and Last Name : =n.Lastname.Firstname or =LastName.FirstName 
  • Search With FirstName : =n.*.FirstName
  • Search With LastName =n.LastName or =LastName

Examples :

  • If you want to search for employee name Sarah Mohammed ,all you need to type is =Mohammed.sarah or =n.Mohammed.Sarah
  • If you have only the Last Name ,then leave the first name Empty by typing  =n.Mohammed or =Mohammed
  • If you have only the First Name ,then type it like =n.*.FirstName or =*.sarah


To be continued … 

SAP Tricks #1

Hi Guys ,

I will give you table of most popular and famous SAP shortcuts and Tricks , Here you go :

Command Description
/n Exit any tcode and go to the main SAP screen
/nend  Close all sessions and logoff
/bend  Cancel a batch input foreground process
/n+Tcode  Call the transaction Tcode in the same session . Ex./npa30
/o  Generate a session list
/o+tcode  Open a transaction tcode in an new session
/i  Close the current session
/h  Turn the debug mode on
/nex Exit SAP
CTRl+Y copy any text from the screen

Please share any shortcuts or tricks you Know.

To be continued …

Payroll has not been run successfully for all personnel numbers

Hi guys,

Every HCM Consultant has faced the below error while dealing with Payroll Exit . I will discuss today easy way to select all personnel with an errors so instead of copying and pasting from  “Incorrect Personnel .no” icon Incorrect Personnel .no , you just can select them all at once in payroll driver or at any report using SAP Matchcode W .


Payroll Control Record- Incorrect Personnel No.List


1- Simply open your payroll driver (pc00_m99_calc) for international driver or use your country specific payroll driver tcode.

2- Click on “Search Help ” button.

International Payroll Driver – Search Help 

3- Select “W – Payroll Correction run” .


4- Click “continue” or press Enter.


5- Select your schema and run the payroll , System will automatically execute personnel with “Correction run” flag who stopped you from Exiting the payroll.


If you need more information about SAP Match-codes Click Here


How can I log access to sensitive HR Infotypes in SAP HCM?

Tracking access and maintenance of particularly sensitive infotypes is good practice as part of an overall Governance, Risk and Compliance strategy and can be achieved using infotype audit logs and the infotype logging report.

You configure the PA audit log in the following tables:

HR Documents: Infotypes with Documents (V_T585A)
HR Documents: Field Group Definition (V_T585B)
HR Documents: Field Group Characteristics (V_T585C).

These tables are displayed via program RPUAUD00 which can be executed using either of the following transactions:

S_AHR_61016380 – Logged Changes in Infotype Data
S_ALR_87014081 – Logged Changes in Infotype Data

PD infotype changes can also be logged by configuring the following table:

Activate Change Documents (T77CDOC_CUST.)

The PD audit log can track changes to infotypes 1000, 1001, and 1002. The results are displayed with program RHCDOC_DISPLAY which does not currently have a standard delivered transaction attached.

More information on the infotype logging report is available in the SAP help.

No batch input data for screen SAPMH5A0 5000 Message no. 00344

I was trying to upload some relationships data using Transaction code “PP01” and i’ve got that error “No batch input data for screen SAPMH5A0 5000 Message no. 00344” . After many many trials recreating the LSMW program and rerecording i decided to do a very quick search on that error and that was what i have found.

  • While executing the upload program i found the relationship infotype is not being selected and that was the main cause for the error (as shown below) :


So I have to use an alternative screen which gives me the ability to enter the infotype (1001- Relationship)  as a code not by selection as you do it in Tcode “pp01”.

  • That’s why i used Transaction code “PP02” to record the program and that perfectly solved my problem.

Done !

How to count duplicated values in Excel?

  1. Take copy of column with duplicated data.
  2. Paste it anywhere.
  3. From Data Menu, Select the column you have just pasted and select remove duplicates.
  4. In another column start to type the below formula :

=COUNTIF(Range of duplicated data, Criteria of counting which in this case you will select the first cell in the column with removed duplications).

Here is a live sample:



  • In Cell C2 write this IF condition : =COUNTIF(A:A,B2)

Done !