SAP CRMS_CLM_SQ_BUSINESS_PARTNER table - Business Partner search conditions details in SAP

SAP CRMS_CLM_SQ_BUSINESS_PARTNER table summary

Object Name: CRMS_CLM_SQ_BUSINESS_PARTNER
Dictionary Type: Structure
Description: Business Partner search conditions

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

Details

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

CRMS_CLM_SQ_BUSINESS_PARTNER-ROLE table field - BP role ▼

Description: BP role
Field Name: ROLE
Data Element: BU_ROLE
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: BU_RLTYP
MemoryID:
AppClass:
SHLP: BUPA_ROLE
SHLP Field: RLTYP
ConvExit:

See all SAP tables containing field ROLE

CRMS_CLM_SQ_BUSINESS_PARTNER-SEARCH_TERM1 table field - Search Help Field 1 (Name 1/Last Name) ▼

Description: Search Help Field 1 (Name 1/Last Name)
Field Name: SEARCH_TERM1
Data Element: BU_MCNAME1
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH_TERM1

CRMS_CLM_SQ_BUSINESS_PARTNER-SEARCH_TERM2 table field - Search Help Field 2 (Name 2/First Name) ▼

Description: Search Help Field 2 (Name 2/First Name)
Field Name: SEARCH_TERM2
Data Element: BU_MCNAME2
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH_TERM2

CRMS_CLM_SQ_BUSINESS_PARTNER-TELEPHONE table field - Telephone number for determining caller ▼

Description: Telephone number for determining caller
Field Name: TELEPHONE
Data Element: AD_TELNRCL
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 TELEPHONE

CRMS_CLM_SQ_BUSINESS_PARTNER-EMAIL table field - E-Mail Address ▼

Description: E-Mail Address
Field Name: EMAIL
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 EMAIL

CRMS_CLM_SQ_BUSINESS_PARTNER-URL table field - URI address search field ▼

Description: URI address search field
Field Name: URL
Data Element: AD_URI2
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: CHAR50
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field URL

CRMS_CLM_SQ_BUSINESS_PARTNER-HOUSE_NUMBER table field - House Number ▼

Description: House Number
Field Name: HOUSE_NUMBER
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_NUMBER

CRMS_CLM_SQ_BUSINESS_PARTNER-STREET table field - Street Name in Uppercase for Search Help ▼

Description: Street Name in Uppercase for Search Help
Field Name: STREET
Data Element: AD_MC_STRT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET

CRMS_CLM_SQ_BUSINESS_PARTNER-CITY table field - City name in Uppercase for Search Help ▼

Description: City name in Uppercase for Search Help
Field Name: CITY
Data Element: AD_MC_CITY
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY

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

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

CRMS_CLM_SQ_BUSINESS_PARTNER-POSTAL_CODE table field - City postal code ▼

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

CRMS_CLM_SQ_BUSINESS_PARTNER-CONTACT table field - Business Partner: Contact Permission ▼

Description: Business Partner: Contact Permission
Field Name: CONTACT
Data Element: BU_CONTACT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BU_CONTACT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTACT

View list of all SAP tables(S4H/ECC)

Select data from SAP table