SAP ABAP Table EMKACCNT (Contract account data for logical databases (marketing))

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-MA (Application Component) Marketing
     ⤷ EE_CRM_MKT_LDB (Package) Logical Database for Marketing Analyses in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	EMKACCNT	Table Relationship Diagram
Short Description	Contract account data for logical databases (marketing)

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in	462