SAP P06_DSN_EMPL table - DSN, section S21.G00.30: employee identification details in SAP

SAP P06_DSN_EMPL table summary

Object Name: P06_DSN_EMPL
Dictionary Type: Structure
Description: DSN, section S21.G00.30: employee identification

Field list for P06_DSN_EMPL table on an S/4 SAP system

Details

P06_DSN_EMPL-EMNIR table field - Social insurance number ▼

Description: Social insurance number
Field Name: EMNIR
Data Element: NUMSS
Data Type: CHAR
length (Dec): 13(0)
Check table:
Conversion Routine:
Domain Name: NUMSS
MemoryID:
AppClass: PNF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMNIR

P06_DSN_EMPL-EMNAP table field - Last name ▼

Description: Last name
Field Name: EMNAP
Data Element: P06_DSN_NOMFAMILLE
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMNAP

P06_DSN_EMPL-EMNAM table field - Customary name, married name... ▼

Description: Customary name, married name...
Field Name: EMNAM
Data Element: P06_NOMUSA
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: TEXT80
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMNAM

P06_DSN_EMPL-EMVOR table field - First names ▼

Description: First names
Field Name: EMVOR
Data Element: P06_DSN_EMVOR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMVOR

P06_DSN_EMPL-EMGES table field - Gender ▼

Description: Gender
Field Name: EMGES
Data Element: P06_DSN_GENDER
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: P06_DSN_GENDER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMGES

P06_DSN_EMPL-EMGBD table field - Birth date ▼

Description: Birth date
Field Name: EMGBD
Data Element: P06_DATENAISS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMGBD

P06_DSN_EMPL-EMGBO table field - Place of birth ▼

Description: Place of birth
Field Name: EMGBO
Data Element: P06_DSN_GBORT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMGBO

P06_DSN_EMPL-EMNEN table field - Street number, extension, type and name ▼

Description: Street number, extension, type and name
Field Name: EMNEN
Data Element: P06_DSN_NENLV
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMNEN

P06_DSN_EMPL-EMPST table field - Postal Code ▼

Description: Postal Code
Field Name: EMPST
Data Element: PSTLZ_HR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: PSTLZ
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPST

P06_DSN_EMPL-EMLOC table field - Town/City ▼

Description: Town/City
Field Name: EMLOC
Data Element: P06_DSN_LOCALITE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMLOC

P06_DSN_EMPL-EMPCO table field - Country code ▼

Description: Country code
Field Name: EMPCO
Data Element: P06_ADCPY
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMPCO

P06_DSN_EMPL-EMADD table field - Delivery code abroad ▼

Description: Delivery code abroad
Field Name: EMADD
Data Element: P06_ADDST
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMADD

P06_DSN_EMPL-EMCUE table field - EU coding ▼

Description: EU coding
Field Name: EMCUE
Data Element: P06_DSN_CODIF_UE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMCUE

P06_DSN_EMPL-EMCDN table field - Birth department code ▼

Description: Birth department code
Field Name: EMCDN
Data Element: P06_DPTNAISS
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMCDN

P06_DSN_EMPL-EMCOP table field - Country of birth indicator ▼

Description: Country of birth indicator
Field Name: EMCOP
Data Element: P06_DSN_EMCOP
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: CHAR2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMCOP

P06_DSN_EMPL-EMCPL table field - Building location affix ▼

Description: Building location affix
Field Name: EMCPL
Data Element: P06_ADCPL
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMCPL

P06_DSN_EMPL-EMSRV table field - Distribution service, street location affix ▼

Description: Distribution service, street location affix
Field Name: EMSRV
Data Element: P06_ADSRV
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMSRV

View list of all SAP tables(S4H/ECC)

Select data from SAP table