SAP ABAP Table RJK0204 (IS-M/SD: Field String for Address with Origin 'Order')

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	RJK0204	Table Relationship Diagram
Short Description	IS-M/SD: Field String for Address with Origin 'Order'

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	IS-M: Extended Adress Management
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
4	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
5	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
6	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
7	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
8	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
9	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
10	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
11	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
12	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
13	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
14	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
15	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
16	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
17	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
18	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
19	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
20	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
21	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
22	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
23	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
24	.INCLUDE	☐				0	0	Core address data
25	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
26	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
27	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
28	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
29	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
30	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
31	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
32	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
33	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
34	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
35	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
36	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
37	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
38	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
39	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
40	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
41	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
42	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
43	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
44	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
45	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
46	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
47	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
48	.INCLUDE	☐				0	0	Include Structure for Alias (Direction, Area, Search Field)
49	ALIASPREDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
50	ALIASPOSTDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
51	ALIASDELADDRLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
52	ALIASDELADDRHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
53	ALIASDELODDEVEN	☐	ODDEVENCODE	ODDEVENCODE	CHAR	1	0	IS-M: Indicator - Even/Odd/All
54	SUCHFELDALIAS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
55	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
56	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
57	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
58	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
59	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
60	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
61	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
62	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
63	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
64	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
65	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
66	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
67	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
68	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
69	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
70	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
71	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
72	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
73	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
74	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
75	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
76	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
77	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
78	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
79	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
80	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
81	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
82	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
83	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
84	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
85	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
86	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
87	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
88	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAP
89	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
90	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
91	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
92	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
93	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
94	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
95	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
96	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
97	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
98	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
99	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
100	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
101	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
102	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
103	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
104	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
105	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
106	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change
107	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
108	ALIASLFDNR	☐	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)	JSTALIAS
109	XNOCARPERMESS	☐	XNOCARPERMESS	XFELD	CHAR	1	0	IS-M: No Change of Carrier When Address Changes
110	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
111	ANI_TELNRP	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
112	ANI_TELNRD	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
113	ANI_ISPHANDY	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
114	HH_REF	☐	GPNR_HH	BU_PARTNER	CHAR	10	0	IS-M: Business Partner Number of Household	JGTHH
115	HH_EXCLUDE	☐	HH_EXCLUDE	XFELD	CHAR	1	0	IS-M: Indicator: Exclude Household Assignment
116	PRIVACY_STATUS	☐	ADDRESS_PRIVACY_STATUS	ADDRESS_PRIVACY_STATUS	CHAR	1	0	IS-M: Status of Address As Regards Data Protection
117	LOGADR	☐	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
118	ADRZA	☐	JADRZA	JADRTA	NUMC	4	0	IS-M: Time Slice Counter in Logical Address
119	GUELTIGVON	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
120	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
121	POSNR_VL	☐	APNR_VL	APNR	NUMC	6	0	Reference Document Item	*
122	DBCODE	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in