1. Home
  2. Resources
  3. SAP Tables
  4. P02_ELM_TMS_INT_PERNR_PART - ELM TemSe: Particulars

SAP Table P02_ELM_TMS_INT_PERNR_PART

ELM TemSe: Particulars

P02_ELM_TMS_INT_PERNR_PART (ELM TemSe: Particulars) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link P02_ELM_TMS_INT_PERNR_PART to other SAP tables.

P02_ELM_TMS_INT_PERNR_PART table fields

Field Data element Checktable Datatype Length Decimals
SECTN Forms: Section P02_DAQ_SECTN CHAR 4 0
CMPNY Enterprise (ELM) P02_ABREHELM T5CSL CHAR 8 0
AWSCH Application key Switzerland P02_ANWSCHCH T5C3I CHAR 4 0
INIDD ELM: Internal Institution ID P02_EMPFSL2 T5C52 CHAR 12 0
ABREH HR-CH: Payroll unit P02_ABREH CHAR 8 0
PERNR Personnel Number PERNR_D NUMC 8 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
RESD1 Reserved Field/Unused Field of Length 4 P02_NUSED4 CHAR 4 0
RESD2 Reserved Field/Unused Field of Length 4 P02_NUSED4 CHAR 4 0
RESD3 Reserved Field/Unused Field of Length 4 P02_NUSED4 CHAR 4 0
RESD4 Reserved Field/Unused Field of Length 4 P02_NUSED4 CHAR 4 0
AHVNR AHV number with the use of punctuation (social insur. CH) P02_AHVNR CHAR 14 0
SVNR Social Insurance Number with Punctuation (CH) P02_AHVNR2 CHAR 16 0
NACHN Last Name PAD_NACHN CHAR 40 0
VORNA First Name PAD_VORNA CHAR 40 0
GESCH Gender Key GESCH CHAR 1 0
NULL unknown
1 Male
2 Female
GBPAS Date of Birth According to Passport GBPAS DATS 8 0
NATIO Nationality NATSL CHAR 3 0
FAMST Marital Status Key FAMST T502T CHAR 1 0
SGPAR Indicator for Single Parent P02_SGPAR CHAR 1 0
X Yes
NULL No
CMPLN Additional Line for Postal Address (2. Line) P02_ELM_CMPLN CHAR 50 0
STRAS Street Without House Number P02_ELM_STRAS CHAR 60 0
POBOX P.O. Box (4. Line) P02_ELM_POBOX CHAR 20 0
LOCTY Locality Such As Region, Province (4.1 Line) P02_ELM_LOCTY CHAR 20 0
PSTLZ Postal Code PSTLZ_HR CHAR 10 0
ORT01 City PAD_ORT01 CHAR 40 0
LAND1 Country ISO code INTCA CHAR 2 0
NUSEL Reserved Field/Unused Field of Length 1 P02_NUSED1 CHAR 1 0
CNTRY Country for Mailing (6. Line) P02_ELM_CNTRY CHAR 40 0
RCANT Canton of Residence P02_ELM_WKANTO CHAR 2 0
AG Aargau
AI Appenzell Inner Rhoden
AR Appenzell Ausser Rhoden
BE Bern
BL Basel-Land
BS Basel-Stadt
FR Freiburg
GE Geneva
GL Glarus
GR Graubuenden
JU Jura
LU Lucerne
NE Neuchatel
NW Nidwalden
OW Obwalden
SG St. Gallen
SH Schaffhausen
SO Solothurn
SZ Schwyz
TG Thurgau
TI Ticino
UR Uri
VD Vaud
VS Valais
ZG Zug
ZH Zurich
EX Expatriates/No Canton of Residence
NUSE1 Reserved Field/Unused Field of Length 1 P02_NUSED1 CHAR 1 0
ASTAT Residence status AUFES CHAR 4 0
VINHA Level of Relationship to Owner of Enterprise P02_VINHA NUMC 2 0
00 Unknown
01 Not Related
02 Wife
03 Husband
04 Blood Relative
05 Sibling
06 Adopted Child
07 Foster Child

P02_ELM_TMS_INT_PERNR_PART foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P02_ELM_TMS_INT_PERNR_PART AWSCH P02_ELM_TMS_INT_PERNR_PART AWSCH T5C3I HR-CH: Application Key Switzerland ANWSCHLCH
P02_ELM_TMS_INT_PERNR_PART AWSCH SYST MANDT T5C3I HR-CH: Application Key Switzerland MANDT
P02_ELM_TMS_INT_PERNR_PART CMPNY SYST MANDT T5CSL Value Table Enterprises for ELM MANDT
P02_ELM_TMS_INT_PERNR_PART CMPNY P02_ELM_TMS_INT_PERNR_PART CMPNY T5CSL Value Table Enterprises for ELM ABREINHEIT
P02_ELM_TMS_INT_PERNR_PART CMPNY * T5CSL Value Table Enterprises for ELM ENDDA
P02_ELM_TMS_INT_PERNR_PART FAMST SYST MANDT T502T Marital Status Designators MANDT
P02_ELM_TMS_INT_PERNR_PART FAMST SYST LANGU T502T Marital Status Designators SPRSL
P02_ELM_TMS_INT_PERNR_PART FAMST P02_ELM_TMS_INT_PERNR_PART FAMST T502T Marital Status Designators FAMST
P02_ELM_TMS_INT_PERNR_PART INIDD SYST MANDT T5C52 Internal Institution ID MANDT
P02_ELM_TMS_INT_PERNR_PART INIDD P02_ELM_TMS_INT_PERNR_PART INIDD T5C52 Internal Institution ID INIDD