The ETTIF table in SAP ERP or S/4HANA stores Instln Facts data. There are total 58 fields in ETTIF table. The Instln Facts table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ETTIF table. It is in IS-U: Billing (EE20) ABAP package and is part of the Contract Billing (IS-U-BI) module.
SAP ETTIF Table Fields
Following is the list of fields that are available in SAP ETTIF table. The primary key fields of the table are MANDT (Client), ANLAGE (Installation), OPERAND (Operand), OPLFDNR (Consecutive number of an operand), SAISON (Season), AB (Date from which time slice is valid), ABLFDNR (Consecutive Number for a From-Date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| ANLAGE | Installation | ANLAGE | * | CHAR (10) |
| OPERAND | Operand | E_OPERAND | * | CHAR (10) |
| OPLFDNR | Consecutive number of an operand | OPLFDNR | NUMC (4) | |
| SAISON | Season | SAISON | * | CHAR (10) |
| AB | Date from which time slice is valid | ABZEITSCH | DATS (8) | |
| ABLFDNR | Consecutive Number for a From-Date | ABLFDNR | NUMC (4) | |
| BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS (8) | |
| BELNR | Billing Document Number | E_BELNR | CHAR (12) | |
| MBELNR | Billing Document Number | E_BELNR | CHAR (12) | |
| ALTBIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS (8) | |
| INAKTIV | Entry Inactive | INAKTIVKZ | CHAR (1) | |
| MANAEND | Indicator: manual change to calculated value | MANAEND | CHAR (1) | |
| TARIFART | Rate Type | TARIFART | TE069 | CHAR (8) |
| KONDIGR | Rate fact group | KONDIGR | * | CHAR (10) |
| WERT1 | Entry value (installed value) for a device | E_WERT1 | DEC (16) | |
| WERT2 | Value to be billed | E_WERT2 | DEC (16) | |
| STRING1 | First key field for operand value | STRING1 | CHAR (10) | |
| STRING2 | Second key field for operand value | STRING2 | CHAR (10) | |
| STRING3 | Third key field for operand value | STRING3 | CHAR (1) | |
| STRING4 | Fourth key field for operand value | STRING4 | CHAR (1) | |
| ERSATZWERT | Replacement value for operands | ERSATZWERT | CHAR (1) | |
| BETRAG | Currency-dependent amount | E_BETRAG | CURR (13) | |
| WAERS | Currency Key | WAERS | * | CUKY (5) |
| LOGIKZW | Logical register number | LOGIKZW | NUMC (18) | |
| LOGIKNR | Logical device number | LOGIKNR | NUMC (18) | |
| EQUNR | Allocation of reference value to equipment number | REFV_EQUNR | * | CHAR (18) |
| ABRECH | Not relevant to billing | ABRECH | CHAR (1) | |
| GENWERT | Contract demand limit | GENWERT | DEC (16) | |
| VERGLREL | Not comparison-relevant (connection) | VERGLREL | CHAR (1) | |
| WDHFAKT | Repetition factor for reference values | WDHFAKT | INT4 (10) | |
| VTYP | Contract category for heating installations | E_VTYP | * | CHAR (4) |
| LAGE | Location of reference value | LAGE | * | CHAR (4) |
| LGZUSATZ | Additional Information on Location | LGZUSATZ | CHAR (40) | |
| HZBAUFRM | Description of a heating installation | HZBAUFRM | TE677 | CHAR (4) |
| LEUCHTNR | External lighting number | LEUCHTNR | CHAR (10) | |
| BSSTATUS | Lighting belongs to the utility company | BSSTATUS | CHAR (1) | |
| WARTKOST | Streetlights subject to maintenance costs | WARTKOST | CHAR (1) | |
| ADDRNUMBER | Address Number | AD_ADDRNUM | * | CHAR (10) |
| ANZEINZ | Number of individual devices in a heating installation | ANZEINZ | INT4 (10) | |
| AUFLDSTG | Heating installation charging control | AUFLDSTG | TE679 | CHAR (10) |
| INHALT | Contents | E_INHALT | CHAR (4) | |
| BZGBEZ | Reference value description deviates from operand descript. | BZGBEZ | CHAR (30) | |
| CONSUMPTION | Consumption for streetlight | LIGHTCONSUMPTION | DEC (16) | |
| ADDAMOUNT | Additional flat-rate amount for a streetlight | ADDAMOUNT | CURR (13) | |
| ADDAMOUNTWAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| TIMBASIS | Time Basis | TIMBASIS | CHAR (3) | |
| TIMTYP | Time category (days or months) | TIMTYP | CHAR (1) | |
| EIGENTUM | Owner | EIGENTUM | CHAR (2) | |
| CONTSHARE | Container Portion | CONTSHARE | DEC (31) | |
| EQUNR_WSTE | Equipment Number | EQUNR | * | CHAR (18) |
| NO_UNITIES | No. of premises | NO_UNITIES | NUMC (6) | |
| BEHAELTER | Serial Number of Container | BEHAELTER | CHAR (18) | |
| BEH_TYPE | Container category | BEH_TYPE | * | CHAR (40) |
| CLEAN_PROP | Property | EEWA_CLEAN_PROP | CHAR (12) | |
| PROPSHARE | Property Portion | PROPSHARE | DEC (31) | |
| BEHGRP | Container Group | BEHGRP | * | CHAR (8) |
| IBASE | IBase: Number of the Installed Base/IBase | IB_IBASE | NUMC (18) |
