P_FrcElmntOrgBusinessAddress

Basic Private View for Force Element Org Business Address | view: PFEORGBUSADDR | Extraction: Not supported | Component: Force Element (S/4)
Tables used: ADRC
Column Name Description
AddressNumber Address Number
FrcElmntOrgAddrFromDate Valid-from date - in current Release only 00010101 possible
Nation FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
FrcElmntOrgAddrFromDate Valid-from date - in current Release only 00010101 possible
FrcElmntOrgAddrToDate Valid-to date in current Release only 99991231 possible
Column Name Description
FrcElmntOrgIsPOBoxWthoutNmbr Flag: PO Box Without Number Show values
Column Name Description Domain name
FrcElmntOrgAddrName1 Name 1 TEXT40
FrcElmntOrgAddrName2 Name 2 TEXT40
FrcElmntOrgAddrName3 Name 3 TEXT40
FrcElmntOrgAddrName4 Name 4 TEXT40
FrcElmntOrgAddrCareOfName c/o name TEXT40
CityName City TEXT40
FrcElmntOrgAddrDistrict District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
FrcElmntOrgAddrPOBoxPostalCode PO Box Postal Code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
POBox PO Box CHAR10
FrcElmntOrgAddrPOBoxCityName PO Box city TEXT40
StreetName Street TEXT60
HouseNumber House Number TEXT10
FrcElmntOrgHsNmbrSuplmntText House number supplement TEXT10
FrcElmntOrgAddrStreetName2 Street 2 TEXT40
FrcElmntOrgAddrStreetName3 Street 3 TEXT40
FrcElmntOrgAddrStreetName4 Street 4 TEXT40
FrcElmntOrgAddrLocationName Street 5 TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
AddressSearchText1 Search Term 1 CHAR20
AddressSearchText2 Search Term 2 CHAR20
FrcElmntOrgAddrTelephoneNumber First telephone no.: dialling code+number CHAR30
FrcElmntOrgAddrTelExtension First Telephone No.: Extension CHAR10
AddressFaxNumber First Fax No.: Area Code + Number CHAR30
FrcElmntOrgAddrFaxNumberExtn First fax no.: extension CHAR10
FrcElmntOrgAddrTaxJurisdiction Tax Jurisdiction AD_TXJCD
FrcElmntOrgAddrPOBoxLobbyName PO Box Lobby TEXT40
FrcElmntOrgAddrDelivSrvcNumber Number of Delivery Service CHAR10
Master Data Relations Join Conditions
Address time zone
  • Client
  • Address time zone
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == TTZZ.CLIENT
  • P_FRCELMNTORGBUSINESSADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Communication Method P_FRCELMNTORGBUSINESSADDRESS.COMMUNICATIONMEDIUMTYPE == TSAC.COMM_TYPE
Country key
  • Client
  • Country/Region Key
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == T005.MANDT
  • P_FRCELMNTORGBUSINESSADDRESS.COUNTRYCODE == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • P_FRCELMNTORGBUSINESSADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • P_FRCELMNTORGBUSINESSADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Non-Delivery Reason
  • Client
  • Street Address Undeliverable Flag
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == TSAD12.CLIENT
  • P_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRNONDELIVREASON == TSAD12.UNDELIVER
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == T005.MANDT
  • P_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRPOBOXCOUNTRY == T005.LAND1
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == T005S.MANDT
  • P_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRPOBOXREGION == T005S.BLAND
  • P_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRPOBOXCOUNTRY == T005S.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == TSAD3.CLIENT
  • P_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRTITLE == TSAD3.TITLE
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == TSAD12.CLIENT
  • P_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGPOBOXNONDELIVRSN == TSAD12.UNDELIVER
Language key P_FRCELMNTORGBUSINESSADDRESS.LANGUAGECODE == T002.SPRAS
Version ID for International Addresses P_FRCELMNTORGBUSINESSADDRESS.NATION == TSADV.NATION
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == T005S.MANDT
  • P_FRCELMNTORGBUSINESSADDRESS.COUNTRYCODE == T005S.LAND1
  • P_FRCELMNTORGBUSINESSADDRESS.REGION == T005S.BLAND
Regional structure grouping
  • Client
  • Regional structure grouping
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == ADRREGGRP.CLIENT
  • P_FRCELMNTORGBUSINESSADDRESS.REGIONALSTRUCTUREGROUPING == ADRREGGRP.REGIOGROUP
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • P_FRCELMNTORGBUSINESSADDRESS.MANDT == TZONE.MANDT
  • P_FRCELMNTORGBUSINESSADDRESS.COUNTRYCODE == TZONE.LAND1
  • P_FRCELMNTORGBUSINESSADDRESS.TRANSPORTZONE == TZONE.ZONE1