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