- Home
- Resources
- SAP Tables
- ETRF - Rate (Head. Data)
SAP Table ETRF
Rate (Head. Data)
ETRF (Rate (Head. Data)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ETRF to other SAP tables.
Source: ETRF (Rate (Head. Data))
ETRF table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
TARIFNR |
Rate key |
TARIFNR |
|
CHAR |
|
10 |
0 |
|
SPARTE |
Division |
SPARTE |
TSPA
|
CHAR |
|
2 |
0 |
|
AKLASSE |
Billing class |
AKLASSE |
EAKLASSE
|
CHAR |
|
4 |
0 |
|
OPERAND |
Register operand in rate |
REG_OPER |
|
CHAR |
|
10 |
0 |
|
USE_REGIST |
Permissibility for registers |
USE_REGISTER |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not permissible at the register level |
X |
Permissible at the register level |
|
USE_RTP |
Permitted for interval meters |
USE_RTP |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not permitted at interval register level |
X |
Permitted at interval register level |
|
USE_DEVICE |
Permissibility for devices |
USE_DEVICE |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not permitted on device level |
X |
Permitted on device level |
|
USE_FACTS |
Permissibility for rate cat. facts and installation facts |
USE_FACTS |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not permissible for rate category and installation facts |
X |
Permissible for rate category and installation facts |
|
USE_PEB |
Permissible as period-end billing rate |
USE_PEB |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not permissible as period-end billing rate |
X |
Permissible as period-end billing rate |
|
USE_WASTE |
Permissibility for Waste Billing |
USE_WASTE |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not Permissible for Waste Billing |
X |
Permissible for Waste Billing |
|
MINPROZ |
Minimum portion in percent |
MINPROZ |
|
NUMC |
|
3 |
0 |
|
PRUEFKL |
Validation class for independent validations |
PRUEFKL |
TE408
|
CHAR |
|
4 |
0 |
|
RTPINTERFACE |
RTP interface |
E_RTPINTERFACE |
ERTPINTERFACE
|
CHAR |
|
10 |
0 |
|
RTPCATEGORY |
RTP Billing Category |
RTPCATEGORY |
|
CHAR |
|
2 |
0 |
Possible values
NULL |
Bill EDM Profile Values with RTP Interface |
01 |
Bill EDM Profile Values with TOU Interface |
02 |
Bill External Profile Values with TOU Interface |
|
ERDAT |
Date on Which Record Was Created |
ERDAT |
|
DATS |
|
8 |
0 |
|
ERNAM |
Name of Person who Created the Object |
ERNAM |
|
CHAR |
|
12 |
0 |
|
AEDAT |
Changed On |
AEDAT |
|
DATS |
|
8 |
0 |
|
AENAM |
Name of Person Who Changed Object |
AENAM |
|
CHAR |
|
12 |
0 |
|
BEGRU |
Authorization Group |
BEGRU |
|
CHAR |
|
4 |
0 |
|
LOEVM |
Deletion Indicator |
LOEVM |
|
CHAR |
|
1 |
0 |
Possible values
|
ETRF foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
ETRF |
AKLASSE |
ETRF |
MANDT |
EAKLASSE |
IS-U Billing Classes |
MANDT |
ETRF |
AKLASSE |
ETRF |
AKLASSE |
EAKLASSE |
IS-U Billing Classes |
AKLASSE |
ETRF |
MANDT |
ETRF |
MANDT |
T000 |
Clients |
MANDT |
ETRF |
PRUEFKL |
ETRF |
MANDT |
TE408 |
Check Classes of Independent Validations |
MANDT |
ETRF |
PRUEFKL |
ETRF |
PRUEFKL |
TE408 |
Check Classes of Independent Validations |
PRUEFKL |
ETRF |
RTPINTERFACE |
ETRF |
MANDT |
ERTPINTERFACE |
RTP Interface (Header Data) |
MANDT |
ETRF |
RTPINTERFACE |
ETRF |
RTPINTERFACE |
ERTPINTERFACE |
RTP Interface (Header Data) |
RTPINTERFACE |
ETRF |
SPARTE |
ETRF |
MANDT |
TSPA |
Organizational Unit: Sales Divisions |
MANDT |
ETRF |
SPARTE |
ETRF |
SPARTE |
TSPA |
Organizational Unit: Sales Divisions |
SPART |