SAP ABAP Table ACMTST_SQLV_EMPL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ACMTST_SQLV_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	UUID	☑	ACMTST_ID	ACM_ID	RAW	16	0	ACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tables
3	EMPLOYEE_ID	☐			CHAR	10	0
4	FIRST_NAME	☐			CHAR	40	0
5	LAST_NAME	☐			CHAR	40	0
6	LOGIN_NAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	ACMTST_DB_USR2
7	GENDER	☐	ACMTST_GENDER	ACMTST_GENDER	CHAR	1	0	ACMTST: Gender/Sex
8	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key
9	PHONE_NUMBER	☐			CHAR	20	0
10	EMAIL_ADDRESS	☐			CHAR	60	0
11	VAL_START_DATE	☐			DATS	8	0
12	VAL_END_DATE	☐			DATS	8	0
13	CURRENCY_CODE	☐			CUKY	5	0
14	SALARY_AMOUNT	☐			CURR	15	2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ACMTST_SQLV_EMPL	LOGIN_NAME	ACMTST_DB_USR2	ACMTST_BNAME
2	ACMTST_SQLV_EMPL	MANDT	T000	MANDT		1	CN

History

Last changed by/on	DDIC	20150523
SAP Release Created in