SAP CRMS4S_IU_CON_ADR_ADV_QRY table - Connection Object Query - Advanced Address search details in SAP

SAP CRMS4S_IU_CON_ADR_ADV_QRY table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

Object Name: CRMS4S_IU_CON_ADR_ADV_QRY
Dictionary Type: Structure
Description: Connection Object Query - Advanced Address search

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

Details

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279

View list of all SAP tables(S4H/ECC)

Select data from SAP table