R_WORKASSIGNMENTKEYMAP

CDS View
3 Fields 6 CDS Views

Work Assignment Key Map

R_WORKASSIGNMENTKEYMAP is a CDS View in S/4HANA. Work Assignment Key Map. It contains 3 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
R_BPRltnShipSupplierTP view_entity inner TRANSACTIONAL TP View for Business Partner Relationship to suppliers
R_WorkAssgmtSrvcCostLvlTP view_entity inner TRANSACTIONAL Work Assignment: Service Cost Level TP
R_WorkAssignmentBP view_entity from COMPOSITE Work assignment all models
R_WorkAssignmentBP view_entity union COMPOSITE Work assignment all models
R_WorkAssignmentDetailsTP view_entity inner TRANSACTIONAL Work Assignment Details TP
R_WorkAssignmentKeyMapOldModel view_entity from COMPOSITE Multi Work Assignments on Old Model

Fields (3)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssignment WorkAssignment,WorkforceAssignment 2
BusinessPartner BusinessPartner,WorkAssignmentBusinessPartner 1
WorkforcePersonExternalID WorkforcePersonExternalID 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 Key Map
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_WORKASSIGNMENTKEYMAP (
    WORKFORCEASSIGNMENT,
    BUSINESSPARTNER,
    WORKFORCEPERSONEXTERNALID,
    PRIMARY KEY (WORKFORCEASSIGNMENT)
);

Learn More