SAP ABAP Table SNWD_EMPLOYEES (EPM: Employee Data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_NWDEMO_MODEL_DDIC (Package) Common Data Dictionary Objects (only) for EPM and NWDEMO

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SNWD_EMPLOYEES	Table Relationship Diagram
Short Description	EPM: Employee Data

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	SNWD_EMPLOYEES	CLIENT	T000	MANDT		1	CN
2	SNWD_EMPLOYEES	PARENT_KEY	SNWD_COMPANY	NODE_KEY		1	CN
3	SNWD_EMPLOYEES	PR_ADDRESS_GUID	SNWD_AD	NODE_KEY		1	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in	730