SAP ABAP Table RJGAU_GP (IS-M/SD: Data Transfer, General Business Partner)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	INTTAB	Structure
Structure	RJGAU_GP	Table Relationship Diagram
Short Description	IS-M/SD: Data Transfer, General 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/SD: Data Transfer, Business Partner
2	GP_SATZART	☐	GP_SATZART	GP_SATZART	CHAR	2	0	IS-M: Record Type for Transfer of BP Data
3	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
4	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
5	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Address Fields
6	JPARVW	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
7	WDAT1	☐	WDAT1	DATUM	DATS	8	0	Valid from date
8	WDAT2	☐	WDAT2	DATUM	DATS	8	0	To
9	.INCLUDE	☐				0	0	IS-M/SD: Address Fields from Screen Input
10	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
11	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
12	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
13	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
14	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
15	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
16	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
17	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
18	.INCLUDE	☐				0	0	Core address data
19	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
20	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
21	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
22	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
23	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
24	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
25	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
26	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
27	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
28	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
29	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
30	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
31	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
32	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
33	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
34	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
35	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
36	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
37	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
38	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
39	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
40	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
41	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
42	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
43	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
44	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
45	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
46	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
47	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
48	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
49	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
50	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
51	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
52	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
53	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
54	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
55	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
56	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
57	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, General Business Partner
58	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
59	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
60	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
61	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
62	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
63	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
64	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
65	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
66	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
67	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
68	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
69	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
70	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
71	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
72	XVERB	☐	XVERB	XFELD	CHAR	1	0	IS-M: Association Indicator
73	XINTERN	☐	XINTERN	XFELD	CHAR	1	0	IS-M: Internal Business Partner Indicator
74	AUFORG	☐	AUFORG	AUFORG	CHAR	10	0	Organizational Plan Unit
75	XSOZIAL	☐	XSOZIAL	XFELD	CHAR	1	0	IS-M: Social Facility Indicator
76	XVERLAG	☐	XVERLAG	XFELD	CHAR	1	0	IS-M: Publisher Indicator
77	XVERLEIG	☐	XVERLEIG	XFELD	CHAR	1	0	IS-M: Indicator: Owned By Publisher
78	VERLVKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
79	ISPCVERL	☐	ISPVERL	TEXT11	CHAR	11	0	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
80	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
81	XINSER	☐	XINSERENT	XINSERENT	CHAR	1	0	IS-M: Selection Indicator for Advertiser
82	XAGEN	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
83	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
84	GP_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
85	AGEN_ART	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
86	AGEN_STR	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
87	AGEN_PLAN	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
88	AGEN_GRU	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
89	J_SOC_SECU	☐	J_SOC_SECU	CHAR020	CHAR	20	0	IS-M: Social Insurance Number
90	.INCLUDE	☐				0	0	IS-M/SD: Bus.Partner Master Data for WBZ Processing
91	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
92	RECHZENTNR	☐	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
93	JWBZKOMART	☐	JWBZKOMART	JWBZKOMART	CHAR	1	0	IS-M: Communication Type in WBZ Processing
94	XWBZFIRMA	☐	XWBZFIRMA	XFELD	CHAR	1	0	IS-M: Business Partner Is WBZ Company
95	WBZZLSCH	☐	WBZZLSCH	ZLSCH	CHAR	1	0	Payment Method for Billing Documents to WBZ Company	T042Z

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJGAU_GP	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJGAU_GP	AGEN_GRU	TJGJ4	AGEN_GRU
3	RJGAU_GP	ANRED	TJG43	JANRED
4	RJGAU_GP	BERUFSL	TJG05	BERUFSL
5	RJGAU_GP	BON	TJGJ2	BONITAET
6	RJGAU_GP	BRAN1	TBRC	BRACO
7	RJGAU_GP	BRAN2	TBRC	BRACO
8	RJGAU_GP	BRAN3	TBRC	BRACO
9	RJGAU_GP	BRAN4	TBRC	BRACO
10	RJGAU_GP	BRAN5	TBRC	BRACO
11	RJGAU_GP	BRSCH	T016	BRSCH
12	RJGAU_GP	GPHERK	TJG41	GPHERK
13	RJGAU_GP	GPNR	JGTGPNR	GPNR
14	RJGAU_GP	GP_DUB	TJGJ0	DUBIOS
15	RJGAU_GP	JFAMST	TJG45	JFAMST
16	RJGAU_GP	JKTOKD	TJG37	JKTOKD
17	RJGAU_GP	JPARVW	TJG39	JPARVW
18	RJGAU_GP	LAND1	T005	LAND1
19	RJGAU_GP	NAMZU	T535N	TITEL
20	RJGAU_GP	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
21	RJGAU_GP	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
22	RJGAU_GP	RECHZENTNR	TJKW0	RECHZENTNR
23	RJGAU_GP	REGIO	T005S	BLAND
24	RJGAU_GP	SPRAS	T002	SPRAS
25	RJGAU_GP	TITEL	T535N	TITEL
26	RJGAU_GP	VERLVKORG	TVKO	VKORG
27	RJGAU_GP	VORSW	T535N	TITEL
28	RJGAU_GP	WBZZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in