SAP table ETRF (Rate (Head. Data))

SAP table ETRF has 2 primary key fields being MANDT,TARIFNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TARIFNR Rate key CHAR 10 0 TARIFNR
SPARTE Division CHAR 2 0 TSPA SPARTE
AKLASSE Billing Class CHAR 4 0 EAKLASSE AKLASSE
OPERAND Register operand in rate CHAR 10 0 REG_OPER
USE_REGIST Permissibility for registers CHAR 1 0 USE_REGISTER
USE_RTP Permitted for interval meters CHAR 1 0 USE_RTP
Not permitted at interval register level
X Permitted at interval register level
USE_DEVICE Permissibility for devices CHAR 1 0 USE_DEVICE
Not permitted on device level
X Permitted on device level
USE_FACTS Permissibility for rate cat. facts and installation facts CHAR 1 0 USE_FACTS
Not permissible for rate category and installation facts
X Permissible for rate category and installation facts
USE_PEB Permissible as period-end billing rate CHAR 1 0 USE_PEB
Not permissible as period-end billing rate
X Permissible as period-end billing rate
USE_WASTE Permissibility for Waste Billing CHAR 1 0 USE_WASTE
Not Permissible for Waste Billing
X Permissible for Waste Billing
MINPROZ Percentage Minimum Share NUMC 3 0 MINPROZ
PRUEFKL Validation class for independent validations CHAR 4 0 TE408 PRUEFKL
RTPINTERFACE RTP interface CHAR 10 0 ERTPINTERFACE E_RTPINTERFACE
RTPCATEGORY RTP Billing Category CHAR 2 0 RTPCATEGORY
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 the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM

ETRF foreign key relationships

Table Field Check Table Check Field
0 ETRF AKLASSE EAKLASSE IS-U Billing Classes MANDT
0 ETRF AKLASSE EAKLASSE IS-U Billing Classes AKLASSE
1 ETRF MANDT T000 Clients MANDT
0 ETRF PRUEFKL TE408 Check Classes of Independent Validations MANDT
0 ETRF PRUEFKL TE408 Check Classes of Independent Validations PRUEFKL
1 ETRF RTPINTERFACE ERTPINTERFACE RTP Interface (Header Data) RTPINTERFACE
0 ETRF SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 ETRF SPARTE TSPA Organizational Unit: Sales Divisions SPART