SAP ABAP Table FKK_CL_ACCOUNT_TXT (Duplicate Processing: Contract Account Details)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA-BF-BP (Application Component) Business Partner
     ⤷ FKK_BUPA_CLEANSING (Package) FI-CA: Merging of Business Partners

Basic Data

Table Category	INTTAB	Structure
Structure	FKK_CL_ACCOUNT_TXT	Table Relationship Diagram
Short Description	Duplicate Processing: Contract Account Details

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	Data include for table FKKVK
2	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
3	VKTYP	☐	VKTYP_KK	VKTYP_KK	CHAR	2	0	Contract Account Category	TFK002A
4	VKONA	☐	VKONA_KK	CHAR20	CHAR	20	0	Contract account number in legacy system
5	.INCLUDE	☐				0	0	Include for Acct Header
6	.INCLUDE	☐				0	0
7	.INCLUDE	☐				0	0	Data include for table FKKVKP
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	AEDATP	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
11	AENAMP	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	FDZTG	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
13	STOPD	☐	STOPD_KK	STOPD_KK	DATS	8	0	Processing lock until
14	QSZDT	☐	QSZDT	DATUM	DATS	8	0	Validity Date for Withholding Tax Exemption Certificate
15	GUID	☐	BUAG_GUID	SYSUUID	RAW	16	0	Business Agreement GUID
16	.INCLUDE	☐				0	0	Data Include for Table FKKVKP (Char.Fields Only)
17	EXVKO	☐	EXVKO_KK	CHAR25	CHAR	25	0	Reference number for business partner
18	OPBUK	☐	OPBUK_KK	OPBUK_KK	CHAR	4	0	Company Code Group	TFK001G
19	STDBK	☐	STDBK_KK	BUKRS	CHAR	4	0	Standard Company Code	*
20	ABWRE	☐	ABWRE_KK	BU_PARTNER	CHAR	10	0	Alternative Payer	BUT000
21	ABWRA	☐	ABWRA_KK	BU_PARTNER	CHAR	10	0	Alternative Payee	BUT000
22	ABWMA	☐	ABWMA_KK	BU_PARTNER	CHAR	10	0	Alternative dunning recipient	BUT000
23	EBVTY	☐	EBVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Incoming Payments
24	ABVTY	☐	ABVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Outgoing Payments
25	EZAWE	☐	EZAWE_KK	CHAR1	CHAR	1	0	Incoming Payment Method
26	EZASP	☐	EZASP_OLD_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Incoming Payments	TFK008
27	AZAWE	☐	AZAWE_KK	CHAR5	CHAR	5	0	Outgoing Payment Methods
28	AZASP	☐	AZASP_OLD_KK	SPZAH_KK	CHAR	1	0	Lock Reason for Outgoing Payments	TFK008
29	EIGBV	☐	EIGBV_KK	EIGBV_KK	CHAR	25	0	Own Bank Details	*
30	VWNZA	☐	VWNZA_KK	VWNZA_KK	CHAR	1	0	Create Where-Used List For Line Items
31	LOEVM	☐	LOEVM_KK	LOEVM_KK	CHAR	1	0	Mark Contract Account for Deletion
32	ABWVK	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	FKKVK
33	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
34	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
35	MANSP	☐	MANSP_OLD_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
36	MGRUP	☐	MGRUP_KK	MGRUP_KK	CHAR	2	0	Grouping fur Dunning Notices	TFK047F
37	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
38	VKPBZ	☐	VKPBZ_KK	VKPBZ_KK	CHAR	2	0	Relationship of Business Partner to Contract Account	TFK002F
39	ADRNB	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
40	VKONV	☐	VKONV_KK	VKONT_KK	CHAR	12	0	Contract account used for payment transactions	FKKVK
41	GPARV	☐	GPARV_KK	BU_PARTNER	CHAR	10	0	Business Partner Acting as Payer in Payment Transactions	BUT000
42	ADRRE	☐	ADRRE_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Alternative Payer	*
43	ADRRA	☐	ADRRA_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Alternative Payee	*
44	ADRMA	☐	ADRMA_KK	AD_ADDRNUM	CHAR	10	0	Address number for alternative dunning notice recipient	*
45	ABWRH	☐	ABWRH_KK	BU_PARTNER	CHAR	10	0	Alternative Invoice Recipient	BUT000
46	ADRRH	☐	ADRRH_KK	AD_ADDRNUM	CHAR	10	0	Address number for alternative bill recipient	*
47	ADRJDC	☐	ADRJDC_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Jurisdiction Code Address	*
48	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
49	TOGRU	☐	TOGRU_KK	TOGRU_KK	CHAR	4	0	Tolerance group for contract account	TFK043
50	STOPG	☐	STOPG_KK	STOPG_KK	CHAR	1	0	Reason for Processing Lock	TFK001S
51	TXJCD	☐	TXJCD_NOCD_KK	TXJCD	CHAR	15	0	Jurisdiction for Tax Calculation - Tax Jurisdiction Code	*
52	COPRC	☐	COPRC_KK	COPRC_KK	CHAR	4	0	Correspondence Variant	TFK070B
53	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
54	CCARD_ID	☐	CCID_IN_KK	CHAR6	CHAR	6	0	Payment Card ID for Incoming Payments
55	CCARD_OUT	☐	CCID_OUT_KK	CHAR6	CHAR	6	0	Payment Card ID for Outgoing Payments
56	UEBTR	☐	XUEBTR_KK	XFELD	CHAR	1	0	Items Transferred To Another Account
57	DEF_REC	☐	DEF_CORR_PARTNER_KK	BU_PARTNER	CHAR	10	0	Alternative Correspondence Recipient for Standard Case	BUT000
58	DEF_REC_IND	☐	DEF_CORR_ACKEY_KK	CORR_ACKEY_KK	CHAR	4	0	FI-CA correspondence - activity key	TFK070L
59	QSSKZ_A	☐	QSSKZ_A_KK	QSSKZ	CHAR	2	0	Witholding Tax Code For Outgoing Payments	*
60	QSSKZ_E	☐	QSSKZ_E_KK	QSSKZ	CHAR	2	0	Withholding Tax Code For Incoming Payments	*
61	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
62	CORR_MAHNV	☐	CORR_MAHNV_KK	MAHNV_KK	CHAR	2	0	Correspondence Dunning Procedure	*
63	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITPV
64	PROVINCE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
65	COUNTY	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
66	VERTYP	☐	VERTYP_KK	VERTYP_KK	CHAR	4	0	Clearing Category For Clearing Postings	TFK111
67	AUGRS_DEF	☐	AUGRS_DEF_KK	AUGRS_DEF_KK	CHAR	1	0	Clearing Restriction
68	LANDL	☐	LANDL_KK	LAND1	CHAR	3	0	Country Supplied (for Tax Notifications)	T005
69	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
70	BPTAXTYPE1	☐	BPTAXTYPE1	BPTAXTYPE	CHAR	4	0	Tax Number Type 1 for Business Partner
71	BPTAXTYPE2	☐	BPTAXTYPE2	BPTAXTYPE	CHAR	4	0	Tax Number type 2 for Business Partner
72	PERSR	☐	PERSR_KK	BU_PARTNER	CHAR	10	0	Clerk Responsible	BUT000
73	INV_CATEGORY	☐	INV_CATEGORY_KK	INV_CATEGORY_KK	CHAR	4	0	Invoicing Category	TFK2604
74	BPCL_SUCC	☐	BPCL_SUCC_KK	BPCL_SUCC_KK	CHAR	1	0	Duplicates Processing: BP Predecessor/Successor
75	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
76	.INCLUDE	☐				0	0	IS-U Contract Acc.
77	.INCLUDE	☐				0	0	Include for Person Acct
78	.INCLUDE	☐				0	0
79	.INCLUDE	☐				0	0	IS-PS-CA Contract Acct(Partner-Dependent), ONLY CHAR FIELDS!
80	.INCLUDE	☐				0	0	FI-CA Extended: Contract Account
81	.INCLUDE	☐				0	0	Common Fields for IS-U/T/M Contract A/R & A/P

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKK_CL_ACCOUNT_TXT	ABWMA	BUT000	PARTNER		1	CN
2	FKK_CL_ACCOUNT_TXT	ABWRA	BUT000	PARTNER		1	CN
3	FKK_CL_ACCOUNT_TXT	ABWRE	BUT000	PARTNER		1	CN
4	FKK_CL_ACCOUNT_TXT	ABWRH	BUT000	PARTNER
5	FKK_CL_ACCOUNT_TXT	ABWVK	FKKVK	VKONT
6	FKK_CL_ACCOUNT_TXT	AZASP	TFK008	ZAHLS	REF	1	CN
7	FKK_CL_ACCOUNT_TXT	BUPLA	J_1BBRANCH	BRANCH	REF
8	FKK_CL_ACCOUNT_TXT	COPRC	TFK070B	COPRC	REF	1	CN
9	FKK_CL_ACCOUNT_TXT	COUNTY	T005E	COUNC	REF
10	FKK_CL_ACCOUNT_TXT	DEF_REC	BUT000	PARTNER	REF	1	CN
11	FKK_CL_ACCOUNT_TXT	DEF_REC_IND	TFK070L	CORR_ACKEY	REF	1	CN
12	FKK_CL_ACCOUNT_TXT	EZASP	TFK008	ZAHLS
13	FKK_CL_ACCOUNT_TXT	FDGRP	T035	GRUPP		1	CN
14	FKK_CL_ACCOUNT_TXT	FITYP	J_1AFITPV	J_1AFITP	REF
15	FKK_CL_ACCOUNT_TXT	GPARV	BUT000	PARTNER	REF
16	FKK_CL_ACCOUNT_TXT	IKEY	TFK056A	IKEY
17	FKK_CL_ACCOUNT_TXT	INV_CATEGORY	TFK2604	INV_CATEGORY	REF
18	FKK_CL_ACCOUNT_TXT	LANDL	T005	LAND1
19	FKK_CL_ACCOUNT_TXT	MAHNV	TFK047A	MAHNV
20	FKK_CL_ACCOUNT_TXT	MANSP	TFK047S	MANSP
21	FKK_CL_ACCOUNT_TXT	MGRUP	TFK047F	MGRUP
22	FKK_CL_ACCOUNT_TXT	OPBUK	TFK001G	OPBUK
23	FKK_CL_ACCOUNT_TXT	PERSR	BUT000	PARTNER	REF	1	CN
24	FKK_CL_ACCOUNT_TXT	PROVINCE	T005S	BLAND	REF
25	FKK_CL_ACCOUNT_TXT	STOPG	TFK001S	STOPG
26	FKK_CL_ACCOUNT_TXT	TOGRU	TFK043	TOGRU		1	CN
27	FKK_CL_ACCOUNT_TXT	VERTYP	TFK111	VERTYP	REF
28	FKK_CL_ACCOUNT_TXT	VKONV	FKKVK	VKONT
29	FKK_CL_ACCOUNT_TXT	VKPBZ	TFK002F	VKPBZ
30	FKK_CL_ACCOUNT_TXT	VKTYP	TFK002A	VKTYP

History

Last changed by/on	SAP	20131127
SAP Release Created in