SAP ABAP Table FOPCV_DESIGN_RAT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	FOPCV_DESIGN_RAT	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	CASE_GUID	☑	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
3	DATE_BEGIN	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
4	DATE_END	☐	ENDDATUM	DATUM	DATS	8	0	End Date
5	TIMEFRAME	☐	FOPC_TIMEFRAME	FOPC_ATTRVALUE	CHAR	10	0	Timeframe
6	TF_YEAR	☐	FOPC_YEAR		CHAR	4	0	Year
7	MATURITY_AS_IS	☐	FOPC_CNTR_MATURITY_AS_IS	FOPC_CNTR_MATURITY_AS_IS	CHAR	10	0	Control Maturity As Is
8	MATURITY_TARGET	☐	FOPC_CNTR_MATURITY		CHAR	10	0	Control Maturity
9	MATURITY_GAP	☐	FOPC_AS_MATURITY_GAP		NUMC	2	0	Maturity Gap
10	DESIGN_RATING	☐	FOPC_AS_RATING	FOPC_AS_RATING	CHAR	1	0	Rating
11	TESTING_TEC	☐	FOPC_ASSMNT_TECHNIQUE	FOPC_ASSMNT_TECHNIQUE	CHAR	10	0	Assessment Technique
12	VALIDATED_BY_UN	☐	FOPC_VALIDATED_BY_UN	UNAME	CHAR	12	0	Person Validating
13	VALIDATION_DATE	☐	FOPC_VALIDATION_DATE	DATUM	DATS	8	0	Validation Date
14	ASSESSMENT_DATE	☐	FOPC_ASSESSMENT_DATE	DATUM	DATS	8	0	Assessment Date
15	ASSESSMENT_BY	☐	FOPC_ASSESSMENT_BY	UNAME	CHAR	12	0	Person Performing the Assessment
16	CASE_TYPE	☐	SCMGCASE_TYPE	SCMGCASE_TYPE	CHAR	4	0	Case Type	SCMGCASETYPE
17	EXT_KEY	☐	SCMG_EXT_KEY	SCMG_EXT_KEY	CHAR	12	0	Case ID
18	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
19	CREATED_BY	☐	SCMG_CREATE_USER	XUBNAME	CHAR	12	0	Created By	USR02
20	CREATE_TIME	☐	SCMG_CREATE_TIME	SCMG_TIMESTAMP	DEC	15	0	Created On
21	CHANGED_BY	☐	SCMG_CHANGE_USER	XUBNAME	CHAR	12	0	Last Changed by	USR02
22	CHANGE_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
23	CLOSED_BY	☐	SCMG_CLOSED_BY	XUBNAME	CHAR	12	0	Closed by User	USR02
24	CLOSING_TIME	☐	SCMG_CLOSING_TIME	SCMG_TIMESTAMP	DEC	15	0	Closed at Time
25	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	SCMGATTR_CATEGO
26	CF_STATUS	☐	FOPC_CF_STATUS	FOPC_CF_STATUS	CHAR	1	0	Carryforward Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FOPCV_DESIGN_RAT	CASE_TYPE	SCMGCASETYPE	CASE_TYPE
2	FOPCV_DESIGN_RAT	CATEGORY	SCMGATTR_CATEGO	CATEGORY
3	FOPCV_DESIGN_RAT	CHANGED_BY	USR02	BNAME
4	FOPCV_DESIGN_RAT	CLOSED_BY	USR02	BNAME
5	FOPCV_DESIGN_RAT	CREATED_BY	USR02	BNAME

History

Last changed by/on	SAP	20130529
SAP Release Created in