Hello Sap Experts:
I am trying to create a program that can find out payroll posting runs initiating the search from FI side where the user knows only about the document number posted in FI from payroll activities.
The user of the program knows BELNR, GJAHR and BUKRS. Based on this, I can fetch specific table in BKPF to get the AWKEY value.
My assumption is that I can have bkpf~awkey = ppdhd~docnum and using this connection, I can fetch all the payroll information required. I hope this is true for both regular and off cycle runs and other factors.
Looking forward to expert SAP guidance from the team.
2025 Oct 02 4:10 AM
Hi,
Yes, your assumption is correct – the AWKEY in BKPF normally stores the payroll posting reference (PPDHD-DOCNUM). Once you read it, you can join with PPDHD/PPHDR to get the payroll run details, valid for both regular and off-cycle runs. Just watch out for formatting (sometimes AWKEY includes year+docnum) and test it in your client system.
2025 Oct 02 4:10 AM
Hi,
Yes, your assumption is correct – the AWKEY in BKPF normally stores the payroll posting reference (PPDHD-DOCNUM). Once you read it, you can join with PPDHD/PPHDR to get the payroll run details, valid for both regular and off-cycle runs. Just watch out for formatting (sometimes AWKEY includes year+docnum) and test it in your client system.
2025 Oct 16 8:40 AM
@saikalyanx
Thank you so much for the confirmation. I request if you can further clarify what you mean by "Just watch out for formatting (sometimes AWKEY includes year+docnum) and test it in your client system."
Does it mean that the simple bkpf~awkey = ppdhd~docnum comparison will not work in this case? If yes, please provide some guidance on how I can develop a general program which can fetch HR side documents given bkpf~awkey and the reverse i.e. fetch FI side documents given ppdhd~docnum.