I_WORKFORCEASSIGNMENTDETAILS

CDS View
5 Fields 3 CDS Views

Workforce Assignment Details

I_WORKFORCEASSIGNMENTDETAILS is a CDS View in S/4HANA. Workforce Assignment Details. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_WorkForcePersonMinEmpl view inner COMPOSITE Minimum Employment of WorkForce
I_WorkforcePersonPrimEmplymt view inner COMPOSITE WorkForce Person Primary Employment
P_PrimaryCostAssignments view from COMPOSITE Primary Cost Assignments for Work Assignments

Fields (5)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssgmtStartDate WorkforceAssgmtStartDate 1
KEY WorkforceAssignment WorkAssignment,WorkforceAssignment 3
CostCenter CostCenter 1
WorkforceAssgmtEndDate WorkforceAssgmtEndDate 1
WorkforceAssignmentStatus WorkforceAssignmentStatus 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.

-- Workforce Assignment Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKFORCEASSIGNMENTDETAILS (
    WORKFORCEASSGMTSTARTDATE,
    WORKFORCEASSIGNMENT,
    COSTCENTER,
    WORKFORCEASSGMTENDDATE,
    WORKFORCEASSIGNMENTSTATUS,
    PRIMARY KEY (WORKFORCEASSGMTSTARTDATE, WORKFORCEASSIGNMENT)
);

Learn More