R_WORKASSIGNMENTDETAILSALL

CDS View
15 Fields 3 CDS Views

Work assignment Details All

R_WORKASSIGNMENTDETAILSALL is a CDS View in S/4HANA. Work assignment Details All. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
R_WorkAssignmentDetail view_entity from COMPOSITE Details for Work Assignment
R_WorkAssignmentDetailsTP view_entity from TRANSACTIONAL Work Assignment Details TP
R_WorkAssignmentDetailsTP_2 view_entity from TRANSACTIONAL Work Assignment Details TP

Fields (15)

KeyField CDS FieldsUsed in Views
KEY StartDate StartDate 3
CompanyCode CompanyCode 3
ControllingArea ControllingArea 1
CostCenter CostCenter 3
EmploymentPercent EmploymentPercent 3
EndDate EndDate 3
IsBlocked IsBlocked 3
ManagerAssignmentExternalID ManagerEmployee 3
ManagerAssignmentID ManagerAssignmentID 3
WeeklyWorkingDays WeeklyWorkingDays 3
WeeklyWorkingHours WeeklyWorkingHours 3
WorkAssignment WorkAssignment 3
WorkforceAssignmentStatus WorkforceAssignmentStatus 3
WorkforcePersonJobCode WorkforcePersonJobCode 3
WorkforcePersonJobTitle WorkforcePersonJobTitle 3

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 All
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_WORKASSIGNMENTDETAILSALL (
    STARTDATE,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    EMPLOYMENTPERCENT,
    ENDDATE,
    ISBLOCKED,
    MANAGERASSIGNMENTEXTERNALID,
    MANAGERASSIGNMENTID,
    WEEKLYWORKINGDAYS,
    WEEKLYWORKINGHOURS,
    WORKASSIGNMENT,
    WORKFORCEASSIGNMENTSTATUS,
    WORKFORCEPERSONJOBCODE,
    WORKFORCEPERSONJOBTITLE,
    PRIMARY KEY (STARTDATE)
);

Learn More