SAP ABAP Table EMDSTAT14 (Fields for Cross-Statistics Records for Master Data)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IS-ST (Application Component) Statistics
     ⤷ EE70 (Package) IS-U: Statistics

Basic Data

Table Category	INTTAB	Structure
Structure	EMDSTAT14	Table Relationship Diagram
Short Description	Fields for Cross-Statistics Records for Master Data

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	OPBUK	☐	OPBUK_KK	OPBUK_KK	CHAR	4	0	Company Code Group	TFK001G
3	VKTYP	☐	VKTYP_KK	VKTYP_KK	CHAR	2	0	Contract Account Category	TFK002A
4	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	KONTOKLASSE
5	VERTYP	☐	E_VERTYP	E_VERTYP	CHAR	4	0	Clearing Category for Clearing Entries	TE510
6	KOFIZ_SD	☐	E_KOFIZ_SD	E_KOFIZ_SD	CHAR	2	0	Account determination ID for contract accounts	TE097A
7	ZAHLKOND	☐	KONDZAHL	KONDZAHL	CHAR	4	0	Payment Condition	TE052
8	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
9	MGRUP	☐	MGRUP_KK	MGRUP_KK	CHAR	2	0	Grouping fur Dunning Notices	TFK047F
10	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
11	MANSP	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
12	KZ_EBVTY	☐	KZ_EBVTY	KZ_EBVTY	CHAR	1	0	Incoming Bank Details Exist
13	KZ_ABVTY	☐	KZ_ABVTY	KZ_ABVTY	CHAR	1	0	Outgoing Bank Details Exist
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
16	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
17	KZ_PERSNR	☐	KZ_PERSNR	KZ_PERSNR	CHAR	1	0	Personnel Number Allocated
18	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
19	PORTION	☐	PORTION	PORTION	CHAR	8	0	Portion	TE420
20	ABRSPERR	☐	ABRSPERR	ABRSPERR	CHAR	2	0	Reason for blocking billing	TE021
21	ABRFREIG	☐	ABRFREIG	ABRFREIG	CHAR	2	0	Reason for releasing billing	TE023
22	MANABR	☐	MANABR	KENNZX	CHAR	1	0	Bill contract manually
23	BEZUG	☐	BEZUG	KENNZX	CHAR	1	0	Reference
24	CAMPAIGN	☐	ISU_MARKETING_CAMPAIGN_EXTERN	PS_POSID	CHAR	24	0	IS-U: Marketing Campaign
25	ANLSTAT	☐	ANLSTAT	ANLSTAT	CHAR	2	0	Installation Status
26	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
27	ABLEINH	☐	ABLEINH	ABLEINHEIT	CHAR	8	0	Meter reading unit	TE422
28	TARIFTYP	☐	TARIFTYP	TARIFTYP	CHAR	10	0	Rate category	ETTA
29	BRANCHE	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
30	ABLSPERR	☐	ABLSPERR	ABLSPERR	CHAR	2	0	Reason for blocking meter reading	TE119
31	ANLART	☐	ANLART	ANLART	CHAR	4	0	Installation type	TE439
32	SPEBENE	☐	SPEBENE	SPEBENE	CHAR	2	0	Voltage Level	TE369
33	PAUSCHAL	☐	E_PAUSCHAL	KENNZX	CHAR	1	0	Device allocation is not possible
34	ACTORID	☐	ACTORID	HROBJID_12	CHAR	12	0	Agent ID in Organizational Management
35	REGPOLIT	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	TE227
36	.INCLUDE	☐				0	0
37	STATANZ	☐	STATANZ	STATANZ	INT4	10	0	Number in statistics

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMDSTAT14	ABLEINH	TE422	TERMSCHL
2	EMDSTAT14	ABLSPERR	TE119	ABLSPERR
3	EMDSTAT14	ABRFREIG	TE023	ABRFREIG
4	EMDSTAT14	ABRSPERR	TE021	ABRSPERR
5	EMDSTAT14	AKLASSE	EAKLASSE	AKLASSE
6	EMDSTAT14	ANLART	TE439	ANLART
7	EMDSTAT14	BRANCHE	TB023	IND_SECTOR
8	EMDSTAT14	BUKRS	T001	BUKRS
9	EMDSTAT14	IKEY	TFK056A	IKEY
10	EMDSTAT14	KOFIZ	TE097	KOFIZ
11	EMDSTAT14	KOFIZ_SD	TE097A	KOFIZ
12	EMDSTAT14	KTOKLASSE	KONTOKLASSE	KTOKL
13	EMDSTAT14	MAHNV	TFK047A	MAHNV
14	EMDSTAT14	MANSP	TFK047S	MANSP
15	EMDSTAT14	MGRUP	TFK047F	MGRUP
16	EMDSTAT14	OPBUK	TFK001G	OPBUK
17	EMDSTAT14	PORTION	TE420	TERMSCHL
18	EMDSTAT14	REGPOLIT	TE227	REGPOLIT
19	EMDSTAT14	SPARTE	TSPA	SPART
20	EMDSTAT14	SPEBENE	TE369	SPEBENE
21	EMDSTAT14	TARIFTYP	ETTA	TARIFTYP
22	EMDSTAT14	VERTYP	TE510	VERTYP
23	EMDSTAT14	VKTYP	TFK002A	VKTYP
24	EMDSTAT14	ZAHLKOND	TE052	ZAHLKOND

History

Last changed by/on	SAP	20110901
SAP Release Created in