SAP ABAP Table RJH_OP_PARTNER_OLD (IS-M: Object Provider Attributes For Old Business Partner)

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	RJH_OP_PARTNER_OLD	Table Relationship Diagram
Short Description	IS-M: Object Provider Attributes For Old Business Partner

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	IS-M: Central Business Partner Table
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
4	XGPLOE	☐	JXLV_GP	XFELD	CHAR	1	0	IS-M: Deletion Flag for General Business Partner
5	XGPLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
6	XGPSPE	☐	XGPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for General Business Partner
7	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
8	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
9	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
10	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
11	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
12	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
13	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
14	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
15	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
16	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	TBRG
17	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
18	GFORM	☐	GFORM	GFORM	CHAR	2	0	Legal status	TVGF
19	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
20	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
21	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
22	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
23	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
24	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
25	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
26	GESCH	☐	JGESCHL	JGESCHL	CHAR	1	0	IS-M: Gender Key
27	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
28	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
29	XNATUR	☐	XNATUR	XFELD	CHAR	1	0	IS-M: Natural Person Indicator
30	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
31	XOHNE	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
32	XDEBI	☐	JXDEBI	XFELD	CHAR	1	0	IS-M: Indicator: Customer Exists
33	KUNNR	☐	JKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Previous System	KNA1
34	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System	*
35	XKREDI	☐	XKREDI	XFELD	CHAR	1	0	IS-M: Indicator: Vendor Exists
36	LIFNR	☐	JLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Previous System	LFA1
37	FLIFNR	☐	JFLIFNR	LIFNR	CHAR	10	0	IS-M: Vendor Number in Non-SAP System	*
38	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
39	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
40	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
41	GPKLA1	☐	GPKLA	GPKLA	CHAR	4	0	IS-M: BP Class (Not in Use Yet)	TJG51
42	GPKLA2	☐	GPKLA2	GPKLA2	CHAR	4	0	IS-M: BP Class 2	TJG53
43	GPKLA3	☐	GPKLA3	GPKLA3	CHAR	4	0	IS-M: BP Class 3	TJG55
44	GPKLA4	☐	GPKLA4	GPKLA4	CHAR	4	0	IS-M: BP Class 4	TJG57
45	GPKLA5	☐	GPKLA5	GPKLA5	CHAR	4	0	IS-M: BP Class 5	TJG59
46	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
47	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
48	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
49	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
50	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
51	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
52	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
53	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
54	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
55	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
56	XVSRVGES	☐	XVSRVGES	XFELD	CHAR	1	0	IS-M: Service Company Indicator
57	XVSGLOEV	☐	JXLV_ZG	XFELD	CHAR	1	0	IS-M: Deletion Flag for Service Company
58	XVSGLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
59	XVSGSPE	☐	XZGSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Service Company
60	XZUST	☐	XZUST	XFELD	CHAR	1	0	IS-M: Carrier Indicator
61	XZUSTLOEV	☐	JXLV_ZU	XFELD	CHAR	1	0	IS-M: Deletion Flag for Carrier
62	XZUSTLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
63	XZUSSPE	☐	XZUSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Carrier
64	XVERMPROV	☐	XVERMPROV	XFELD	CHAR	1	0	IS-M: Sales Agent - Commission Recipient
65	XVERMPROVV	☐	JXLV_PV	XFELD	CHAR	1	0	IS-M: Deletion Flag for Sales Agent/Commission Recipient
66	XVERMPROKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
67	XVERSPE	☐	XPVSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient
68	XVERB	☐	XVERB	XFELD	CHAR	1	0	IS-M: Association Indicator
69	XVEBLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
70	XVEBSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
71	XINKASSO	☐	XINKASSO	XFELD	CHAR	1	0	IS-M: Field Collector Indicator
72	XINKLOEV	☐	JXLV_IK	XFELD	CHAR	1	0	IS-M: Deletion Flag for Field Collector
73	XINKLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
74	XINKSPE	☐	XIKSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Field Collector
75	XRECHER	☐	XRECHER	XFELD	CHAR	1	0	IS-M: Researcher Indicator
76	XRECHLOEV	☐	JXLV_RC	XFELD	CHAR	1	0	IS-M: Deletion Flag for Researcher
77	XRECHLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
78	XRECHSPE	☐	XRCSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Researcher
79	MAILNBETR	☐	JMAILNBETR	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address of User in Charge
80	XKAHS	☐	XKAHS	XFELD	CHAR	1	0	IS-M: Customer Pickup Point Indicator
81	XKAHLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
82	XKAHSSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
83	XSPEDI	☐	XSPEDI	XFELD	CHAR	1	0	IS-M: Forwarding Agent Indicator
84	XSPEDLOEV	☐	JXLV_SP	XFELD	CHAR	1	0	IS-M: Deletion Flag for Forwarding Agent
85	XSPEDLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
86	XSPESPE	☐	XSPSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Forwarding Agent
87	XVERTKUN	☐	XVERTKUN	XFELD	CHAR	1	0	IS-M: Sales Customer Indicator
88	XVKUNLOEV	☐	JXLV_KU	XFELD	CHAR	1	0	IS-M: Deletion Flag for Sales Customer
89	XVKUNLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
90	XVKUNSPE	☐	XKUSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator for Sales Customer
91	XEUW	☐	XEUW	XFELD	CHAR	1	0	IS-M: Retailer Indicator
92	XEUWLOEV	☐	JXLV_EW	XFELD	CHAR	1	0	IS-M: Deletion Flag for Retailer
93	XEUWLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
94	XEUWSPE	☐	XEWSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator - Retailer
95	XINTERN	☐	XINTERN	XFELD	CHAR	1	0	IS-M: Internal Business Partner Indicator
96	XINTLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
97	AUFORG	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
98	XINTSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
99	XSOZIAL	☐	XSOZIAL	XFELD	CHAR	1	0	IS-M: Social Facility Indicator
100	XSOZLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
101	XSOZSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
102	XPOST	☐	XPOST	XFELD	CHAR	1	0	IS-M: Mail Depot Indicator
103	XPOSLOEV	☐	JXLV_PO	XFELD	CHAR	1	0	IS-M: Deletion Flag for Post
104	XPOSLOEKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
105	XPOSSPE	☐	XPOSPE	XFELD	CHAR	1	0	IS-M/SD: Lock Indicator - Post
106	XVERLAG	☐	XVERLAG	XFELD	CHAR	1	0	IS-M: Publisher Indicator
107	XVERLLOEV	☐	XLOESCH	XFELD	CHAR	1	0	IS-M: Deletion Flag (Role-Specific)
108	XVERLSPE	☐	XSPERR	XFELD	CHAR	1	0	IS-M: Lock Indicator (Role-Specific)
109	XVERLEIG	☐	XVERLEIG	XFELD	CHAR	1	0	IS-M: Indicator: Owned By Publisher
110	VERLVKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
111	ISPCVERL	☐	ISPVERL	TEXT11	CHAR	11	0	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
112	XMEDIAK	☐	XMEDIAK	XFELD	CHAR	1	0	IS-M: Media customer
113	XMEDIAKLV	☐	XMKLV	XFELD	CHAR	1	0	IS-M: Deletion Flag for Media Customer
114	XMEDIAKLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
115	XMEDIAKSP	☐	XMKSPE	XFELD	CHAR	1	0	IS-M: Lock Indicator for Media Customer
116	XINSER	☐	XINSERENT	XINSERENT	CHAR	1	0	IS-M: Selection Indicator for Advertiser
117	XINSERLV	☐	XISLV	XFELD	CHAR	1	0	IS-M: Advertiser Deletion Flag
118	XINSERLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
119	XINSERSP	☐	XISSPE	XFELD	CHAR	1	0	IS-M: Advertiser Lock Indicator
120	XMVERM	☐	XMVERMITTL	XFELD	CHAR	1	0	IS-M: Media Sales Agent Indicator
121	XMVERMLV	☐	XMVLV	XFELD	CHAR	1	0	IS-M: Deletion Flag for Media Sales Agent
122	XMVERMLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
123	XMVERMSP	☐	XMVSPE	XFELD	CHAR	1	0	IS-M: Lock Indicator for Media Sales Agent
124	XAGEN	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
125	XAGENLV	☐	XARLV	XFELD	CHAR	1	0	IS-M: Agency Deletion Flag
126	XAGENLKZ	☐	XLOESCHKZ	XFELD	CHAR	1	0	IS-M: Deletion Indicator (Role-Specific)
127	XAGENLSP	☐	XARSPE	XFELD	CHAR	1	0	IS-M: Agency Lock Indicator
128	AGEN_ART	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
129	AGEN_STR	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
130	AGEN_PLAN	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
131	AGEN_GRU	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
132	XDUB	☐	XDUBIOS	XFELD	CHAR	1	0	IS-M: No Longer Used - Credit Query Indicator
133	GP_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
134	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
135	KLIM_EINZ	☐	JKLIMEINZ	WERT8	CURR	15	2	IS-M: Individual Credit Limit
136	KLIM_GES	☐	JKLIMGES	WERT8	CURR	15	2	IS-M: Total Credit Limit
137	KLIM_WAERS	☐	JWAERS	WAERS	CUKY	5	0	IS-M: Currency Key	TCURC
138	.INCLUDE	☐				0	0	IS-M/SD: Bus.Partner Master Data for WBZ Processing
139	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
140	RECHZENTNR	☐	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
141	JWBZKOMART	☐	JWBZKOMART	JWBZKOMART	CHAR	1	0	IS-M: Communication Type in WBZ Processing
142	XWBZFIRMA	☐	XWBZFIRMA	XFELD	CHAR	1	0	IS-M: Business Partner Is WBZ Company
143	WBZZLSCH	☐	WBZZLSCH	ZLSCH	CHAR	1	0	Payment Method for Billing Documents to WBZ Company	TJK42
144	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
145	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	JGTSADR
146	XISPCTEILN	☐	XISPCTEILN	XFELD	CHAR	1	0	IS-M: Indicator: Business Partner Is EDI Participant
147	ISPCTEILN	☐	ISPCTEILN	NUM8	NUMC	8	0	IS-M: EDI Participant Number
148	ISPCART	☐	ISPCART	JISPCART	NUMC	1	0	IS-M: EDI Participant Type	TJGR1
149	J_SOC_SECU	☐	J_SOC_SECU	CHAR020	CHAR	20	0	IS-M: Social Insurance Number
150	XHOUSEHOLD	☐	XHOUSEHOLD	XFELD	CHAR	1	0	IS-M: Household Indicator
151	UVADR_ST	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
152	UVADR_PF	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
153	UVADR_GK	☐	UVADR_AD	UVADR_AD	CHAR	1	0	IS-M: Coding Status of Address
154	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
155	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
156	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
157	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
158	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
159	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
160	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
161	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
162	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
163	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
164	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
165	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
166	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
167	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
168	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
169	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
170	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
171	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
172	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
173	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
174	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
175	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
176	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
177	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
178	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
179	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
180	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
181	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
182	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
183	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
184	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
185	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
186	ALIASPREDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
187	ALIASPOSTDIRECTN	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	*
188	ALIASDELADDRLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
189	ALIASDELADDRHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
190	ALIASDELODDEVEN	☐	ODDEVENCODE	ODDEVENCODE	CHAR	1	0	IS-M: Indicator - Even/Odd/All
191	SUCHFELDALIAS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
192	POSTEINORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
193	ERSTADR	☐	ERSTADR	ERSTADR	CHAR	1	0	IS-M: Address Proposal for Alternatives
194	POSTEINSTR	☐	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
195	PEINORTPF	☐	ALORT2	ALORT	CHAR	8	0	IS-M: Postal Unit of City for PO Box	JSTORTPRO
196	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
197	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
198	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
199	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
200	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
201	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
202	SORT2	☐	SORTL2	CHAR20	CHAR	20	0	IS-M: Sort Field 2 (for Internal Use)
203	SORT3	☐	SORTL3	TEXT30	CHAR	30	0	IS-M: Sort field 3 (internal)
204	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
205	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
206	TELFP	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
207	TELFD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
208	TELW1	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
209	TELW2	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
210	TELW3	☐	TELWT	TEXT16	CHAR	16	0	IS-M: Additional Telephone Number
211	TELW4	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
212	TELW5	☐	TELWF	TEXT20	CHAR	20	0	IS-M: Mobile Phone Number
213	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
214	TELF1	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
215	TELF2	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
216	TELF3	☐	TELFT	TEXT16	CHAR	16	0	IS-M: Additional Fax Number
217	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
218	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
219	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
220	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
221	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
222	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
223	VBELN_REF	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
224	POSNR_REF	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
225	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
226	BEABLS_REF	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	JRTBEABST
227	TELFP_COD	☐	TELFP	TEXT16	CHAR	16	0	IS-M: Home Phone Number
228	TELFD_COD	☐	TELFD	TEXT16	CHAR	16	0	IS-M: Telephone Number at Work
229	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
230	NAME2_MACO	☐	NAME2_ISPM	NAME_MACO	CHAR	35	0	IS-M: Bus.Partner's First Name (Upper Case for Matchcode)
231	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
232	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)
233	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
234	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
235	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
236	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
237	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
238	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
239	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
240	TECHNUMZUG	☐	TECHNUMZUG	XFELD	CHAR	1	0	IS-M: Technical Relocation Due to Postal Data Change
241	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
242	ALIASLFDNR	☐	ALIASLFDNR	NUMC10	NUMC	10	0	IS-M: Sequence Number for Alias Table (Key)	JSTALIAS
243	XNOCARPERMESS	☐	XNOCARPERMESS	XFELD	CHAR	1	0	IS-M: No Change of Carrier When Address Changes
244	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
245	ANI_TELNRP	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
246	ANI_TELNRD	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJH_OP_PARTNER_OLD	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJH_OP_PARTNER_OLD	ADRNR	JGTSADR	ADRNR	REF	1	N
3	RJH_OP_PARTNER_OLD	AGEN_GRU	TJGJ4	AGEN_GRU	KEY	1	CN
4	RJH_OP_PARTNER_OLD	ALIASLFDNR	JSTALIAS	ALIASLFDNR	KEY	C	CN
5	RJH_OP_PARTNER_OLD	ANRED	TJG43	JANRED	REF	C	CN
6	RJH_OP_PARTNER_OLD	AUFORG	TVBUR	VKBUR	KEY	1	CN
7	RJH_OP_PARTNER_OLD	BEABLS_REF	JRTBEABST	BEABLST	REF	C	CN
8	RJH_OP_PARTNER_OLD	BEGRU	TBRG	BRGRU
9	RJH_OP_PARTNER_OLD	BERUFSL	TJG05	BERUFSL	REF	C	CN
10	RJH_OP_PARTNER_OLD	BON	TJGJ2	BONITAET	KEY	1	CN
11	RJH_OP_PARTNER_OLD	BRAN1	TBRC	BRACO	REF	C	CN
12	RJH_OP_PARTNER_OLD	BRAN2	TBRC	BRACO	REF	C	CN
13	RJH_OP_PARTNER_OLD	BRAN3	TBRC	BRACO	REF	C	CN
14	RJH_OP_PARTNER_OLD	BRAN4	TBRC	BRACO	REF	C	CN
15	RJH_OP_PARTNER_OLD	BRAN5	TBRC	BRACO	REF	C	CN
16	RJH_OP_PARTNER_OLD	BRSCH	T016	BRSCH	REF	C	CN
17	RJH_OP_PARTNER_OLD	CITYC	T005G	CITYC	REF	C	CN
18	RJH_OP_PARTNER_OLD	COUNC	T005E	COUNC	REF	C	CN
19	RJH_OP_PARTNER_OLD	GFORM	TVGF	GFORM	REF	C	CN
20	RJH_OP_PARTNER_OLD	GPHERK	TJG41	GPHERK	REF	C	CN
21	RJH_OP_PARTNER_OLD	GPKLA1	TJG51	GPKLA	REF	C	CN
22	RJH_OP_PARTNER_OLD	GPKLA2	TJG53	GPKLA2	REF	C	CN
23	RJH_OP_PARTNER_OLD	GPKLA3	TJG55	GPKLA3	REF	C	CN
24	RJH_OP_PARTNER_OLD	GPKLA4	TJG57	GPKLA4	REF	C	CN
25	RJH_OP_PARTNER_OLD	GPKLA5	TJG59	GPKLA5	REF	C	CN
26	RJH_OP_PARTNER_OLD	GP_DUB	TJGJ0	DUBIOS	KEY	1	CN
27	RJH_OP_PARTNER_OLD	GP_REF	JGTGPNR	GPNR	REF	C	CN
28	RJH_OP_PARTNER_OLD	ISPCART	TJGR1	ISPCART	KEY	1	CN
29	RJH_OP_PARTNER_OLD	JFAMST	TJG45	JFAMST	REF	C	CN
30	RJH_OP_PARTNER_OLD	JKTOKD	TJG37	JKTOKD	KEY	1	CN
31	RJH_OP_PARTNER_OLD	JPARVW_REF	TJG39	JPARVW	REF	C	CN
32	RJH_OP_PARTNER_OLD	KATR1	TVK1	KATR1	REF	C	CN
33	RJH_OP_PARTNER_OLD	KATR10	TVK0	KATR10	REF	C	CN
34	RJH_OP_PARTNER_OLD	KATR2	TVK2	KATR2	REF	C	CN
35	RJH_OP_PARTNER_OLD	KATR3	TVK3	KATR3	REF	C	CN
36	RJH_OP_PARTNER_OLD	KATR4	TVK4	KATR4	REF	C	CN
37	RJH_OP_PARTNER_OLD	KATR5	TVK5	KATR5	REF	C	CN
38	RJH_OP_PARTNER_OLD	KATR6	TVK6	KATR6	REF	C	CN
39	RJH_OP_PARTNER_OLD	KATR7	TVK7	KATR7	REF	C	CN
40	RJH_OP_PARTNER_OLD	KATR8	TVK8	KATR8	REF	C	CN
41	RJH_OP_PARTNER_OLD	KATR9	TVK9	KATR9	REF	C	CN
42	RJH_OP_PARTNER_OLD	KLIM_WAERS	TCURC	WAERS	REF	C	CN
43	RJH_OP_PARTNER_OLD	KUNNR	KNA1	KUNNR	REF	C	1
44	RJH_OP_PARTNER_OLD	LAND1	T005	LAND1	REF	C	CN
45	RJH_OP_PARTNER_OLD	LIFNR	LFA1	LIFNR	REF	C	1
46	RJH_OP_PARTNER_OLD	MANDT	T000	MANDT	KEY	1	CN
47	RJH_OP_PARTNER_OLD	NAMZU	T535N	TITEL
48	RJH_OP_PARTNER_OLD	NIELS	TNLS	NIELS	REF	C	CN
49	RJH_OP_PARTNER_OLD	PEINORTPF	JSTORTPRO	ALORT	REF	C	CN
50	RJH_OP_PARTNER_OLD	POSNR_REF	JKAP	POSNR	REF	C	CN
51	RJH_OP_PARTNER_OLD	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
52	RJH_OP_PARTNER_OLD	POSTEINORT	JSTORTPRO	ALORT	REF	C	CN
53	RJH_OP_PARTNER_OLD	POSTEINSTR	JSTSTRPRO	STRASSENNR	REF	C	CN
54	RJH_OP_PARTNER_OLD	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
55	RJH_OP_PARTNER_OLD	RECHZENTNR	TJKW0	RECHZENTNR	KEY	1	CN
56	RJH_OP_PARTNER_OLD	REGIO	T005S	BLAND	REF	C	CN
57	RJH_OP_PARTNER_OLD	SPRAS	T002	SPRAS	REF	C	CN
58	RJH_OP_PARTNER_OLD	TITEL	T535N	TITEL
59	RJH_OP_PARTNER_OLD	TXJCD	TTXJ	TXJCD	REF	C	CN
60	RJH_OP_PARTNER_OLD	VBELN_REF	JKAK	VBELN	REF	C	CN
61	RJH_OP_PARTNER_OLD	VERLVKORG	TVKO	VKORG	REF	C	CN
62	RJH_OP_PARTNER_OLD	VORSW	T535N	TITEL
63	RJH_OP_PARTNER_OLD	WBZZLSCH	TJK42	ZLSCH	REF	1	CN

History

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