P2RB_PENS

Pensioner's data (B) | #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
💲 Currency Key (T500C.WAERS):
BETRG Wage Type Amount for Payments
BETRT HR Payroll: Amount
BETPT Payroll: Amount per unit
BETRS HR Payroll: Amount
BETPS Payroll: Amount per unit
BETRO HR Payroll: Amount
BETPO Payroll: Amount per unit
Column Name Description
Column Name Description
ZDATE First payment date
BEGDA Start Date
ENDDA End Date
ENDVA Closing Date Pension Advantage
Column Name Description
Column Name Description Domain name
PERIO Periodicity P12_PERIO
CAFRD Career Fraction Numerator NUMC2
CAFRN Career fraction denominator NUMC2
LGART Wage Type LGART
ZFPER First payment period PABRP
REFNR Reference Number CHAR20
PENFN Pension File Number CHAR15
ORADV Origin of Advantage P12_ORADV
COZIV Code for ZIV Contribution P12_COZIV
KINPE Kind of Pension P12_KINPE
JURST Juridical Statute P12_JURST
KINCA Kind of Pension Calculation P12_KINCA
ANZHT HR payroll: Number PRANZHL
ANZHS HR payroll: Number PRANZHL
SIGN1 Sign amount field CHAR1
ANZHO HR payroll: Number PRANZHL
SIGN2 Sign amount field CHAR1
OBJPS Object Identification OBJPS
COADV Code of Advantage P12_COADV
INSTN Registration Number Institution P12_INSTN
CANCL Cancellation of Pension Advantage CHAR001
Master Data Relations Join Conditions
Currency Key
  • P2RB_PENS.MANDT == TCURC.MANDT
  • P2RB_PENS.WAERS == TCURC.WAERS