SAP table FERC_R0 (Execution history)

SAP table FERC_R0 has 2 primary key fields being MANDT,RUN_ID.

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
RUN_ID Regulatory reporting run identification number NUMC 4 0 FE_RUN_ID
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
GJAHR Fiscal Year NUMC 4 0 GJAHR
PERIO Period NUMC 3 0 CO_PERIO
RRCTY Record type CHAR 1 0 FE_RRCTY
0 Actual
1 Plan
VERSN Version CHAR 3 0 T894 RVERS
LAST_STEP Regulatory procedure CHAR 2 0 FE_STEP
00 Standard cost adjustment
10 Trace flow of primary costs
20 Post traced costs
30 Post variances of reg. allocation
40 Direct postings
50 Prepare drill down tables
60 Archive data
70 Delete archived data
NEXT_STEP Regulatory procedure CHAR 2 0 FE_STEP
00 Standard cost adjustment
10 Trace flow of primary costs
20 Post traced costs
30 Post variances of reg. allocation
40 Direct postings
50 Prepare drill down tables
60 Archive data
70 Delete archived data
ST_00 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_00 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_10 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_10 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_20 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_20 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_30 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_30 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_40 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_40 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_50 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_50 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
EX_50_20 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
EX_50_40 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_60 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_60 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ST_70 Status of regulatory procedure CHAR 1 0 FE_STATUS
- Procedure inactive
A Procedure terminated because of errors
E Procedure incomplete
P Procedure partially reversed
R Procedure fully reversed
S Procedure completed without errors
W Procedure successfully concluded despite errors
X procedure being processed
Y Procedure being reversed
EX_70 Number of runs of regulatory procedure NUMC 3 0 FE_RUN_NO
ADMI_RUN Archiving Session Number CHAR 6 0 ADMI_RUN_D
WAERS Currency Key for Amounts in Controlling Area Currency CUKY 5 0 TCURC RACUR
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
SAPRELEASE SAP Release CHAR 10 0 SAPRELEASE
SAPPATCHLV Support Package Level of a Software Component CHAR 10 0 SAPPATCHLV

FERC_R0 foreign key relationships

Table Field Check Table Check Field
0 FERC_R0 KOKRS TKA01 Controlling Areas MANDT
1 FERC_R0 KTOPL T004 Directory of Charts of Accounts MANDT
0 FERC_R0 MANDT T000 Clients MANDT
1 FERC_R0 PERIV T009 Fiscal Year Variants MANDT
1 FERC_R0 PERIV T009 Fiscal Year Variants PERIV
0 FERC_R0 VERSN T894 FI-SL and FI-LC Versions MANDT
0 FERC_R0 VERSN T894 FI-SL and FI-LC Versions RLDNR
0 FERC_R0 VERSN T894 FI-SL and FI-LC Versions RVERS
1 FERC_R0 WAERS TCURC Currency Codes MANDT
1 FERC_R0 WAERS TCURC Currency Codes WAERS