WFP_D_WADETS_DFT

Transparent Table Application Table
21 Fields 1 CDS Views

Draft table for entity R_WORKASSIGNMENTDETAILSTP

WFP_D_WADETS_DFT is an SAP database table in S/4HANA. Draft table for entity R_WORKASSIGNMENTDETAILSTP. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WorkAssignmentDetailsDraft view_entity from BASIC View for the Draft Table wfp_d_wadets_dft

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workassignmentuuid bu_partner_guid BP GUID
KEY startdate wfd_start_date Start Date
enddate wfd_end_date End Date
workassignment wfd_workforce_assgmt WorkForce Assgmt ID
workassignmentbusinesspartner bu_partner Busn. Partner
personuuid bu_partner_guid BP GUID
companycode bukrs Company Code
costcenter kostl Cost Center
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

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFP_D_WADETS_DFT (
    MANDT,                          -- Client [mandt]
    WORKASSIGNMENTUUID,             -- BP GUID [bu_partner_guid]
    STARTDATE,                      -- Start Date [wfd_start_date]
    ENDDATE,                        -- End Date [wfd_end_date]
    WORKASSIGNMENT,                 -- WorkForce Assgmt ID [wfd_workforce_assgmt]
    WORKASSIGNMENTBUSINESSPARTNER,  -- Busn. Partner [bu_partner]
    PERSONUUID,                     -- BP GUID [bu_partner_guid]
    COMPANYCODE,                    -- Company Code [bukrs]
    COSTCENTER,                     -- Cost Center [kostl]
    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]
    PRIMARY KEY (MANDT, WORKASSIGNMENTUUID, STARTDATE)
);

Learn More