SAP ABAP View FOPCV_MC_TSTLRAT (Management Control Test Rating Cases)
Hierarchy
FINBASIS (Software Component) Fin. Basis
   FIN-CGV-MIC (Application Component) Management of Internal Controls
     FOPC_EXTRACTION (Package) MIC Extraction
Basic Data
View Type D Database View 
Database View FOPCV_MC_TSTLRAT  
Short Description Management Control Test Rating Cases    
Root table FOPCCASETL   Test log 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 FOPCCASETL FOPCCASETL
2 SCMG_T_CASE_ATTR  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 FOPCCASETL MANDT JL EQ 0 0
2 SCMG_T_CASE_ATTR MANDT JR EQ AND 0 0
3 FOPCCASETL CASE_GUID JL EQ 0 0
4 SCMG_T_CASE_ATTR CASE_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT FOPCCASETL MANDT   MANDT Client
2 CASE_GUID FOPCCASETL CASE_GUID   SYSUUID_C UUID in character form
3 DATE_BEGIN FOPCCASETL DATE_BEGIN   BEGDATUM Start Date
4 DATE_END FOPCCASETL DATE_END   ENDDATUM End Date
5 TIMEFRAME FOPCCASETL TIMEFRAME   FOPC_TIMEFRAME Timeframe
6 TF_YEAR FOPCCASETL TF_YEAR   FOPC_YEAR Year
7 TESTER_NUMB FOPCCASETL TESTER_NUMB   FOPC_TESTER Tester
8 TESTING_DATE FOPCCASETL TESTING_DATE   FOPC_TESTING_DATE Test Date
9 TESTING_METHOD FOPCCASETL TESTING_METHOD   FOPC_TESTING_METHOD Testing Method
10 TESTING_TEC FOPCCASETL TESTING_TEC   FOPC_CNTR_TESTING_TECHNIQUE Testing Technique
11 TEST_EXCEPTION FOPCCASETL TEST_EXCEPTION   FOPC_EXCEPTION Test Log: Exception
12 TESTING_RATING FOPCCASETL TESTING_RATING   FOPC_AS_RATING Rating
13 CASE_TYPE SCMG_T_CASE_ATTR CASE_TYPE   SCMGCASE_TYPE Case Type
14 EXT_KEY SCMG_T_CASE_ATTR EXT_KEY   SCMG_EXT_KEY Case ID
15 EXT_REF SCMG_T_CASE_ATTR EXT_REF   SCMG_EXT_REF External reference
16 CREATED_BY SCMG_T_CASE_ATTR CREATED_BY   SCMG_CREATE_USER Created By
17 CREATE_TIME SCMG_T_CASE_ATTR CREATE_TIME   SCMG_CREATE_TIME Created On
18 CHANGED_BY SCMG_T_CASE_ATTR CHANGED_BY   SCMG_CHANGE_USER Last Changed by
19 CHANGE_TIME SCMG_T_CASE_ATTR CHANGE_TIME   SCMG_CHANGE_TIME Last Changed On
20 CLOSED_BY SCMG_T_CASE_ATTR CLOSED_BY   SCMG_CLOSED_BY Closed by User
21 CLOSING_TIME SCMG_T_CASE_ATTR CLOSING_TIME   SCMG_CLOSING_TIME Closed at Time
22 CATEGORY SCMG_T_CASE_ATTR CATEGORY   SCMG_CATEGORY Category
23 CF_STATUS FOPCCASETL CF_STATUS   FOPC_CF_STATUS Carryforward Status
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in 100