SAP ABAP Table TFICA_DEF (Samples for Contract Account Types)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-PS-CA (Application Component) Public Sector Contract Accounting
     ⤷ FMCAD (Package) PSCD: Basics & Documents

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TFICA_DEF	Table Relationship Diagram
Short Description	Samples for Contract Account Types

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VKTYP	☑	VKTYP_KK	VKTYP_KK	CHAR	2	0	Contract Account Category	TFK002A
3	APPLK	☑	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
4	VKONA	☐	VKONA_KK	CHAR20	CHAR	20	0	Contract account number in legacy system
5	VKBEZ	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
6	.INCLUDE	☐				0	0
7	.INCLUDE	☐				0	0	Data Include for TFICA_DEF (Public Sector Template Values)
8	EXVKO	☐	EXVKO_KK	CHAR25	CHAR	25	0	Reference number for business partner
9	OPBUK	☐	OPBUK_KK	OPBUK_KK	CHAR	4	0	Company Code Group	TFK001G
10	STDBK	☐	STDBK_KK	BUKRS	CHAR	4	0	Standard Company Code	*
11	ABWRE	☐	ABWRE_KK	BU_PARTNER	CHAR	10	0	Alternative Payer	BUT000
12	ABWRA	☐	ABWRA_KK	BU_PARTNER	CHAR	10	0	Alternative Payee	BUT000
13	ABWMA	☐	ABWMA_KK	BU_PARTNER	CHAR	10	0	Alternative dunning recipient	BUT000
14	EBVTY	☐	EBVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Incoming Payments
15	ABVTY	☐	ABVTY_KK	CHAR4	CHAR	4	0	Bank Details ID for Outgoing Payments
16	EZAWE	☐	EZAWE_KK	CHAR1	CHAR	1	0	Incoming Payment Method
17	AZAWE	☐	AZAWE_KK	CHAR5	CHAR	5	0	Outgoing Payment Methods
18	VWNZA	☐	VWNZA_KK	VWNZA_KK	CHAR	1	0	Create Where-Used List For Line Items
19	LOEVM	☐	LOEVM_KK	LOEVM_KK	CHAR	1	0	Mark Contract Account for Deletion
20	ABWVK	☐	ABWVK_KK	VKONT_KK	CHAR	12	0	Alternative contract account for collective bills	FKKVK
21	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
22	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
23	MGRUP	☐	MGRUP_KK	MGRUP_KK	CHAR	2	0	Grouping fur Dunning Notices	TFK047F
24	FDGRP	☐	FDGRP_KK	FDGRP	CHAR	10	0	Planning Group	T035
25	FDZTG	☐	FDZTG_KK	NUM2	NUMC	2	0	Additional Days for Cash Management
26	VKPBZ	☐	VKPBZ_KK	VKPBZ_KK	CHAR	2	0	Relationship of Business Partner to Contract Account	TFK002F
27	VKONV	☐	VKONV_KK	VKONT_KK	CHAR	12	0	Contract account used for payment transactions	FKKVK
28	GPARV	☐	GPARV_KK	BU_PARTNER	CHAR	10	0	Business Partner Acting as Payer in Payment Transactions	BUT000
29	ABWRH	☐	ABWRH_KK	BU_PARTNER	CHAR	10	0	Alternative Invoice Recipient	BUT000
30	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
31	TOGRU	☐	TOGRU_KK	TOGRU_KK	CHAR	4	0	Tolerance group for contract account	TFK043
32	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
33	COPRC	☐	COPRC_KK	COPRC_KK	CHAR	4	0	Correspondence Variant	TFK070B
34	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
35	CCARD_ID	☐	CCID_IN_KK	CHAR6	CHAR	6	0	Payment Card ID for Incoming Payments
36	CCARD_OUT	☐	CCID_OUT_KK	CHAR6	CHAR	6	0	Payment Card ID for Outgoing Payments
37	UEBTR	☐	XUEBTR_KK	XFELD	CHAR	1	0	Items Transferred To Another Account
38	DEF_REC	☐	DEF_CORR_PARTNER_KK	BU_PARTNER	CHAR	10	0	Alternative Correspondence Recipient for Standard Case	BUT000
39	DEF_REC_IND	☐	DEF_CORR_ACKEY_KK	CORR_ACKEY_KK	CHAR	4	0	FI-CA correspondence - activity key	TFK070L
40	QSSKZ_A	☐	QSSKZ_A_KK	QSSKZ	CHAR	2	0	Witholding Tax Code For Outgoing Payments	*
41	QSSKZ_E	☐	QSSKZ_E_KK	QSSKZ	CHAR	2	0	Withholding Tax Code For Incoming Payments	*
42	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
43	QSZDT	☐	QSZDT_DI_KK	CHAR8	CHAR	8	0	Withholding tax exemption cert. valid-until date(YYYYMMDD)
44	CORR_MAHNV	☐	CORR_MAHNV_KK	MAHNV_KK	CHAR	2	0	Correspondence Dunning Procedure	*
45	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITPV
46	PROVINCE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
47	COUNTY	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
48	VERTYP	☐	VERTYP_KK	VERTYP_KK	CHAR	4	0	Clearing Category For Clearing Postings	TFK111
49	AUGRS_DEF	☐	AUGRS_DEF_KK	AUGRS_DEF_KK	CHAR	1	0	Clearing Restriction
50	LANDL	☐	LANDL_KK	LAND1	CHAR	3	0	Country Supplied (for Tax Notifications)	T005
51	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
52	BPTAXTYPE1	☐	BPTAXTYPE1	BPTAXTYPE	CHAR	4	0	Tax Number Type 1 for Business Partner
53	BPTAXTYPE2	☐	BPTAXTYPE2	BPTAXTYPE	CHAR	4	0	Tax Number type 2 for Business Partner
54	.INCLUDE	☐				0	0	Public Sector: Fields in Contract Account(Partner-Dependent)
55	INVTP	☐	INVTP_PS	INVTP_PS	CHAR	2	0	Invoice Type
56	FCALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
57	.INCLUDE	☐				0	0	Manually Set Indicators
58	XFIX_EZAWE	☐	XFIX_EZAWE_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Incoming Payment Method
59	XFIX_AZAWE	☐	XFIX_AZAWE_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Outgoing Payment Method
60	XFIX_OP_LOCK	☐	XFIX_OP_LOCK_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Lock Reason for Outgoing Payment
61	XFIX_IKEY	☐	XFIX_IKEY_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Interest Key
62	XFIX_TOGRU	☐	XFIX_TOGRU_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Tolerance Group
63	XFIX_VERTYP	☐	XFIX_VERTYP_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Clearing Category
64	XFIX_MAHNV	☐	XFIX_MAHNV_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Dunning Procedure
65	XFIX_COPRC	☐	XFIX_COPRC_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Correspondence Variant
66	XFIX_CORR_MAHNV	☐	XFIX_CORR_MAHNV_PS	BOOLE	CHAR	1	0	Apply Manual Setting for Correspondence Dunning Procedure
67	XNO_AUTO_UPDATE	☐	PIQSTUPD_NO_AUTOUPDATE	BOOLE	CHAR	1	0	Deactivate Automatic Update of Student Account Entirely
68	.INCLUDE	☐				0	0
69	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TFICA_DEF	ABWMA	BUT000	PARTNER		1	CN
2	TFICA_DEF	ABWRA	BUT000	PARTNER		1	CN
3	TFICA_DEF	ABWRE	BUT000	PARTNER		1	CN
4	TFICA_DEF	ABWRH	BUT000	PARTNER
5	TFICA_DEF	ABWVK	FKKVK	VKONT
6	TFICA_DEF	BUPLA	J_1BBRANCH	BRANCH	REF
7	TFICA_DEF	COPRC	TFK070B	COPRC	REF	1	CN
8	TFICA_DEF	COUNTY	T005E	COUNC	REF
9	TFICA_DEF	DEF_REC	BUT000	PARTNER	REF	1	CN
10	TFICA_DEF	DEF_REC_IND	TFK070L	CORR_ACKEY	REF	1	CN
11	TFICA_DEF	FDGRP	T035	GRUPP		1	CN
12	TFICA_DEF	FITYP	J_1AFITPV	J_1AFITP	REF
13	TFICA_DEF	GPARV	BUT000	PARTNER	REF
14	TFICA_DEF	IKEY	TFK056A	IKEY
15	TFICA_DEF	LANDL	T005	LAND1
16	TFICA_DEF	MAHNV	TFK047A	MAHNV
17	TFICA_DEF	MANDT	T000	MANDT	KEY	1	CN
18	TFICA_DEF	MGRUP	TFK047F	MGRUP
19	TFICA_DEF	OPBUK	TFK001G	OPBUK
20	TFICA_DEF	PROVINCE	T005S	BLAND	REF
21	TFICA_DEF	TOGRU	TFK043	TOGRU		1	CN
22	TFICA_DEF	TXJCD	TTXJ	TXJCD	REF	1	CN
23	TFICA_DEF	VERTYP	TFK111	VERTYP	REF
24	TFICA_DEF	VKONV	FKKVK	VKONT	REF	1	CN
25	TFICA_DEF	VKPBZ	TFK002F	VKPBZ
26	TFICA_DEF	VKTYP	TFK002A	VKTYP	KEY	1	C

History

Last changed by/on	SAP	20130529
SAP Release Created in	464