SAP ABAP View SEPM_SDDL_V_EMPL (Erzeugt aus Ddl Source SEPM_SDDL_EMPLOYEES)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_EPM_CDS (Package) EPM: Core Data Services

Basic Data

View Type	D	Database View
Database View	SEPM_SDDL_V_EMPL
Short Description	Erzeugt aus Ddl Source SEPM_SDDL_EMPLOYEES
Root table	SNWD_EMPLOYEES	EPM: Employee Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SNWD_EMPLOYEES	SNWD_EMPLOYEES

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SNWD_EMPLOYEES	CLIENT		☐	MANDT	☐	Client
2	EMPLOYEE_KEY	SNWD_EMPLOYEES	NODE_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
3	COMPANY_KEY	SNWD_EMPLOYEES	PARENT_KEY		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
4	EMPLOYEE_ID	SNWD_EMPLOYEES	EMPLOYEE_ID		☐	SNWD_ID	☐	EPM: Employee ID
5	FIRST_NAME	SNWD_EMPLOYEES	FIRST_NAME		☐	SNWD_FIRST_NAME	☐	EPM: First Name
6	MIDDLE_NAME	SNWD_EMPLOYEES	MIDDLE_NAME		☐	SNWD_MIDDLE_NAME	☐	EPM: Middle Name
7	LAST_NAME	SNWD_EMPLOYEES	LAST_NAME		☐	SNWD_LAST_NAME	☐	EPM: Last Name
8	INITIALS	SNWD_EMPLOYEES	INITIALS		☐	SNWD_INITIALS	☐	EPM: Initials
9	SEX	SNWD_EMPLOYEES	SEX		☐	SNWD_SEX	☐	EPM: Sex
10	LANGUAGE	SNWD_EMPLOYEES	LANGUAGE		☐	SPRAS	☐	Language Key
11	PHONE_NUMBER	SNWD_EMPLOYEES	PHONE_NUMBER		☐	SNWD_PHONE_NUMBER	☐	EPM: Phone Number
12	EMAIL_ADDRESS	SNWD_EMPLOYEES	EMAIL_ADDRESS		☐	SNWD_EMAIL_ADDRESS	☐	EPM: E-Mail Address
13	LOGIN_NAME	SNWD_EMPLOYEES	LOGIN_NAME		☐		☐
14	PRIVATE_ADDRESS_KEY	SNWD_EMPLOYEES	PR_ADDRESS_GUID		☐	SNWD_NODE_KEY	☐	EPM: Generic Node Key
15	VALID_START_DATE	SNWD_EMPLOYEES	VAL_START_DATE		☐	SNWD_VALIDITY_START_DATE	☐	EPM: Start date of Validity
16	VALID_END_DATE	SNWD_EMPLOYEES	VAL_END_DATE		☐	SNWD_VALIDITY_END_DATE	☐	EPM: End date of Validity
17	CURRENCY_CODE	SNWD_EMPLOYEES	CURRENCY		☐	SNWD_CURR_CODE	☐	EPM: Currency Code
18	SALARY_AMOUNT	SNWD_EMPLOYEES	SALARY_AMOUNT		☐	SNWD_SALARY_AMOUNT	☐	EPM: Salary
19	ACCOUNT_NUMBER	SNWD_EMPLOYEES	ACCOUNT_NUMBER		☐		☐
20	BANK_ID	SNWD_EMPLOYEES	BANK_ID		☐		☐
21	BANK_NAME	SNWD_EMPLOYEES	BANK_NAME		☐	SNWD_BANK_NAME	☐	EPM: Name of a bank
22	EMPLOYEE_PIC_URL	SNWD_EMPLOYEES	EMPLOYEE_PIC_URL		☐	SNWD_EMPLOYEE_PIC_URL	☐	EPM: URL of Product Image

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	DDIC	20150523
SAP Release Created in	740