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 |
|
|||||||||
MWSTMBEZ | Indicator: interpret tax changes on a monthly basis | CHAR | 1 | 0 | MWSTMBEZ | ||||||||||
BACKBI | Type of backbilling | CHAR | 1 | 0 | BACKBI |
|
|||||||||
NUMPERBB | Number of periods for backbilling | INT1 | 3 | 0 | NUMPERBB | ||||||||||
PERENDBI | Type of period-end billing | CHAR | 1 | 0 | PERENDBI |
|
|||||||||
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 |
|
|||||||||
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 |
|
|||||||||
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 |