SAP ABAP Table JYTADRCODE (IS-M: Address Data with Coding and Postal Units)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	JYTADRCODE	Table Relationship Diagram
Short Description	IS-M: Address Data with Coding and Postal Units

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	.INCLUDE	☐				0	0	Core address data
2	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
3	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
4	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
5	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
6	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
7	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
8	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
9	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
10	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
11	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
12	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
13	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
14	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
15	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
16	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
17	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
18	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
19	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
20	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
21	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
22	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
23	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
24	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
25	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
26	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
27	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
28	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
29	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
30	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	*
31	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	*
32	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
33	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
34	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
35	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
36	ALIASLFDNR	☐	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)
37	.INCLUDE	☐				0	0	Include Structure for Alias (Direction, Area, Search Field)
38	ALIASPREDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
39	ALIASPOSTDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
40	ALIASDELADDRLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
41	ALIASDELADDRHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
42	ALIASDELODDEVEN	☐	ODDEVENCODE	ODDEVENCODE	CHAR	1	0	IS-M: Indicator - Even/Odd/All
43	SUCHFELDALIAS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
44	HH_REF	☐	GPNR_HH	BU_PARTNER	CHAR	10	0	IS-M: Business Partner Number of Household	*
45	HH_EXCLUDE	☐	HH_EXCLUDE	XFELD	CHAR	1	0	IS-M: Indicator: Exclude Household Assignment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JYTADRCODE	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	JYTADRCODE	LAND1	T005	LAND1	REF	C	CN
3	JYTADRCODE	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
4	JYTADRCODE	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in