SAP ABAP Table DMF_S_LOCATION_ADDR (External View on Location address)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD (Application Component) Logistics Basic Data
     ⤷ DMF_DDIC (Package) Data Dictionary Objects for DMF

Basic Data

Table Category	INTTAB	Structure
Structure	DMF_S_LOCATION_ADDR	Table Relationship Diagram
Short Description	External View on Location address

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EXT_LOCATION_ID	☐	DMF_LOCATION	DMF_LOCATION	CHAR	60	0	DMF Location (/DMF/EXT_LOCATION_ID)
2	LOCATION_TCD	☐	DMF_LOCATION_TYPE_CODE	DMF_LOCATION_TYPE_CODE	CHAR	4	0	Location Type Code (/DMF/LOCATION_TYPE_CODE)
3	FUNCTION	☐	DMF_FUNCTION	DMF_FUNCTION_CODE	CHAR	1	0	Function Code
4	ADDRESS_ID	☐	DMF_ADDRESS	AD_ADDRNUM	CHAR	10	0	Address ID (/DMF/ADDRESS)	*
5	TITLE	☐	DMF_ADDRESS_AD_TITLE	AD_TITLE	CHAR	4	0	Form of Address ID (/DMF/ADDRESS_AD_TITLE)	*
6	PHONE_NUM	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
7	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
8	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
9	STATE	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
10	NAME	☐	DMF_ADDRESS_AD_NAME1	TEXT40	CHAR	40	0	Name 1 (/DMF/ADDRESS_AD_NAME1)
11	NAME_2	☐	DMF_ADDRESS_AD_NAME2	TEXT40	CHAR	40	0	Name 2 (/DMF/ADDRESS_AD_NAME2)
12	NAME_3	☐	DMF_ADDRESS_AD_NAME3	TEXT40	CHAR	40	0	Name 3 (/DMF/ADDRESS_AD_NAME3)
13	NAME_4	☐	DMF_ADDRESS_AD_NAME4	TEXT40	CHAR	40	0	Name 4 (/DMF/ADDRESS_AD_NAME4)
14	C_O_NAME	☐	DMF_ADDRESS_AD_NAME_CO	TEXT40	CHAR	40	0	c/o Name(/DMF/ADDRESS_AD_NAME_CO)
15	CITY	☐	DMF_ADDRESS_AD_CITY1	TEXT40	CHAR	40	0	City (/DMF/ADDRESS_AD_CITY1)
16	DISTRICT	☐	DMF_ADDRESS_AD_CITY2	TEXT40	CHAR	40	0	District (/DMF/ADDRESS_AD_CITY2)
17	CITY_NO	☐	DMF_ADDRESS_AD_CITYNUM	CITY_CODE	CHAR	12	0	City Code for City/Street File (/DMF/ADDRESS_AD_CITYNUM)	*
18	DISTRCT_NO	☐	DMF_ADDRESS_AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street (/DMF/ADDRESS_AD_CITYPNM)	*
19	CHCKSTATUS	☐	DMF_ADDRESS_AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status (/DMF/ADDRESS_AD_CHECKST)
20	REGIOGROUP	☐	DMF_ADDRESS_REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional Structure Grouping (/DMF/ADDRESS_REGIOGROUP)	*
21	POSTL_COD1	☐	DMF_ADDRESS_AD_PSTCD1	CHAR10	CHAR	10	0	City Postal Code (/DMF/ADDRESS_AD_PSTCD1)
22	POSTL_COD2	☐	DMF_ADDRESS_AD_PSTCD2	CHAR10	CHAR	10	0	PO Box Postal Code (/DMF/ADDRESS_AD_PSTCD2)
23	POSTL_COD3	☐	DMF_ADDRESS_AD_PSTCD3	CHAR10	CHAR	10	0	Company Postal Code (/DMF/ADDRESS_AD_PSTCD3)
24	PCODE1_EXT	☐	DMF_ADDRESS_AD_PST1XT	CHAR10	CHAR	10	0	City Postal Code Extension (/DMF/ADDRESS_AD_PST1XT)
25	PCODE2_EXT	☐	DMF_ADDRESS_AD_PST2XT	CHAR10	CHAR	10	0	PO Box Postal Code Extension (/DMF/ADDRESS_AD_PST2XT)
26	PCODE3_EXT	☐	DMF_ADDRESS_AD_PST3XT	CHAR10	CHAR	10	0	Major Cust. Postal Code Extension (/DMF/ADDRESS_AD_PST3XT)
27	PO_BOX	☐	DMF_ADDRESS_AD_POBX	CHAR10	CHAR	10	0	PO Box (/DMF/ADDRESS_AD_POBX)
28	PO_W_O_NO	☐	DMF_ADDRESS_AD_POBXNUM	XFELD	CHAR	1	0	PO Box Without Number (/DMF/ADDRESS_AD_POBXNUM)
29	PO_BOX_CIT	☐	DMF_ADDRESS_AD_POBXLOC	TEXT40	CHAR	40	0	PO Box City (/DMF/ADDRESS_AD_POBXLOC)
30	PBOXCIT_NO	☐	DMF_ADDRESS_AD_POBXLOC	TEXT40	CHAR	40	0	PO Box City (/DMF/ADDRESS_AD_POBXLOC)
31	PO_BOX_REG	☐	DMF_ADDRESS_AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (/DMF/ADDRESS_AD_POBXREG)	*
32	POBOX_CTRY	☐	DMF_ADDRESS_AD_POBXCTY	LAND1	CHAR	3	0	PO Box Country (/DMF/ADDRESS_AD_POBXCTY)	*
33	PO_CTRYISO	☐	DMF_ADDRESS_INTCA	INTCA	CHAR	2	0	Country ISO Code (/DMF/ADDRESS_INTCA)
34	DELIV_DIS	☐	DMF_ADDRESS_AD_PSTLAR	TEXT15	CHAR	15	0	Post Delivery District (/DMF/ADDRESS_AD_PSTLAR)
35	TRANSPZONE	☐	DMF_ADDRESS_LZONE	ZONE	CHAR	10	0	Transportation Zone (/DMF/ADDRESS_LZONE)	*
36	STREET	☐	DMF_ADDRESS_AD_STREET	TEXT60	CHAR	60	0	Street (/DMF/ADDRESS_AD_STREET)
37	STREET_NO	☐	DMF_ADDRESS_AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File (/DMF/ADDRESS_AD_STRNUM)	*
38	STR_ABBR	☐	DMF_ADDRESS_AD_STRABBR	STRTYPEAB	CHAR	2	0	Abbreviation of Street Name (/DMF/ADDRESS_AD_STRABBR)	*
39	HOUSE_NO1	☐	DMF_ADDRESS_AD_HSNM1	TEXT10	CHAR	10	0	House Number (/DMF/ADDRESS_AD_HSNM1)
40	HOUSE_NO2	☐	DMF_ADDRESS_AD_HSNM2	TEXT10	CHAR	10	0	House number supplement (/DMF/ADDRESS_AD_HSNM2)
41	HOUSE_NO3	☐	DMF_ADDRESS_AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range (/DMF/ADDRESS_AD_HSNM3)
42	STR_SUPPL1	☐	DMF_ADDRESS_AD_STRSPP1	TEXT40	CHAR	40	0	Street 2 (/DMF/ADDRESS_AD_STRSPP1)
43	STR_SUPPL2	☐	DMF_ADDRESS_AD_STRSPP2	TEXT40	CHAR	40	0	Street 3 (/DMF/ADDRESS_AD_STRSPP2)
44	STR_SUPPL3	☐	DMF_ADDRESS_AD_STRSPP3	TEXT40	CHAR	40	0	Street 4 (/DMF/ADDRESS_AD_STRSPP3)
45	LOCATN	☐	DMF_ADDRESS_AD_LCTN	TEXT40	CHAR	40	0	Street 5 (/DMF/ADDRESS_AD_LCTN)
46	BUILDING	☐	DMF_ADDRESS_AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code) (/DMF/ADDRESS_AD_BLDNG)
47	FLOOR	☐	DMF_ADDRESS_AD_FLOOR	TEXT10	CHAR	10	0	Floor in building (/DMF/ADDRESS_AD_FLOOR)
48	ROOM_NO	☐	DMF_ADDRESS_AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number (/DMF/ADDRESS_AD_ROOMNUM)
49	COUNTRY	☐	DMF_COUNTRY_CODE	LAND1	CHAR	3	0	Data Element For the Country Key (/DMF/COUNTRY_CODE)	*
50	COUNTRYISO	☐	DMF_COUNTRY_CODE_ISO	INTCA	CHAR	2	0	Iso Code for Country (/DMF/COUNTRY_CODE_ISO)
51	LANGU	☐	DMF_LANGU	SPRAS	LANG	1	0	External Language (/DMF/LANGU)	*
52	LANGU_ISO	☐	DMF_LANGUAGE_ISO	LAISO	CHAR	2	0	ISO Code Language (/DMF/LANGUAGE_ISO)
53	REGION	☐	DMF_LOCATION_REGION	REGIO	CHAR	3	0	Region in an address (/DMF/LOCATION_REGION)	*
54	SORT1	☐	DMF_ADDRESS_AD_SORT1	CHAR20	CHAR	20	0	Search Term 1 (/DMF/ADDRESS_AD_SORT1)
55	SORT2	☐	DMF_ADDRESS_AD_SORT2	CHAR20	CHAR	20	0	Search Term 2 (/DMF/ADDRESS_AD_SORT2)
56	EXTENS_1	☐	DMF_ADDRESS_AD_EXTENS1	TEXT40	CHAR	40	0	Extension (/DMF/ADDRESS_AD_EXTENS1)
57	EXTENS_2	☐	DMF_ADDRESS_AD_EXTENS2	TEXT40	CHAR	40	0	Extension (/DMF/ADDRESS_AD_EXTENS2)
58	TIME_ZONE	☐	DMF_ADDRESS_AD_TZONE	TZNZONE	CHAR	6	0	Time Zone of Address (/DMF/ADDRESS_AD_TZONE)	*
59	TAXJURCODE	☐	DMF_ADDRESS_AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction (/DMF/ADDRESS_AD_TXJCD)
60	LANGU_CR	☐	DMF_ADDRESS_AD_LANGUCR	SPRAS	LANG	1	0	Address record creat. orig. lang. (/DMF/ADDRESS_AD_LANGUCR)	*
61	LANGUCRISO	☐	DMF_ADDRESS_LAISO	LAISO	CHAR	2	0	Language According to ISO 639 (/DMF/ADDRESS_LAISO)
62	COMM_TYPE	☐	DMF_ADDRESS_AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (/DMF/ADDRESS_AD_COMM)	*
63	HOME_CITY	☐	DMF_ADDRESS_AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city) (/DMF/ADDRESS_AD_CITY3)
64	CITYH_CODE	☐	DMF_ADDRESS_AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street (/DMF/ADDRESS_AD_CITYHNM)	*
65	DONT_USE_S	☐	DMF_ADDRESS_AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address - Undeliverable (/DMF/ADDRESS_AD_NO_USES)	*
66	DONT_USE_P	☐	DMF_ADDRESS_AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address - Undeliverable (/DMF/ADDRESS_AD_NO_USEP)	*

History

Last changed by/on	SAP	20110901
SAP Release Created in	605