SAP table T5MP1 (General Messages for the PBS Remuneration Statement)

SAP table T5MP1 has 8 primary key fields being MANDT,FIRMA,AGRUP,PABRP,PABRJ,PAYTY,PAYID,PAYDT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FIRMA HR_DK: PBS company used in the SAP system CHAR 2 0 T5M5H P09_COMP_S
AGRUP HR-DK PBS key field PGROUP Denmark CHAR 1 0 T5M5J P09_AGRPE
PABRP Payroll Period NUMC 2 0 PABRP
PABRJ Payroll Year NUMC 4 0 PABRJ
PAYTY Payroll type CHAR 1 0 PAYTY
Regular payroll run
A Bonus payment
B Correction accounting
C Manual check
S Additional payment
PAYID Payroll Identifier CHAR 1 0 PAYID
PAYDT Pay date for awards DATS 8 0 PAYDT
SPRSL Language Key LANG 1 0 T002 SPRAS
OBNAM Name CHAR 70 0 STXH TDOBNAME

T5MP1 foreign key relationships

Table Field Check Table Check Field
0 T5MP1 AGRUP T5M5J SAP-PBS Interface: AGRUPPE (DK) MANDT
0 T5MP1 AGRUP T5M5J SAP-PBS Interface: AGRUPPE (DK) FIRMA
0 T5MP1 AGRUP T5M5J SAP-PBS Interface: AGRUPPE (DK) SEKEY
0 T5MP1 AGRUP T5M5J SAP-PBS Interface: AGRUPPE (DK) ENDDA
1 T5MP1 FIRMA T5M5H SAP-PBS Interface: Company (DK) MANDT
1 T5MP1 FIRMA T5M5H SAP-PBS Interface: Company (DK) FIRMA
1 T5MP1 FIRMA T5M5H SAP-PBS Interface: Company (DK) ENDDA
0 T5MP1 OBNAM STXH STXD SAPscript text file header MANDT
0 T5MP1 OBNAM STXH STXD SAPscript text file header TDNAME
0 T5MP1 OBNAM STXH STXD SAPscript text file header TDSPRAS