SAP table TE069 (Rate Types)
SAP table TE069 has 2 primary key fields being MANDT,TARIFART.
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
Client
CLNT
3
0
*
MANDT
Rate Type
CHAR
8
0
TARIFART
SPARTE
Division
CHAR
2
0
TSPA
SPARTE
AKLASSE
Billing Class
CHAR
4
0
EAKLASSE
AKLASSE
USE_REGIST
Permissibility for registers
CHAR
1
0
USE_REGISTER
USE_DEVICE
Permissibility for devices
CHAR
1
0
USE_DEVICE
Possible values
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
Possible values
Not permissible for rate category and installation facts
X
Permissible for rate category and installation facts
USE_RTP
Permitted for interval meters
CHAR
1
0
USE_RTP
Possible values
Not permitted at interval register level
X
Permitted at interval register level
USE_PEB
Permissible as period-end billing rate
CHAR
1
0
USE_PEB
Possible values
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
Possible values
Not Permissible for Waste Billing
X
Permissible for Waste Billing
ESTI_ANL
Ignore Contract Allocation of Register During Extrapolation
CHAR
1
0
ESTI_ANL
TE069 foreign key relationships
Table
Field
Check Table
Check Field
0 TE069
AKLASSE
EAKLASSE IS-U Billing Classes
MANDT
0 TE069
AKLASSE
EAKLASSE IS-U Billing Classes
AKLASSE
1 TE069
SPARTE
TSPA Organizational Unit: Sales Divisions
MANDT
1 TE069
SPARTE
TSPA Organizational Unit: Sales Divisions
SPART