I_WORKASSIGNMENTKEYMAPPING

CDS View
11 Fields 33 CDS Views

Work Assignment Key Mappings

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

CDS Views using this table (33)

ViewTypeJoinVDMDescription
I_MaintPersnRespWorkAgreement view_entity inner COMPOSITE Maintenance Person Work Agreement
I_PersWrkAgrmtSrchHelp_1 view inner COMPOSITE Search Help for WorkAgreements
I_TimeSheetAndAvailyKPI view_entity from COMPOSITE Timesheet and availability KPIs
I_TimeSheetMissingHoursByUser view_entity left_outer COMPOSITE Timesheet missing hours by user
I_WorkAssgmtAddressDEX view_entity from COMPOSITE Work Assignment Address Details
I_WorkAssgmtDetsDEX_1 view_entity inner BASIC Workforce Person Assignment Details
I_WorkAssgmtPaymentDEX view_entity from COMPOSITE Work Assignment Payment Details
I_WorkAssgmtSrvcCostLvlDEX_1 view_entity from COMPOSITE Workforce Person Service Cost Level
I_WorkAssignment_1 view_entity from BASIC Work Assignments
I_WorkAssignmentAddress view_entity from COMPOSITE Work Assignment Address Details
I_WorkAssignmentBP view_entity from COMPOSITE BP Details of Work Assignment
I_WorkAssignmentBP view_entity union COMPOSITE BP Details of Work Assignment
I_WorkAssignmentDetail view_entity inner BASIC Work Assignment Details
I_WorkAssignmentDEX_1 view_entity from BASIC Work Assignments
I_WorkAssignmentsVH view_entity from COMPOSITE Search Help for Work Assignments
I_WorkAssignmentValueHelp view_entity from COMPOSITE Work Assignments of a Workforce Person
I_WorkforcePersonMapping view_entity from COMPOSITE Workforce Person Mappings
I_WorkForcePersonMappings view_entity from COMPOSITE Workforce Person Mappings
I_WorkforcePersonMappings_1 view_entity from COMPOSITE Workforce Person Mappings
I_WrkAssgmtPaymentDetail view_entity from COMPOSITE Work Assignment Payment Details
I_WrkAssgmtSrvcCostLvl_1 view_entity from COMPOSITE Workforce Person Service Cost Level
I_WrkAssgmtWrkOrderDetail view_entity from COMPOSITE Assignment Work Order Details
I_WrkFrcPersnMainEmployment view_entity from COMPOSITE Main Employment of Workforce Person
N_PersonWorkAgreement_1 view from Auxillary view
P_EmployeeValidity view_entity from COMPOSITE Employee Validity
P_TmeShtGeneralTaskListSDM view_entity from COMPOSITE SDM General Timesheet Task
P_TmeShtTskIntEmplStaffedTask view_entity inner COMPOSITE SDM Staffed Timesheet Task
P_TmeShtTskIntEmplStaffedTask1 view_entity inner COMPOSITE SDM Staffed Timesheet Task
P_TmeShtTskUnstaffedWorkList view_entity inner COMPOSITE SDM Unstaffed Timesheet Task
P_WFD_EMPLOYMENT_1 view_entity from COMPOSITE Employment Details
P_WorkAssignmentActiveJobDets view_entity from COMPOSITE Work Assignment Active Job Details
P_WorkforcePersonInitialAssgmt view_entity from COMPOSITE Initial Assignment of WorkforcePerson
R_WorkAssignmentAddress view_entity from TRANSACTIONAL Work Assignment Address Details

Fields (11)

KeyField CDS FieldsUsed in Views
KEY Country2DigitISOCode Country2DigitISOCode 20
KEY WorkAssignment EmploymentInternalID,PersonWorkAgreement,WorkAssignment,WorkforceAssignment 14
KEY WorkAssignmentExternalID MainEmployment,WorkAssignmentExternalID,WorkforceAssignmentExternalID 20
KEY WorkAssignmentStartDate StartDate,WorkAssignmentStartDate,WorkforceAssgmtStartDate 9
KEY WorkforcePersonExternalID WorkforcePersonExternalID 17
BusinessPartner BusinessPartner,WorkAssignmentBusinessPartner 7
CentralPerson CentralPerson,PersonnelNumber 3
IsBlocked IsBlocked 17
IsContingentWorker IsContingentWorker 3
WorkAssignmentEndDate EndDate,WorkAssignmentEndDate 5
WorkforcePersonID WorkforcePersonID 4

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 (
    COUNTRY2DIGITISOCODE,
    WORKASSIGNMENT,
    WORKASSIGNMENTEXTERNALID,
    WORKASSIGNMENTSTARTDATE,
    WORKFORCEPERSONEXTERNALID,
    BUSINESSPARTNER,
    CENTRALPERSON,
    ISBLOCKED,
    ISCONTINGENTWORKER,
    WORKASSIGNMENTENDDATE,
    WORKFORCEPERSONID,
    PRIMARY KEY (COUNTRY2DIGITISOCODE, WORKASSIGNMENT, WORKASSIGNMENTEXTERNALID, WORKASSIGNMENTSTARTDATE, WORKFORCEPERSONEXTERNALID)
);

Learn More