SAP ABAP Table EMKINSTLN (Installation 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	EMKINSTLN	Table Relationship Diagram
Short Description	Installation 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	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	EANL
4	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
5	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
6	TARIFTYP	☐	TARIFTYP_ANL	TARIFTYP	CHAR	10	0	Rate category	ETTA
7	ANLSTAT	☐	ANLSTAT	ANLSTAT	CHAR	2	0	Installation Status
8	KONZBEFR	☐	KONZBEFR	KONZBEFR	CHAR	1	0	Exempt from franchise fee
9	PAUSCHAL	☐	E_PAUSCHAL	KENNZX	CHAR	1	0	Device allocation is not possible
10	BRANCHE	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
11	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
12	ABLEINH	☐	ABLEINHEIT	ABLEINHEIT	CHAR	8	0	Meter reading unit	TE422
13	TEMP_AREA	☐	TEMP_AREA	TEMP_AREA	CHAR	8	0	Temperature area	TE307
14	KONZVER	☐	KONZVER	KONZVER	CHAR	10	0	Franchise contract	*
15	BILLING_PARTY	☐	BILLING_PARTY	SERVICE_PROV	CHAR	10	0	Service Provider that Bills the Installation	*
16	INVOICING_PARTY	☐	INVOICING_PARTY	SERVICE_PROV	CHAR	10	0	Service Provider That Invoices the Contract	*
17	PROV_LAST_RES	☐	PROV_LAST_RESSORT	SERVICE_PROV	CHAR	10	0	Obligation to Supply	*
18	MAININST	☐	MAININST	ANLAGE	CHAR	10	0	Key of Primary Installation	EANL
19	INSTROLE	☐	INSTROLE	INSTROLE	CHAR	4	0	Role of an Installation Within the Installation Group	TE673
20	INSTGRTYPE	☐	INSTGRTYPE	INSTGRTYPE	CHAR	4	0	Grouping Type for Installation Group	TE672
21	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
22	SCHEMANR	☐	SCHEMANR	SCHEMANR	CHAR	10	0	Number of the billing schema	ESCH
23	HOCHART	☐	HOCHART	HOCHART	CHAR	1	0	Type of extrapolation in unbilled revenue reporting
24	VPERGRUP	☐	VPERGRUP	VPERGRUP	CHAR	4	0	Previous period control group
25	PRUEFGR	☐	PRUEFGR	PRUEFGR	CHAR	4	0	Validation group for dependent validations	TE413
26	ABSSTEU	☐	ABSSTEU	ABSSTEU	CHAR	1	0	Budget billing control
27	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TESPT
28	VSTELLE	☐	VSTELLE	VSTELLE	CHAR	10	0	Premise	EVBS
29	ABLSPERR	☐	ABLSPERR	ABLSPERR	CHAR	2	0	Reason for blocking meter reading	TE119
30	BAPERTYP	☐	BAPERTYP	BAPERTYP	CHAR	1	0	Base period category
31	ANSCHREI	☐	ANSCHREI	ANSCHREI	CHAR	10	0	Notification control for MR announcement/request
32	SPEBENE	☐	SPEBENE	SPEBENE	CHAR	2	0	Voltage Level	TE369
33	DRCKSTUF	☐	DRCKSTUF_GRID	DRCKSTUF_GRID	CHAR	2	0	Gas Pressure Level at Installation Level (Grid)	TE696
34	ANLART	☐	ANLART	ANLART	CHAR	4	0	Installation type	TE439
35	BEZUG	☐	BEZUG	KENNZX	CHAR	1	0	Reference
36	ABLESARTST	☐	ABLESARTST	ABLESARTST	CHAR	8	0	Control of perm. number of cust. MRs and autom. estimations	TE438
37	NODISCONCT	☐	NODISCONCT	NODISCONCT	CHAR	4	0	Reason for guarantee of supply	TE759
38	SERVICE	☐	SERCODE	SERVCAT	CHAR	4	0	Service Type	TECDE
39	DEREGSTAT	☐	DEREGSTAT	DEREGSTAT	CHAR	2	0	Deregulation status	TEDEREGSTAT
40	INFOREL	☐	INFOREL	INFOREL	CHAR	2	0	Release Status for Installation Data	TEINFOREL
41	ETIMEZONE	☐	EDM_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone for EDM Objects	TTZZ
42	OUCONT	☐	OUCONT	KENNZX	CHAR	1	0	Outline Contract
43	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
46	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
47	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
48	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMKINSTLN	ABLEINH	TE422	TERMSCHL	REF	C	CN
2	EMKINSTLN	ABLESARTST	TE438	ABLESARTST	REF	1	CN
3	EMKINSTLN	ABLSPERR	TE119	ABLSPERR		1	CN
4	EMKINSTLN	AKLASSE	EAKLASSE	AKLASSE	REF	1	CN
5	EMKINSTLN	ANLAGE	EANL	MANDT	KEY	1	CN
6	EMKINSTLN	ANLART	TE439	ANLART		1	CN
7	EMKINSTLN	BRANCHE	TB038A	IND_SECTOR	REF
8	EMKINSTLN	DEREGSTAT	TEDEREGSTAT	DEREGSTAT	REF	C	CN
9	EMKINSTLN	DRCKSTUF	TE696	DRUCKSTUF		1	N
10	EMKINSTLN	ETIMEZONE	TTZZ	TZONE	KEY	1	CN
11	EMKINSTLN	INFOREL	TEINFOREL	INFOREL	REF	C	CN
12	EMKINSTLN	INSTGRTYPE	TE672	INSTGRTYPE
13	EMKINSTLN	INSTROLE	TE673	INSTROLE
14	EMKINSTLN	ISTYPE	TB038	ISTYPE
15	EMKINSTLN	MAININST	EANL	MANDT
16	EMKINSTLN	MANDT	T000	MANDT	KEY	1	CN
17	EMKINSTLN	NODISCONCT	TE759	NODISCONCT	REF	1	CN
18	EMKINSTLN	PRUEFGR	TE413	PRUEFGR		1	CN
19	EMKINSTLN	SCHEMANR	ESCH	SCHEMANR		1	CN
20	EMKINSTLN	SERVICE	TECDE	SERVICE	REF	C	CN
21	EMKINSTLN	SPARTE	TESPT	SPARTE		1	CN
22	EMKINSTLN	SPEBENE	TE369	SPEBENE		1	CN
23	EMKINSTLN	TARIFTYP	ETTA	TARIFTYP	REF	1	CN
24	EMKINSTLN	TEMP_AREA	TE307	TEMP_AREA	REF	C	CN
25	EMKINSTLN	VSTELLE	EVBS	VSTELLE		1	CN

History

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