SAP ABAP Table V_TCMAC_DEF (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_TCMAC_DEF	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in