SAP ABAP Table RJGAU_KU_O (IS-M/SD: Data Transfer, Sales Customer, Old Structure)

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_KU_O	Table Relationship Diagram
Short Description	IS-M/SD: Data Transfer, Sales Customer, Old Structure

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	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
2	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	*
3	.INCLUDE	☐				0	0	IS-M/SD: Address Fields from Screen Input
4	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
5	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
6	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
7	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
8	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
9	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
10	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
11	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
12	.INCLUDE	☐				0	0	Core address data
13	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
14	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
15	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
16	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
17	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
18	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
19	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
20	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
21	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
22	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
23	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
24	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
25	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
26	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
27	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
28	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
29	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
30	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
31	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
32	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
33	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
34	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
35	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
36	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
37	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
38	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
39	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
40	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
41	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
42	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
43	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
44	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
45	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
46	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
47	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
48	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
49	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
50	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
51	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	*
52	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
53	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
54	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	*
55	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	*
56	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
57	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
58	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
59	XVERB	☐	XVERB	XFELD	CHAR	1	0	IS-M: Association Indicator
60	XINTERN	☐	XINTERN	XFELD	CHAR	1	0	IS-M: Internal Business Partner Indicator
61	AUFORG	☐	AUFORG	AUFORG	CHAR	10	0	Organizational Plan Unit
62	XSOZIAL	☐	XSOZIAL	XFELD	CHAR	1	0	IS-M: Social Facility Indicator
63	XVERLAG	☐	XVERLAG	XFELD	CHAR	1	0	IS-M: Publisher Indicator
64	XVERLEIG	☐	XVERLEIG	XFELD	CHAR	1	0	IS-M: Indicator: Owned By Publisher
65	VERLVKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
66	ISPCVERL	☐	ISPVERL	TEXT11	CHAR	11	0	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
67	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
68	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
69	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
70	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
71	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
72	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System	*
73	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
74	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
75	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
76	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
77	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
78	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
79	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
80	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	*
81	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	*
82	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
83	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
84	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	*
85	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
86	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
87	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
88	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
89	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
90	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
91	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
92	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
93	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
94	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
95	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	*
96	VERSG	☐	VERSG	VERSG	CHAR	1	0	Statistics group	*
97	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
98	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
99	ZTERM_V	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
100	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	*
101	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
102	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	*
103	TAXKD1	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	*
104	TAXKD2	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	*
105	TAXKD3	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	*
106	TAXKD4	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	*
107	JPARVW	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	*
108	WDAT1	☐	WDAT1	DATUM	DATS	8	0	Valid from date
109	WDAT2	☐	WDAT2	DATUM	DATS	8	0	To
110	GP_SATZART	☐	GP_SATZART	GP_SATZART	CHAR	2	0	IS-M: Record Type for Transfer of BP Data
111	.INCLUDE	☐				0	0	IS-M/SD: Bus.Partner Master Data for WBZ Processing
112	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
113	RECHZENTNR	☐	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
114	JWBZKOMART	☐	JWBZKOMART	JWBZKOMART	CHAR	1	0	IS-M: Communication Type in WBZ Processing
115	XWBZFIRMA	☐	XWBZFIRMA	XFELD	CHAR	1	0	IS-M: Business Partner Is WBZ Company
116	WBZZLSCH	☐	WBZZLSCH	ZLSCH	CHAR	1	0	Payment Method for Billing Documents to WBZ Company	TJK42
117	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJGAU_KU_O	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJGAU_KU_O	ANRED	TJG43	JANRED
3	RJGAU_KU_O	LAND1	T005	LAND1
4	RJGAU_KU_O	NAMZU	T535N	TITEL
5	RJGAU_KU_O	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
6	RJGAU_KU_O	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
7	RJGAU_KU_O	RECHZENTNR	TJKW0	RECHZENTNR
8	RJGAU_KU_O	REGIO	T005S	BLAND
9	RJGAU_KU_O	SPRAS	T002	SPRAS
10	RJGAU_KU_O	TITEL	T535N	TITEL
11	RJGAU_KU_O	VORSW	T535N	TITEL
12	RJGAU_KU_O	WBZZLSCH	TJK42	ZLSCH	KEY	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in