SAP ABAP Table SDDICTESTELM01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SDDICTESTELM01	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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	NODE_KEY	☑	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	EMPLOYEE_ID	☐	SNWD_ID	D_EPM_ID	CHAR	10	0	EPM: Employee ID
5	FIRST_NAME	☐	SNWD_FIRST_NAME	D_CHAR_40	CHAR	40	0	EPM: First Name
6	MIDDLE_NAME	☐	SNWD_MIDDLE_NAME	D_CHAR_40	CHAR	40	0	EPM: Middle Name
7	LAST_NAME	☐	SNWD_LAST_NAME	D_CHAR_40	CHAR	40	0	EPM: Last Name
8	INITIALS	☐	SNWD_INITIALS	CHAR10	CHAR	10	0	EPM: Initials
9	SEX	☐	SNWD_SEX	D_MF	CHAR	1	0	EPM: Sex
10	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key
11	PHONE_NUMBER	☐	SNWD_PHONE_NUMBER		CHAR	30	0	EPM: Phone Number
12	EMAIL_ADDRESS	☐	SNWD_EMAIL_ADDRESS	D_CHAR_255	CHAR	255	0	EPM: E-Mail Address
13	LOGIN_NAME	☐			CHAR	12	0
14	PR_ADDRESS_GUID	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_AD
15	VAL_START_DATE	☐	SNWD_VALIDITY_START_DATE	DATS	DATS	8	0	EPM: Start date of Validity
16	VAL_END_DATE	☐	SNWD_VALIDITY_END_DATE	DATS	DATS	8	0	EPM: End date of Validity
17	CURRENCY	☐	SNWD_CURR_CODE		CUKY	5	0	EPM: Currency Code
18	SALARY_AMOUNT	☐	SNWD_SALARY_AMOUNT		CURR	15	2	EPM: Salary
19	ACCOUNT_NUMBER	☐			CHAR	10	0
20	BANK_ID	☐			CHAR	10	0
21	BANK_NAME	☐	SNWD_BANK_NAME	D_CHAR_255	CHAR	255	0	EPM: Name of a bank
22	EMPLOYEE_PIC_URL	☐	SNWD_EMPLOYEE_PIC_URL		CHAR	255	0	EPM: URL of Product Image

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SDDICTESTELM01	CLIENT	T000	MANDT		1	CN
2	SDDICTESTELM01	PARENT_KEY	SNWD_COMPANY	NODE_KEY		1	CN
3	SDDICTESTELM01	PR_ADDRESS_GUID	SNWD_AD	NODE_KEY		1	CN

History

Last changed by/on	DDIC	20150523
SAP Release Created in