1. Home
  2. Resources
  3. SAP Tables
  4. 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.

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
NULL Not permissible at the register level
X Permissible at the register level
USE_RTP Permitted for interval meters USE_RTP CHAR 1 0
NULL Not permitted at interval register level
X Permitted at interval register level
USE_DEVICE Permissibility for devices USE_DEVICE CHAR 1 0
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
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
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
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
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
X Yes
NULL No

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 SPARTE TSPA Organizational Unit: Sales Divisions SPART
ETRF SPARTE ETRF MANDT TSPA Organizational Unit: Sales Divisions MANDT