I_WORKASSIGNMENTDETAILSALL

CDS View
16 Fields 14 CDS Views

Work Assignment Details

I_WORKASSIGNMENTDETAILSALL is a CDS View in S/4HANA. Work Assignment Details. It contains 16 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_WorkAssgmtDetsDEX_1 view_entity from BASIC Workforce Person Assignment Details
I_WorkAssignmentDetail view_entity from BASIC Work Assignment Details
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person
P_PERSONWORKAGRMTORGLDETAILS1 view_entity from COMPOSITE ZI_PersonWorkAgrmtOrglDetails1
P_PERSONWORKAGRMTORGLDETAILS1 view_entity union_all COMPOSITE ZI_PersonWorkAgrmtOrglDetails1
P_WFD_EMPLOYMENT view_entity inner COMPOSITE Get minimum Active employment
P_WFD_GET_MINEPERNR_MAIN_EMP view_entity inner COMPOSITE Get min. Active pernr with Main Emp
P_WFD_GET_MINEPERNR_NMAIN_EMP view_entity inner COMPOSITE Get minimum Active pernr with Main Employment flag
P_WorkAssignmentActiveJobDets view_entity inner COMPOSITE Work Assignment Active Job Details
P_WorkAssignmentCostCenterDets view_entity from COMPOSITE Work Assignment Details with Cost Center
P_WorkAssignmentCostCenterDets view_entity union_all COMPOSITE Work Assignment Details with Cost Center
P_WRKASSGMTDETSCOSTCENTER view_entity from COMPOSITE P_WRKASSGMTDETSCOSTCENTER
R_WorkAssgmtAltCostAssgmt view_entity inner BASIC Alternate Cost Object for Wrk Assignment
R_WorkAssignmentListSummary view_entity inner COMPOSITE Work Assignment Summary List

Fields (16)

KeyField CDS FieldsUsed in Views
KEY WorkAssignment EmploymentInternalID,WorkAssignment 3
KEY WorkAssignmentStartDate StartDate,WorkAssignmentStartDate 7
CompanyCode CompanyCode 8
ControllingArea ControllingArea 1
CostCenter CostCenter 7
Country2DigitISOCode Country2DigitISOCode 1
EmploymentPercent EmploymentPercent 3
SupervisorWorkAssignmentExtID ManagerEmployee,SupervisorWorkAssignmentExtID 4
SupervisorWorkAssignmentID ManagerAssignmentID 1
WeeklyWorkingDays WeeklyWorkingDays 3
WeeklyWorkingHours WeeklyWorkingHours 3
WorkAssignmentEndDate EndDate,WorkAssignmentEndDate 7
WorkAssignmentStatus WorkAssignmentStatus 2
WorkforceAssignmentIsPrimary WorkforceAssignmentIsPrimary 1
WorkforcePersonJobCode Job,WorkforcePersonJobCode 3
WorkforcePersonJobTitle WorkforcePersonJobTitle 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 Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKASSIGNMENTDETAILSALL (
    WORKASSIGNMENT,
    WORKASSIGNMENTSTARTDATE,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY2DIGITISOCODE,
    EMPLOYMENTPERCENT,
    SUPERVISORWORKASSIGNMENTEXTID,
    SUPERVISORWORKASSIGNMENTID,
    WEEKLYWORKINGDAYS,
    WEEKLYWORKINGHOURS,
    WORKASSIGNMENTENDDATE,
    WORKASSIGNMENTSTATUS,
    WORKFORCEASSIGNMENTISPRIMARY,
    WORKFORCEPERSONJOBCODE,
    WORKFORCEPERSONJOBTITLE,
    PRIMARY KEY (WORKASSIGNMENT, WORKASSIGNMENTSTARTDATE)
);

Learn More