SAP table EKDI (Rate Facts)

SAP table EKDI has 6 primary key fields being MANDT,TARIFNR,KONDIGR,OPERAND,SAISON,BIS.

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
TARIFNR Rate key CHAR 10 0 * TARIFNR
KONDIGR Rate fact group CHAR 10 0 TE067 KONDIGR
OPERAND Operand CHAR 10 0 * E_OPERAND
SAISON Season CHAR 10 0 * SAISON
BIS Date at Which a Time Slice Expires DATS 8 0 BISZEITSCH
AB Date from which time slice is valid DATS 8 0 ABZEITSCH
WERT1 Entry value (installed value) for a device DEC 16 7 E_WERT1
WERT2 Value to be billed DEC 16 7 E_WERT2
STRING1 First Key Field for Operand Value CHAR 10 0 STRING1
STRING2 Second key field for operand value CHAR 10 0 STRING2
STRING3 Third key field for operand value CHAR 1 0 STRING3
STRING4 Fourth key field for operand value CHAR 1 0 STRING4
ERSATZWERT Replacement value for operands CHAR 1 0 ERSATZWERT
Normal operand value
1 Operand value is an optional value
2 Operand value is a required value
3 Operand value determined at runtime
BETRAG Currency-dependent amount CURR 13 2 E_BETRAG
WAERS Currency Key CUKY 5 0 * WAERS

EKDI foreign key relationships

Table Field Check Table Check Field
0 EKDI KONDIGR TE067 Fact Groups MANDT
0 EKDI KONDIGR TE067 Fact Groups KONDIGR
1 EKDI MANDT T000 Clients MANDT