SAP ABAP Table EKUNI (IS-U-Specific Fields for Business Partner)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE04 (Package) IS-U: Customer/Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	EKUNI	Table Relationship Diagram
Short Description	IS-U-Specific Fields for Business Partner

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	WAKLASS	☐	WAKLASS	E_WAKLASS	CHAR	4	0	Employee classification	TE697
2	FIRMART	☐	FIRMART	FIRMART	CHAR	2	0	Type of installation company	TE183
3	ARBFELD	☐	ARBFELD	ARBFELD	CHAR	2	0	Company work field	TE185
4	MITGLIED	☐	MITGLIED	MITGLIED	CHAR	1	0	Membership of installer
5	SPZULASS	☐	SPZULASS	SPZULASS	CHAR	20	0	Division license of installer
6	ARTZULASS	☐	ARTZULASS	ARTZULASS	CHAR	2	0	Installer license type	TE189
7	AUSWANZ	☐	AUSWANZ	AUSWANZ	NUMC	2	0	Number of identifications
8	PLOMBENZ	☐	PLOMBENZ	PLOMBENZ	CHAR	10	0	Sealing pliers number
9	FREMDEVU	☐	FREMDEVU	EVU	CHAR	3	0	Main utility company	TE187
10	STATINS	☐	STATINS	STATINS	CHAR	2	0	Valid status of installer in supply area	TE061
11	STATDATUM	☐	STATDATUM	STATDATUM	DATS	8	0	Date on which status of installer comes into effect
12	ERSTZUL	☐	ERSTZUL	ERSTZUL	DATS	8	0	Date of initial license of installer
13	WERKSTATT	☐	WERKSTATT	WERKSTATT	DATS	8	0	Date of workshop inspection
14	VERLZUL	☐	VERLZUL	VERLZUL	DATS	8	0	Date of license renewal
15	ENDEZUL	☐	ENDEZUL	ENDEZUL	DATS	8	0	Date until which license is renewed
16	ANZEVU	☐	ANZEVU	ANZEVU	NUMC	2	0	Number of utility companies
17	ANZFIL	☐	ANZFIL	ANZFIL	NUMC	2	0	Number of branches supported by an installionr company
18	AUSW_INST	☐	AUSW_INST	AUSW_INST	CHAR	10	0	Identification number for installer license
19	DR_LICENSE_LAND1	☐	DR_LICENSE_LAND1	LAND1	CHAR	3	0	Country in which driver's license was acquired	T005
20	DR_LICENSE_REGIO	☐	DR_LICENSE_REGIO	REGIO	CHAR	3	0	Region in which driver's license was acquired	T005S
21	DR_LICENSE	☐	DR_LICENSE	DR_LICENSE	CHAR	20	0	Driver's license number
22	SOC_SECURE	☐	E_SOC_SECU	E_SOC_SECU	CHAR	12	0	Social Insurance Number
23	WELFARE	☐	WELFARE	WELFARE	CHAR	9	0	Welfare office
24	PLACE_EMPL	☐	PLACE_EMPL	CHAR40	CHAR	40	0	Work center
25	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	KONTOKLASSE
26	BUPINFOREL	☐	BUPINFOREL	BUPINFOREL	CHAR	2	0	Information release for business partner data	TEBUPINFOREL
27	CLERK_ID	☐	E_CLERK_ID	E_CLERK_ID	CHAR	8	0	Business partner-specific criteria for agent determination	TECLERK_ID
28	RECPTYPE	☐	E_RECPTYPE	E_RECPTYPE	CHAR	1	0	Category for Alternate Payee
29	PYMET	☐	E_PYMET_DON	PYMET_KK	CHAR	1	0	Payment method for donations/fund payments	TFK042Z
30	EMBVT	☐	E_EMBVT_DON	CHAR4	CHAR	4	0	Bank details ID for donations/fund payments
31	HKONT	☐	E_HKONT_DON	SAKNR	CHAR	10	0	G/L accounts for donations/fund payments	SKA1
32	CLASSIFICATION	☐	E_CLASSIFICATION	CHAR4	CHAR	4	0	Classification of Business Partner	TE181
33	VIP	☐	E_VIP	KENNZX	CHAR	1	0	Indicate Very Important Business Partner
34	IDENT_INST	☐	IDENT_INST	IDENT_INST	CHAR	18	0	Identification Number for Installer License

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKUNI	ARBFELD	TE185	ARBFELD
2	EKUNI	ARTZULASS	TE189	ARTZULASS
3	EKUNI	BUPINFOREL	TEBUPINFOREL	INFOREL
4	EKUNI	CLASSIFICATION	TE181	CLASSIFICATION
5	EKUNI	CLERK_ID	TECLERK_ID	CLERK_ID
6	EKUNI	DR_LICENSE_LAND1	T005	LAND1
7	EKUNI	DR_LICENSE_REGIO	T005S	BLAND
8	EKUNI	FIRMART	TE183	FIRMART
9	EKUNI	FREMDEVU	TE187	EVU
10	EKUNI	HKONT	SKA1	SAKNR
11	EKUNI	KTOKLASSE	KONTOKLASSE	KTOKL
12	EKUNI	PYMET	TFK042Z	ZLSCH
13	EKUNI	STATINS	TE061	STATINS
14	EKUNI	WAKLASS	TE697	WAKLASS

History

Last changed by/on	SAP	20110901
SAP Release Created in