C_FrcElmntOrgAddressTP

Consumption View for Force Element Org Address | view: CFEORGADDRTP | Extraction: Not supported | Component: Force Element (S/4)
Tables used: TSAD12, TSAD12T, ADDRC_DELI_SERVT, ADDRC_DELI_SERV, TSAD3, TSAD3T, T005, T005T, TSAC, TSACT, /ISDFPS/GEOLOC, GEOLOC, ADRREGGRP, ADRREGGRPT, TTXD, TTXDT, T777S, T778S, T778U, T777U, USR02, DFS_FE_STRUCAUTH, T002, T002T, T005S, T005U, TTZZ, TTZZT, TZONE, TZONT, /ISDFPS/FORCE, HRP1952, ADR2, ADRC, ADRCT, HRP1950, ADR6, HRP1000, T77UA
Column Name Description
FrcElmntOrgType FK Object Type
ForceElementOrgID FK Object ID
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
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
Column Name Description Domain name
Nation Version ID for International Addresses
FrcElmntOrgAddrGeoLocLongitude Geolocation Longitude
FrcElmntOrgAddrGeoLocLatitude Geolocation Latitude
FrcElmntOrgAddrGeoLocAltitude Geolocation Altitude
FrcElmntOrgAddrGeoLocationText Location Description
FrcElmntOrgPlngStsCritlty null
FrcElmntOrgSubTypeName Subtype Text
FrcElmntOrgAddrName1 Name 1
FrcElmntOrgAddrName2 Name 2
FrcElmntOrgAddrName3 Name 3
FrcElmntOrgAddrName4 Name 4
FrcElmntOrgAddrCareOfName c/o name
CityName City
FrcElmntOrgAddrDistrict District TEXT40
HomeCityName City (different from postal city)
PostalCode City postal code
FrcElmntOrgAddrPOBoxPostalCode PO Box Postal Code
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
POBox PO Box CHAR10
AddressNonDeliverableReasonTxt Reason for Non-Delivery (Text) TEXT30
FrcElmntOrgIsPOBoxWthoutNmbr Flag: PO Box Without Number
FrcElmntOrgAddrPOBoxCityName PO Box city
StreetName Street
HouseNumber House Number
FrcElmntOrgHsNmbrSuplmntText House number supplement TEXT10
FrcElmntOrgAddrStreetName2 Street 2
FrcElmntOrgAddrStreetName3 Street 3
FrcElmntOrgAddrStreetName4 Street 4
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
AddressSearchText2 Search Term 2
AddressFaxNumber First Fax No.: Area Code + Number
FrcElmntOrgAddrFaxNumberExtn First fax no.: extension
FrcElmntOrgAddrTaxJurisdiction Tax Jurisdiction
FrcElmntOrgAddrPOBoxLobbyName PO Box Lobby
FrcElmntOrgAddrDelivSrvcNumber Number of Delivery Service CHAR10
FrcElmntOrgAddrSequenceNumber Sequence Number NUMC3
FrcElmntOrgAddrTelephoneNumber Telephone no.: dialling code+number
FrcElmntOrgAddrTelExtension Telephone no.: Extension
FrcElmntOrgAddrCellPhoneNumber Telephone no.: dialling code+number CHAR30
LanguageName Name of Language
AddressText Address notes TEXT50
EmailAddress E-Mail Address AD_SMTPADR
FrcElmntOrgGeoLocationUUID GUID 16 SYSUUID
FrcElmntOrgGeoLocLongitude Geo location longitude
FrcElmntOrgGeoLocLatitude Geo location latitude
FrcElmntOrgGeoLocAltitude Geo location height
FrcElmntOrgGeoLocPrecision Precision (street, postal code, ...) of a Geo location
FrcElmntOrgGeoLocTimeZone Time Zone
FrcElmntOrgGeoLocCrtnDteTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
FrcElmntOrgGeoLocCreatedByUser User Name
FrcElmntOrgGeoLocChgdDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
FrcElmntOrgGeoLocLastChgdByUsr User Name
FrcElmntOrgName Object Name TEXT40
FrcElmntOrgPlngStatusName Planning Status Name TEXT25
MstrProjCustContactTitleName Title text
FrcElmntOrgAddrRgnlGrpgDesc Text Field
RegionName Description TEXT20
CountryName Country/Region Name
TransportZoneDescription Description
FrcElmntOrgAddrCommTypeDesc Communication type description
TimeZoneText Time Zone Text TEXT30
FrcElmntOrgAddrTaxJxDesc Name of the Tax Jurisdiction Code Structure
DeliveryServiceText Delivery Service Description TEXT40
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
  • ?
  • ?
  • C_FRCELMNTORGADDRESSTP.MANDT == ADRC.CLIENT
  • C_FRCELMNTORGADDRESSTP.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • C_FRCELMNTORGADDRESSTP.[column in domain "AD_NATION"] == ADRC.NATION
  • C_FRCELMNTORGADDRESSTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Address time zone
  • Address time zone
  • Client
  • C_FRCELMNTORGADDRESSTP.ADDRESSTIMEZONE == TTZZ.TZONE
  • C_FRCELMNTORGADDRESSTP.MANDT == TTZZ.CLIENT
Communication Method C_FRCELMNTORGADDRESSTP.COMMUNICATIONMEDIUMTYPE == TSAC.COMM_TYPE
Country key
  • Client
  • Country/Region Key
  • C_FRCELMNTORGADDRESSTP.MANDT == T005.MANDT
  • C_FRCELMNTORGADDRESSTP.COUNTRYCODE == T005.LAND1
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • C_FRCELMNTORGADDRESSTP.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • C_FRCELMNTORGADDRESSTP.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Object ID
  • Client
  • Object Type
  • Object ID
  • Plan Version
  • C_FRCELMNTORGADDRESSTP.MANDT == PLOGI.MANDT
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGTYPE == PLOGI.OTYPE
  • C_FRCELMNTORGADDRESSTP.FORCEELEMENTORGID == PLOGI.OBJID
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGPLANVERSION == PLOGI.PLVAR
Location Code
  • Location Code
  • Client
Non-Delivery Reason
  • Street Address Undeliverable Flag
  • Client
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRNONDELIVREASON == TSAD12.UNDELIVER
  • C_FRCELMNTORGADDRESSTP.MANDT == TSAD12.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRPOBOXCOUNTRY == T005.LAND1
  • C_FRCELMNTORGADDRESSTP.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_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRPOBOXCOUNTRY == T005S.LAND1
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRPOBOXREGION == T005S.BLAND
  • C_FRCELMNTORGADDRESSTP.MANDT == T005S.MANDT
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGADDRTITLE == TSAD3.TITLE
  • C_FRCELMNTORGADDRESSTP.MANDT == TSAD3.CLIENT
Infotype
  • Client
  • Infotype
  • C_FRCELMNTORGADDRESSTP.MANDT == T778T.MANDT
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGINFOTYPE == T778T.INFTY
Plan Version
  • Client
  • Plan Version
  • C_FRCELMNTORGADDRESSTP.MANDT == T778P.MANDT
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGPLANVERSION == T778P.PLVAR
Planning Status
  • Client
  • Planning Status
  • C_FRCELMNTORGADDRESSTP.MANDT == T778S.MANDT
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGPLNGSTATUS == T778S.ISTAT
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • C_FRCELMNTORGADDRESSTP.MANDT == TSAD12.CLIENT
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGPOBOXNONDELIVRSN == TSAD12.UNDELIVER
Object Type
  • Client
  • Object Type
  • C_FRCELMNTORGADDRESSTP.MANDT == T778O.MANDT
  • C_FRCELMNTORGADDRESSTP.FRCELMNTORGTYPE == T778O.OTYPE
Language key C_FRCELMNTORGADDRESSTP.LANGUAGECODE == T002.SPRAS
Person number
  • Person Number
  • ?
  • ?
  • Client
  • C_FRCELMNTORGADDRESSTP.PERSONNUMBER == ADRP.PERSNUMBER
  • C_FRCELMNTORGADDRESSTP.[column in domain "AD_NATION"] == ADRP.NATION
  • C_FRCELMNTORGADDRESSTP.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_FRCELMNTORGADDRESSTP.MANDT == ADRP.CLIENT
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • C_FRCELMNTORGADDRESSTP.REGION == T005S.BLAND
  • C_FRCELMNTORGADDRESSTP.MANDT == T005S.MANDT
  • C_FRCELMNTORGADDRESSTP.COUNTRYCODE == T005S.LAND1
Regional structure grouping
  • Regional structure grouping
  • Client
  • C_FRCELMNTORGADDRESSTP.REGIONALSTRUCTUREGROUPING == ADRREGGRP.REGIOGROUP
  • C_FRCELMNTORGADDRESSTP.MANDT == ADRREGGRP.CLIENT
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • C_FRCELMNTORGADDRESSTP.TRANSPORTZONE == TZONE.ZONE1
  • C_FRCELMNTORGADDRESSTP.MANDT == TZONE.MANDT
  • C_FRCELMNTORGADDRESSTP.COUNTRYCODE == TZONE.LAND1