I_WORKASSIGNMENTDETAILSALL

CDS View
6 Fields 1 CDS Views

Work Assignment Details

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkAssignmentStartDate WorkAssignmentStartDate 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
Country2DigitISOCode Country2DigitISOCode 1
WorkAssignmentEndDate WorkAssignmentEndDate 1
WorkforcePersonJobCode Job 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_WORKASSIGNMENTDETAILSALL (
    WORKASSIGNMENTSTARTDATE,
    COMPANYCODE,
    COSTCENTER,
    COUNTRY2DIGITISOCODE,
    WORKASSIGNMENTENDDATE,
    WORKFORCEPERSONJOBCODE,
    PRIMARY KEY (WORKASSIGNMENTSTARTDATE)
);

Learn More