SAP ABAP Table ETTIFB (Installation Facts (Reference Values))

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-BI (Application Component) Contract Billing
     ⤷ EE20 (Package) IS-U: Billing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ETTIFB	Table Relationship Diagram
Short Description	Installation Facts (Reference Values)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	ANLAGE	☑	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
3	OPERAND	☑	E_OPERAND	E_OPERAND	CHAR	10	0	Operand	*
4	OPLFDNR	☑	OPLFDNR	LFDNR4	NUMC	4	0	Consecutive number of an operand
5	AB	☑	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
6	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
7	TARIFART	☐	TARIFART	TARIFART	CHAR	8	0	Rate Type	*
8	KONDIGR	☐	KONDIGR	KONDIGR	CHAR	10	0	Rate fact group	*
9	.INCLUDE	☐				0	0	General Fields for Operand Values
10	WERT1	☐	E_WERT1	OPWERT	DEC	16	7	Entry value (installed value) for a device
11	WERT2	☐	E_WERT2	OPWERT	DEC	16	7	Value to be billed
12	STRING1	☐	STRING1	CHAR10	CHAR	10	0	First key field for operand value
13	STRING2	☐	STRING2	CHAR10	CHAR	10	0	Second key field for operand value
14	STRING3	☐	STRING3	CHAR1	CHAR	1	0	Third key field for operand value
15	STRING4	☐	STRING4	CHAR1	CHAR	1	0	Fourth key field for operand value
16	ERSATZWERT	☐	ERSATZWERT	ERSATZWERT	CHAR	1	0	Replacement value for operands
17	BETRAG	☐	E_BETRAG	WRTV7	CURR	13	2	Currency-dependent amount
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	.INCLUDE	☐				0	0	Special Fields for Operand Values
20	.INCLUDE	☐				0	0	Special Fields for Operands of Categ. BEZUGSGR
21	LOGIKZW	☐	LOGIKZW	LOGIKZW	NUMC	18	0	Logical register number
22	LOGIKNR	☐	LOGIKNR	LOGIKNR	NUMC	18	0	Logical device number
23	EQUNR	☐	REFV_EQUNR	EQUNR	CHAR	18	0	Allocation of reference value to equipment number	*
24	ABRECH	☐	ABRECH	KENNZX	CHAR	1	0	Not relevant to billing
25	GENWERT	☐	GENWERT	LWERT	DEC	16	6	Contract demand limit
26	VERGLREL	☐	VERGLREL	KENNZX	CHAR	1	0	Not comparison-relevant (connection)
27	WDHFAKT	☐	WDHFAKT	E_FAKTOR	INT4	10	0	Repetition factor for reference values
28	VTYP	☐	E_VTYP	VTYP	CHAR	4	0	Contract category for heating installations	*
29	LAGE	☐	LAGE	LAGE	CHAR	4	0	Location of reference value	*
30	LGZUSATZ	☐	LGZUSATZ	LGZUSATZ	CHAR	40	0	Additional Information on Location
31	HZBAUFRM	☐	HZBAUFRM	HZBAUFRM	CHAR	4	0	Description of a heating installation	TE677
32	LEUCHTNR	☐	LEUCHTNR	LEUCHTNR	CHAR	10	0	External lighting number
33	BSSTATUS	☐	BSSTATUS	BSSTATUS	CHAR	1	0	Lighting belongs to the utility company
34	WARTKOST	☐	WARTKOST	WARTKOST	CHAR	1	0	Streetlights subject to maintenance costs
35	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
36	ANZEINZ	☐	ANZEINZ	ANZEINZ	INT4	10	0	Number of individual devices in a heating installation
37	AUFLDSTG	☐	AUFLDSTG	AUFLDSTG	CHAR	10	0	Heating installation charging control	TE679
38	INHALT	☐	E_INHALT	E_INHALT	CHAR	4	0	Contents
39	BZGBEZ	☐	BZGBEZ	TEXT30	CHAR	30	0	Reference value description deviates from operand descript.
40	CONSUMPTION	☐	LIGHTCONSUMPTION	OPWERT	DEC	16	7	Consumption for streetlight
41	ADDAMOUNT	☐	ADDAMOUNT	WRTV7	CURR	13	2	Additional flat-rate amount for a streetlight
42	ADDAMOUNTWAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
43	TIMBASIS	☐	TIMBASIS	TIMBASIS	CHAR	3	0	Time Basis
44	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
45	EIGENTUM	☐	EIGENTUM	EIGENTUM	CHAR	2	0	Owner
46	CONTSHARE	☐	CONTSHARE	CONTSHARE	DEC	31	14	Container Portion
47	EQUNR_WSTE	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
48	NO_UNITIES	☐	NO_UNITIES	NUMC6	NUMC	6	0	No. of premises
49	BEHAELTER	☐	BEHAELTER	GERNR	CHAR	18	0	Serial Number of Container
50	BEH_TYPE	☐	BEH_TYPE	MATNR	CHAR	18	0	Container category	*
51	CLEAN_PROP	☐	EEWA_CLEAN_PROP	EEWA_CLEAN_PROP	CHAR	12	0	Property
52	PROPSHARE	☐	PROPSHARE	CONTSHARE	DEC	31	14	Property Portion
53	BEHGRP	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group	*
54	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ETTIFB	ADDAMOUNTWAERS	TCURC	WAERS		1	CN
2	ETTIFB	AUFLDSTG	TE679	AUFLDSTG
3	ETTIFB	HZBAUFRM	TE677	HZBAUFRM

History

Last changed by/on	SAP	20110901
SAP Release Created in