I_WORKASSIGNMENTKEYMAPPING

CDS View
9 Fields 5 CDS Views

Work Assignment Key Mappings

I_WORKASSIGNMENTKEYMAPPING is a CDS View in S/4HANA. Work Assignment Key Mappings. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_WorkAssignmentBP view_entity from COMPOSITE BP Details of Work Assignment
I_WorkAssignmentBP view_entity union COMPOSITE BP Details of Work Assignment
I_WorkAssignmentValueHelp view_entity from COMPOSITE Work Assignments of a Workforce Person
I_WorkForcePersonMappings view_entity from COMPOSITE Workforce Person Mappings
P_WorkforcePersonInitialAssgmt view_entity from COMPOSITE Initial Assignment of WorkforcePerson

Fields (9)

KeyField CDS FieldsUsed in Views
KEY WorkAssignment WorkAssignment,WorkforceAssignment 3
BusinessPartner BusinessPartner,WorkAssignmentBusinessPartner 3
CentralPerson CentralPerson 1
Country2DigitISOCode Country2DigitISOCode 1
IsBlocked IsBlocked 2
WorkAssignmentExternalID WorkAssignmentExternalID,WorkforceAssignmentExternalID 2
WorkAssignmentStartDate WorkforceAssgmtStartDate 1
WorkforcePersonExternalID WorkforcePersonExternalID 4
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 Key Mappings
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKASSIGNMENTKEYMAPPING (
    WORKASSIGNMENT,
    BUSINESSPARTNER,
    CENTRALPERSON,
    COUNTRY2DIGITISOCODE,
    ISBLOCKED,
    WORKASSIGNMENTEXTERNALID,
    WORKASSIGNMENTSTARTDATE,
    WORKFORCEPERSONEXTERNALID,
    WORKFORCEPERSONID,
    PRIMARY KEY (WORKASSIGNMENT)
);

Learn More