I_WORKASSIGNMENTDETAIL_1

CDS View
6 Fields 3 CDS Views

Details for Work Assignment

I_WORKASSIGNMENTDETAIL_1 is a CDS View in S/4HANA. Details for Work Assignment. It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InactiveWorkAssignment view_entity inner COMPOSITE Work Assignment Status of a Worker
R_WorkAssgmtAltCostAssgmt view_entity inner BASIC Alternate Cost Object for Wrk Assignment
R_WorkAssgmtAltCostAssgmtUnion view_entity from COMPOSITE Alt Cost Assgmnts at Wrk Assignmnt

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssgmtStartDate WorkAssignmentStartDate 1
CompanyCode CompanyCode 2
ControllingArea ControllingArea 2
CostCenter CostCenter 1
WorkforceAssgmtEndDate WorkAssignmentEndDate 1
WorkforceAssignment WorkAssignment 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.

-- Details for Work Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKASSIGNMENTDETAIL_1 (
    WORKFORCEASSGMTSTARTDATE,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    WORKFORCEASSGMTENDDATE,
    WORKFORCEASSIGNMENT,
    PRIMARY KEY (WORKFORCEASSGMTSTARTDATE)
);

Learn More