P_WORKASSIGNMENTKEYMAP

CDS View
5 Fields 2 CDS Views

Work Assignment Keymap

P_WORKASSIGNMENTKEYMAP is a CDS View in S/4HANA. Work Assignment Keymap. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkAssignment_1 view_entity inner BASIC Work Assignments
R_WorkAssignmentDetail_1 view_entity inner BASIC Work Assignment Details

Fields (5)

KeyField CDS FieldsUsed in Views
BusinessPartner BusinessPartner 2
Country2DigitISOCode Country2DigitISOCode 1
WorkAssignmentExternalID WorkAssignmentExternalID 1
WorkforcePersonDataSource WorkforcePersonDataSource 1
WorkforcePersonID WorkforcePersonID 1

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.

-- Work Assignment Keymap
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKASSIGNMENTKEYMAP (
    BUSINESSPARTNER,
    COUNTRY2DIGITISOCODE,
    WORKASSIGNMENTEXTERNALID,
    WORKFORCEPERSONDATASOURCE,
    WORKFORCEPERSONID
);

Learn More