SAP ABAP Table RJGAU_EV (IS-M/SD: Data Transfer, Retailer)

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

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJGAU_EV	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	RJGAU_EV	AGEN_GRU	TJGJ4	AGEN_GRU
3	RJGAU_EV	AKONT	SKA1	SAKNR
4	RJGAU_EV	ANRED	TJG43	JANRED
5	RJGAU_EV	BANKS	T005	LAND1
6	RJGAU_EV	BANKS_1	T005	LAND1
7	RJGAU_EV	BANKS_2	T005	LAND1
8	RJGAU_EV	BANKS_3	T005	LAND1
9	RJGAU_EV	BERUFSL	TJG05	BERUFSL
10	RJGAU_EV	BON	TJGJ2	BONITAET
11	RJGAU_EV	BRAN1	TBRC	BRACO
12	RJGAU_EV	BRAN2	TBRC	BRACO
13	RJGAU_EV	BRAN3	TBRC	BRACO
14	RJGAU_EV	BRAN4	TBRC	BRACO
15	RJGAU_EV	BRAN5	TBRC	BRACO
16	RJGAU_EV	BRSCH	T016	BRSCH
17	RJGAU_EV	CITYC	T005G	CITYC
18	RJGAU_EV	COUNC	T005E	COUNC
19	RJGAU_EV	EBEDIENART	TJG23	EBEDIENART	REF	C	CN
20	RJGAU_EV	EFREQUENZ	TJG27	EFREQUENZ	REF	C	CN
21	RJGAU_EV	EUMSEINFL	TJG25	EUMSEINFL	REF	C	CN
22	RJGAU_EV	EVKFLAECHE	TJG21	EVKFLAECHE	REF	C	CN
23	RJGAU_EV	EVKSTART	TJG17	EVKSTART	REF	C	CN
24	RJGAU_EV	EVKSTBEZ	TJG19	EVKSTBEZ	REF	C	CN
25	RJGAU_EV	FKUNNR	KNA1	KUNNR
26	RJGAU_EV	GPHERK	TJG41	GPHERK
27	RJGAU_EV	GPNR	JGTGPNR	GPNR
28	RJGAU_EV	GP_DUB	TJGJ0	DUBIOS
29	RJGAU_EV	HBKID	T012	HBKID
30	RJGAU_EV	INCO1	TINC	INCO1
31	RJGAU_EV	ISMGEOKATEGORIE	TJGGEOCAT	ISMGEOKATEGORIE	KEY
32	RJGAU_EV	ISMPLANCALENDER	TFACD	IDENT	KEY	1	CN
33	RJGAU_EV	ISPCART	TJGR1	ISPCART
34	RJGAU_EV	JFAMST	TJG45	JFAMST
35	RJGAU_EV	JKTOKD	TJG37	JKTOKD
36	RJGAU_EV	JPARVW	TJG39	JPARVW
37	RJGAU_EV	KALKS	TVKD	KALKS
38	RJGAU_EV	KDGRP	T151	KDGRP
39	RJGAU_EV	KONDA	T188	KONDA
40	RJGAU_EV	KTGRD	TVKT	KTGRD
41	RJGAU_EV	KURST	TCURV	KURST
42	RJGAU_EV	LAND1	T005	LAND1
43	RJGAU_EV	MBRSYS	TJG15	MBRSYS	REF	C	CN
44	RJGAU_EV	NAMZU	T535N	TITEL
45	RJGAU_EV	OEFFDI	TJG33	OEFFTG	REF	C	CN
46	RJGAU_EV	OEFFDO	TJG33	OEFFTG	REF	C	CN
47	RJGAU_EV	OEFFFR	TJG33	OEFFTG	REF	C	CN
48	RJGAU_EV	OEFFMI	TJG33	OEFFTG	REF	C	CN
49	RJGAU_EV	OEFFMO	TJG33	OEFFTG	REF	C	CN
50	RJGAU_EV	OEFFSA	TJG33	OEFFTG	REF	C	CN
51	RJGAU_EV	OEFFSO	TJG33	OEFFTG	REF	C	CN
52	RJGAU_EV	OEFFZT	TJG29	OEFFZT	REF	C	CN
53	RJGAU_EV	PERFK	TFACD	IDENT
54	RJGAU_EV	PLTYP	T189	PLTYP
55	RJGAU_EV	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
56	RJGAU_EV	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
57	RJGAU_EV	RECHZENTNR	TJKW0	RECHZENTNR	KEY	1	CN
58	RJGAU_EV	REGIO	T005S	BLAND
59	RJGAU_EV	SCHLZT	TJG31	SCHLZT	REF	C	CN
60	RJGAU_EV	SPART	TSPA	SPART
61	RJGAU_EV	SPRAS	T002	SPRAS
62	RJGAU_EV	TAXKD1	TSKD	TAXKD
63	RJGAU_EV	TAXKD2	TSKD	TAXKD
64	RJGAU_EV	TAXKD3	TSKD	TAXKD
65	RJGAU_EV	TAXKD4	TSKD	TAXKD
66	RJGAU_EV	TITEL	T535N	TITEL
67	RJGAU_EV	TOGRU	T043G	TOGRU
68	RJGAU_EV	USTLAND1_1	T005	LAND1
69	RJGAU_EV	USTLAND1_2	T005	LAND1
70	RJGAU_EV	USTLAND1_3	T005	LAND1
71	RJGAU_EV	USTLAND1_4	T005	LAND1
72	RJGAU_EV	VERLVKORG	TVKO	VKORG
73	RJGAU_EV	VERSG	TVSG	VERSG
74	RJGAU_EV	VKBUR	TVBUR	VKBUR
75	RJGAU_EV	VKGRP	TVKGR	VKGRP
76	RJGAU_EV	VKORG	TVKO	VKORG
77	RJGAU_EV	VORSW	T535N	TITEL
78	RJGAU_EV	VTWEG	TVTW	VTWEG
79	RJGAU_EV	WAERS	TCURC	WAERS
80	RJGAU_EV	WBZZLSCH	T042Z	ZLSCH
81	RJGAU_EV	ZAHLS	T008	ZAHLS
82	RJGAU_EV	ZUAWA	TZUN	ZUAWA

History

Last changed by/on	SAP	20130529
SAP Release Created in