C_FrcElmntOrgBusinessAddress

Consumption View for Business Address | view: CFEORGBUSADDR | Extraction: Not supported | Component: Force Element (S/4)
Tables used: GEOLOC, ADR2, ADRC, ADRCT, ADR6
Column Name Description
AddressNumber Address Number
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
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
FrcElmntOrgGeoLocPrecision Precision (street, postal code, ...) of a Geo location 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
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
FrcElmntOrgAddrSequenceNumber Sequence Number NUMC3
FrcElmntOrgAddrTelephoneNumber Telephone no.: dialling code+number CHAR30
FrcElmntOrgAddrTelExtension Telephone no.: Extension CHAR10
FrcElmntOrgAddrCellPhoneNumber Telephone no.: dialling code+number CHAR30
AddressText Address notes TEXT50
EmailAddress E-Mail Address AD_SMTPADR
FrcElmntOrgGeoLocationUUID GUID 16 SYSUUID
AddressID Address Number AD_ADDRNUM
FrcElmntOrgGeoLocLongitude Geo location longitude GEOLONLAT
FrcElmntOrgGeoLocLatitude Geo location latitude GEOLONLAT
FrcElmntOrgGeoLocAltitude Geo location height GEOALT
FrcElmntOrgGeoLocTimeZone Time Zone TZNZONE
FrcElmntOrgGeoLocCrtnDteTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
FrcElmntOrgGeoLocCreatedByUser User Name UNAME
FrcElmntOrgGeoLocChgdDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
FrcElmntOrgGeoLocLastChgdByUsr User Name UNAME
Master Data Relations Join Conditions
Address time zone
  • Address time zone
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == TTZZ.CLIENT
Communication Method C_FRCELMNTORGBUSINESSADDRESS.COMMUNICATIONMEDIUMTYPE == TSAC.COMM_TYPE
Country key
  • Country/Region Key
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.COUNTRYCODE == T005.LAND1
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • C_FRCELMNTORGBUSINESSADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • C_FRCELMNTORGBUSINESSADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Non-Delivery Reason
  • Street Address Undeliverable Flag
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRNONDELIVREASON == TSAD12.UNDELIVER
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == TSAD12.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRPOBOXCOUNTRY == T005.LAND1
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRPOBOXCOUNTRY == T005S.LAND1
  • C_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRPOBOXREGION == T005S.BLAND
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == T005S.MANDT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == TSAD3.CLIENT
  • C_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGADDRTITLE == TSAD3.TITLE
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == TSAD12.CLIENT
  • C_FRCELMNTORGBUSINESSADDRESS.FRCELMNTORGPOBOXNONDELIVRSN == TSAD12.UNDELIVER
Language C_FRCELMNTORGBUSINESSADDRESS.LANGUAGECODE == T002.SPRAS
Version ID for International Addresses C_FRCELMNTORGBUSINESSADDRESS.NATION == TSADV.NATION
Person number
  • Person Number
  • ?
  • ?
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.PERSONNUMBER == ADRP.PERSNUMBER
  • C_FRCELMNTORGBUSINESSADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • C_FRCELMNTORGBUSINESSADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == ADRP.CLIENT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_FRCELMNTORGBUSINESSADDRESS.COUNTRYCODE == T005S.LAND1
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == T005S.MANDT
  • C_FRCELMNTORGBUSINESSADDRESS.REGION == T005S.BLAND
Regional structure grouping
  • Regional structure grouping
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.REGIONALSTRUCTUREGROUPING == ADRREGGRP.REGIOGROUP
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == ADRREGGRP.CLIENT
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • Client
  • C_FRCELMNTORGBUSINESSADDRESS.COUNTRYCODE == TZONE.LAND1
  • C_FRCELMNTORGBUSINESSADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • C_FRCELMNTORGBUSINESSADDRESS.MANDT == TZONE.MANDT