SAP ABAP Table CRMAHR (Data on Persons)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO-ATF (Application Component) ABAP Test Frameworks ( ATC, CheckMan, Code Inspector)
     ⤷ S_CHECK_RESULT_MANAGEMENT (Package) SAP ONLY: Check Internal Guidelines - Basic Module

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMAHR	Table Relationship Diagram
Short Description	Data on Persons

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	USERID	☑	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
2	USERNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
3	FIRSTNAME	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
4	LASTNAME	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
5	PHONE	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
6	COSTCENTER	☐	COST_CT	TEXT10	CHAR	10	0	Addresses: Cost center
7	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
8	BUILDING	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
9	ROOM	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
10	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
11	ROLEID	☐	CRMROLEID	CRMROLEID	CHAR	10	0	User Role	CRMAHRROL
12	RESP1	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
13	RESP2	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
14	RESP3	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
15	RESP4	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
16	RESP5	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
17	CHGTSTAMP	☐	CRMTSCHG	TSTAMP	NUMC	14	0	Timestamp of change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMAHR	ROLEID	CRMAHRROL	ROLEID	REF

History

Last changed by/on	SAP	20130604
SAP Release Created in