The ETTAF table in SAP ERP or S/4HANA stores Rate Cat.Facts data. There are total 17 fields in ETTAF table. The Rate Cat.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 ETTAF table. It is in IS-U: Billing (EE20) ABAP package and is part of the Contract Billing (IS-U-BI) module.
SAP ETTAF Table Fields
Following is the list of fields that are available in SAP ETTAF table. The primary key fields of the table are MANDT (Client), TARIFTYP (Rate category), OPERAND (Operand), SAISON (Season), BIS (Date at Which a Time Slice Expires).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| TARIFTYP | Rate category | TARIFTYP | * | CHAR (10) |
| OPERAND | Operand | E_OPERAND | * | CHAR (10) |
| SAISON | Season | SAISON | * | CHAR (10) |
| BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS (8) | |
| AB | Date from which time slice is valid | ABZEITSCH | DATS (8) | |
| 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) |
