SAP CRM_ISU_PRM_SEARCH_ADDR table - Search Structure for premises by address details in SAP

SAP CRM_ISU_PRM_SEARCH_ADDR table summary

Object Name: CRM_ISU_PRM_SEARCH_ADDR
Dictionary Type: Structure
Description: Search Structure for premises by address

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

Details

CRM_ISU_PRM_SEARCH_ADDR-NAME1 table field - Name (Field NAME1) in Uppercase for Search Help ▼

Description: Name (Field NAME1) in Uppercase for Search Help
Field Name: NAME1
Data Element: AD_MC_NAME
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 NAME1

CRM_ISU_PRM_SEARCH_ADDR-NAME2 table field - Name 2 ▼

Description: Name 2
Field Name: NAME2
Data Element: AD_NAME2
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 NAME2

CRM_ISU_PRM_SEARCH_ADDR-CITY1 table field - City name in Uppercase for Search Help ▼

Description: City name in Uppercase for Search Help
Field Name: CITY1
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 CITY1

CRM_ISU_PRM_SEARCH_ADDR-CITY2 table field - District ▼

Description: District
Field Name: CITY2
Data Element: AD_CITY2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_PART
SHLP Field: CITY_PART
ConvExit:

See all SAP tables containing field CITY2

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

CRM_ISU_PRM_SEARCH_ADDR-POST_CODE2 table field - PO Box Postal Code ▼

Description: PO Box Postal Code
Field Name: POST_CODE2
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 POST_CODE2

CRM_ISU_PRM_SEARCH_ADDR-POST_CODE3 table field - Company Postal Code (for Large Customers) ▼

Description: Company Postal Code (for Large Customers)
Field Name: POST_CODE3
Data Element: AD_PSTCD3
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_CODE3

CRM_ISU_PRM_SEARCH_ADDR-PO_BOX_LOC table field - PO Box city ▼

Description: PO Box city
Field Name: PO_BOX_LOC
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_LOC

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

CRM_ISU_PRM_SEARCH_ADDR-STR_SUPPL1 table field - Street 2 ▼

Description: Street 2
Field Name: STR_SUPPL1
Data Element: AD_STRSPP1
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 STR_SUPPL1

CRM_ISU_PRM_SEARCH_ADDR-STR_SUPPL2 table field - Street 3 ▼

Description: Street 3
Field Name: STR_SUPPL2
Data Element: AD_STRSPP2
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 STR_SUPPL2

CRM_ISU_PRM_SEARCH_ADDR-STR_SUPPL3 table field - Street 4 ▼

Description: Street 4
Field Name: STR_SUPPL3
Data Element: AD_STRSPP3
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 STR_SUPPL3

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

CRM_ISU_PRM_SEARCH_ADDR-HOUSE_NUM2 table field - House number supplement ▼

Description: House number supplement
Field Name: HOUSE_NUM2
Data Element: AD_HSNM2
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_NUM2

CRM_ISU_PRM_SEARCH_ADDR-HOUSE_NUM3 table field - (Not supported) House Number Range ▼

Description: (Not supported) House Number Range
Field Name: HOUSE_NUM3
Data Element: AD_HSNM3
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_NUM3

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

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

CRM_ISU_PRM_SEARCH_ADDR-SORT1 table field - Search Term 1 ▼

Description: Search Term 1
Field Name: SORT1
Data Element: AD_SORT1
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT1

CRM_ISU_PRM_SEARCH_ADDR-SORT2 table field - Search Term 2 ▼

Description: Search Term 2
Field Name: SORT2
Data Element: AD_SORT2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT2

CRM_ISU_PRM_SEARCH_ADDR-SORT_PHN table field - (Not Supported) Phonetic Search Sort Field ▼

Description: (Not Supported) Phonetic Search Sort Field
Field Name: SORT_PHN
Data Element: AD_SRTPHN
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT_PHN

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

CRM_ISU_PRM_SEARCH_ADDR-NAME1_LNG table field - Name 1 ▼

Description: Name 1
Field Name: NAME1_LNG
Data Element: AD_NAME1
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 NAME1_LNG

CRM_ISU_PRM_SEARCH_ADDR-CITY1_LNG table field - City ▼

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

CRM_ISU_PRM_SEARCH_ADDR-STREET_LNG table field - Street ▼

Description: Street
Field Name: STREET_LNG
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_LNG

CRM_ISU_PRM_SEARCH_ADDR-PO_BOX_LOBBY table field - PO Box Lobby ▼

Description: PO Box Lobby
Field Name: PO_BOX_LOBBY
Data Element: AD_PO_BOX_LBY
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 PO_BOX_LOBBY

CRM_ISU_PRM_SEARCH_ADDR-DELI_SERV_TYPE table field - Type of Delivery Service ▼

Description: Type of Delivery Service
Field Name: DELI_SERV_TYPE
Data Element: AD_DELIVERY_SERVICE_TYPE
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AD_DELIVERY_SERVICE_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELI_SERV_TYPE

CRM_ISU_PRM_SEARCH_ADDR-DELI_SERV_NUMBER table field - Number of Delivery Service ▼

Description: Number of Delivery Service
Field Name: DELI_SERV_NUMBER
Data Element: AD_DELIVERY_SERVICE_NUMBER
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 DELI_SERV_NUMBER

CRM_ISU_PRM_SEARCH_ADDR-COUNTY table field - County name in upper case for search help ▼

Description: County name in upper case for search help
Field Name: COUNTY
Data Element: AD_MC_COUNTY
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 COUNTY

CRM_ISU_PRM_SEARCH_ADDR-TOWNSHIP table field - Township name in upper case for search help ▼

Description: Township name in upper case for search help
Field Name: TOWNSHIP
Data Element: AD_MC_TWSHP
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 TOWNSHIP

CRM_ISU_PRM_SEARCH_ADDR-COUNTY_LNG table field - County ▼

Description: County
Field Name: COUNTY_LNG
Data Element: AD_COUNTY
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTCNTYNAME
SHLP Field: COUNTY
ConvExit:

See all SAP tables containing field COUNTY_LNG

CRM_ISU_PRM_SEARCH_ADDR-TOWNSHIP_LNG table field - Township ▼

Description: Township
Field Name: TOWNSHIP_LNG
Data Element: AD_TOWNSHIP
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTWSHPNAME
SHLP Field: TOWNSHIP
ConvExit:

See all SAP tables containing field TOWNSHIP_LNG

CRM_ISU_PRM_SEARCH_ADDR-VS_FLOOR table field - Floor in building ▼

Description: Floor in building
Field Name: VS_FLOOR
Data Element: AD_FLOOR
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 VS_FLOOR

CRM_ISU_PRM_SEARCH_ADDR-VS_ROOMNUMBER table field - Room or Apartment Number ▼

Description: Room or Apartment Number
Field Name: VS_ROOMNUMBER
Data Element: AD_ROOMNUM
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 VS_ROOMNUMBER

CRM_ISU_PRM_SEARCH_ADDR-VS_STR_SUPPL1 table field - Street 2 ▼

Description: Street 2
Field Name: VS_STR_SUPPL1
Data Element: AD_STRSPP1
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 VS_STR_SUPPL1

CRM_ISU_PRM_SEARCH_ADDR-VS_STR_SUPPL3 table field - Street 4 ▼

Description: Street 4
Field Name: VS_STR_SUPPL3
Data Element: AD_STRSPP3
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 VS_STR_SUPPL3

CRM_ISU_PRM_SEARCH_ADDR-VS_HOUSE_NUM2 table field - House number supplement ▼

Description: House number supplement
Field Name: VS_HOUSE_NUM2
Data Element: AD_HSNM2
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 VS_HOUSE_NUM2

CRM_ISU_PRM_SEARCH_ADDR-VS_LOCATION table field - Street 5 ▼

Description: Street 5
Field Name: VS_LOCATION
Data Element: AD_LCTN
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 VS_LOCATION

CRM_ISU_PRM_SEARCH_ADDR-VS_BUILDING table field - Building (Number or Code) ▼

Description: Building (Number or Code)
Field Name: VS_BUILDING
Data Element: AD_BLDNG
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VS_BUILDING

View list of all SAP tables(S4H/ECC)

Select data from SAP table