SAP ABAP Table ISMAM_TXW_JGTSADR (DART IS-M/AM: Enhanced Address Management)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	ISMAM_TXW_JGTSADR	Table Relationship Diagram
Short Description	DART IS-M/AM: Enhanced Address Management

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
3	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
4	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
5	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
6	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
7	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
8	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
9	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
10	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
11	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
12	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
13	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
14	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
15	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
16	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
17	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
18	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
19	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
20	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
21	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
22	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
23	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
24	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
25	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
26	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
27	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
28	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
29	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
30	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
31	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
32	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
33	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
34	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
35	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
36	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
37	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
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	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
44	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
45	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
46	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
47	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
48	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
49	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
50	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
51	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
52	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
53	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
54	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
55	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
56	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
57	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
58	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
59	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
60	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
61	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
62	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
63	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
64	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
65	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
66	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
67	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
68	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
69	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
70	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
71	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
72	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
73	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
74	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
75	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
76	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
77	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
78	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
79	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
80	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
81	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
82	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
83	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
84	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
85	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
86	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
87	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
88	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
89	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change
90	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
91	ALIASLFDNR	☐	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)	JSTALIAS
92	XNOCARPERMESS	☐	XNOCARPERMESS	XFELD	CHAR	1	0	IS-M: No Change of Carrier When Address Changes
93	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
94	ANI_TELNRP	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
95	ANI_TELNRD	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
96	HH_REF	☐	GPNR_HH	BU_PARTNER	CHAR	10	0	IS-M: Business Partner Number of Household	JGTHH
97	HH_EXCLUDE	☐	HH_EXCLUDE	XFELD	CHAR	1	0	IS-M: Indicator: Exclude Household Assignment
98	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISMAM_TXW_JGTSADR	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	ISMAM_TXW_JGTSADR	ALIASLFDNR	JSTALIAS	ALIASLFDNR	KEY	C	CN
3	ISMAM_TXW_JGTSADR	ANRED	TJG43	JANRED	REF	C	CN
4	ISMAM_TXW_JGTSADR	BEABLS_REF	JRTBEABST	BEABLST	REF	C	CN
5	ISMAM_TXW_JGTSADR	CITYC	T005G	CITYC	REF	C	CN
6	ISMAM_TXW_JGTSADR	COUNC	T005E	COUNC	REF	C	CN
7	ISMAM_TXW_JGTSADR	GPHERK	TJG41	GPHERK	KEY	1	CN
8	ISMAM_TXW_JGTSADR	GP_REF	JGTGPNR	GPNR	REF	C	CN
9	ISMAM_TXW_JGTSADR	HH_REF	JGTHH	PARTNER
10	ISMAM_TXW_JGTSADR	JPARVW_REF	TJG39	JPARVW	REF	C	CN
11	ISMAM_TXW_JGTSADR	LAND1	T005	LAND1	REF	C	CN
12	ISMAM_TXW_JGTSADR	MANDT	T000	MANDT	KEY	1	CN
13	ISMAM_TXW_JGTSADR	NAMZU	T535N	TITEL
14	ISMAM_TXW_JGTSADR	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
15	ISMAM_TXW_JGTSADR	POSNR_REF	JKAP	POSNR	REF	C	CN
16	ISMAM_TXW_JGTSADR	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
17	ISMAM_TXW_JGTSADR	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
18	ISMAM_TXW_JGTSADR	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
19	ISMAM_TXW_JGTSADR	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
20	ISMAM_TXW_JGTSADR	REGIO	T005S	BLAND	REF	C	CN
21	ISMAM_TXW_JGTSADR	SPRAS	T002	SPRAS	REF	C	CN
22	ISMAM_TXW_JGTSADR	TITEL	T535N	TITEL
23	ISMAM_TXW_JGTSADR	TXJCD	TTXJ	TXJCD	REF	C	CN
24	ISMAM_TXW_JGTSADR	VBELN_REF	JKAK	VBELN	REF	C	CN
25	ISMAM_TXW_JGTSADR	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20130529
SAP Release Created in	471