SAP ABAP View ACMTST_SQLV_EMPL (Erzeugt aus Ddl Source ACMTST_DDL_EMPL)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SEC-AUT (Application Component) Authorization Management
     ⤷ SACMTST (Package) Objects for Testing the ACM functionality

Basic Data

View Type	D	Database View
Database View	ACMTST_SQLV_EMPL
Short Description	Erzeugt aus Ddl Source ACMTST_DDL_EMPL
Root table	ACMTST_DB_EMPL	ACMTST: Employee (DB-Table)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ACMTST_DB_EMPL	ACMTST_DB_EMPL

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	ACMTST_DB_EMPL	CLIENT		☐	MANDT	☐	Client
2	UUID	ACMTST_DB_EMPL	UUID		☐	ACMTST_ID	☐	ACMTST: Globally unique-ID - PrimaryKey of all ACMTST-Tables
3	EMPLOYEE_ID	ACMTST_DB_EMPL	EMPLOYEE_ID		☐		☐
4	FIRST_NAME	ACMTST_DB_EMPL	FIRST_NAME		☐		☐
5	LAST_NAME	ACMTST_DB_EMPL	LAST_NAME		☐		☐
6	LOGIN_NAME	ACMTST_DB_EMPL	LOGIN_NAME		☐	XUBNAME	☐	User Name in User Master Record
7	GENDER	ACMTST_DB_EMPL	GENDER		☐	ACMTST_GENDER	☐	ACMTST: Gender/Sex
8	LANGUAGE	ACMTST_DB_EMPL	LANGUAGE		☐	SPRAS	☐	Language Key
9	PHONE_NUMBER	ACMTST_DB_EMPL	PHONE_NUMBER		☐		☐
10	EMAIL_ADDRESS	ACMTST_DB_EMPL	EMAIL_ADDRESS		☐		☐
11	VAL_START_DATE	ACMTST_DB_EMPL	VAL_START_DATE		☐		☐
12	VAL_END_DATE	ACMTST_DB_EMPL	VAL_END_DATE		☐		☐
13	CURRENCY_CODE	ACMTST_DB_EMPL	CURRENCY_CODE		☐		☐
14	SALARY_AMOUNT	ACMTST_DB_EMPL	SALARY_AMOUNT		☐		☐

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