SAP ADDR_KEY_2 table - Structure with Complete Address Key details in SAP

SAP ADDR_KEY_2 table summary

Object Name: ADDR_KEY_2
Dictionary Type: Structure
Description: Structure with Complete Address Key

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

Details

ADDR_KEY_2-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

ADDR_KEY_2-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

ADDR_KEY_2-ADDR_TYPE table field - Address type (1=Organization, 2=Person, 3=Contact person) ▼

Description: Address type (1=Organization, 2=Person, 3=Contact person)
Field Name: ADDR_TYPE
Data Element: AD_ADRTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_ADRTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDR_TYPE

ADDR_KEY_2-ADDRHANDLE table field - Handle for Creating Addresses/Persons (Bus. Addr. Services) ▼

Description: Handle for Creating Addresses/Persons (Bus. Addr. Services)
Field Name: ADDRHANDLE
Data Element: AD_HANDLE
Data Type: CHAR
length (Dec): 140(0)
Check table:
Conversion Routine:
Domain Name: TEXT140
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ADDRHANDLE

ADDR_KEY_2-PERSHANDLE table field - Handle for Creating Addresses/Persons (Bus. Addr. Services) ▼

Description: Handle for Creating Addresses/Persons (Bus. Addr. Services)
Field Name: PERSHANDLE
Data Element: AD_HANDLE
Data Type: CHAR
length (Dec): 140(0)
Check table:
Conversion Routine:
Domain Name: TEXT140
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSHANDLE

ADDR_KEY_2-DATE_FROM 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
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

ADDR_KEY_2-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: *
Conversion Routine:
Domain Name: AD_NATION
MemoryID: ADDRESS_NATION
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATION

View list of all SAP tables(S4H/ECC)

Select data from SAP table