SAP ICM_EMPLOYEE table - Generated Table for View details in SAP

SAP ICM_EMPLOYEE table summary

Object Name: ICM_EMPLOYEE
Dictionary Type: Table view
Description: Generated Table for View

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

Details

ICM_EMPLOYEE-MANDT table field - Client ▼

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

ICM_EMPLOYEE-PARTNER_GUID table field - Business Partner GUID ▼

Description: Business Partner GUID
Field Name: PARTNER_GUID
Data Element: BU_PARTNER_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARTNER_GUID

ICM_EMPLOYEE-ADDRESS_GUID table field - GUID of a Business Partner Workplace Address ▼

Description: GUID of a Business Partner Workplace Address
Field Name: ADDRESS_GUID
Data Element: BU_WP_ADDRESS_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRESS_GUID

ICM_EMPLOYEE-ADDRNUMBER table field - Address Number ▼

Description: Address Number
Field Name: ADDRNUMBER
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRNUMBER

ICM_EMPLOYEE-DATE_FROM_ADRC table field - Valid-from date - in current Release only 00010101 possible ▼

Description: Valid-from date - in current Release only 00010101 possible
Field Name: DATE_FROM_ADRC
Data Element: AD_DATE_FR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_FROM_ADRC

ICM_EMPLOYEE-NATION table field - Version ID for International Addresses ▼

Description: Version ID for International Addresses
Field Name: NATION
Data Element: AD_NATION
Data Type: CHAR
length (Dec): 1(0)
Check table: TSADV
Conversion Routine:
Domain Name: AD_NATION
MemoryID: ADDRESS_NATION
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATION

ICM_EMPLOYEE-PARTNER table field - Business Partner Number ▼

Description: Business Partner Number
Field Name: PARTNER
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field PARTNER

ICM_EMPLOYEE-PERSNUMBER_ADR2 table field - Person Number ▼

Description: Person Number
Field Name: PERSNUMBER_ADR2
Data Element: AD_PERSNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRP
Conversion Routine: ALPHA
Domain Name: AD_PERSNUM
MemoryID: CDT
AppClass:
SHLP: ADDRESS
SHLP Field: PERSNUMBER
ConvExit: ALPHA

See all SAP tables containing field PERSNUMBER_ADR2

ICM_EMPLOYEE-ADDRNUMBER_ADR2 table field - Address Number ▼

Description: Address Number
Field Name: ADDRNUMBER_ADR2
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRC
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRNUMBER_ADR2

ICM_EMPLOYEE-DATE_FROM_ADR2_ADR table field - Valid-from date - in current Release only 00010101 possible ▼

Description: Valid-from date - in current Release only 00010101 possible
Field Name: DATE_FROM_ADR2_ADR
Data Element: AD_DATE_FR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_FROM_ADR2_ADR

ICM_EMPLOYEE-CONSUMER_ADR2 table field - Sequence Number ▼

Description: Sequence Number
Field Name: CONSUMER_ADR2
Data Element: AD_CONSNUM
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUMC3
MemoryID:
AppClass: QSS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSUMER_ADR2

ICM_EMPLOYEE-PERSNUMBER_ADR6 table field - Person Number ▼

Description: Person Number
Field Name: PERSNUMBER_ADR6
Data Element: AD_PERSNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRP
Conversion Routine: ALPHA
Domain Name: AD_PERSNUM
MemoryID: CDT
AppClass:
SHLP: ADDRESS
SHLP Field: PERSNUMBER
ConvExit: ALPHA

See all SAP tables containing field PERSNUMBER_ADR6

ICM_EMPLOYEE-ADDRNUMBER_ADR6 table field - Address Number ▼

Description: Address Number
Field Name: ADDRNUMBER_ADR6
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: ADRC
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRNUMBER_ADR6

ICM_EMPLOYEE-DATE_FROM_ADR6_ADR table field - Valid-from date - in current Release only 00010101 possible ▼

Description: Valid-from date - in current Release only 00010101 possible
Field Name: DATE_FROM_ADR6_ADR
Data Element: AD_DATE_FR
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DATE_FROM_ADR6_ADR

ICM_EMPLOYEE-CONSNUMBER_ADR6 table field - Sequence Number ▼

Description: Sequence Number
Field Name: CONSNUMBER_ADR6
Data Element: AD_CONSNUM
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: NUMC3
MemoryID:
AppClass: QSS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONSNUMBER_ADR6

ICM_EMPLOYEE-PERSNUMBER table field - Person Number ▼

Description: Person Number
Field Name: PERSNUMBER
Data Element: AD_PERSNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: AD_PERSNUM
MemoryID: CDT
AppClass:
SHLP: ADDRESS
SHLP Field: PERSNUMBER
ConvExit: ALPHA

See all SAP tables containing field PERSNUMBER

ICM_EMPLOYEE-NAME_LAST table field - Last name of business partner (person) ▼

Description: Last name of business partner (person)
Field Name: NAME_LAST
Data Element: BU_NAMEP_L
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_LAST

ICM_EMPLOYEE-NAME_FIRST table field - First name of business partner (person) ▼

Description: First name of business partner (person)
Field Name: NAME_FIRST
Data Element: BU_NAMEP_F
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_FIRST

ICM_EMPLOYEE-AUGRP table field - Authorization Group ▼

Description: Authorization Group
Field Name: AUGRP
Data Element: BU_AUGRP
Data Type: CHAR
length (Dec): 4(0)
Check table: TB037
Conversion Routine:
Domain Name: BU_AUGRP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUGRP

ICM_EMPLOYEE-CITY1 table field - City ▼

Description: City
Field Name: CITY1
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY1

ICM_EMPLOYEE-POST_CODE1 table field - City postal code ▼

Description: City postal code
Field Name: POST_CODE1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE1

ICM_EMPLOYEE-STREET table field - Street ▼

Description: Street
Field Name: STREET
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET

ICM_EMPLOYEE-HOUSE_NUM1 table field - House Number ▼

Description: House Number
Field Name: HOUSE_NUM1
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NUM1

ICM_EMPLOYEE-COUNTRY table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

ICM_EMPLOYEE-REGION table field - Region (State, Province, County) ▼

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

ICM_EMPLOYEE-TELNR_LONG table field - Complete Number: Dialling Code+Number+Extension ▼

Description: Complete Number: Dialling Code+Number+Extension
Field Name: TELNR_LONG
Data Element: AD_TELNRLG
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELNR_LONG

ICM_EMPLOYEE-SMTP_ADDR table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: SMTP_ADDR
Data Element: AD_SMTPADR
Data Type: CHAR
length (Dec): 241(0)
Check table:
Conversion Routine: SXIDN
Domain Name: AD_SMTPADR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: SXIDN

See all SAP tables containing field SMTP_ADDR

View list of all SAP tables(S4H/ECC)

Select data from SAP table