P2RB_ST

Tax payroll Belgium | #transactional | Component: Belgium
Column Name Description
MANDT Client
DCT_PERNR Personnel Number
DCT_SEQNR FK Sequence Number
DCT_ROWID Unique Row Number
Column Name Description
BVFSV Additional Tax Advance Amount
Column Name Description
Column Name Description
BEGDA Start Date
ENDDA End Date
ARBER Expiration Date of Work Permit
DISND Dismissal Notification Date
Column Name Description
BVEKI Partner's Income Show values
BVEMV Partner Disabled Show values
BVWMV Employee Disabled Show values
BVWWE Single Parent for Tax Allowance Purposes Show values
BVBOR Border Worker Show values
BVCOA Legal Cohabitation Show values
SHFTW Tax Deduction for Shift Show values
TAXDE Tax Declaration Method Show values
Column Name Description Domain name
CNTR2 National assignment indicator RAW1
AKSTA Activity status NUM1
ANSTA Employment status NUM1
JUPER Legal Person JUPER
BREGM Regulation contract months per year CHAR2
BVKKA Number of Children for Child Allowance NUM2
BVAKA Registration Number at Child Allowance Fund CHAR15
BVMUT Employee's Health Insurance P12_BVMUT
BVAMU Health Insurance Number CHAR15
BVKTL Number of dependant children NUM2
BVMKT Number of Disabled Children NUM2
BVETL Conversion flag CHAR001
BVATL Number of other dependants under 65 DEC3
BVAMT Number of disabled dependants under 65 DEC3
BVPCT Total Tax Percentage Rate DEC3_2
BVFOR Taxable Part Belgium P12_BVFOR
BVRES Resident CHAR1
BV281 Code for 281 Tax Slip P12_BV281
BVBAR Employee specification CHAR2
NR65S Number of Dependents as of Age 65 Years NUM2
N65SD Number of Disabled Dependants as of 65 NUM2
BVEXC Reason for Tax Exemption P12_BVEXC
CRN65 Number of dependents over 65 with care needs NUM2
BVBKV Foreign executive or researcher CHAR1
Master Data Relations Join Conditions
Company Code
  • P2RB_ST.MANDT == T001.MANDT
  • P2RB_ST.BUKRS == T001.BUKRS
Partner's Profession
  • Partner's Profession
  • Client
  • P2RB_ST.BVECH == T5B12.BVECH
  • P2RB_ST.MANDT == T5B12.MANDT
Marital Status
  • Marital Status
  • Client
  • P2RB_ST.BVFAM == T5B14.BVFAM
  • P2RB_ST.MANDT == T5B14.MANDT
Tax Calculation Method
  • P2RB_ST.MANDT == T5B11.MANDT
  • P2RB_ST.BVTAX == T5B11.BVTAX
Leave Regulation Tax
  • P2RB_ST.MANDT == T5B13.MANDT
  • P2RB_ST.BVVAK == T5B13.BVVAK
Contract Type
  • P2RB_ST.MANDT == T547V.MANDT
  • P2RB_ST.CTTYP == T547V.CTTYP
Employee Group
  • Employee Group
  • Client
  • P2RB_ST.PERSG == T501.PERSG
  • P2RB_ST.MANDT == T501.MANDT
Employee Subgroup
  • Employee Subgroup
  • Client
  • P2RB_ST.PERSK == T503K.PERSK
  • P2RB_ST.MANDT == T503K.MANDT
Currency Key
  • P2RB_ST.MANDT == TCURC.MANDT
  • P2RB_ST.WAERS == TCURC.WAERS
Plant
  • P2RB_ST.MANDT == T001W.MANDT
  • P2RB_ST.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Subarea
  • Personnel Subarea
  • ?
  • P2RB_ST.MANDT == T001P.MANDT
  • P2RB_ST.BTRTL == T001P.BTRTL
  • P2RB_ST.[column in domain "PERSA"] == T001P.WERKS