1. Home
  2. Resources
  3. SAP Tables
  4. ETTA - General Rate Category (Header Data)

SAP Table ETTA

General Rate Category (Header Data)

ETTA (General Rate Category (Header 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 ETTA to other SAP tables.

ETTA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TARIFTYP Rate category TARIFTYP CHAR 10 0
SPARTE Division SPARTE TSPA CHAR 2 0
AKLASSE Billing class AKLASSE EAKLASSE CHAR 4 0
GASABART Type of gas billing GASABART CHAR 2 0
01 Standard cubic meter
02 Thermal
03 Volumetric
MWSTMBEZ Indicator: interpret tax changes on a monthly basis MWSTMBEZ CHAR 1 0
NULL Field inactive
X Field active
BACKBI Type of backbilling BACKBI CHAR 1 0
0 No backbilling
1 Floating backbilling
2 Backbilling over the last x periods
NUMPERBB Number of periods for backbilling NUMPERBB INT1 3 0
PERENDBI Type of period-end billing PERENDBI CHAR 1 0
0 No period-end billing
1 Period-end billing integrated with last periodic billing
2 Separate period-end billing
NUMPERPEB Number of periods for period-end billing NUMPERPEB INT1 3 0
DIFPBPEB Difference between last billing and period-end billing DIFPBPEB INT1 3 0
AUSGRUP Outsorting check group for billing AUSGRUP TE191 CHAR 8 0
SCHEMANR Number of the billing schema SCHEMANR ESCH CHAR 10 0
HOCHART Type of extrapolation in unbilled revenue reporting HOCHART CHAR 1 0
NULL Ind. from gen. rate type is used (only in indiv. rate type)
0 No extrapolation
1 Normal extrapolation (without weighting)
2 Extrapolation from last billing
VPERGRUP Previous period control group VPERGRUP CHAR 4 0
PRUEFGR Validation group for dependent validations PRUEFGR TE413 CHAR 4 0
ABSSTEU Budget billing control ABSSTEU CHAR 1 0
NULL Ind. from gen. rate type is used (only in indiv. rate type)
1 Budget billing amount from simulation of next billing period
2 Bud. billing amts from amounts in current billing line items
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
ENDPRIO Priority of Period-End Billing ENDPRIO CHAR 1 0
NULL Field inactive
X Field active
STAGRUTTYP Statistics group for the rate category E_STGRUT CHAR 2 0
BIADVANCE Billing in Advance BIADVANCE CHAR 1 0
NULL Field inactive
X Field active
DYPERCON Dynamic period control DYPERCON CHAR 4 0
CONDBILLPROG Execute Conditional Billing Program E_CONDBILLPROG CHAR 1 0
NULL Field inactive
X Field active

ETTA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ETTA AKLASSE ETTA MANDT EAKLASSE IS-U Billing Classes MANDT
ETTA AKLASSE ETTA AKLASSE EAKLASSE IS-U Billing Classes AKLASSE
ETTA AUSGRUP ETTA MANDT TE191 Outsorting Check Groups for Billing MANDT
ETTA AUSGRUP ETTA AUSGRUP TE191 Outsorting Check Groups for Billing AUSGRUP
ETTA MANDT ETTA MANDT T000 Clients MANDT
ETTA PRUEFGR ETTA PRUEFGR TE413 Valdiation Groups for Dependent Validations PRUEFGR
ETTA PRUEFGR * TE413 Valdiation Groups for Dependent Validations MANDT
ETTA SCHEMANR ETTA SCHEMANR ESCH Billing Schema (Header Data) SCHEMANR
ETTA SCHEMANR * ESCH Billing Schema (Header Data) MANDT
ETTA SPARTE ETTA MANDT TSPA Organizational Unit: Sales Divisions MANDT
ETTA SPARTE ETTA SPARTE TSPA Organizational Unit: Sales Divisions SPART