WFD_D_JOBCODET

Transparent Table Application Table

Job Code Title

WFD_D_JOBCODET is an SAP database table in S/4HANA. Job Code Title. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_JobText view from BASIC Job text
I_JobText view union_all BASIC Job text
I_WorkforceAssignmentJobTitle view from BASIC Assignment Job Code Title
P_J_PDOBJECT view union_all BASIC

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY job_code WFD_JOB_CODE Job Code
KEY language LANGU Language
start_date WFD_START_DATE Start Date
end_date WFD_END_DATE End Date
job_title WFD_JOBTITLE Job Title

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.

-- Job Code Title
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_JOBCODET (
    CLIENT,      -- Client [MANDT]
    JOB_CODE,    -- Job Code [WFD_JOB_CODE]
    LANGUAGE,    -- Language [LANGU]
    START_DATE,  -- Start Date [WFD_START_DATE]
    END_DATE,    -- End Date [WFD_END_DATE]
    JOB_TITLE,   -- Job Title [WFD_JOBTITLE]
    PRIMARY KEY (CLIENT, JOB_CODE, LANGUAGE)
);