SAP table EVFL (CNE5: Field definition for PS earned value analysis)
SAP table EVFL has 2 primary key fields being MANDT,EVFLD.
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
EVFLD
Field names for progress analysis values (PS)
CHAR
10
0
EV_FELD
FLDTY
Field type in progress analysis (PS)
NUMC
2
0
EV_FELDTYP
Possible values
01
Planned percentage of completion (%)
02
Actual percentage of completion (%)
11
BCWS
12
BCWP
21
Variance
22
Index
FGRFL
Base field for percentage of completion
CHAR
10
0
EVFL
EVFL_FGRFL
FGGEW
Aggregation weighting for percentage of completion
CHAR
10
0
EVFL_FGGEW
TRMKR
Set of dates for network
CHAR
1
0
PS_TERMBAS
TFRSP
Earliest possible activity / Latest possible activity
CHAR
1
0
FRSP
Possible values
1
Earliest possible
2
Latest possible
VRSTR
Version of planned dates
CHAR
12
0
EVFL_VRSTR
FWTFG
Percentage of completion (field name) for earned value
CHAR
10
0
EVFL
EVFL_FWFGF
FWTBZ
Base used in determining earned value
CHAR
10
0
EVFL_FWBZF
VRSBZ
Version of base
CHAR
12
0
EVFL_VRSKO
OPR1H
Origin of an operand in progress analysis
CHAR
1
0
EVFL_OPRHK
Possible values
1
SAP field, total
2
SAP field, period
3
Customer field from EVFL
OPR1F
Operand for deviation or index (field name)
CHAR
10
0
EVFL_OPRFL
OPR2H
Origin of an operand in progress analysis
CHAR
1
0
EVFL_OPRHK
Possible values
1
SAP field, total
2
SAP field, period
3
Customer field from EVFL
OPR2F
Operand for deviation or index (field name)
CHAR
10
0
EVFL_OPRFL
FLDNR
Field number in reporting
NUMC
2
0
EVFL_FLDNR
EVFL foreign key relationships
Table
Field
Check Table
Check Field
0 EVFL
FGRFL
EVFL
CNE5: Field definition for PS earned value analysis
MANDT
0 EVFL
FGRFL
EVFL
CNE5: Field definition for PS earned value analysis
EVFLD
1 EVFL
FWTFG
EVFL
CNE5: Field definition for PS earned value analysis
MANDT
1 EVFL
FWTFG
EVFL
CNE5: Field definition for PS earned value analysis
EVFLD
0 EVFL
MANDT
T000
Clients
MANDT