SAP ABAP Table RJHA1401 (IS-PAM: Screen structure for partner details)

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	RJHA1401	Table Relationship Diagram
Short Description	IS-PAM: Screen structure for partner details

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	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	*
2	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	*
3	AG_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
4	AG_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
5	AG_GPNR	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
6	AG_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
7	MV_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
8	MV_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
9	MV_GPNR	☐	VERM_MEDIA	GPNR	CHAR	10	0	IS-M: Media Sales Agent	JJVDB_MV_FK
10	MV_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
11	MV_KNZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
12	CE_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
13	CE_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
14	CE_GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
15	CE_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
16	IS_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
17	IS_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
18	IS_GPNR	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
19	IS_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
20	IS_KNZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
21	RG_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
22	RG_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
23	RG_GPNR	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
24	RG_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
25	RE_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
26	RE_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
27	RE_GPNR	☐	GPNR_RECH	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
28	RE_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
29	BE_MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
30	BE_ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
31	BE_GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
32	BE_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
33	BE_KNZ	☐	XFELD	XFELD	CHAR	1	0	Checkbox
34	.INCLUDE	☐				0	0	IS-M: View for Bus.Partner Addresses (replaces JGVADDRES1)
35	.INCLUDE	☐				0	0	IS-M: Extended Adress Management
36	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
37	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
38	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
39	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
40	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
41	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
42	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
43	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
44	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
45	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
46	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
47	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
48	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
49	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
50	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
51	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
52	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
53	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
54	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
55	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
56	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
57	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
58	.INCLUDE	☐				0	0	Core address data
59	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
60	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
61	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
62	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
63	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
64	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
65	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
66	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
67	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
68	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
69	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
70	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
71	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
72	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
73	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
74	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
75	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
76	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
77	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
78	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
79	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
80	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
81	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
82	.INCLUDE	☐				0	0	Include Structure for Alias (Direction, Area, Search Field)
83	ALIASPREDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
84	ALIASPOSTDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
85	ALIASDELADDRLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
86	ALIASDELADDRHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
87	ALIASDELODDEVEN	☐	ODDEVENCODE	ODDEVENCODE	CHAR	1	0	IS-M: Indicator - Even/Odd/All
88	SUCHFELDALIAS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
89	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
90	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
91	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
92	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
93	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
94	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
95	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
96	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
97	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
98	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
99	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
100	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
101	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
102	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
103	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
104	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
105	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
106	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
107	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
108	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
109	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
110	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
111	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
112	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
113	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
114	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
115	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
116	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
117	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
118	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
119	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
120	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
121	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
122	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
123	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
124	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
125	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
126	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
127	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
128	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
129	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
130	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
131	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
132	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
133	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
134	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
135	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
136	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
137	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
138	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
139	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
140	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change
141	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
142	ALIASLFDNR	☐	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)	JSTALIAS
143	XNOCARPERMESS	☐	XNOCARPERMESS	XFELD	CHAR	1	0	IS-M: No Change of Carrier When Address Changes
144	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
145	ANI_TELNRP	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
146	ANI_TELNRD	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
147	ANI_ISPHANDY	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
148	HH_REF	☐	GPNR_HH	BU_PARTNER	CHAR	10	0	IS-M: Business Partner Number of Household	JGTHH
149	HH_EXCLUDE	☐	HH_EXCLUDE	XFELD	CHAR	1	0	IS-M: Indicator: Exclude Household Assignment
150	PRIVACY_STATUS	☐	ADDRESS_PRIVACY_STATUS	ADDRESS_PRIVACY_STATUS	CHAR	1	0	IS-M: Status of Address As Regards Data Protection
151	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
152	LOGADR	☐	JLOGADR	JLOGADR	NUMC	4	0	IS-M: Logical Address Number
153	ADRZA	☐	JADRZA	JADRTA	NUMC	4	0	IS-M: Time Slice Counter in Logical Address
154	JPARVW	☐	JPARVW2	JPARVW	CHAR	2	0	IS-M: Business Partner Roles	*
155	WDAT1	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
156	WDAT2	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
157	VADRNR	☐	JVADRNR	JADRNR	CHAR	10	0	IS-M: Address Number of Previous Address (Relocation)	*
158	XKAHS	☐	XKAHS	XFELD	CHAR	1	0	IS-M: Customer Pickup Point Indicator
159	SD_UPDA	☐	XFELD	XFELD	CHAR	1	0	Checkbox
160	SD_UPDA_FS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
161	ERFUSER_AD	☐	ERFUSER	USNAM	CHAR	12	0	Created By
162	ERFDATE_AD	☐	ERFDATE	DATUM	DATS	8	0	Created On
163	ERFTIME_AD	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
164	AENUSER_AD	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
165	AENDATE_AD	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
166	AENTIME_AD	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
167	MARK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
168	X_UEBER	☐	X_UEBER	XFELD	CHAR	1	0	IS-M/AM: Copy Entry Indicator
169	ROLLE	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
170	GP_NAME	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
171	PARZA	☐	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
172	ADRESSVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
173	ADR_ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
174	ADR_FELD1	☐	ADR_FELD1	NAME	CHAR	35	0	IS-M: Address Field for Business Partner Name
175	ADR_FELD2	☐	ADR_FELD2	NAME	CHAR	35	0	IS-M: Address Field for Business Partner Name
176	PARNR	☐	ISM_CNTCT_PRSN	BU_PARTNER	CHAR	10	0	IS-M: Contact Person	*
177	X_ADRND	☐	X_ADRND	XFELD	CHAR	1	0	IS-M: Business Address For Contact Person Indicator
178	X_ADRNP	☐	X_ADRNP	XFELD	CHAR	1	0	IS-M: Home Address For Contact Person Indicator
179	X_ASADR	☐	X_ASADR	XFELD	CHAR	1	0	IS-M: Indicator for order-specific address

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in