P05TPRNL_EE_PD

Pension Return: Personal Data - Pers Level | #masterdata | Component: Reporting
Column Name Description
MANDT FK Client
APPL FK Subapplication
JUPER Legal Person
WERKS FK Personnel Area
REGYR For-Period Year
REGPE For-Period
SEQNO Sequence number
REPTP Reporting Type Show values
PERNR Personnel Number
BEGDA_IR Start Date Income Relationship
Column Name Description
Column Name Description
Column Name Description
BEGDA_IR Start Date Income Relationship
GBDAT Date of Birth
DDATE Date of Death
FAMDT Valid From Date of Current Marital Status
Column Name Description
REPTP Reporting Type Show values
ADDRTP Address Type Show values
GESCH Gender Show values
INVEX Individual exemptions Show values
GESCP Gender Partner Code Show values
Column Name Description Domain name
BSNCD Citizen Service Number [BSN] NUM9
NACHN Last Name NACHN
INITS Initials TEXT10
VORSW Name Prefix TITEL
NATIO Nationality LAND1
FAMST Marital Status Key FAMST
FANAP Birthname Partner PAD_NACHN
NPFXP Name Prefix Partner TITEL
INITP Initials Partner TEXT10
STRAS Street and House Number PAD_STRAS
HSNMR House Number PAD_HSNMR
POSTA Identification of an apartment in a building PAD_HSNMR
LOCAT 2nd address line PAD_LOCAT
PSTLZ Postal Code PSTLZ
ORT01 City PAD_ORT01
LAND1 ISO Code of the Country/Region INTCA
IBAN IBAN (International Bank Account Number) IBAN
EMAIL Communication: Long Identification/Number COMM_ID_LONG
NATUP Nationality P05_NANEN
PAD_NACHN Last Name PAD_NACHN
Master Data Relations Join Conditions
Subapplication
  • Subapplication
  • Client
  • ?
  • P05TPRNL_EE_PD.APPL == T596A.APPL
  • P05TPRNL_EE_PD.MANDT == T596A.MANDT
  • P05TPRNL_EE_PD.[column in domain "MOLGA"] == T596A.MOLGA
Client P05TPRNL_EE_PD.MANDT == T000.MANDT
Communication Language P05TPRNL_EE_PD.SPRSL == T002.SPRAS
Region (State, Province, County)
  • Nationality
  • Region (State, Province, County)
  • P05TPRNL_EE_PD.MANDT == T005S.MANDT
  • P05TPRNL_EE_PD.NATIO == T005S.LAND1
  • P05TPRNL_EE_PD.STATE == T005S.BLAND
Other Relations | to Master Data Relations ↑ Join Conditions
Personnel Area
  • P05TPRNL_EE_PD.MANDT == T500P.MANDT
  • P05TPRNL_EE_PD.WERKS == T500P.PERSA