I_WORKASSIGNMENTDETAILS

CDS View

Work Assignment details

I_WORKASSIGNMENTDETAILS is a CDS View in S/4HANA. Work Assignment details. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkAssignmentDetsJobCodeFam view_entity from BASIC Work assignment job code dets for cloud

Fields (4)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssgmtStartDate WorkAssignmentStartDate 1
KEY WorkforceAssignment WorkAssignment 1
CompanyCode CompanyCode 1
WorkforcePersonJobCode WorkforcePersonJobCode 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_WORKASSIGNMENTDETAILS (
    WORKFORCEASSGMTSTARTDATE,
    WORKFORCEASSIGNMENT,
    COMPANYCODE,
    WORKFORCEPERSONJOBCODE,
    PRIMARY KEY (WORKFORCEASSGMTSTARTDATE, WORKFORCEASSIGNMENT)
);