WFD_D_KEYMAP

Transparent Table Application Table
15 Fields 39 CDS Views

Workforce Person Key Mapping

WFD_D_KEYMAP is an SAP database table in S/4HANA. Workforce Person Key Mapping. It contains 15 fields. 39 CDS views read from this table.

CDS Views using this table (39)

ViewTypeJoinVDMDescription
I_EmployDetOp view inner BASIC Employment details for OnPremise
I_EmployOrgDetOp view inner BASIC Employment org details for onPremise
I_EmployStatDet view inner BASIC Employment status
I_EmployWSDet view inner BASIC Employment working time details
I_PersonWorkAgreement view from COMPOSITE Retrieve the work agreements of the Person
I_PersonWorkAgrmtToECId view from BASIC Internal view to get the ECUS ID
I_PersWrkAgrmtToPartner view from BASIC Internal for HCM : Donot Use
I_WorkAssgmtDetsDEX view_entity inner BASIC Workforce Person Assignment Details
I_WorkAssgmtToExtIDDEX view_entity from BASIC Ext IDs of Work Assgmt and Wrkfrc Person
I_WorkAssignment view_entity from BASIC Work Assignments
I_WorkAssignmentDEX view_entity from BASIC Work Assignments
I_WorkAssignmentKeyMapping view_entity from BASIC Work Assignment Key Mappings
I_WorkerImageURL view_entity inner BASIC Image URL of Worker
I_WorkforceAssignmentKeyMap view_entity from BASIC Workforce Assignment Key Mapping
I_WorkforcePersonDEX view_entity inner COMPOSITE Workforce Person
I_WorkforcePersonKeyMap view_entity from BASIC Keymapping for Worker
I_WorkforcePersonPhoto view_entity inner BASIC Workforce Person Photo
P_EmploymentManagerOP view union_all BASIC Employment Manager for OnPremise
P_EMPLREPORTINGSTRUCTUREOP view union_all BASIC Employment Reporting Structure for OnPremise
P_HrRelation_CP_P view from BASIC Read HRP1001 relation table and wfd_d_keymap table
P_HrRelation_P_CP view from BASIC Read HRP1001 relation table and wfd_d_keymap table
P_N_EmployDetOp view inner BASIC Employment details for OnPremise
P_N_Employee view inner BASIC Employee
P_N_Employment view inner BASIC Employment
P_N_EmploymentMinPernr view inner BASIC Main Employment
P_N_EmployOrgDetOp view inner BASIC Employment org details for onPremise
P_N_EmployStatDet view inner BASIC Employment status
P_N_EmployWSDet view inner BASIC Employment working time details
P_N_PersonWorkAgreement view from BASIC Retrieve the work agreements of the Person
P_N_PersWrkAgrmtToPartner view from BASIC Internal for HCM : Donot Use
P_PDOBJECT_001 view union_all BASIC PD Object
P_PDRELATION_001 view union_all BASIC PD Relation
P_PERSONWORKAGREEMENTVR view from BASIC Retrieve the work agreements of the Person
P_PersWrkAgrmtToPartner view union_all BASIC Internal to HCM : Do not use
P_WFDKEYMAP view from BASIC SDM View for WFD_D_KEYMAP
P_WORKASSIGNMENTKEYMAP view_entity from BASIC Work Assignment Keymap
P_WorkforceKeyMapping view from BASIC Private view for key mapping details
P_WorkforceKeyMapUser view from BASIC Converting User ID field from keymap table to upper case
R_WorkAssignmentKeyMap view_entity from BASIC Work Assignment Key Map

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY workforce_assgmt_id wfd_workforce_assgmt WorkForce Assgmt ID
country wfd_country Country/Region
worker_id wfd_worker_id Worker ID
business_partner_id bu_partner Busn. Partner
central_person wfd_central_person WorkForce Master ID
user_id wfd_user_id User ID
person_id wfd_person_id Person ID
person_id_external wfd_person_id_external External Person ID
person_guid wfd_person_guid Person GUID
employment_id wfd_employment_id Employment ID
work_assignment_ext_id wfd_assgmt_ext_id WFA Ext. ID
block_ind wfd_blocked Blocked Indicator
data_source wfd_data_source Data Source
bp_model_type wfd_bp_model_type Workforceperson BP Model type

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Workforce Person Key Mapping
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_KEYMAP (
    CLIENT,                  -- Client [mandt]
    WORKFORCE_ASSGMT_ID,     -- WorkForce Assgmt ID [wfd_workforce_assgmt]
    COUNTRY,                 -- Country/Region [wfd_country]
    WORKER_ID,               -- Worker ID [wfd_worker_id]
    BUSINESS_PARTNER_ID,     -- Busn. Partner [bu_partner]
    CENTRAL_PERSON,          -- WorkForce Master ID [wfd_central_person]
    USER_ID,                 -- User ID [wfd_user_id]
    PERSON_ID,               -- Person ID [wfd_person_id]
    PERSON_ID_EXTERNAL,      -- External Person ID [wfd_person_id_external]
    PERSON_GUID,             -- Person GUID [wfd_person_guid]
    EMPLOYMENT_ID,           -- Employment ID [wfd_employment_id]
    WORK_ASSIGNMENT_EXT_ID,  -- WFA Ext. ID [wfd_assgmt_ext_id]
    BLOCK_IND,               -- Blocked Indicator [wfd_blocked]
    DATA_SOURCE,             -- Data Source [wfd_data_source]
    BP_MODEL_TYPE,           -- Workforceperson BP Model type [wfd_bp_model_type]
    PRIMARY KEY (CLIENT, WORKFORCE_ASSGMT_ID)
);

Learn More