SAP ABAP Table EKUNUPD (BP: IS-U-Specific Data (Update))

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	EKUNUPD	Table Relationship Diagram
Short Description	BP: IS-U-Specific Data (Update)

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in