WFD_D_KEYMAP

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)
);