SAP ABAP Table SEPM_SDDL_V_EMPL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SEPM_SDDL_V_EMPL	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	EMPLOYEE_KEY	☑	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key
3	COMPANY_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	PRIVATE_ADDRESS_KEY	☐	SNWD_NODE_KEY	SYSUUID	RAW	16	0	EPM: Generic Node Key	SNWD_AD
15	VALID_START_DATE	☐	SNWD_VALIDITY_START_DATE	DATS	DATS	8	0	EPM: Start date of Validity
16	VALID_END_DATE	☐	SNWD_VALIDITY_END_DATE	DATS	DATS	8	0	EPM: End date of Validity
17	CURRENCY_CODE	☐	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	SEPM_SDDL_V_EMPL	COMPANY_KEY	SNWD_COMPANY	NODE_KEY		1	CN
2	SEPM_SDDL_V_EMPL	MANDT	T000	MANDT		1	CN
3	SEPM_SDDL_V_EMPL	PRIVATE_ADDRESS_KEY	SNWD_AD	NODE_KEY		1	CN

History

Last changed by/on	DDIC	20150523
SAP Release Created in