Location Address

: 0CRM_PR_LOCAT_ADDR_ATTR

This DataSource extracts the attributes of the new set type COM_LOCAT_ADDR (Postal Address). It uses extract structure CRMT_PR_LOCAT_ADDR_ATTR_BW to transfer its data. The name of the function module for extraction is CRM_PR_LOCAT_ADDR_EXTRACTOR.

Technical Data

Application Component	CRM (0CRM-IO)
Available as of Release	CRM 5.0
Shipment	BI Content 7.0.2 Add-On
Content Versions	None
RemoteCube-Capable	Yes
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`CLIENT`	Client	`COMM_PRODUCT`	`CLIENT`
`PRODUCT_GUID`	Internal Unique ID of Product	`COMM_PRODUCT`	`PRODUCT_GUID`
`LOGSYS`	Original System	`COMM_PRODUCT`	`LOGSYS`
`PRODUCT_ID`	Product ID	`COMM_PRODUCT`	`PRODUCT_ID`
`PRODUCT_TYPE`	Product Type	`COMM_PRODUCT`	`PRODUCT_TYPE`
`OBJECT_FAMILY`	Object Family	`COMM_PRODUCT`	`OBJECT_FAMILY`
`ADDRNUMBER`	Address Number	`COM_LOCAT_ADDR`	`ADDR_NUM`
`DATE_FROM`	Date Valid From	`ADRC`	`DATE_FROM`
`NATION`	International Address Version ID	`ADRC`	`NATION`
`DATE_TO`	Valid-To Date	`ADRC`	`DATE_TO`
`TITLE`	Form-Of-Address Key	`ADRC`	`TITLE`
`NAME1`	Name 1	`ADRC`	`NAME1`
`NAME2`	Name 2	`ADRC`	`NAME2`
`NAME3`	Name 3	`ADRC`	`NAME3`
`NAME4`	Name 4	`ADRC`	`NAME4`
`NAME_CO`	c/o name	`ADRC`	`NAME_CO`
`CITY1`	City	`ADRC`	`CITY1`
`CITY2`	District	`ADRC`	`CITY2`
`CITY_CODE`	City code for city/street file	`ADRC`	`CITY_CODE`
`CITYP_CODE`	District Code for City and Street File	`ADRC`	`CITY_CODE`
`HOME_CITY`	City (Different from Postal City)	`ADRC`	`HOME_CITY`
`CITYH_CODE`	Different City Coding for City/Street File	`ADRC`	`CITYH_CODE`
`REGIOGROUP`	Regional Structure Grouping	`ADRC`	`REGIOGROUP`
`POST_CODE1`	City Postal Code	`ADRC`	`POST_CODE1`
`POST_CODE2`	PO Box Postal Code	`ADRC`	`POST_CODE2`
`POST_CODE3`	Company Postal Code (For Large Customers)	`ADRC`	`POST_CODE3`
`PO_BOX`	PO Box	`ADRC`	`PO_BOX`
`PO_BOX_NUM`	Flag: PO Box Without Number	`ADRC`	`PO_BOX_NUM`
`PO_BOX_LOC`	PO Box City	`ADRC`	`PO_BOX_LOC`
`CITY_CODE2`	City PO Box Code (City File)	`ADRC`	`CITY_CODE2`
`PO_BOX_REG`	Region for PO Box (Country, State, Province)	`ADRC`	`PO_BOX_REG`
`PO_BOX_CTY`	PO Box Country	`ADRC`	`PO_BOX_CTY`
`TRANSPZONE`	Transportation Zone to or from Which the Goods Are Delivered	`ADRC`	`TRANSPZONE`
`STREET`	Street	`ADRC`	`STREET`
`STREETCODE`	Street Code for City/Street File	`ADRC`	`STREETCODE`
`HOUSE_NUM1`	House Number	`ADRC`	`HOUSE_NUM1`
`HOUSE_NUM2`	House Number Supplement	`ADRC`	`HOUSE_NUM2`
`STR_SUPPL1`	Street 2	`ADRC`	`STR_SUPPL1`
`STR_SUPPL2`	Street 3	`ADRC`	`STR_SUPPL2`
`STR_SUPPL3`	Street 4	`ADRC`	`STR_SUPPL3`
`LOCATION`	Street 5	`ADRC`	`LOCATION`
`BUILDING`	Building (Number or Code)	`ADRC`	`BUILDING`
`FLOOR`	Floor in Building	`ADRC`	`FLOOR`
`ROOMNUMBER`	Room or Apartment Number	`ADRC`	`ROOMNUMBER`
`COUNTRY`	Building (Number and Code)	`ADRC`	`COUNTRY`
`LANGU`	Floor in Building	`ADRC`	`FLOOR`
`REGION`	Room or Apartment Number	`ADRC`	`REGION`
`PERS_ADDR`	Country Key	`ADRC`	`PERS_ADDR`
`SORT1`	Language Key	`ADRC`	`SORT1`
`SORT2`	Region (State, Province, County)	`ADRC`	`SORT2`
`TEL_NUMBER`	Flag: This is a personal address	`ADRC`	`TEL_NUMBER`
`TEL_EXTENS`	First Telephone No.: Extension	`ADRC`	`TEL_EXTENS`
`FAX_NUMBER`	First Fax No.: Dialing Code + No.	`ADRC`	`FAX_NUMBER`
`FAX_EXTENS`	First Fax No.: Extension	`ADRC`	`FAX_EXTENS`
`EXTENSION1`	Extension (only for Data Conversion e.g. data line)	`ADRC`	`EXTENSION1`
`EXTENSION2`	Extension (Only or Data Conversion, eg. telebox)	`ADRC`	`EXTENSION2`
`TIME_ZONE`	Address Time Zone	`ADRC`	`TIME_ZONE`
`TAXJURCODE`	Tax Jurisdiction Code	`ADRC`	`TAXJURCODE`