SAP ABAP Table FOPC_S_DEFICANA_UI (Deficiency Analysis UI Structure)

Hierarchy

☛ FINBASIS (Software Component) Fin. Basis
   ⤷ FIN-CGV-MIC (Application Component) Management of Internal Controls
     ⤷ FOPC_REPORTING (Package) Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	FOPC_S_DEFICANA_UI	Table Relationship Diagram
Short Description	Deficiency Analysis UI Structure

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	.INCLUDE	☐				0	0	MIC: Deficiency Analysis
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	ANALYSIS_ID	☐	FOPC_ANALYSIS_GUID	SYSUUID_C	CHAR	32	0	Analysis GUID
4	CASE_GUID	☐	SCMG_CASE_GUID	SYSUUID_C	CHAR	32	0	Technical Case Key (Case GUID)
5	ACCTGRP_SLOT	☐	FOPC_ACCTGRP_SLOT		INT1	3	0	Slot for Account Group
6	ANALYSIS_BY_ORG	☐	FOPC_ORGUNIT_ID	FOPC_ORGUNIT_ID	CHAR	8	0	Organizational Unit ID
7	ACCTGRP	☐	FOPC_PRT_ACCGROUP		CHAR	8	0	Account Groups
8	EXT_REF	☐	SCMG_EXT_REF	CHAR30	CHAR	30	0	External reference
9	CASE_TITLE	☐	FOPC_IS_TITLE	TEXT80	CHAR	80	0	Name of Issue
10	STATUS	☐	FOPC_ISSUE_STAT	J_STATUS	CHAR	5	0	Issue Status
11	ISSUE_PRIORITY	☐	FOPC_ISSUE_PRIORITY	FOPC_ISSUE_PRIORITY	CHAR	1	0	Issue Priority
12	CATEGORY	☐	SCMG_CATEGORY	CHAR4	CHAR	4	0	Category	SCMGATTR_CATEGO
13	TIMEFRAME	☐	FOPC_TIMEFRAME	FOPC_ATTRVALUE	CHAR	10	0	Timeframe
14	TF_YEAR	☐	FOPC_YEAR		CHAR	4	0	Year
15	DEFIC_TYPE	☐	FOPC_DEFIC_TYPE	FOPC_ATTRVALUE	CHAR	10	0	Deficiency Type
16	CURRENCY	☐	FOPC_THR_CURR	WAERS	CUKY	5	0	Currency	TCURC
17	IMPACT_POTENTIAL	☐	FOPC_DEFIC_IMPACT		CURR	15	2	Impact Potential of a Deficiency
18	LIKELIHOOD	☐	FOPC_DEFIC_LIKELIHOOD	FOPC_ATTRVALUE	CHAR	10	0	Likelihood of a Deficiency
19	MITIGATION	☐	FOPC_DEFIC_MITIGATION	FOPC_DEFIC_MITIGATION	CHAR	1	0	Mitigation of Deficiency
20	MAGNITUDE	☐	FOPC_DEFIC_MAGNITUDE	FOPC_ATTRVALUE	CHAR	10	0	Deficiency Magnitude
21	MAGNITUDE_MAP	☐	FOPC_DEFIC_MAGNITUDE_MAP	FOPC_ATTRVALUE	CHAR	10	0	Deficiency Analysis: Assignment Magnitude to Classification
22	CLASS	☐	FOPC_DEFIC_CLASS	FOPC_ATTRVALUE	CHAR	10	0	Classification of Deficiency
23	AGGREG_CODE	☐	FOPC_AGGREG_CODE	FOPC_AGGREG_CODE	CHAR	40	0	Aggregation Type
24	DEFIC_COMMENT	☐	FOPC_DEFIC_COMMENT		STRG	0	0	Comment
25	ANALYSIS_TIME	☐	SCMG_CHANGE_TIME	SCMG_TIMESTAMP	DEC	15	0	Last Changed On
26	ANALYSIS_BY	☐	FOPC_ANALYSIS_BY	XUBNAME	CHAR	12	0	Analysis By (User ID)	*
27	ANA_STATUS	☐	FOPC_DEFIC_ANA_STATUS	FOPC_DEFIC_ANA_STATUS	CHAR	1	0	Status of Deficiency Analysis
28	ISSUE_DESC	☐	FOPC_ISSUE_DESC		STRG	0	0	Description of Issue
29	COMP_CONTROL	☐	FOPC_COMPCONTROLS		STRG	0	0	Compensating Controls
30	IMPLICATION	☐	FOPC_UI_IMPLICATION		STRG	0	0	Implication
31	ISSUE_COMMENT	☐	FOPC_ISSUE_COMMENT		STRG	0	0	Comments for Issue
32	ORGUNIT_ID	☐	FOPC_ORGUNIT_ID	FOPC_ORGUNIT_ID	CHAR	8	0	Organizational Unit ID
33	ORGUNIT	☐	FOPC_UI_ORGUNIT	FOPC_TEXT	CHAR	100	0	Organizational Unit Title
34	PRGROUP	☐	FOPC_UI_PRGROUP	FOPC_TEXT	CHAR	100	0	Process Group Title
35	PROCESS	☐	FOPC_UI_PROCESS	FOPC_TEXT	CHAR	100	0	Process Title
36	CONTROL	☐	FOPC_UI_CONTROL	FOPC_UI_CONTROL	CHAR	40	0	Control
37	CTRL_TYPE	☐	FOPC_CNTR_TYPE	FOPC_CNTR_TYPE	CHAR	10	0	Control Type
38	CTRL_DESC	☐	FOPC_UI_CONTROL_LTXT		STRG	0	0	Control Description
39	RISK_COVERED	☐	FOPC_RISK_COVERED		STRG	0	0	Risk Covered
40	CTRL_SIG	☐	FOPC_CNTR_SIGNIFICANCE	FOPC_CNTR_SIGNIFICANCE	CHAR	10	0	Control Significance
41	CTRL_AUTOM	☐	FOPC_CNTR_AUTOMATION		CHAR	10	0	Automation
42	CTRL_NATURE	☐	FOPC_CNTR_NATURE		CHAR	10	0	Nature of Control
43	DEFIC_TYPE_VAR	☐	FOPC_ATTRVALUE	FOPC_ATTRVALUE	CHAR	10	0	Attribute Value
44	PRE_DEFIC_COMMENT	☐	FOPC_DEFIC_COMMENT		STRG	0	0	Comment
45	PRE_RECORDS	☐			INT1	3	0
46	PRIORITY_ICON	☐	FOPC_IS_PRIORITY_ICON	ICONNAME	CHAR	30	0	Symbol for Priority of Issue
47	PRIORITY_TXT	☐			STRG	0	0
48	ACCTGRP_TABLE	☐	FOPC_CONTEXT_ATTR_VALUE_LIST		TTYP	0	0
49	ISSUE_PROCESSOR	☐	FOPC_REP_ISSUE_PROCESSOR	UNAME	CHAR	12	0	ID of Processor of Issue
50	ISSUE_PROCESSOR_T	☐	FOPC_REP_ISSUE_PROCESSOR_T	TEXT100	CHAR	100	0	Issue Processor
51	ISSUE_RESPONSIBLE	☐	FOPC_REP_ISSUE_RESPONSIBLE	UNAME	CHAR	12	0	Issue Owner (ID)
52	ISSUE_RESPONSIBLE_T	☐	FOPC_REP_ISSUE_RESPONSIBLE_T	TEXT100	CHAR	100	0	Issue Owner
53	LIKELIHOOD_T	☐	FOPC_DEFIC_LIKELIHOOD_T	TEXT40	CHAR	40	0	Likelihood of Deficiency (Description)
54	MITIGATION_T	☐	FOPC_DEFIC_MITIGATION_T	TEXT40	CHAR	40	0	Mitigation of Deficiency (Description)
55	MAGNITUDE_T	☐	FOPC_DEFIC_MAGNITUDE_T	TEXT40	CHAR	40	0	Magnitude of Deficiency (Description)
56	MAGNITUDE_MAP_T	☐	FOPC_DEFIC_MAGNITUDE_MAP_T	TEXT40	CHAR	40	0	Assignment of Magnitude - Classification (Description)
57	CLASS_T	☐	FOPC_DEFIC_CLASS_T	TEXT40	CHAR	40	0	Classification of Deficiency (Description)
58	DEFIC_TYPE_T	☐	FOPC_DEFIC_TYPE_T	TEXT40	CHAR	40	0	Deficiency Type (Description)
59	ISSUE_CATEGORY_T	☐	FOPC_REP_ISSUE_CAT_T	FOPC_TEXT	CHAR	100	0	Issue Type
60	ACCGROUP_T	☐	FOPC_REP_ACCGROUP_TEXT	FOPC_TEXT	CHAR	100	0	Account Group (Text)
61	CNT_RELEVANCE	☐	FOPC_DEFIC_RELEVANCE		STRG	0	0	List of Relevance IDs of Control
62	CNT_RELEVANCE_T	☐	FOPC_DEFIC_RELEVANCE_T		STRG	0	0	List of Relevances of Control

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FOPC_S_DEFICANA_UI	CATEGORY	SCMGATTR_CATEGO	CATEGORY
2	FOPC_S_DEFICANA_UI	CURRENCY	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in	700