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

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

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, General Business Partner
2	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Business Partner
3	GP_SATZART	☐	GP_SATZART	GP_SATZART	CHAR	2	0	IS-M: Record Type for Transfer of BP Data
4	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	JGTGPNR
5	JKTOKD	☐	JKTOKD	JKTOKD	CHAR	4	0	IS-M: Business Partner Account Group	TJG37
6	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Address Fields
7	JPARVW	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
8	WDAT1	☐	WDAT1	DATUM	DATS	8	0	Valid from date
9	WDAT2	☐	WDAT2	DATUM	DATS	8	0	To
10	.INCLUDE	☐				0	0	IS-M/SD: Address Fields from Screen Input
11	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
12	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
13	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
14	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
15	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
16	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
17	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
18	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
19	.INCLUDE	☐				0	0	Core address data
20	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
21	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
22	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
23	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
24	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
25	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
26	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
27	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
28	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
29	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
30	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
31	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
32	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
33	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
34	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
35	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
36	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
37	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
38	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
39	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
40	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
41	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
42	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
43	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
44	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
45	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
46	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
47	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
48	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
49	MAILN	☐	JMAILN	SO_OBJ_NAM	CHAR	12	0	IS-M: Mail Address
50	.INCLUDE	☐				0	0	IS-P: Home/Work Telephone Data
51	ISPTELVWP	☐	ISPTELVWP	ISPTELVW	CHAR	10	0	IS-M: Area Code (Home)
52	ISPTELP	☐	ISPTELP	ISPTEL	CHAR	20	0	IS-M: Telephone Number
53	ISPTELVWD	☐	ISPTELVWD	ISPTELVW	CHAR	10	0	IS-M: Area Code - Work
54	ISPTELD	☐	ISPTELD	ISPTEL	CHAR	20	0	IS-M: Telephone Number
55	ISPHANDY	☐	ISPHANDY	CHAR30	CHAR	30	0	IS-M: Mobile Phone Number
56	ISPEMAIL	☐	ISPEMAIL	CHAR50LOW	CHAR	50	0	IS-M: E-Mail Address
57	ISPADRBSND	☐	ISPADRBSND	TEXT50	CHAR	50	0	IS-M/SD: Note for Home Delivery to Ship-to Party
58	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, General Business Partner
59	BERUFSL	☐	BERUFSL	BERUFSL	CHAR	8	0	IS-M: Occupation	TJG05
60	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
61	JGEBDAT	☐	JGEBDAT	DATUM	DATS	8	0	IS-M: Date of Birth of a Business Partner
62	JFAMST	☐	JFAMST	JFAMST	CHAR	1	0	IS-M: Business Partner's Marital Status	TJG45
63	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	TJG41
64	XNOWERB	☐	XNOWERB	XFELD	CHAR	1	0	IS-M: No Advertising
65	BRAN1	☐	BRAN1_D	BRACO	CHAR	10	0	Industry code 1	TBRC
66	BRAN2	☐	BRAN2	BRACO	CHAR	10	0	Industry code 2	TBRC
67	BRAN3	☐	BRAN3	BRACO	CHAR	10	0	Industry code 3	TBRC
68	BRAN4	☐	BRAN4	BRACO	CHAR	10	0	Industry code 4	TBRC
69	BRAN5	☐	BRAN5	BRACO	CHAR	10	0	Industry code 5	TBRC
70	XVERMSACH	☐	XVERMSACH	XFELD	CHAR	1	0	IS-M: BP Authorized to Receive Gifts
71	XMITARB	☐	XMITARB	XFELD	CHAR	1	0	IS-M: Employee Indicator
72	PERNR	☐	JPERNR2	JPERNR	CHAR	20	0	IS-M: Personnel Number
73	XVERB	☐	XVERB	XFELD	CHAR	1	0	IS-M: Association Indicator
74	XINTERN	☐	XINTERN	XFELD	CHAR	1	0	IS-M: Internal Business Partner Indicator
75	AUFORG	☐	AUFORG	AUFORG	CHAR	10	0	Organizational Plan Unit
76	XSOZIAL	☐	XSOZIAL	XFELD	CHAR	1	0	IS-M: Social Facility Indicator
77	XVERLAG	☐	XVERLAG	XFELD	CHAR	1	0	IS-M: Publisher Indicator
78	XVERLEIG	☐	XVERLEIG	XFELD	CHAR	1	0	IS-M: Indicator: Owned By Publisher
79	VERLVKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
80	ISPCVERL	☐	ISPVERL	TEXT11	CHAR	11	0	IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04
81	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
82	XINSER	☐	XINSERENT	XINSERENT	CHAR	1	0	IS-M: Selection Indicator for Advertiser
83	XAGEN	☐	XAGENTUR	XFELD	CHAR	1	0	IS-M: Agency Indicator
84	BON	☐	JBONITAET	JBONITAET	CHAR	2	0	IS-M: Creditworthiness Indicator	TJGJ2
85	GP_DUB	☐	JDUBIOS	JDUBIOS	CHAR	1	0	IS-M: Credit Query Indicator	TJGJ0
86	AGEN_ART	☐	XAGEN_KREA	XFELD	CHAR	1	0	IS-M: Creative Boutique Indicator
87	AGEN_STR	☐	XAGEN_STR	XFELD	CHAR	1	0	IS-M: Distribution Agency Indicator
88	AGEN_PLAN	☐	XAGEN_PLAN	XFELD	CHAR	1	0	IS-M: Planning Agency Indicator
89	AGEN_GRU	☐	AGEN_GRUP	AGEN_GRUP	CHAR	1	0	IS-M: Agency Type	TJGJ4
90	J_SOC_SECU	☐	J_SOC_SECU	CHAR020	CHAR	20	0	IS-M: Social Insurance Number
91	.INCLUDE	☐				0	0	IS-M/SD: Bus.Partner Master Data for WBZ Processing
92	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
93	RECHZENTNR	☐	JWBZRZNR	JWBZRZNR	CHAR	2	0	IS-M: WBZ, Computer Center Number	TJKW0
94	JWBZKOMART	☐	JWBZKOMART	JWBZKOMART	CHAR	1	0	IS-M: Communication Type in WBZ Processing
95	XWBZFIRMA	☐	XWBZFIRMA	XFELD	CHAR	1	0	IS-M: Business Partner Is WBZ Company
96	WBZZLSCH	☐	WBZZLSCH	ZLSCH	CHAR	1	0	Payment Method for Billing Documents to WBZ Company	T042Z
97	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Customer Data
98	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Customer and Vendor Data
99	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
100	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
101	FISKN	☐	FISKN	MAXKK	CHAR	10	0	Account number of the master record with the fiscal address
102	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
103	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
104	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
105	USTLAND1_1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
106	STCEG_1	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
107	USTLAND1_2	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
108	STCEG_2	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
109	USTLAND1_3	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
110	STCEG_3	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
111	USTLAND1_4	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
112	STCEG_4	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
113	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
114	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Bank Data
115	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
116	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
117	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
118	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
119	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
120	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
121	KZDEB	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
122	KZKRED	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
123	ISPXHB	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
124	EZWANN	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
125	ISPEZBIS	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
126	ISPEZWEM	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
127	ISPEZBTR	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
128	EZKTOIN	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
129	ISPBNKSP	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
130	ISPEZWAERS	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
131	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
132	.INCLU-_1	☐				0	0	IS-M/SD: Data Transfer, Bank Data
133	BANKS_1	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
134	BANKL_1	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
135	BANKN_1	☐	BANKN	BANKN	CHAR	18	0	Bank account number
136	BKONT_1	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
137	BKREF_1	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
138	XEZER_1	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
139	KZDEB_1	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
140	KZKRED_1	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
141	ISPXHB_1	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
142	EZWANN_1	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
143	ISPEZBIS_1	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
144	ISPEZWEM_1	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
145	ISPEZBTR_1	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
146	EZKTOIN_1	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
147	ISPBNKSP_1	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
148	ISPEZWAERS_1	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
149	IBAN_1	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
150	.INCLU-_2	☐				0	0	IS-M/SD: Data Transfer, Bank Data
151	BANKS_2	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
152	BANKL_2	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
153	BANKN_2	☐	BANKN	BANKN	CHAR	18	0	Bank account number
154	BKONT_2	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
155	BKREF_2	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
156	XEZER_2	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
157	KZDEB_2	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
158	KZKRED_2	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
159	ISPXHB_2	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
160	EZWANN_2	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
161	ISPEZBIS_2	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
162	ISPEZWEM_2	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
163	ISPEZBTR_2	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
164	EZKTOIN_2	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
165	ISPBNKSP_2	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
166	ISPEZWAERS_2	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
167	IBAN_2	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
168	.INCLU-_3	☐				0	0	IS-M/SD: Data Transfer, Bank Data
169	BANKS_3	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
170	BANKL_3	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
171	BANKN_3	☐	BANKN	BANKN	CHAR	18	0	Bank account number
172	BKONT_3	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
173	BKREF_3	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
174	XEZER_3	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
175	KZDEB_3	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
176	KZKRED_3	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
177	ISPXHB_3	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
178	EZWANN_3	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
179	ISPEZBIS_3	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
180	ISPEZWEM_3	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
181	ISPEZBTR_3	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
182	EZKTOIN_3	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
183	ISPBNKSP_3	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
184	ISPEZWAERS_3	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
185	IBAN_3	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
186	.INCLUDE	☐				0	0	IS-M: BP Data Transfer Credit Cards 0
187	.INCLUDE	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
188	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
189	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
190	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
191	DATAB	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
192	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
193	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
194	CCLOCK	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
195	CCDEF	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
196	.INCLU-_1	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
197	CCINS_1	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
198	CCNUM_1	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
199	CCNAME_1	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
200	DATAB_1	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
201	DATBI_1	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
202	CCTYP_1	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
203	CCLOCK_1	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
204	CCDEF_1	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
205	.INCLU-_2	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
206	CCINS_2	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
207	CCNUM_2	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
208	CCNAME_2	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
209	DATAB_2	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
210	DATBI_2	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
211	CCTYP_2	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
212	CCLOCK_2	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
213	CCDEF_2	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
214	.INCLU-_3	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
215	CCINS_3	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
216	CCNUM_3	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
217	CCNAME_3	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
218	DATAB_3	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
219	DATBI_3	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
220	CCTYP_3	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
221	CCLOCK_3	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
222	CCDEF_3	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
223	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System	KNA1
224	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
225	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
226	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
227	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
228	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
229	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Sales Customer, Sales Data 1
230	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKA1
231	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
232	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
233	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
234	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
235	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
236	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
237	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
238	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Sales Customer, Sales Data 2
239	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
240	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
241	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
242	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
243	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
244	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
245	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
246	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
247	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
248	VERSG	☐	VERSG	VERSG	CHAR	1	0	Statistics group	TVSG
249	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
250	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
251	ZTERM_V	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
252	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
253	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
254	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
255	TAXKD1	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
256	TAXKD2	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
257	TAXKD3	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
258	TAXKD4	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
259	KSREMIND	☐	KSREMIND	KSREMIND	CHAR	2	0	IS-M/SD: Customer Procedure for Monitoring	*
260	.INCLUDE	☐				0	0	IS-M: Data Transfer for BP Dunning Data
261	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	*
262	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
263	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
264	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
265	KNRMA	☐	KNRMA	KUNNR	CHAR	10	0	Account number of the dunning recipient	*
266	GMVDT	☐	GMVDT	DATUM	DATS	8	0	Date of the legal dunning proceedings
267	BUSAB	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	*
268	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	*
269	BUSABB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
270	EIKTOD	☐	EIKTO_D	CHAR12	CHAR	12	0	Our account number at customer
271	ZSABE	☐	DZSABE_D	TEXT15	CHAR	15	0	User at customer
272	KVERM	☐	KVERM	TEXT30	CHAR	30	0	Memo
273	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	*
274	XDEZV	☐	XDEZV	XFELD	CHAR	1	0	Indicator: Local processing?
275	PERKZ	☐	PERKZ_KNB1	PERKZ_KNB1	CHAR	1	0	Collective invoice variant

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJGAU_KU	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJGAU_KU	AGEN_GRU	TJGJ4	AGEN_GRU
3	RJGAU_KU	AKONT	SKA1	SAKNR
4	RJGAU_KU	ANRED	TJG43	JANRED
5	RJGAU_KU	BANKS	T005	LAND1
6	RJGAU_KU	BANKS_1	T005	LAND1
7	RJGAU_KU	BANKS_2	T005	LAND1
8	RJGAU_KU	BANKS_3	T005	LAND1
9	RJGAU_KU	BERUFSL	TJG05	BERUFSL
10	RJGAU_KU	BON	TJGJ2	BONITAET
11	RJGAU_KU	BRAN1	TBRC	BRACO
12	RJGAU_KU	BRAN2	TBRC	BRACO
13	RJGAU_KU	BRAN3	TBRC	BRACO
14	RJGAU_KU	BRAN4	TBRC	BRACO
15	RJGAU_KU	BRAN5	TBRC	BRACO
16	RJGAU_KU	BRSCH	T016	BRSCH
17	RJGAU_KU	CITYC	T005G	CITYC
18	RJGAU_KU	COUNC	T005E	COUNC
19	RJGAU_KU	FKUNNR	KNA1	KUNNR
20	RJGAU_KU	GPHERK	TJG41	GPHERK
21	RJGAU_KU	GPNR	JGTGPNR	GPNR
22	RJGAU_KU	GP_DUB	TJGJ0	DUBIOS
23	RJGAU_KU	HBKID	T012	HBKID
24	RJGAU_KU	INCO1	TINC	INCO1
25	RJGAU_KU	JFAMST	TJG45	JFAMST
26	RJGAU_KU	JKTOKD	TJG37	JKTOKD
27	RJGAU_KU	JPARVW	TJG39	JPARVW
28	RJGAU_KU	KALKS	TVKD	KALKS
29	RJGAU_KU	KDGRP	T151	KDGRP
30	RJGAU_KU	KONDA	T188	KONDA
31	RJGAU_KU	KTGRD	TVKT	KTGRD
32	RJGAU_KU	KURST	TCURV	KURST
33	RJGAU_KU	LAND1	T005	LAND1
34	RJGAU_KU	NAMZU	T535N	TITEL
35	RJGAU_KU	PERFK	TFACD	IDENT
36	RJGAU_KU	PLTYP	T189	PLTYP
37	RJGAU_KU	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
38	RJGAU_KU	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
39	RJGAU_KU	RECHZENTNR	TJKW0	RECHZENTNR	KEY	1	CN
40	RJGAU_KU	REGIO	T005S	BLAND
41	RJGAU_KU	SPART	TSPA	SPART
42	RJGAU_KU	SPRAS	T002	SPRAS
43	RJGAU_KU	TAXKD1	TSKD	TAXKD
44	RJGAU_KU	TAXKD2	TSKD	TAXKD
45	RJGAU_KU	TAXKD3	TSKD	TAXKD
46	RJGAU_KU	TAXKD4	TSKD	TAXKD
47	RJGAU_KU	TITEL	T535N	TITEL
48	RJGAU_KU	TOGRU	T043G	TOGRU
49	RJGAU_KU	USTLAND1_1	T005	LAND1
50	RJGAU_KU	USTLAND1_2	T005	LAND1
51	RJGAU_KU	USTLAND1_3	T005	LAND1
52	RJGAU_KU	USTLAND1_4	T005	LAND1
53	RJGAU_KU	VERLVKORG	TVKO	VKORG
54	RJGAU_KU	VERSG	TVSG	VERSG
55	RJGAU_KU	VKBUR	TVBUR	VKBUR
56	RJGAU_KU	VKGRP	TVKGR	VKGRP
57	RJGAU_KU	VKORG	TVKO	VKORG
58	RJGAU_KU	VORSW	T535N	TITEL
59	RJGAU_KU	VTWEG	TVTW	VTWEG
60	RJGAU_KU	WAERS	TCURC	WAERS
61	RJGAU_KU	WBZZLSCH	T042Z	ZLSCH
62	RJGAU_KU	ZAHLS	T008	ZAHLS
63	RJGAU_KU	ZUAWA	TZUN	ZUAWA

History

Last changed by/on	SAP	20130529
SAP Release Created in