I_WORKASSIGNMENTDETAIL_1

CDS View
6 Fields 4 CDS Views

Details for Work Assignment

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_InactiveWorkAssignment view_entity inner COMPOSITE Work Assignment Status of a Worker
I_WorkAssignmentAltCost view_entity inner BASIC Alternate Cost Objects for Work Assignment
I_WorkerFactSheetSearch view_entity inner COMPOSITE Workforce Person Details
P_InactiveWorkAssignment view_entity inner COMPOSITE Work Assignment Status of a Worker

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssgmtStartDate WorkforceAssgmtStartDate 1
KEY WorkforceAssignment WorkAssignment 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
IsBlocked IsBlocked 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.

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

Learn More