SAP ABAP Table EKUNADRD (Screen Fields: Cust. Addr. and Communication for Subscreens)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	EKUNADRD	Table Relationship Diagram
Short Description	Screen Fields: Cust. Addr. and Communication for Subscreens

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	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
2	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
3	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
4	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
5	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
7	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
8	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
10	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
11	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
12	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	*
13	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
14	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
15	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
16	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
17	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
18	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
19	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
20	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
21	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
22	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
23	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
24	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
25	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
26	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
27	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
28	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
29	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
30	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
31	TEL_NUMBER	☐	E_TLNMBR	CHAR30	CHAR	30	0	Telephone No.: Dialling Code + Number
32	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
33	MOB_NUMBER	☐	E_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Phone No.: Dial.Code + Number (Address-Indep.)
34	TEL_NUMBER_AI	☐	E_TLNMBR1_AI	CHAR30	CHAR	30	0	First Telephone No.: Dial.Code + Number - Address-Independ.
35	TEL_EXTENS_AI	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
36	SMTP_ADDR_AI	☐	E_SMTPADR_AI	AD_SMTPADR	CHAR	241	0	E-Mail Address (Address-Independent)
37	FAX_NUMBER	☐	E_FXNMBR	CHAR30	CHAR	30	0	Fax Number: Dialling Code + Number
38	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
39	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
40	OTHER_ADDR	☐	OTHER_ADDR	KENNZX	CHAR	1	0	Additional addresses for customer exist
41	.INCLUDE	☐				0	0	Texts for Customer Address Fields in Subscreens
42	LANDT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
43	REGIONT	☐	REGIONT	TEXT20	CHAR	20	0	Text for region
44	SPRAST	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKUNADRD	COUNTRY	T005	LAND1
2	EKUNADRD	LANGU	T002	SPRAS
3	EKUNADRD	REGION	T005S	BLAND
4	EKUNADRD	TIME_ZONE	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in