P2RD_ST

Payroll Result: Tax (G) | #transactional | Component: Germany
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
FRB1M Monthly Personal Exemption According to Tax Card
FRB1J Annual Personal Exemption According to Tax Card
FRB2M Monthly Exemption for Specific Occupational Groups
FRB2J Annual Exemption for Specific Occupational Groups
PKPV Contribution Base Rate Private HI/CI
L2016 ER Supplementary Benefits Paid in 2016 (Sec.100 EStG)
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
BEGBZ Beginning of statement period
Column Name Description
STRKL Tax Class (D) Show values
STTAB Tax Table (D) Show values
LZZRM Payroll Period Show values
ALTKZ Identifier: Old-Age Exemption Show values
DSTLB Output Month Show values
T5D2M Checkbox Show values
STBEL Elster Special Processing Show values
AUSN1 Change on First Day of Subsequent Period Show values
ELSTAM Change by ELStAM Show values
KRV SI Contribution Deduction Indicator Show values
PKV Indicator HI Show values
PVZ Indicator CI Allowance Show values
PVS Indicator CI Saxony Show values
DBALD Country for Tax Calculation DTC Show values
Column Name Description Domain name
CNTR2 Tax split RAW1
JUPER Legal Person JUPER
STKRT Certification period NUM2
KDFBT Number of Tax Exemptions for Children (D) DEC2_1
STRKD Number of Children for Berlin Supplement DEC3
KISTA Church tax deduction - employee KISTA
KISTE Church Tax Deduction - Spouse KISTA
MODEL Tax Procedure Used CHAR3
STAGE Tax days DEC2
SPER1 Lock Tax Procedure CHAR1
SPER2 Lock Tax Procedure CHAR1
SPER3 Lock Tax Procedure CHAR1
SPER4 Lock Tax Procedure CHAR1
SPER5 Lock Tax Procedure CHAR1
SPERK Lock for Annual Church Tax Declaration CHAR1
GMDNR Municipality Number (D) GMNDN
FZAMT Tax Office Number (D) FZAMN
SIDNR Tax Identification Number P01_SIDNR
WERKS Personnel Area Reporting PERSA
BTRTL Personnel Subarea Reporting BTRTL
AGSNR Tax Number in Electronic Tax Return Format CHAR15
FAKTOR Factor for Factor Procedure
KVZ Additional Contribution Rate to HI and CI
Master Data Relations Join Conditions
Tax procedure
  • ?
  • Tax procedure
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.PRMNZ == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Tax Exemption Reason
  • ?
  • Tax Exemption Reason
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.STBFG == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Flat-Rate Tax Procedure
  • ?
  • Flat-Rate Tax Procedure
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.STFRG == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Tax Liability
  • ?
  • Tax Liability
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.STPFL == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Special Rule for Taxation (D)
  • ?
  • Special Rule for Taxation (D)
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.STRS2 == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Special Rule for Taxation (D)
  • ?
  • Special Rule for Taxation (D)
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.STRSO == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Pension Tax Exemption Granted
  • ?
  • Pension Tax Exemption Granted
  • Client
  • P2RD_ST.[column in domain "SRART"] == T5D2D.SRART
  • P2RD_ST.VFREI == T5D2D.SRKEN
  • P2RD_ST.MANDT == T5D2D.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Church Tax Area (D)
  • Church Tax Area (D)
  • Client
  • P2RD_ST.KISTG == T5D2L.BRDLD
  • P2RD_ST.MANDT == T5D2L.MANDT