SAP ABAP Table ACMTST_DB_EMPL (ACMTST: Employee (DB-Table))

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

Table Category	TRANSP	Transparent table
Transparent table	ACMTST_DB_EMPL	Table Relationship Diagram
Short Description	ACMTST: Employee (DB-Table)

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	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
15	ACCOUNT_NUMBER	☐			CHAR	10	0
16	BANK_ID	☐			CHAR	10	0
17	BANK_NAME	☐			CHAR	255	0

Foreign Keys

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

History

Last changed by/on	SAP	20141013
SAP Release Created in	740