SAP ABAP Table SACM_DEPTS_V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SACM_DEPTS_V	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	T000
2	DEPARTMENT_ID	☑	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key
3	PARENT_KEY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_COMPANY
4	ORG_UNIT_NAME	☐	SNWD_ORG_UNIT_NAME	D_CHAR_20	CHAR	20	0	EPM: Org Unit Name
5	PARENT_ORG_UNIT	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_ITELO_DEPTS
6	MANAGER_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_EMPLOYEES
7	ADDRESS_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_COMPANY
8	ORG_UNIT_ID	☐	SNWD_ORG_UNIT_ID	D_EPM_ID	CHAR	10	0	EPM: ID of org unit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SACM_DEPTS_V	ADDRESS_GUID	SNWD_COMPANY	NODE_KEY		1	CN
2	SACM_DEPTS_V	MANAGER_GUID	SNWD_EMPLOYEES	NODE_KEY
3	SACM_DEPTS_V	MANDT	T000	MANDT		1	CN
4	SACM_DEPTS_V	PARENT_KEY	SNWD_COMPANY	NODE_KEY		1	CN
5	SACM_DEPTS_V	PARENT_ORG_UNIT	SNWD_ITELO_DEPTS	NODE_KEY

History

Last changed by/on	DDIC	20150523
SAP Release Created in