WFD_D_KEYMAP

Transparent Table Application Table
15 Fields 35 CDS Views

Key Mapping Persistence

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

CDS Views using this table (35)

ViewTypeJoinVDMDescription
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_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
P_Employmentminpernrstop_001 view union_all BASIC
P_EmploymentOp_001 view inner BASIC
P_EMPLREPORTINGSTRUCTUREOP view union_all BASIC
P_HrRelation_CP_P view from BASIC
P_HrRelation_P_CP view from BASIC
P_N_EmployDetOp view inner BASIC
P_N_Employee view inner BASIC
P_N_EmployeeOp view inner BASIC
P_N_Employment view inner BASIC
P_N_EmploymentMinPernr view inner BASIC
P_N_EmployOrgDetOp view inner BASIC
P_N_EmployStatDet view inner BASIC
P_N_EmployWSDet view inner BASIC
P_N_PersonWorkAgreement view from BASIC
P_N_PersWrkAgrmtToPartner view from BASIC
P_PDOBJECT_001 view union_all BASIC
P_PDRELATION_001 view union_all BASIC
P_PERSONWORKAGREEMENTVR view from BASIC
P_PersonWorkAgrmtToECId view from BASIC
P_PersonWorkAgrmtToECId view union_all BASIC
P_PersWrkAgrmtToPartner view union_all BASIC
P_WFDKEYMAP view from BASIC SDM View for WFD_D_KEYMAP
P_WorkforceKeyMapping view from BASIC
P_WorkforceKeyMapUser view from BASIC
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.

-- Key Mapping Persistence
-- 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