SAP ELMT_ITEM_DB table - Ext. List Management: Item Database Area details in SAP

SAP ELMT_ITEM_DB table summary

Object Name: ELMT_ITEM_DB
Dictionary Type: Structure
Description: Ext. List Management: Item Database Area

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

Details

ELMT_ITEM_DB-ITEM_GUID table field - Ext. List Management: GUID for Item in an Address List ▼

Description: Ext. List Management: GUID for Item in an Address List
Field Name: ITEM_GUID
Data Element: ELMT_ITEM_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: ELM_GUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ITEM_GUID

ELMT_ITEM_DB-LIST_ID table field - Ext. List Management: ID for Address List ▼

Description: Ext. List Management: ID for Address List
Field Name: LIST_ID
Data Element: ELMT_LIST_ID
Data Type: CHAR
length (Dec): 28(0)
Check table:
Conversion Routine:
Domain Name: ELM_LIST_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIST_ID

ELMT_ITEM_DB-LIST_GUID table field - Ext. List Mangement: GUID for Address List ▼

Description: Ext. List Mangement: GUID for Address List
Field Name: LIST_GUID
Data Element: ELMT_LIST_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: ELM_GUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIST_GUID

ELMT_ITEM_DB-BU_PARTNER table field - Business Partner Number ▼

Description: Business Partner Number
Field Name: BU_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 BU_PARTNER

ELMT_ITEM_DB-CONTACTED table field - Ext. List Management: Item Flag ▼

Description: Ext. List Management: Item Flag
Field Name: CONTACTED
Data Element: ELMT_ITEM_FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ELM_ITEM_FLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTACTED

ELMT_ITEM_DB-WON table field - Ext. List Management: Item Flag ▼

Description: Ext. List Management: Item Flag
Field Name: WON
Data Element: ELMT_ITEM_FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ELM_ITEM_FLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WON

ELMT_ITEM_DB-POSTAL_ERROR table field - Ext. List Management: Item Flag ▼

Description: Ext. List Management: Item Flag
Field Name: POSTAL_ERROR
Data Element: ELMT_ITEM_FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ELM_ITEM_FLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTAL_ERROR

ELMT_ITEM_DB-DUPLICATE table field - Ext. List Management: Item Flag ▼

Description: Ext. List Management: Item Flag
Field Name: DUPLICATE
Data Element: ELMT_ITEM_FLAG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: ELM_ITEM_FLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DUPLICATE

ELMT_ITEM_DB-CITY table field - City ▼

Description: City
Field Name: CITY
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 CITY

ELMT_ITEM_DB-POSTL_COD1 table field - City postal code ▼

Description: City postal code
Field Name: POSTL_COD1
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 POSTL_COD1

ELMT_ITEM_DB-POSTL_COD2 table field - PO Box Postal Code ▼

Description: PO Box Postal Code
Field Name: POSTL_COD2
Data Element: AD_PSTCD2
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 POSTL_COD2

ELMT_ITEM_DB-PO_BOX table field - PO Box ▼

Description: PO Box
Field Name: PO_BOX
Data Element: AD_POBX
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 PO_BOX

ELMT_ITEM_DB-PO_BOX_CIT table field - PO Box city ▼

Description: PO Box city
Field Name: PO_BOX_CIT
Data Element: AD_POBXLOC
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_NAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field PO_BOX_CIT

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

ELMT_ITEM_DB-HOUSE_NO table field - House Number ▼

Description: House Number
Field Name: HOUSE_NO
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_NO

ELMT_ITEM_DB-COUNTRYISO table field - ISO Code of the Country/Region ▼

Description: ISO Code of the Country/Region
Field Name: COUNTRYISO
Data Element: INTCA
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: INTCA
MemoryID:
AppClass:
SHLP: F4_INTCA
SHLP Field: INTCA
ConvExit:

See all SAP tables containing field COUNTRYISO

ELMT_ITEM_DB-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: *
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

ELMT_ITEM_DB-ID_NUMBER table field - Identification Number ▼

Description: Identification Number
Field Name: ID_NUMBER
Data Element: BU_ID_NUMBER
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID_NUMBER

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

ELMT_ITEM_DB-ORG_TITLE_KEY table field - Form-of-Address Key ▼

Description: Form-of-Address Key
Field Name: ORG_TITLE_KEY
Data Element: AD_TITLE
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AD_TITLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORG_TITLE_KEY

ELMT_ITEM_DB-ORG_NAME1 table field - Name 1 of organization ▼

Description: Name 1 of organization
Field Name: ORG_NAME1
Data Element: BU_NAMEOR1
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 ORG_NAME1

ELMT_ITEM_DB-ORG_NAME2 table field - Name 2 of organization ▼

Description: Name 2 of organization
Field Name: ORG_NAME2
Data Element: BU_NAMEOR2
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 ORG_NAME2

ELMT_ITEM_DB-ORG_NAME3 table field - Name 3 of organization ▼

Description: Name 3 of organization
Field Name: ORG_NAME3
Data Element: BU_NAMEOR3
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 ORG_NAME3

ELMT_ITEM_DB-ORG_LEGALFORM table field - BP: Legal form of organization ▼

Description: BP: Legal form of organization
Field Name: ORG_LEGALFORM
Data Element: BU_LEGENTY
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: BU_LEGENTY
MemoryID:
AppClass:
SHLP: H_TB019
SHLP Field: LEGAL_ENTY
ConvExit:

See all SAP tables containing field ORG_LEGALFORM

ELMT_ITEM_DB-ORG_FOUND_DATE table field - Date organization founded ▼

Description: Date organization founded
Field Name: ORG_FOUND_DATE
Data Element: BU_FOUND_DAT
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 ORG_FOUND_DATE

ELMT_ITEM_DB-ORG_TELEPHONE table field - Telephone no.: dialling code+number ▼

Description: Telephone no.: dialling code+number
Field Name: ORG_TELEPHONE
Data Element: AD_TLNMBR
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 ORG_TELEPHONE

ELMT_ITEM_DB-ORG_TEL_EXT table field - Telephone no.: Extension ▼

Description: Telephone no.: Extension
Field Name: ORG_TEL_EXT
Data Element: AD_TLXTNS
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 ORG_TEL_EXT

ELMT_ITEM_DB-ORG_FAX table field - Fax number: dialling code+number ▼

Description: Fax number: dialling code+number
Field Name: ORG_FAX
Data Element: AD_FXNMBR
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 ORG_FAX

ELMT_ITEM_DB-ORG_FAX_EXT table field - Fax no.: Extension ▼

Description: Fax no.: Extension
Field Name: ORG_FAX_EXT
Data Element: AD_FXXTNS
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 ORG_FAX_EXT

ELMT_ITEM_DB-ORG_URI table field - Ext. List Management: URI Organization ▼

Description: Ext. List Management: URI Organization
Field Name: ORG_URI
Data Element: ELMT_URI
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: ELM_URI
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORG_URI

ELMT_ITEM_DB-PERS_TITLE_KEY table field - Form-of-Address Key ▼

Description: Form-of-Address Key
Field Name: PERS_TITLE_KEY
Data Element: AD_TITLE
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AD_TITLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERS_TITLE_KEY

ELMT_ITEM_DB-PERS_FIRSTNAME table field - First name of business partner (person) ▼

Description: First name of business partner (person)
Field Name: PERS_FIRSTNAME
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 PERS_FIRSTNAME

ELMT_ITEM_DB-PERS_LASTNAME table field - Last name of business partner (person) ▼

Description: Last name of business partner (person)
Field Name: PERS_LASTNAME
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 PERS_LASTNAME

ELMT_ITEM_DB-PERS_INITIAL table field - Middle name or second forename of a person ▼

Description: Middle name or second forename of a person
Field Name: PERS_INITIAL
Data Element: BU_NAMEMID
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 PERS_INITIAL

ELMT_ITEM_DB-PERS_TITLE_ACA1 table field - Academic Title: Key ▼

Description: Academic Title: Key
Field Name: PERS_TITLE_ACA1
Data Element: AD_TITLE1
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: AD_TITLE1
MemoryID:
AppClass:
SHLP: AD_TITLE1
SHLP Field: TITLE_KEY
ConvExit:

See all SAP tables containing field PERS_TITLE_ACA1

ELMT_ITEM_DB-PERS_BIRTHDATE table field - Date of Birth of Business Partner ▼

Description: Date of Birth of Business Partner
Field Name: PERS_BIRTHDATE
Data Element: BU_BIRTHDT
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 PERS_BIRTHDATE

ELMT_ITEM_DB-PERS_SEX table field - Sex of business partner (person) ▼

Description: Sex of business partner (person)
Field Name: PERS_SEX
Data Element: BU_SEXID
Data Type: CHAR
length (Dec): 1(0)
Check table: *
Conversion Routine:
Domain Name: BU_SEXID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERS_SEX

ELMT_ITEM_DB-PERS_MARITALSTAT table field - Marital Status of Business Partner ▼

Description: Marital Status of Business Partner
Field Name: PERS_MARITALSTAT
Data Element: BU_MARST
Data Type: CHAR
length (Dec): 1(0)
Check table: *
Conversion Routine:
Domain Name: BU_MARST
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERS_MARITALSTAT

ELMT_ITEM_DB-PERS_TELEPHON table field - Telephone no.: dialling code+number ▼

Description: Telephone no.: dialling code+number
Field Name: PERS_TELEPHON
Data Element: AD_TLNMBR
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 PERS_TELEPHON

ELMT_ITEM_DB-PERS_TEL_EXT table field - Telephone no.: Extension ▼

Description: Telephone no.: Extension
Field Name: PERS_TEL_EXT
Data Element: AD_TLXTNS
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 PERS_TEL_EXT

ELMT_ITEM_DB-PERS_FAX table field - Fax number: dialling code+number ▼

Description: Fax number: dialling code+number
Field Name: PERS_FAX
Data Element: AD_FXNMBR
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 PERS_FAX

ELMT_ITEM_DB-PERS_FAX_EXT table field - Fax no.: Extension ▼

Description: Fax no.: Extension
Field Name: PERS_FAX_EXT
Data Element: AD_FXXTNS
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 PERS_FAX_EXT

ELMT_ITEM_DB-PERS_E_MAIL table field - Ext. List Management: Email Address Person ▼

Description: Ext. List Management: Email Address Person
Field Name: PERS_E_MAIL
Data Element: ELMT_EMAIL
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: ELM_EMAIL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERS_E_MAIL

ELMT_ITEM_DB-PERS_PAGER table field - Pager number ▼

Description: Pager number
Field Name: PERS_PAGER
Data Element: AD_PAGNMBR
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERS_PAGER

ELMT_ITEM_DB-CP_FUNCTIONNAME table field - Function name of partner ▼

Description: Function name of partner
Field Name: CP_FUNCTIONNAME
Data Element: BU_FNCTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CP_FUNCTIONNAME

ELMT_ITEM_DB-CP_FUNCTIONKEY table field - Function of partner ▼

Description: Function of partner
Field Name: CP_FUNCTIONKEY
Data Element: BU_PAFKT
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: BU_PAFKT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CP_FUNCTIONKEY

ELMT_ITEM_DB-ITEM_CUSTOMER_EXT table field - Dummy function in length 1 ▼

Description: Dummy function in length 1
Field Name: ITEM_CUSTOMER_EXT
Data Element: DUMMY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DUMMY
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ITEM_CUSTOMER_EXT

View list of all SAP tables(S4H/ECC)

Select data from SAP table