SAP ABAP Table EMKBPART (Business partner 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	EMKBPART	Table Relationship Diagram
Short Description	Business partner 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	BP: General data I
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - External)
5	.INCLUDE	☐				0	0	CBP: General data (independent of partner cat.)
6	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Initial Screen
7	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
8	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	TB004
9	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
10	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
11	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Data Screens
12	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
13	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
14	SOURCE	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	TB005
15	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
16	XDELE	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
17	XBLCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
18	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
19	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
20	BU_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
21	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
22	NOT_RELEASED	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
23	NOT_LG_COMPETENT	☐	BU_NOT_LEG_COMPETENT	BOOLE	CHAR	1	0	Indicator: Not Legally Competent
24	PRINT_MODE	☐	BU_PRINT_MODE	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
25	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
26	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
27	.INCLUDE	☐				0	0
28	.INCLU--AP	☐				0	0	Cost/Revenue Type in Resource Role
29	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	DPR_RATES
30	.INCLUDE	☐				0	0	CBP: General data (Organization)
31	.INCLUDE	☐				0	0	CBP: General Data, Organization (CHAR Fields)
32	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
33	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
34	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
35	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
36	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	TB019
37	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
38	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
39	.INCLUDE	☐				0	0	CBP: General Data, Organization (Non CHAR Fields)
40	FOUND_DAT	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
41	LIQUID_DAT	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
42	LOCATION_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
43	LOCATION_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
44	LOCATION_3	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
45	.INCLUDE	☐				0	0	CBP: General Data, Person
46	.INCLUDE	☐				0	0	CBP: General Data, Person (CHAR Fields)
47	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
48	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
49	NAME_LST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
50	NAME_LAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
51	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
52	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
53	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
54	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
55	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
56	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
57	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
58	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
59	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
60	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
61	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
62	LANGU_CORR	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	T002
63	XSEXM	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
64	XSEXF	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
65	BIRTHPL	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
66	MARST	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	TB027
67	EMPLO	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
68	JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	TB028
69	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	T005
70	CNTAX	☐	BU_CNTAX	LAND1	CHAR	3	0	Obsolete Field	*
71	CNDSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	T005
72	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
73	XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
74	XUBNAME	☐	BU_XUBNAME	XUBNAME	CHAR	12	0	Obsolete Field	USR02
75	BU_LANGU	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	T002
76	.INCLUDE	☐				0	0	CBP: General Data, Person (Non CHAR Fields)
77	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
78	DEATHDT	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
79	PERNO	☐	BU_PERNO	PERSONID	NUMC	8	0	Personnel Number
80	CHILDREN	☐	BU_CHILDREN	NUMC2	NUMC	2	0	Obsolete Field
81	MEM_HOUSE	☐	BU_MEM_HOUSE	DEC2	DEC	2	0	Obsolete Field
82	.INCLUDE	☐				0	0	CBP: General data (group of people)
83	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	TB025
84	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
85	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
86	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - Internal)
87	.INCLUDE	☐				0	0	CBP: Internal general data (not dependent on partner cat.)
88	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
89	MC_NAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
90	CRUSR	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
91	CRDAT	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
92	CRTIM	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
93	CHUSR	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
94	CHDAT	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
95	CHTIM	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed
96	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
97	ADDRCOMM	☐	BU_ADDRCOMM	AD_ADDRNUM	CHAR	10	0	Address Number	*
98	TD_SWITCH	☐	BU_TD_SWITCH	CHAR1	CHAR	1	0	Planned Change Documents for Partner Were Converted
99	IS_ORG_CENTRE	☐	BU_IS_ORG_CENTRE	BU_IS_ORG_CENTRE	CHAR	1	0	Indicator: Business Partner Is Also an Organizational Center
100	DB_KEY	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
101	VALID_FROM	☐	BU_BP_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start BUT000 BP Data
102	VALID_TO	☐	BU_BP_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End BUT000 BP Data
103	XPCPT	☐	BU_XPCPT	BU_XPCPT	CHAR	1	0	Business Purpose Completed Flag
104	.INCLU--AP	☐				0	0	Append BUT000: Indicator Natural Person for Taxes
105	NATPERS	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
106	.INCLU--AP	☐				0	0	Obsolete: Business Partner: Treasury Append
107	PAR_REL	☐	BP_PAR_REL	BP_PAR_REL	CHAR	1	0	Business Partner Released
108	BP_SORT	☐	BP_SORT_PH	CHAR20	CHAR	20	0	Sort Field for Phonetic Search; Obsolete
109	.INCLU--AP	☐				0	0	Business Partner: Further Data for BCA
110	KBANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
111	KBANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
112	.INCLUDE	☐				0	0	IS-U-Specific Fields for Business Partner
113	WAKLASS	☐	WAKLASS	E_WAKLASS	CHAR	4	0	Employee classification	TE697
114	FIRMART	☐	FIRMART	FIRMART	CHAR	2	0	Type of installation company	TE183
115	ARBFELD	☐	ARBFELD	ARBFELD	CHAR	2	0	Company work field	TE185
116	MITGLIED	☐	MITGLIED	MITGLIED	CHAR	1	0	Membership of installer
117	SPZULASS	☐	SPZULASS	SPZULASS	CHAR	20	0	Division license of installer
118	ARTZULASS	☐	ARTZULASS	ARTZULASS	CHAR	2	0	Installer license type	TE189
119	AUSWANZ	☐	AUSWANZ	AUSWANZ	NUMC	2	0	Number of identifications
120	PLOMBENZ	☐	PLOMBENZ	PLOMBENZ	CHAR	10	0	Sealing pliers number
121	FREMDEVU	☐	FREMDEVU	EVU	CHAR	3	0	Main utility company	TE187
122	STATINS	☐	STATINS	STATINS	CHAR	2	0	Valid status of installer in supply area	TE061
123	STATDATUM	☐	STATDATUM	STATDATUM	DATS	8	0	Date on which status of installer comes into effect
124	ERSTZUL	☐	ERSTZUL	ERSTZUL	DATS	8	0	Date of initial license of installer
125	WERKSTATT	☐	WERKSTATT	WERKSTATT	DATS	8	0	Date of workshop inspection
126	VERLZUL	☐	VERLZUL	VERLZUL	DATS	8	0	Date of license renewal
127	ENDEZUL	☐	ENDEZUL	ENDEZUL	DATS	8	0	Date until which license is renewed
128	ANZEVU	☐	ANZEVU	ANZEVU	NUMC	2	0	Number of utility companies
129	ANZFIL	☐	ANZFIL	ANZFIL	NUMC	2	0	Number of branches supported by an installionr company
130	AUSW_INST	☐	AUSW_INST	AUSW_INST	CHAR	10	0	Identification number for installer license
131	DR_LICENSE_LAND1	☐	DR_LICENSE_LAND1	LAND1	CHAR	3	0	Country in which driver's license was acquired	T005
132	DR_LICENSE_REGIO	☐	DR_LICENSE_REGIO	REGIO	CHAR	3	0	Region in which driver's license was acquired	T005S
133	DR_LICENSE	☐	DR_LICENSE	DR_LICENSE	CHAR	20	0	Driver's license number
134	SOC_SECURE	☐	E_SOC_SECU	E_SOC_SECU	CHAR	12	0	Social Insurance Number
135	WELFARE	☐	WELFARE	WELFARE	CHAR	9	0	Welfare office
136	PLACE_EMPL	☐	PLACE_EMPL	CHAR40	CHAR	40	0	Work center
137	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	KONTOKLASSE
138	BUPINFOREL	☐	BUPINFOREL	BUPINFOREL	CHAR	2	0	Information release for business partner data	TEBUPINFOREL
139	CLERK_ID	☐	E_CLERK_ID	E_CLERK_ID	CHAR	8	0	Business partner-specific criteria for agent determination	TECLERK_ID
140	RECPTYPE	☐	E_RECPTYPE	E_RECPTYPE	CHAR	1	0	Category for Alternate Payee
141	PYMET	☐	E_PYMET_DON	PYMET_KK	CHAR	1	0	Payment method for donations/fund payments	TFK042Z
142	EMBVT	☐	E_EMBVT_DON	CHAR4	CHAR	4	0	Bank details ID for donations/fund payments
143	HKONT	☐	E_HKONT_DON	SAKNR	CHAR	10	0	G/L accounts for donations/fund payments	SKA1
144	CLASSIFICATION	☐	E_CLASSIFICATION	CHAR4	CHAR	4	0	Classification of Business Partner	TE181
145	VIP	☐	E_VIP	KENNZX	CHAR	1	0	Indicate Very Important Business Partner
146	IDENT_INST	☐	IDENT_INST	IDENT_INST	CHAR	18	0	Identification Number for Installer License
147	BONIT	☐	BONIT_KK	BONIT_KK	NUMC	4	0	Creditworthiness
148	XSMTPADR	☐	XSMTPADR	KENNZX	CHAR	1	0	Internet mail (SMTP-) address exists
149	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
150	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMKBPART	ARBFELD	TE185	ARBFELD
2	EMKBPART	ARTZULASS	TE189	ARTZULASS
3	EMKBPART	AUGRP	TB037	AUGRP	REF	1	CN
4	EMKBPART	BPKIND	TB004	BPKIND	REF	1	CN
5	EMKBPART	BUPINFOREL	TEBUPINFOREL	INFOREL
6	EMKBPART	BU_GROUP	TB001	BU_GROUP	REF	1	CN
7	EMKBPART	BU_LANGU	T002	SPRAS	REF	C	CN
8	EMKBPART	BU_LOGSYS	TBDLS	LOGSYS		1	CN
9	EMKBPART	CLASSIFICATION	TE181	CLASSIFICATION
10	EMKBPART	CLERK_ID	TECLERK_ID	CLERK_ID
11	EMKBPART	CLIENT	T000	MANDT	KEY	1	CN
12	EMKBPART	CNDSC	T005	LAND1	REF	1	CN
13	EMKBPART	DR_LICENSE_LAND1	T005	LAND1
14	EMKBPART	DR_LICENSE_REGIO	T005S	BLAND
15	EMKBPART	FIRMART	TE183	FIRMART
16	EMKBPART	FREMDEVU	TE187	EVU
17	EMKBPART	HKONT	SKA1	SAKNR
18	EMKBPART	IND_SECTOR	TB023	IND_SECTOR	REF	1	CN
19	EMKBPART	JOBGR	TB028	JOBGR	REF	1	CN
20	EMKBPART	KTOKLASSE	KONTOKLASSE	KTOKL
21	EMKBPART	LANGU_CORR	T002	SPRAS	REF	C	CN
22	EMKBPART	LEGAL_ENTY	TB019	LEGAL_ENTY	KEY	1	CN
23	EMKBPART	LEGAL_ORG	TB032	LEGAL_ORG	REF	1	CN
24	EMKBPART	MARST	TB027	MARST		1	CN
25	EMKBPART	NAMCOUNTRY	T005	LAND1	REF	C	CN
26	EMKBPART	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
27	EMKBPART	NATIO	T005	LAND1		1	CN
28	EMKBPART	PARTGRPTYP	TB025	PARTGRPTYP	KEY	1	CN
29	EMKBPART	PREFIX1	TSAD4	PREFIX_KEY
30	EMKBPART	PREFIX2	TSAD4	PREFIX_KEY
31	EMKBPART	PYMET	TFK042Z	ZLSCH
32	EMKBPART	RATE	DPR_RATES	RATE	KEY
33	EMKBPART	SOURCE	TB005	SOURCE	KEY	1	CN
34	EMKBPART	STATINS	TE061	STATINS
35	EMKBPART	TITLE	TSAD3	TITLE	REF
36	EMKBPART	TITLE_ACA1	TSAD2	TITLE_KEY
37	EMKBPART	TITLE_ACA2	TSAD2	TITLE_KEY
38	EMKBPART	TITLE_ROYL	TSAD5	TITLE_KEY
39	EMKBPART	WAKLASS	TE697	WAKLASS
40	EMKBPART	XUBNAME	USR02	BNAME	KEY	1	CN

History

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