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

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

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, Customer and Vendor Data
2	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
3	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
4	FISKN	☐	FISKN	MAXKK	CHAR	10	0	Account number of the master record with the fiscal address
5	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
6	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
7	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
8	USTLAND1_1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
9	STCEG_1	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
10	USTLAND1_2	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
11	STCEG_2	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
12	USTLAND1_3	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	STCEG_3	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
14	USTLAND1_4	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
15	STCEG_4	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
16	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
17	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Bank Data
18	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
19	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
20	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
21	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
22	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
23	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
24	KZDEB	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
25	KZKRED	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
26	ISPXHB	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
27	EZWANN	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
28	ISPEZBIS	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
29	ISPEZWEM	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
30	ISPEZBTR	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
31	EZKTOIN	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
32	ISPBNKSP	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
33	ISPEZWAERS	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
34	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
35	.INCLU-_1	☐				0	0	IS-M/SD: Data Transfer, Bank Data
36	BANKS_1	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
37	BANKL_1	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
38	BANKN_1	☐	BANKN	BANKN	CHAR	18	0	Bank account number
39	BKONT_1	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
40	BKREF_1	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
41	XEZER_1	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
42	KZDEB_1	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
43	KZKRED_1	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
44	ISPXHB_1	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
45	EZWANN_1	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
46	ISPEZBIS_1	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
47	ISPEZWEM_1	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
48	ISPEZBTR_1	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
49	EZKTOIN_1	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
50	ISPBNKSP_1	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
51	ISPEZWAERS_1	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
52	IBAN_1	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
53	.INCLU-_2	☐				0	0	IS-M/SD: Data Transfer, Bank Data
54	BANKS_2	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
55	BANKL_2	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
56	BANKN_2	☐	BANKN	BANKN	CHAR	18	0	Bank account number
57	BKONT_2	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
58	BKREF_2	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
59	XEZER_2	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
60	KZDEB_2	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
61	KZKRED_2	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
62	ISPXHB_2	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
63	EZWANN_2	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
64	ISPEZBIS_2	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
65	ISPEZWEM_2	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
66	ISPEZBTR_2	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
67	EZKTOIN_2	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
68	ISPBNKSP_2	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
69	ISPEZWAERS_2	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
70	IBAN_2	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
71	.INCLU-_3	☐				0	0	IS-M/SD: Data Transfer, Bank Data
72	BANKS_3	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
73	BANKL_3	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
74	BANKN_3	☐	BANKN	BANKN	CHAR	18	0	Bank account number
75	BKONT_3	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
76	BKREF_3	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
77	XEZER_3	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
78	KZDEB_3	☐	ISPKZDEB	XFELD	CHAR	1	0	IS-M: Customer Indicator
79	KZKRED_3	☐	ISPKZKRED	XFELD	CHAR	1	0	IS-M: Vendor
80	ISPXHB_3	☐	ISPKZHB	XFELD	CHAR	1	0	IS-M: Indicator: Main Bank Details
81	EZWANN_3	☐	ISPEZWANN	DATUM	DATS	8	0	IS-M: Date on Which Collection Authorization Issued
82	ISPEZBIS_3	☐	ISPEZBIS	DATUM	DATS	8	0	IS-M: Date to Which Collection Authorization Is Valid
83	ISPEZWEM_3	☐	ISPEZWEM	TEXT35	CHAR	35	0	IS-M: Collection Authorization Issued By
84	ISPEZBTR_3	☐	J_ISPEZBT	CHAR11	CHAR	11	0	IS-M: Collection Authorization Limit
85	EZKTOIN_3	☐	ISPEZKTOIN	TEXT35	CHAR	35	0	IS-M: Account Holder for Collection Authorization
86	ISPBNKSP_3	☐	ISPBNKSP	XFELD	CHAR	1	0	IS-M: Indicator - Bank Details Blocked for IS-M/SD
87	ISPEZWAERS_3	☐	ISPEZWAERS	WAERS	CUKY	5	0	IS-M: Currency for Collection Authorization	*
88	IBAN_3	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
89	.INCLUDE	☐				0	0	IS-M: BP Data Transfer Credit Cards 0
90	.INCLUDE	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
91	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
92	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
93	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
94	DATAB	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
95	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
96	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
97	CCLOCK	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
98	CCDEF	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
99	.INCLU-_1	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
100	CCINS_1	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
101	CCNUM_1	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
102	CCNAME_1	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
103	DATAB_1	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
104	DATBI_1	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
105	CCTYP_1	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
106	CCLOCK_1	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
107	CCDEF_1	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
108	.INCLU-_2	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
109	CCINS_2	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
110	CCNUM_2	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
111	CCNAME_2	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
112	DATAB_2	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
113	DATBI_2	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
114	CCTYP_2	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
115	CCLOCK_2	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
116	CCDEF_2	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
117	.INCLU-_3	☐				0	0	IS-M: BP Data Transfer Credit Cards 1
118	CCINS_3	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
119	CCNUM_3	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
120	CCNAME_3	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
121	DATAB_3	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
122	DATBI_3	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
123	CCTYP_3	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	*
124	CCLOCK_3	☐	CCLOCK	CCLOCK	CHAR	2	0	Payment cards: Reason for payment card block	*
125	CCDEF_3	☐	CCDEF	XFELD	CHAR	1	0	Payment cards: Indicator for default payment card
126	FKUNNR	☐	JFKUNNR	KUNNR	CHAR	10	0	IS-M: Customer Number in Non-SAP System	KNA1
127	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
128	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
129	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
130	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
131	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
132	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Sales Customer, Sales Data 1
133	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKA1
134	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
135	ALTKN	☐	ALTKN	CHAR10	CHAR	10	0	Previous Master Record Number
136	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
137	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	T043G
138	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
139	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
140	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
141	.INCLUDE	☐				0	0	IS-M/SD: Data Transfer, Sales Customer, Sales Data 2
142	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
143	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
144	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
145	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
146	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
147	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
148	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
149	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
150	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
151	VERSG	☐	VERSG	VERSG	CHAR	1	0	Statistics group	TVSG
152	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
153	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
154	ZTERM_V	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
155	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
156	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
157	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
158	TAXKD1	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
159	TAXKD2	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
160	TAXKD3	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
161	TAXKD4	☐	TAKLD	TAXKD	CHAR	1	0	Tax classification for customer	TSKD
162	KSREMIND	☐	KSREMIND	KSREMIND	CHAR	2	0	IS-M/SD: Customer Procedure for Monitoring	*
163	.INCLUDE	☐				0	0	IS-M: Data Transfer for BP Dunning Data
164	MAHNA	☐	MAHNA	MAHNA	CHAR	4	0	Dunning Procedure	*
165	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
166	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
167	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
168	KNRMA	☐	KNRMA	KUNNR	CHAR	10	0	Account number of the dunning recipient	*
169	GMVDT	☐	GMVDT	DATUM	DATS	8	0	Date of the legal dunning proceedings
170	BUSAB	☐	BUSAB_MA	BUSAB	CHAR	2	0	Dunning clerk	*
171	MGRUP	☐	MGRUP	MGRUP	CHAR	2	0	Key for dunning notice grouping	*
172	BUSABB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
173	EIKTOD	☐	EIKTO_D	CHAR12	CHAR	12	0	Our account number at customer
174	ZSABE	☐	DZSABE_D	TEXT15	CHAR	15	0	User at customer
175	KVERM	☐	KVERM	TEXT30	CHAR	30	0	Memo
176	XAUSZ	☐	XAUSZ	AUSZG	CHAR	1	0	Indicator for periodic account statements	*
177	XDEZV	☐	XDEZV	XFELD	CHAR	1	0	Indicator: Local processing?
178	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_GPD	AKONT	SKA1	SAKNR
2	RJGAU_GPD	BANKS	T005	LAND1
3	RJGAU_GPD	BANKS_1	T005	LAND1
4	RJGAU_GPD	BANKS_2	T005	LAND1
5	RJGAU_GPD	BANKS_3	T005	LAND1
6	RJGAU_GPD	CITYC	T005G	CITYC
7	RJGAU_GPD	COUNC	T005E	COUNC
8	RJGAU_GPD	FKUNNR	KNA1	KUNNR
9	RJGAU_GPD	HBKID	T012	HBKID
10	RJGAU_GPD	INCO1	TINC	INCO1
11	RJGAU_GPD	KALKS	TVKD	KALKS
12	RJGAU_GPD	KDGRP	T151	KDGRP
13	RJGAU_GPD	KONDA	T188	KONDA
14	RJGAU_GPD	KTGRD	TVKT	KTGRD
15	RJGAU_GPD	KURST	TCURV	KURST
16	RJGAU_GPD	PERFK	TFACD	IDENT
17	RJGAU_GPD	PLTYP	T189	PLTYP
18	RJGAU_GPD	SPART	TSPA	SPART
19	RJGAU_GPD	TAXKD1	TSKD	TAXKD
20	RJGAU_GPD	TAXKD2	TSKD	TAXKD
21	RJGAU_GPD	TAXKD3	TSKD	TAXKD
22	RJGAU_GPD	TAXKD4	TSKD	TAXKD
23	RJGAU_GPD	TOGRU	T043G	TOGRU
24	RJGAU_GPD	USTLAND1_1	T005	LAND1
25	RJGAU_GPD	USTLAND1_2	T005	LAND1
26	RJGAU_GPD	USTLAND1_3	T005	LAND1
27	RJGAU_GPD	USTLAND1_4	T005	LAND1
28	RJGAU_GPD	VERSG	TVSG	VERSG
29	RJGAU_GPD	VKBUR	TVBUR	VKBUR
30	RJGAU_GPD	VKGRP	TVKGR	VKGRP
31	RJGAU_GPD	VKORG	TVKO	VKORG
32	RJGAU_GPD	VTWEG	TVTW	VTWEG
33	RJGAU_GPD	WAERS	TCURC	WAERS
34	RJGAU_GPD	ZAHLS	T008	ZAHLS
35	RJGAU_GPD	ZUAWA	TZUN	ZUAWA

History

Last changed by/on	SAP	20130529
SAP Release Created in