1. Home
  2. Resources
  3. SAP Tables
  4. HCMT_BSP_PA_ES_R0002 - Spain Personal data

SAP Table HCMT_BSP_PA_ES_R0002

Spain Personal data

HCMT_BSP_PA_ES_R0002 (Spain Personal data) 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 HCMT_BSP_PA_ES_R0002 to other SAP tables.

HCMT_BSP_PA_ES_R0002 table fields

Field Data element Checktable Datatype Length Decimals
OBJECT_KEY HCM Object Key HCM_OBJECT_KEY CHAR 100 0
PERNR Personnel Number PERNR_D NUMC 8 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
SPRTX Lock indicator for HR master record (text) SPRPSTEXT CHAR 40 0
ITBLD Infotype Screen Control ITBLD CHAR 2 0
BEGDA Valid-From Date PAD_BEGDA DATS 8 0
ENDDA Valid To Date PAD_ENDDA DATS 8 0
ANRED Form-of-Address Key ANRDE T522G CHAR 1 0
ANREX Form of address text ANREX CHAR 5 0
KNZNM Name Format Indicator for Employee in a List KNZNM NUMC 2 0
NACHN Last Name PAD_NACHN CHAR 40 0
NAME2 Name at Birth PAD_NAME2 CHAR 40 0
VORNA First Name PAD_VORNA CHAR 40 0
INITS Initials INITS CHAR 10 0
VORSW Name Prefix VORSW T535N CHAR 15 0
VORS2 Second Name Prefix VORS2 T535N CHAR 15 0
TITEL Title TITEL T535N CHAR 15 0
PERID Document number PES_UI_0002_PRDNI CHAR 17 0
ID_TYPE Identity document type PES_IDTYPE CHAR 1 0
1 DNI (NIF)
2 Passport
3 European Union Residency Card
4 Work and Residency Permit
6 Alien identification number (NIE)
GBDAT Date of Birth GBDAT DATS 8 0
GBORT Birthplace PAD_GBORT CHAR 40 0
GBDEP State GBDEP T005S CHAR 3 0
BEZEI Description BEZEI20 CHAR 20 0
GBLND Country of Birth GBLND T005 CHAR 3 0
LANDX Country Name LANDX CHAR 15 0
SPRSL Communication Language PAD_SPRAS T002 LANG 1 0
NATIO Nationality NATSL T005 CHAR 3 0
NATIX Nationality NATIO CHAR 15 0
FAMST Marital Status Key FAMST T502T CHAR 1 0
FAMDT Valid From Date of Current Marital Status FAMDT DATS 8 0
ANZKD Number of Children ANZKD DEC 3 0
NACH2 Second Name PAD_NACH2 CHAR 40 0
FASEX Indicator: Gender of family member FASEX CHAR 1 0
GESC2 Gender Key GESCH CHAR 1 0
NULL unknown
1 Male
2 Female
TITL2 Second Title PAD_TITL2 T535N CHAR 15 0
NATI2 Second Nationality PAD_NATS2 T005 CHAR 3 0
NA2TX Nationality (long text) NATTX CHAR 15 0
NATI3 Third Nationality PAD_NATS3 T005 CHAR 3 0
NA3TX Nationality (long text) NATTX CHAR 15 0
KONFE Religious Denomination Key KONFE T516T CHAR 2 0
KITXT Religious Denomination KITXT CHAR 4 0
NAMZU Other Title NAMZU T535N CHAR 15 0

HCMT_BSP_PA_ES_R0002 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
HCMT_BSP_PA_ES_R0002 ANRED SYST MANDT T522G Title Keys MANDT
HCMT_BSP_PA_ES_R0002 ANRED HCMT_BSP_PA_ES_R0002 ANRED T522G Title Keys ANRED
HCMT_BSP_PA_ES_R0002 FAMST SYST LANGU T502T Marital Status Designators SPRSL
HCMT_BSP_PA_ES_R0002 FAMST HCMT_BSP_PA_ES_R0002 FAMST T502T Marital Status Designators FAMST
HCMT_BSP_PA_ES_R0002 FAMST SYST MANDT T502T Marital Status Designators MANDT
HCMT_BSP_PA_ES_R0002 GBDEP SYST MANDT T005S Taxes: Region (Province) Key MANDT
HCMT_BSP_PA_ES_R0002 GBDEP HCMT_BSP_PA_ES_R0002 GBLND T005S Taxes: Region (Province) Key LAND1
HCMT_BSP_PA_ES_R0002 GBDEP HCMT_BSP_PA_ES_R0002 GBDEP T005S Taxes: Region (Province) Key BLAND
HCMT_BSP_PA_ES_R0002 GBLND HCMT_BSP_PA_ES_R0002 GBLND T005 Countries LAND1
HCMT_BSP_PA_ES_R0002 GBLND SYST MANDT T005 Countries MANDT
HCMT_BSP_PA_ES_R0002 KONFE SYST MANDT T516T Religious Denomination Texts MANDT
HCMT_BSP_PA_ES_R0002 KONFE HCMT_BSP_PA_ES_R0002 SPRSL T516T Religious Denomination Texts SPRSL
HCMT_BSP_PA_ES_R0002 KONFE HCMT_BSP_PA_ES_R0002 KONFE T516T Religious Denomination Texts KONFE
HCMT_BSP_PA_ES_R0002 NAMZU SYST MANDT T535N Name affixes MANDT
HCMT_BSP_PA_ES_R0002 NAMZU * T535N Name affixes ART
HCMT_BSP_PA_ES_R0002 NAMZU HCMT_BSP_PA_ES_R0002 NAMZU T535N Name affixes TITEL
HCMT_BSP_PA_ES_R0002 NATI2 SYST MANDT T005 Countries MANDT
HCMT_BSP_PA_ES_R0002 NATI2 HCMT_BSP_PA_ES_R0002 NATI2 T005 Countries LAND1
HCMT_BSP_PA_ES_R0002 NATI3 SYST MANDT T005 Countries MANDT
HCMT_BSP_PA_ES_R0002 NATI3 HCMT_BSP_PA_ES_R0002 NATI3 T005 Countries LAND1
HCMT_BSP_PA_ES_R0002 NATIO HCMT_BSP_PA_ES_R0002 NATIO T005 Countries LAND1
HCMT_BSP_PA_ES_R0002 NATIO SYST MANDT T005 Countries MANDT
HCMT_BSP_PA_ES_R0002 SPRSL HCMT_BSP_PA_ES_R0002 SPRSL T002 Language Keys (Component BC-I18) SPRAS
HCMT_BSP_PA_ES_R0002 TITEL 'T' T535N Name affixes ART
HCMT_BSP_PA_ES_R0002 TITEL HCMT_BSP_PA_ES_R0002 TITEL T535N Name affixes TITEL
HCMT_BSP_PA_ES_R0002 TITEL SYST MANDT T535N Name affixes MANDT
HCMT_BSP_PA_ES_R0002 TITL2 SYST MANDT T535N Name affixes MANDT
HCMT_BSP_PA_ES_R0002 TITL2 * T535N Name affixes ART
HCMT_BSP_PA_ES_R0002 TITL2 HCMT_BSP_PA_ES_R0002 TITL2 T535N Name affixes TITEL
HCMT_BSP_PA_ES_R0002 VORS2 SYST MANDT T535N Name affixes MANDT
HCMT_BSP_PA_ES_R0002 VORS2 'V' T535N Name affixes ART
HCMT_BSP_PA_ES_R0002 VORS2 HCMT_BSP_PA_ES_R0002 VORS2 T535N Name affixes TITEL
HCMT_BSP_PA_ES_R0002 VORSW HCMT_BSP_PA_ES_R0002 VORSW T535N Name affixes TITEL
HCMT_BSP_PA_ES_R0002 VORSW SYST MANDT T535N Name affixes MANDT
HCMT_BSP_PA_ES_R0002 VORSW 'V' T535N Name affixes ART