P_WORKASSIGNMENT

CDS View
6 Fields 2 CDS Views

Work Assignments

P_WORKASSIGNMENT is a CDS View in S/4HANA. Work Assignments. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkAssignment_1 view_entity from BASIC Work Assignments
R_WorkAssignmentDetail_1 view_entity inner BASIC Work Assignment Details

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkAssignment WorkAssignment 1
IsBlocked IsBlocked 2
IsContingentWorker IsContingentWorker 1
WorkAssignmentEndDate WorkAssignmentEndDate 1
WorkAssignmentExternalID WorkAssignmentExternalID 1
WorkAssignmentStartDate WorkAssignmentStartDate 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 Assignments
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_WORKASSIGNMENT (
    WORKASSIGNMENT,
    ISBLOCKED,
    ISCONTINGENTWORKER,
    WORKASSIGNMENTENDDATE,
    WORKASSIGNMENTEXTERNALID,
    WORKASSIGNMENTSTARTDATE,
    PRIMARY KEY (WORKASSIGNMENT)
);

Learn More