FROM_DAT in AGR_USERS
Start date (DE: Beginndatum)
FROM_DAT is a field in SAP table AGR_USERS (Assignment of roles to users). It represents "Start date". Data element: AGR_FDATE. Available in 7 CDS view(s) as from_dat, valid_from, CharcFromDate.
Business Meaning
| Description (EN) | Start date |
|---|---|
| Beschreibung (DE) | Beginndatum |
| Data Element | AGR_FDATE |
| Key Field | Yes |
CDS Views & Technical Names (7)
AGR_USERS.FROM_DAT is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
from_dat
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /dmbe/I_User_Roles | direct | Assignment of roles to users | ||
| P_USER_ROLE | direct | Get roles for users with reference user | ||
| P_UserRoles | direct | User role assignments | ||
| P_USR_AUTH_ROLE | direct | User with Roles or Authorizations |
valid_from
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Agr_Users_Usrefus | direct | User-Role Assignment for ref. User | ||
| Pfcg_Role_To_User | direct | Assigmnt:PFCGRoleName-User(incl.RefUser) |
CharcFromDate
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ACMRoleAssignmentForUser | direct | BASIC | Interface layer for role assigned to the user |
Other Tables with Field FROM_DAT (1)
| Table | Data Element | Key | Description |
|---|---|---|---|
| USGRP_USER | AGR_FDATE | KEY | Assignment of Users to User Groups |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA