SAP table ETTA (General Rate Category (Header Data))

SAP table ETTA has 2 primary key fields being MANDT,TARIFTYP.

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
TARIFTYP Rate category CHAR 10 0 TARIFTYP
SPARTE Division CHAR 2 0 TSPA SPARTE
AKLASSE Billing Class CHAR 4 0 EAKLASSE AKLASSE
GASABART Type of gas billing CHAR 2 0 GASABART
01 Standard cubic meter
02 Thermal
03 Volumetric
MWSTMBEZ Indicator: interpret tax changes on a monthly basis CHAR 1 0 MWSTMBEZ
BACKBI Type of backbilling CHAR 1 0 BACKBI
0 No backbilling
1 Floating backbilling
2 Backbilling over the last x periods
NUMPERBB Number of periods for backbilling INT1 3 0 NUMPERBB
PERENDBI Type of period-end billing CHAR 1 0 PERENDBI
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 INT1 3 0 NUMPERPEB
DIFPBPEB Difference between last billing and period-end billing INT1 3 0 DIFPBPEB
AUSGRUP Outsorting check group for billing CHAR 8 0 TE191 AUSGRUP
SCHEMANR Number of the billing schema CHAR 10 0 ESCH SCHEMANR
HOCHART Type of extrapolation in unbilled revenue reporting CHAR 1 0 HOCHART
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 CHAR 4 0 VPERGRUP
PRUEFGR Validation group for dependent validations CHAR 4 0 TE413 PRUEFGR
ABSSTEU Budget billing control CHAR 1 0 ABSSTEU
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 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
ENDPRIO Priority of Period-End Billing CHAR 1 0 ENDPRIO
STAGRUTTYP Statistics group for the rate category CHAR 2 0 E_STGRUT
BIADVANCE Billing in Advance CHAR 1 0 BIADVANCE
DYPERCON Dynamic period control CHAR 4 0 DYPERCON
CONDBILLPROG Execute Conditional Billing Program CHAR 1 0 E_CONDBILLPROG
VISIBILITY Visibility CHAR 1 0 E_VISIBILITY

ETTA foreign key relationships

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