I_FrcElmntOrgAddressTP

Transactional Processing View for Force Element Org Address | view: IFEORGADDRTP | Extraction: Not supported | Component: Force Element (S/4)
Tables used: GEOLOC, HRP1952, ADR2, ADRC, ADRCT, ADR6
Column Name Description
ForceElementOrgID FK Object ID
FrcElmntOrgType FK Object Type
FrcElmntOrgSubType FK Subtype
FrcElmntOrgPlngStatus FK Planning Status
FrcElmntOrgValdtyStartDate Start Date
FrcElmntOrgValdtyEndDate End Date
Column Name Description
Column Name Description
Column Name Description
FrcElmntOrgValdtyStartDate Start Date
FrcElmntOrgValdtyEndDate End Date
FrcElmntOrgAddrFromDate Valid-from date - in current Release only 00010101 possible
FrcElmntOrgValdtyStartDateFoEd Start Date
FrcElmntOrgValdtyEndDateFoEd End Date
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
NumberOfForceElementOrg Number of Infotype Record With Same Key NUM03
Nation Version ID for International Addresses AD_NATION
FrcElmntOrgAddrGeoLocLongitude Geolocation Longitude GEOLONLAT
FrcElmntOrgAddrGeoLocLatitude Geolocation Latitude GEOLONLAT
FrcElmntOrgAddrGeoLocAltitude Geolocation Altitude GEOALT
FrcElmntOrgPlngStsCritlty null
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
FrcElmntOrgAddrGeoLocLonFoEd Geo location longitude GEOLONLAT
FrcElmntOrgAddrGeoLocLatFoEd Geo location latitude GEOLONLAT
FrcElmntOrgAddrGeoLocAltdFoEd Geo location height GEOALT
Master Data Relations Join Conditions
Address Number
  • Client
  • ?
  • ?
  • Address Number
  • Address Number
  • I_FRCELMNTORGADDRESSTP.MANDT == ADRC.CLIENT
  • I_FRCELMNTORGADDRESSTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_FRCELMNTORGADDRESSTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_FRCELMNTORGADDRESSTP.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • I_FRCELMNTORGADDRESSTP.ADDRESSID == ADRC.ADDRNUMBER
Address time zone
  • Address time zone
  • Client
  • I_FRCELMNTORGADDRESSTP.ADDRESSTIMEZONE == TTZZ.TZONE
  • I_FRCELMNTORGADDRESSTP.MANDT == TTZZ.CLIENT
Communication Method I_FRCELMNTORGADDRESSTP.COMMUNICATIONMEDIUMTYPE == TSAC.COMM_TYPE
Country key
  • Client
  • Country/Region Key
  • I_FRCELMNTORGADDRESSTP.MANDT == T005.MANDT
  • I_FRCELMNTORGADDRESSTP.COUNTRYCODE == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • I_FRCELMNTORGADDRESSTP.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • I_FRCELMNTORGADDRESSTP.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Object ID
  • Object ID
  • Plan Version
  • Client
  • Object Type
  • I_FRCELMNTORGADDRESSTP.FORCEELEMENTORGID == PLOGI.OBJID
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGPLANVERSION == PLOGI.PLVAR
  • I_FRCELMNTORGADDRESSTP.MANDT == PLOGI.MANDT
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGTYPE == PLOGI.OTYPE
Location Code
  • Location Code
  • Client
Non-Delivery Reason
  • Client
  • Street Address Undeliverable Flag
  • I_FRCELMNTORGADDRESSTP.MANDT == TSAD12.CLIENT
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRNONDELIVREASON == TSAD12.UNDELIVER
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRPOBOXCOUNTRY == T005.LAND1
  • I_FRCELMNTORGADDRESSTP.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRPOBOXCOUNTRY == T005S.LAND1
  • I_FRCELMNTORGADDRESSTP.MANDT == T005S.MANDT
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRPOBOXREGION == T005S.BLAND
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_FRCELMNTORGADDRESSTP.MANDT == TSAD3.CLIENT
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRTITLE == TSAD3.TITLE
Infotype
  • Infotype
  • Client
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGINFOTYPE == T778T.INFTY
  • I_FRCELMNTORGADDRESSTP.MANDT == T778T.MANDT
Plan Version
  • Plan Version
  • Client
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGPLANVERSION == T778P.PLVAR
  • I_FRCELMNTORGADDRESSTP.MANDT == T778P.MANDT
Planning Status
  • Planning Status
  • Client
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGPLNGSTATUS == T778S.ISTAT
  • I_FRCELMNTORGADDRESSTP.MANDT == T778S.MANDT
Non-Delivery Reason
  • PO Box Address Undeliverable Flag
  • Client
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGPOBOXNONDELIVRSN == TSAD12.UNDELIVER
  • I_FRCELMNTORGADDRESSTP.MANDT == TSAD12.CLIENT
Object Type
  • Client
  • Object Type
  • I_FRCELMNTORGADDRESSTP.MANDT == T778O.MANDT
  • I_FRCELMNTORGADDRESSTP.FRCELMNTORGTYPE == T778O.OTYPE
Language key I_FRCELMNTORGADDRESSTP.LANGUAGECODE == T002.SPRAS
Person number
  • ?
  • ?
  • Client
  • Person Number
  • I_FRCELMNTORGADDRESSTP.[column in domain "AD_NATION"] == ADRP.NATION
  • I_FRCELMNTORGADDRESSTP.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_FRCELMNTORGADDRESSTP.MANDT == ADRP.CLIENT
  • I_FRCELMNTORGADDRESSTP.PERSONNUMBER == ADRP.PERSNUMBER
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_FRCELMNTORGADDRESSTP.MANDT == T005S.MANDT
  • I_FRCELMNTORGADDRESSTP.COUNTRYCODE == T005S.LAND1
  • I_FRCELMNTORGADDRESSTP.REGION == T005S.BLAND
Regional structure grouping
  • Client
  • Regional structure grouping
  • I_FRCELMNTORGADDRESSTP.MANDT == ADRREGGRP.CLIENT
  • I_FRCELMNTORGADDRESSTP.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
  • I_FRCELMNTORGADDRESSTP.MANDT == TZONE.MANDT
  • I_FRCELMNTORGADDRESSTP.COUNTRYCODE == TZONE.LAND1
  • I_FRCELMNTORGADDRESSTP.TRANSPORTZONE == TZONE.ZONE1