/SCMTMS/CV_LocQuByPhysAdd

Helper View for Query By Physical Address | view: /SCMTMS/CV_LOC06 | Extraction: Not supported | Component: Location
Tables used: ADR2, ADRC, ADCP, ADRC, ADR6, ADR3, BUT000, /SCMB/LOC_BEGRU, /SAPAPO/LOC, /SAPAPO/LOCMAP
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
location_type_code Location Type Show values
lifecycle_status Location Life Cycle Status Code Show values
pobox_indicator Flag: PO Box Without Number Show values
mobile_phone_indicator Indicator: Telephone is a Mobile Telephone Show values
smsenabled_indicator Indicator: Telephone is SMS-Enabled Show values
bp_completed Business Purpose Completed Flag Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
location_id Location /SAPAPO/LOCNO
location_uuid Location UUID SYSUUID
iatacode International Air Transport Association Location Identifier /SAPAPO/LOC_IATACODE
unlocode United Nations Code for Trade and Transport Locations /SAPAPO/LOC_UNLOCODE
city_name City TEXT40
street_postal_code City postal code CHAR10
street_name Street TEXT60
house_id House Number TEXT10
additional_house_id House number supplement TEXT10
care_of_name c/o name TEXT40
district_name District TEXT40
additional_city_name City (different from postal city) TEXT40
pobox_postal_code PO Box Postal Code CHAR10
company_postal_code Company Postal Code (for Large Customers) CHAR10
pobox_deviating_city_name PO Box city TEXT40
street_prefix_name Street 2 TEXT40
additional_street_prefix_name Street 3 TEXT40
street_suffix_name Street 4 TEXT40
additional_street_suffix_name Street 5 TEXT40
building_id Building (Number or Code) TEXT20
floor_id Floor in building TEXT10
room_id Room or Apartment Number TEXT10
pobox_id PO Box CHAR10
search_term_1 Search Term 1 CHAR20
search_term_2 Search Term 2 CHAR20
first_line_name Name 1 TEXT40
second_line_name Name 2 TEXT40
third_line_name Name 3 TEXT40
fourth_line_name Name 4 TEXT40
fax_subscriber_id Fax number: dialling code+number CHAR30
fax_extension_id Fax no.: Extension CHAR10
tel_subscriber_id Telephone no.: dialling code+number CHAR30
tel_extension_id Telephone no.: Extension CHAR10
email_uri E-Mail Address AD_SMTPADR
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
City code for city/street file
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • City code for city/street file
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == ADRCITY.CLIENT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == ADRCITY.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == ADRCITY.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == ADRCITY.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.CITY == ADRCITY.CITY_CODE
Language key /SCMTMS/CV_LOCQUBYPHYSADD.CORRESPONDENCE_LANGUAGE_CODE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == T005.MANDT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == T005.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == T005.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == T005.LAND1
Country key
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == T005.MANDT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == T005.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == T005.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == TSAD3.CLIENT
  • /SCMTMS/CV_LOCQUBYPHYSADD.FORM_OF_ADDRESS == TSAD3.TITLE
Region code
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Region (State, Province, County)
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == T005S.MANDT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == T005S.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == T005S.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == T005S.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.REGION == T005S.BLAND
Regional structure grouping
  • Client
  • Regional structure grouping
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == ADRREGGRP.CLIENT
  • /SCMTMS/CV_LOCQUBYPHYSADD.REGION_GROUP == ADRREGGRP.REGIOGROUP
Street Number for City/Street File
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Street Number for City/Street File
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == ADRSTREET.CLIENT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == ADRSTREET.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == ADRSTREET.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == ADRSTREET.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.STREET == ADRSTREET.STRT_CODE
Country key
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == T005.MANDT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == T005.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == T005.LAND1
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
District code for City and Street file
  • Client
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • City code for city/street file
  • District code for City and Street file
  • /SCMTMS/CV_LOCQUBYPHYSADD.MANDT == ADRCITYPRT.CLIENT
  • /SCMTMS/CV_LOCQUBYPHYSADD.COUNTRY_CODE == ADRCITYPRT.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.FAX_COUNTRY_CODE == ADRCITYPRT.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.TEL_COUNTRY_CODE == ADRCITYPRT.COUNTRY
  • /SCMTMS/CV_LOCQUBYPHYSADD.CITY == ADRCITYPRT.CITY_CODE
  • /SCMTMS/CV_LOCQUBYPHYSADD.DISTRICT == ADRCITYPRT.CITYP_CODE