WFP_D_DETS_DFT_2

Transparent Table Application Table
23 Fields 1 CDS Views

Draft table for entity R_WORKASSIGNMENTDETAILSTP_2

WFP_D_DETS_DFT_2 is an SAP database table in S/4HANA. Draft table for entity R_WORKASSIGNMENTDETAILSTP_2. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WorkAssignmentDetailsDraft_2 view_entity from BASIC View for the Draft Table wfp_d_dets_dft_2

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workassignmentbusinesspartner bu_partner Busn. Partner
KEY startdate wfd_start_date Start Date
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
enddate wfd_end_date End Date
workassignment wfd_workforce_assgmt WorkForce Assgmt ID
companycode bukrs Company Code
costcenter kostl Cost Center
businesspartner bu_partner Busn. Partner
workforcepersonjobcode wfd_job_code Job Code
workforcepersonjobtitle wfd_jobtitle Job Title
workforceassignmentisprimary xfeld Checkbox
managerassignmentid wfd_manager_work_assgmt Manager Assgmt ID
weeklyworkingdays wfd_weekly_wrkg_days Working Days
weeklyworkinghours wfd_weekly_wrkg_hrs Working Hours
employmentpercent wfd_emplymt_percent Emplymt Percentage
workforceassignmentstatus wfd_emplymt_status Employment Status
manageremployee wfd_manager_assgmt_ext_id Manager External ID
iseditable boolean Boolean Variable (X = True, - = False, Space = Unknown)
employmentpercentageunit qprozent Percent
isblocked wfd_blocked Blocked Indicator
workforcepersondraftuuid sdraft_uuid Draft Document ID

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.

-- Draft table for entity R_WORKASSIGNMENTDETAILSTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFP_D_DETS_DFT_2 (
    MANDT,                          -- Client [mandt]
    WORKASSIGNMENTBUSINESSPARTNER,  -- Busn. Partner [bu_partner]
    STARTDATE,                      -- Start Date [wfd_start_date]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    ENDDATE,                        -- End Date [wfd_end_date]
    WORKASSIGNMENT,                 -- WorkForce Assgmt ID [wfd_workforce_assgmt]
    COMPANYCODE,                    -- Company Code [bukrs]
    COSTCENTER,                     -- Cost Center [kostl]
    BUSINESSPARTNER,                -- Busn. Partner [bu_partner]
    WORKFORCEPERSONJOBCODE,         -- Job Code [wfd_job_code]
    WORKFORCEPERSONJOBTITLE,        -- Job Title [wfd_jobtitle]
    WORKFORCEASSIGNMENTISPRIMARY,   -- Checkbox [xfeld]
    MANAGERASSIGNMENTID,            -- Manager Assgmt ID [wfd_manager_work_assgmt]
    WEEKLYWORKINGDAYS,              -- Working Days [wfd_weekly_wrkg_days]
    WEEKLYWORKINGHOURS,             -- Working Hours [wfd_weekly_wrkg_hrs]
    EMPLOYMENTPERCENT,              -- Emplymt Percentage [wfd_emplymt_percent]
    WORKFORCEASSIGNMENTSTATUS,      -- Employment Status [wfd_emplymt_status]
    MANAGEREMPLOYEE,                -- Manager External ID [wfd_manager_assgmt_ext_id]
    ISEDITABLE,                     -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    EMPLOYMENTPERCENTAGEUNIT,       -- Percent [qprozent]
    ISBLOCKED,                      -- Blocked Indicator [wfd_blocked]
    WORKFORCEPERSONDRAFTUUID,       -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, WORKASSIGNMENTBUSINESSPARTNER, STARTDATE, DRAFTUUID)
);

Learn More