P2RC_SV

Payroll Results: Social Insurance (Switzerland) | #transactional | Component: Switzerland
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
Column Name Description
KZ_AHV_ALV HR-CH: Indicator for restart cumulations SI Show values
KZ_SUVA HR-CH: Indicator for restart cumulations SI Show values
PROZSV Indicator for percentage-based SI obligation Show values
KZ_UEB HR-CH: Indicator for restart cumulations SI Show values
KZ_KT HR-CH: Indicator for restart cumulations SI Show values
KZ_CUS1 HR-CH: Indicator for restart cumulations SI Show values
KZ_CUS2 HR-CH: Indicator for restart cumulations SI Show values
KZ_CUS3 HR-CH: Indicator for restart cumulations SI Show values
MOREN Monthly AHV Pensioner Exemption Show values
Column Name Description Domain name
CNTR1 SI split RAW1
AHVNR AHV Number P02_AHVNR
BTRT1 Personnel subarea P02_BTRTE
NBUPF NIA supplementary insurance CHAR1
ALVKA Settling unemployment insurance fund CHAR6
FAMKA Key for family equalization fund FAMKA
ALTCD Age code (SI CH) CHAR1
AHPFL AHV/IV/EO/ALV liability for minor/adult/pensioner NUM1
EOPFL AHV/IV/EO/ALV liability for minor/adult/pensioner NUM1
IVPFL AHV/IV/EO/ALV liability for minor/adult/pensioner NUM1
ALPFL AHV/IV/EO/ALV liability for minor/adult/pensioner NUM1
VSGES Insurance companies CHAR2
PR_AHV_AG Value of payroll constants DEC7_2
PR_AHV_AN Value of payroll constants DEC7_2
PR_ALV_AG Value of payroll constants DEC7_2
PR_ALV_AN Value of payroll constants DEC7_2
PR_ALV2_AG Value of payroll constants DEC7_2
PR_ALV2_AN Value of payroll constants DEC7_2
PR_BU_AG Value of payroll constants DEC7_2
PR_NBU_AG Value of payroll constants DEC7_2
PR_NBU_AN Value of payroll constants DEC7_2
PR_NBUZ_AG Value of payroll constants DEC7_2
PR_NBUZ_AN Value of payroll constants DEC7_2
MOUVG HR-CH: Grouping of payroll units for UVG P02_MOUVG
ABREHAL HR-CH: Payroll unit - AHV/UI P02_ABREHAL
ABREHUVG HR-CH: Payroll unit UVG P02_ABREHUVG
ABREHFAK HR-CH: Payroll unit: Family-related bonuses P02_ABREHFAK
ABREHSFO HR-CH: Payroll unit: Social Funds P02_ABREHSFO
ABREHUEB HR-CH: Payroll unit: Voluntary Insurance P02_ABREHUEB
ABREHKT HR-CH: Payroll unit - Sickness indemnity insurance P02_ABREHKT
ABREHNBUZ HR-CH: Payroll unit: NBU additional insurance P02_ABREHNBUZ
ABREHCU1 HR-CH: Payroll unit: Customer insurance 1 P02_ABREHCU1
ABREHCU2 HR-CH: Payroll unit: Customer insurance 2 P02_ABREHCU2
ABREHCU3 HR-CH: Payroll unit: Customer insurance 3 P02_ABREHCU3
NAHVN Social Insurance Number (CH) P02_NAHVNR
HPN_FAK_CE Main Contract for Family-Related Bonuses (CE) PERNR
Master Data Relations Join Conditions
AHV/UI obligation
  • P2RC_SV.MANDT == T5C1A.MANDT
  • P2RC_SV.AHVPF == T5C1A.AHVPF