0RENTUNIT_ADR_ATTR

RE: Extraction Address for Rental Unit | #ATTR | Extraction method: F1 | No Delta | Component: Real Estate Management Master Data
Tables used: VIMIMVVIZNRNVIMI01VIOB39SANS1 ... +19 more
Column Name Description
BUKRS Company Code
SWENR Business Entity Number
SGENR Building Number
SGRNR Land Number for BE
SMENR Number of Rental Unit
ADDRNUMBER Address Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
Column Name Description
CHCKSTATUS City file test status Show values
PO_BOX_NUM Flag: PO Box Without Number Show values
PERS_ADDR Flag: This is a personal address Show values
FLAGCOMM2 Flag: Telephone number(s) defined Show values
FLAGCOMM3 Flag: Fax number(s) defined Show values
FLAGCOMM4 Flag: Teletex number(s) defined Show values
FLAGCOMM5 Flag: Telex number(s) defined Show values
FLAGCOMM6 Flag: E-mail address(es) defined Show values
FLAGCOMM7 Flag: RML (remote mail) addresse(s) defined Show values
FLAGCOMM8 Flag: X.400 addresse(s) defined Show values
FLAGCOMM9 Flag: RFC destination(s) defined Show values
Column Name Description Domain name
REOBJ BW RE: InfoObject Real Estate Object (WE, GE, GR) J_OBJNR
SMIVE Lease-Out Number VVSMIVE
TITLE Form-of-Address Key AD_TITLE
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
NAME3 Name 3 TEXT40
NAME4 Name 4 TEXT40
NAME_TEXT Converted name field (with form of address) TEXT50
NAME_CO c/o name TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
CITY_CODE City code for city/street file CITY_CODE
CITYP_CODE District code for City and Street file CITYP_CODE
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
CITY_CODE2 City PO box code (City file) CITY_CODE
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) REGIO
PO_BOX_CTY PO Box of Country/Region LAND1
POSTALAREA (Not Supported) Post Delivery District TEXT15
TRANSPZONE Transportation zone to or from which the goods are delivered ZONE
STREET Street TEXT60
STREETCODE Street Number for City/Street File STRT_CODE
STREETABBR (Not Supported) Abbreviation of Street Name STRTYPEAB
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
HOUSE_NUM3 (Not supported) House Number Range TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
LOCATION Street 5 TEXT40
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
COUNTRY Country/Region Key LAND1
LANGU Language Key SPRAS
REGION Region (State, Province, County) REGIO
ADDR_GROUP Address Group (Key) (Business Address Services) AD_GROUP
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGIN
MC_NAME1 Name (Field NAME1) in Uppercase for Search Help CHAR25
MC_CITY1 City name in Uppercase for Search Help CHAR25
MC_STREET Street Name in Uppercase for Search Help CHAR25
EXTENSION1 Extension (only for data conversion) (data line/telebox) TEXT40
EXTENSION2 Extension (only for data conversion) (data line/telebox) TEXT40
TIME_ZONE Address time zone TZNZONE
TAXJURCODE Tax Jurisdiction AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID
LANGU_CREA Address record creation original language SPRAS