SAP Table ETRFD

Scrn Fld List for Rate

ETRFD (Scrn Fld List for Rate) 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 ETRFD to other SAP tables.

ETRFD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LRATESTEP Logical Number of Rate Step LRATESTEP NUMC 10 0
SPARTE Division SPARTE TSPA CHAR 2 0
AKLASSE Billing class AKLASSE EAKLASSE CHAR 4 0
OPERAND Register operand in rate REG_OPER TE221 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
V_TARIFNR Rate key TARIFNR CHAR 10 0
OPERANDBEZ Text (30 Characters) TEXT30 CHAR 30 0
TARIFBEZ Rate description TARIFBEZ CHAR 50 0
SPARTENBEZ Name VTXTK CHAR 20 0
AKLASSBEZ Text for billing class AKLASSETXT CHAR 30 0
KONZIGRBEZ Text for franchise tax group KONLANG CHAR 45 0
MASSBILLC6 Unit of measurement for billing MASSBILLC6 CHAR 6 0
GEWSCHLBEZ Weighting procedure description GEWTXT CHAR 40 0
MARK Indicator: posting line selected? MARK CHAR 1 0
X Yes
NULL No
PRUEFKL Validation class for independent validations PRUEFKL TE408 CHAR 4 0
PRUEFKLBEZ Text (30 Characters) TEXT30 CHAR 30 0
RTPINTERFACE RTP interface E_RTPINTERFACE CHAR 10 0
RTPINTERFACETEXT RTP interface description E_RTPINTERFACETEXT CHAR 60 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
RTPCATEGORYTEXT Description of RTP Category E_RTPCATEGORYTEXT CHAR 60 0
TARIFNR Rate key TARIFNR CHAR 10 0
TARLFDNR Consecutive number of rate step TARLFDNR NUMC 4 0
OPTIONAL Optional billing step OPTIONAL CHAR 1 0
NULL Billing step is always carried out
X Billing step is optional
TIMECONTRL Period control TIMECONTRL TE432 CHAR 2 0
STTARIF Statistical rate STTARIF CHAR 10 0
S_TVORG Debit sub-transaction for billing S_TVORG CHAR 4 0
H_TVORG Credit sub-transaction for billing H_TVORG CHAR 4 0
S_ABSTVORG Budget billing debit sub-transaction S_ABSTVORG CHAR 4 0
H_ABSTVORG Budget billing credit sub-transaction H_ABSTVORG CHAR 4 0
CHNG_SIGN Reverse +/- sign CHNG_SIGN CHAR 1 0
NULL Field inactive
X Field active
KONZIGR Franchise fee group KONZIGR TE241 CHAR 10 0
SAISON Season reference for rate step SAISON_SCHEMA TE221 CHAR 10 0
PROGRAMM Variant program in rate step E_PROG_RATE TE313 CHAR 8 0
EIN01 Input operand EINOPERA01 TE221 CHAR 10 0
EIN02 Input operand EINOPERA02 TE221 CHAR 10 0
EIN03 Input operand EINOPERA03 TE221 CHAR 10 0
EIN04 Input operand EINOPERA04 TE221 CHAR 10 0
EIN05 Input operand EINOPERA05 TE221 CHAR 10 0
EIN06 Input operand EINOPERA06 TE221 CHAR 10 0
EIN07 Input operand EINOPERA07 TE221 CHAR 10 0
EIN08 Input operand EINOPERA08 TE221 CHAR 10 0
EIN09 Input operand EINOPERA09 TE221 CHAR 10 0
EIN10 Input operand EINOPERA10 TE221 CHAR 10 0
AUS01 Output operand AUSOPERA01 TE221 CHAR 10 0
AUS02 Output operand AUSOPERA02 TE221 CHAR 10 0
AUS03 Output operand AUSOPERA03 TE221 CHAR 10 0
AUS04 Output operand AUSOPERA04 TE221 CHAR 10 0
AUS05 Output operand AUSOPERA05 TE221 CHAR 10 0
VARCONT1 Variant control VARCONT CHAR 2 0
NULL Control not used
F 'Incorrect,' info line will be output
T 'True,' info line will be output
01 Number of Control rule according to EVIND
VARCONT2 Variant control VARCONT CHAR 2 0
NULL Control not used
F 'Incorrect,' info line will be output
T 'True,' info line will be output
01 Number of Control rule according to EVIND
VARCONT3 Variant control VARCONT CHAR 2 0
NULL Control not used
F 'Incorrect,' info line will be output
T 'True,' info line will be output
01 Number of Control rule according to EVIND
VARCONT4 Variant control VARCONT CHAR 2 0
NULL Control not used
F 'Incorrect,' info line will be output
T 'True,' info line will be output
01 Number of Control rule according to EVIND
VARCONT5 Variant control VARCONT CHAR 2 0
NULL Control not used
F 'Incorrect,' info line will be output
T 'True,' info line will be output
01 Number of Control rule according to EVIND
BELZART1 Document line type 1 BELZART1 TE835 CHAR 6 0
BELZART2 Line item type 2 BELZART2 TE835 CHAR 6 0
BELZART3 Document line type 3 BELZART3 TE835 CHAR 6 0
BELZART4 Document line type 4 BELZART4 TE835 CHAR 6 0
BELZART5 Document line type 5 BELZART5 TE835 CHAR 6 0

ETRFD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ETRFD AKLASSE ETRFD MANDT EAKLASSE IS-U Billing Classes MANDT
ETRFD AKLASSE ETRFD AKLASSE EAKLASSE IS-U Billing Classes AKLASSE
ETRFD AUS01 ETRFD AUS01 TE221 Operands OPERAND
ETRFD AUS01 SYST MANDT TE221 Operands MANDT
ETRFD AUS02 SYST MANDT TE221 Operands MANDT
ETRFD AUS02 ETRFD AUS02 TE221 Operands OPERAND
ETRFD AUS03 SYST MANDT TE221 Operands MANDT
ETRFD AUS03 ETRFD AUS03 TE221 Operands OPERAND
ETRFD AUS04 SYST MANDT TE221 Operands MANDT
ETRFD AUS04 ETRFD AUS04 TE221 Operands OPERAND
ETRFD AUS05 SYST MANDT TE221 Operands MANDT
ETRFD AUS05 ETRFD AUS05 TE221 Operands OPERAND
ETRFD BELZART1 SYST MANDT TE835 Line Item Type MANDT
ETRFD BELZART1 ETRFD BELZART1 TE835 Line Item Type BELZART
ETRFD BELZART2 SYST MANDT TE835 Line Item Type MANDT
ETRFD BELZART2 ETRFD BELZART2 TE835 Line Item Type BELZART
ETRFD BELZART3 SYST MANDT TE835 Line Item Type MANDT
ETRFD BELZART3 ETRFD BELZART3 TE835 Line Item Type BELZART
ETRFD BELZART4 ETRFD BELZART4 TE835 Line Item Type BELZART
ETRFD BELZART4 SYST MANDT TE835 Line Item Type MANDT
ETRFD BELZART5 SYST MANDT TE835 Line Item Type MANDT
ETRFD BELZART5 ETRFD BELZART5 TE835 Line Item Type BELZART
ETRFD EIN01 SYST MANDT TE221 Operands MANDT
ETRFD EIN01 ETRFD EIN01 TE221 Operands OPERAND
ETRFD EIN02 SYST MANDT TE221 Operands MANDT
ETRFD EIN02 ETRFD EIN02 TE221 Operands OPERAND
ETRFD EIN03 SYST MANDT TE221 Operands MANDT
ETRFD EIN03 ETRFD EIN03 TE221 Operands OPERAND
ETRFD EIN04 ETRFD EIN04 TE221 Operands OPERAND
ETRFD EIN04 SYST MANDT TE221 Operands MANDT
ETRFD EIN05 SYST MANDT TE221 Operands MANDT
ETRFD EIN05 ETRFD EIN05 TE221 Operands OPERAND
ETRFD EIN06 SYST MANDT TE221 Operands MANDT
ETRFD EIN06 ETRFD EIN06 TE221 Operands OPERAND
ETRFD EIN07 SYST MANDT TE221 Operands MANDT
ETRFD EIN07 ETRFD EIN07 TE221 Operands OPERAND
ETRFD EIN08 SYST MANDT TE221 Operands MANDT
ETRFD EIN08 ETRFD EIN08 TE221 Operands OPERAND
ETRFD EIN09 SYST MANDT TE221 Operands MANDT
ETRFD EIN09 ETRFD EIN09 TE221 Operands OPERAND
ETRFD EIN10 SYST MANDT TE221 Operands MANDT
ETRFD EIN10 ETRFD EIN10 TE221 Operands OPERAND
ETRFD KONZIGR SYST MANDT TE241 Franchise Tax Groups MANDT
ETRFD KONZIGR ETRFD KONZIGR TE241 Franchise Tax Groups KONZIGR
ETRFD OPERAND ETRFD MANDT TE221 Operands MANDT
ETRFD OPERAND ETRFD OPERAND TE221 Operands OPERAND
ETRFD PROGRAMM SYST MANDT TE313 Variant Programs MANDT
ETRFD PROGRAMM ETRFD PROGRAMM TE313 Variant Programs PROGRAMM
ETRFD PRUEFKL ETRFD MANDT TE408 Check Classes of Independent Validations MANDT
ETRFD PRUEFKL ETRFD PRUEFKL TE408 Check Classes of Independent Validations PRUEFKL
ETRFD SAISON ETRFD SAISON TE221 Operands OPERAND
ETRFD SAISON ETRFD MANDT TE221 Operands MANDT
ETRFD SPARTE ETRFD MANDT TSPA Organizational Unit: Sales Divisions MANDT
ETRFD SPARTE ETRFD SPARTE TSPA Organizational Unit: Sales Divisions SPART
ETRFD TIMECONTRL SY MANDT TE432 Table for Period Control MANDT
ETRFD TIMECONTRL ETRFD TIMECONTRL TE432 Table for Period Control TIMECONTRL