SAP ABAP Table EMKBCONT (Customer contact 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	EMKBCONT	Table Relationship Diagram
Short Description	Customer contact 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	Business Partner Contact
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BPCONTACT	☐	CT_CONTACT	CT_CONTACT	CHAR	12	0	Business Partner Contact	*
4	PCATEGORY	☐	CT_PCATEG	CT_PCATEG	CHAR	1	0	Business Partner Category of SAP System
5	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
6	ALTPARTNER	☐	CT_ALTPART	BU_PARTNER	CHAR	10	0	Contact Person	BUT000
7	RLTYP	☐	BU_RLTYP	BU_RLTYP	CHAR	6	0	BDT: Object part	*
8	CTYPE	☐	CT_CTYPE	CT_CTYPE	CHAR	3	0	Contact Type	BCONTT
9	CCLASS	☐	CT_CCLASS	CT_CLASS	CHAR	4	0	Contact Class	BCONTC
10	ACTIVITY	☐	CT_ACTIVIT	CT_ACTIVIT	CHAR	4	0	Contact Action	BCONTA
11	F_COMING	☐	CT_COMING	CT_COMING	CHAR	1	0	Contact Direction (Incoming or Outgoing)	BCONTCD
12	ORIGIN	☐	CT_ORIGIN	CT_ORIGIN	CHAR	1	0	Technical Origin of Business Partner Contact
13	CTDATE	☐	DATUM	DATUM	DATS	8	0	Date
14	CTTIME	☐	TIME_	SYTIME	TIMS	6	0	Time
15	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
16	.INCLUDE	☐				0	0	Creation and Change Data
17	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
18	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
20	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
22	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
23	WFID	☐	CT_WFID	SWW_WIID	NUMC	12	0	Workflow ID	SWWWIHEAD
24	ADDINFO	☐	CT_ADDINFO	CT_ADDINFO	CHAR	2	0	Additional Documents Are Available	BCONTAI
25	PRIORITY	☐	CT_PRIORITY	CT_PRIORITY	CHAR	2	0	Contact Priority	BCONTP
26	CUSTINFO	☐	CT_CUSTINFO	CT_CUSTINFO	CHAR	2	0	Customer Information	BCONTCI
27	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
28	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
29	.INCLUDE	☐				0	0
30	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMKBCONT	ACTIVITY	BCONTA	ACTIVITY
2	EMKBCONT	ADDINFO	BCONTAI	ADDINFO	KEY	1	CN
3	EMKBCONT	ALTPARTNER	BUT000	PARTNER
4	EMKBCONT	BUKRS	T001	BUKRS
5	EMKBCONT	CCLASS	BCONTC	CCLASS
6	EMKBCONT	CTYPE	BCONTT	CTYPE
7	EMKBCONT	CUSTINFO	BCONTCI	CUSTINFO
8	EMKBCONT	F_COMING	BCONTCD	F_COMING
9	EMKBCONT	MANDT	T000	MANDT
10	EMKBCONT	PARTNER	BUT000	PARTNER
11	EMKBCONT	PRIORITY	BCONTP	PRIORITY
12	EMKBCONT	SPARTE	TSPA	SPART
13	EMKBCONT	WFID	SWWWIHEAD	WI_ID

History

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