_ASSIGNMENTKEYMAP

7 Fields

_ASSIGNMENTKEYMAP is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY WorkAssignmentExternalID WorkAssignmentExternalID 3
KEY WorkforcePersonUserID ManagerAssignmentExternalID,WorkforcePersonUserID 4
BusinessPartner BusinessPartner,Person 3
IsBlocked IsBlocked 2
WorkforceAssignment WorkAssignment,WorkforceAssignmentID 5
WorkforcePersonExternalID WorkforcePersonExternalID 2
WorkforcePersonID WorkforcePersonID 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ASSIGNMENTKEYMAP (
    WORKASSIGNMENTEXTERNALID,
    WORKFORCEPERSONUSERID,
    BUSINESSPARTNER,
    ISBLOCKED,
    WORKFORCEASSIGNMENT,
    WORKFORCEPERSONEXTERNALID,
    WORKFORCEPERSONID,
    PRIMARY KEY (WORKASSIGNMENTEXTERNALID, WORKFORCEPERSONUSERID)
);

Learn More