USER_ID in WFD_D_KEYMAP
User ID (DE: Benutzer-ID)
USER_ID is a field in SAP table WFD_D_KEYMAP (Workforce Person Key Mapping). It represents "User ID". Data element: WFD_USER_ID. Available in 12 CDS view(s) as WorkforcePersonUserID, WorkAssignmentExternalID, PersonWorkAgreementExternalID.
Business Meaning
| Description (EN) | User ID |
|---|---|
| Beschreibung (DE) | Benutzer-ID |
| Data Element | WFD_USER_ID |
| Key Field | No |
CDS Views & Technical Names (12)
WFD_D_KEYMAP.USER_ID 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.
WorkforcePersonUserID
(7 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_WorkforcePersonKeyMap | direct | BASIC | Keymapping for Worker | |
| P_WORKASSIGNMENTKEYMAP | direct | BASIC | Work Assignment Keymap | |
| R_WorkAssignmentKeyMap | direct | BASIC | Work Assignment Key Map | |
| R_WorkAssignment | via 2 level | COMPOSITE | Work Assignment for Worker Factsheet | |
| R_WorkAssignmentListSummary | via 2 level | COMPOSITE | Work Assignment Summary List | |
| C_WorkAssignment_1 | via 3 levels | CONSUMPTION | Work Assignment for Worker Factsheet | |
| C_WorkAssignmentListSummary | via 3 levels | CONSUMPTION | Work Assignment Summary List |
WorkAssignmentExternalID
(3 views)
User ID
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_WorkAssgmtDetsDEX | direct | BASIC | Workforce Person Assignment Details | |
| I_WorkAssgmtToExtIDDEX | direct | BASIC | Ext IDs of Work Assgmt and Wrkfrc Person | |
| I_WorkAssignmentDEX | direct | BASIC | Work Assignments |
PersonWorkAgreementExternalID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_PersonWorkAgrmtToECId | direct | BASIC | Internal view to get the ECUS ID |
UserID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_WorkforceKeyMapping | direct | BASIC | Private view for key mapping details |
Other Tables with Field USER_ID (29)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /IWNGW/NRECIP | /IWNGW/HUB_COS_RECIPIENT_ID | KEY | HUB Transactional - Notification Recipients |
| /IWNGW/NTYP_SETN | /IWNGW/HUB_MED_RECIPIENT_ID | KEY | HUB Metadata - Notification Type Personalization |
| /PLMB/AUTH_UGUSR | /PLMB/AUTH_USER_ID | KEY | User Enitity - User - Assignment |
| /PRA/AR_REC_BAL | ERNAM | Accounts Receivable Balance | |
| /PRA/AR_REC_BALH | ERNAM | Accounts Receivable Balance History | |
| /SSB/FAVOURITES | /SSB/ABAP_USER_ID | KEY | User-specific favourites in Smart Business (Customizing) |
| /UI2/RECMUSRPRC | SYUNAME | KEY | Recommendation Data For User Preference |
| ACO_GROUP_USER | ACO_USER_ID | KEY | ACO: User in user groups |
| ACO_SUBSTITUTE | ACO_USER_ID | Objektbezogene Berechtigungen für Vertreter | |
| ACO_USER | ACO_USER_ID | Objektbezogene Berechtigungen für einen Benutzer | |
| APS_BUSR_MC_BU | APS_USERID | KEY | IAM: Business User - Buffer for Mass Change Users |
| APS_IAM_D_BRCUA | SYUNAME | KEY | IAM: Business Role - Catalog - User Assignment -> PFCG Role |
| APS_IAM_W_INFO | APS_USERID | IAM: Information System Template Filter | |
| FPM_SAVED_SEARCH | SYUNAME | KEY | FPM Table for saved searches |
| ISLM_TSKSCHD | UNAME | Table for managing background job tasks | |
| KSR_TS_MAIN | SYST_UNAME | KSR: Tenant Specific Main Records | |
| MMPUR_CAT_MY_FAV | MMPUR_CAT_USER_NAME | KEY | Personal Markers |
| MMPUR_CAT_RTGRVW | MMPUR_CAT_USER_NAME | KEY | Rating and review table |
| MMPURUPLDFILETMP | MMPUR_D_EMP_ID | Error Messages for Excel based Data Exchange | |
| PRECO_D_ALGO | PRECO_USER_DSRC | Product Recommendation Algorithm | |
| RSANAUMMTSKSCHD | UNAME | Table for managing PAi background job tasks | |
| SMN_TS_WORK_PRC | SYST_UNAME | SMN: Tenant Specific Work Process Data | |
| SWWUSERWI | XUBNAME | KEY | Aktuelle Workitems eines Benutzers |
| SWWWIPAGENT | XUBNAME | KEY | Workflow Runtime: Potential Agents of a Work Item |
| TMO_HPT_RECORDS | TMO_CR_V_USER_ID | TMO-HPT: Records | |
| TMO_HTS_M_STS | SYST_UNAME | TMO_HTS: Replic.+Enriched Data from M_SERVICE_THREAD_SAMPLES | |
| VCH_SIM_FAVORITE | SYUNAME | KEY | Stores the Favorite items of users |
| WDY_CONF_USER | WDY_CONF_USER_TYPE | KEY | Web Dynpro: Configuration Data for User |
| WDY_CONF_USERT | WDY_CONF_USER_TYPE | KEY | Web Dynpro: Configuration Data for User |
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