WFP_D_WA_DFT

Transparent Table Application Table
30 Fields 1 CDS Views

Draft table for entity R_WORKASSIGNMENTTP

WFP_D_WA_DFT is an SAP database table in S/4HANA. Draft table for entity R_WORKASSIGNMENTTP. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WorkAssignmentDraft view from BASIC View for the Draft Table wfp_d_wa_dft

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY workassignmentuuid BU_PARTNER_GUID BP GUID
startdate abap.dats
enddate abap.dats
workassignment WFD_WORKFORCE_ASSGMT WorkForce Assgmt ID
workassignmentexternalid WFD_ASSGMT_EXT_ID WFA Ext. ID
workforcepersonid WFD_WORKER_ID Worker ID
workforcepersonuserid WFD_USER_ID User ID
workassignmentdatasource WFD_DATA_SOURCE Data Source
workassignmentbusinesspartner BU_PARTNER Busn. Partner
person BU_PARTNER Busn. Partner
personuuid BU_PARTNER_GUID BP GUID
companycode BUKRS Company Code
workassignmentcountryisocode INTCA ISO Code
rolecategory BU_PARTNERROLECAT BP Role Cat.
basicrolecategory BU_PARTNERROLECAT BP Role Cat.
businesspartnerrole BU_PARTNERROLE BP Role
employmentsituation BUM_WF_EMPLOYMENT_SITUATION Employment Situation
buspartrelshpsupplierisvisible BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
creationdatetime VDM_LASTCHANGEDON Last Changed On
businesspartnerrelshpsupplier abap.char
businesspartnername abap.char
isblocked WFD_BLOCKED Blocked Indicator
isbusinesspurposecompleted BU_XPCPT Purpose Completed
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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_WORKASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFP_D_WA_DFT (
    MANDT,                           -- Client [MANDT]
    WORKASSIGNMENTUUID,              -- BP GUID [BU_PARTNER_GUID]
    STARTDATE,                       -- abap.dats
    ENDDATE,                         -- abap.dats
    WORKASSIGNMENT,                  -- WorkForce Assgmt ID [WFD_WORKFORCE_ASSGMT]
    WORKASSIGNMENTEXTERNALID,        -- WFA Ext. ID [WFD_ASSGMT_EXT_ID]
    WORKFORCEPERSONID,               -- Worker ID [WFD_WORKER_ID]
    WORKFORCEPERSONUSERID,           -- User ID [WFD_USER_ID]
    WORKASSIGNMENTDATASOURCE,        -- Data Source [WFD_DATA_SOURCE]
    WORKASSIGNMENTBUSINESSPARTNER,   -- Busn. Partner [BU_PARTNER]
    PERSON,                          -- Busn. Partner [BU_PARTNER]
    PERSONUUID,                      -- BP GUID [BU_PARTNER_GUID]
    COMPANYCODE,                     -- Company Code [BUKRS]
    WORKASSIGNMENTCOUNTRYISOCODE,    -- ISO Code [INTCA]
    ROLECATEGORY,                    -- BP Role Cat. [BU_PARTNERROLECAT]
    BASICROLECATEGORY,               -- BP Role Cat. [BU_PARTNERROLECAT]
    BUSINESSPARTNERROLE,             -- BP Role [BU_PARTNERROLE]
    EMPLOYMENTSITUATION,             -- Employment Situation [BUM_WF_EMPLOYMENT_SITUATION]
    BUSPARTRELSHPSUPPLIERISVISIBLE,  -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    CREATIONDATETIME,                -- Last Changed On [VDM_LASTCHANGEDON]
    BUSINESSPARTNERRELSHPSUPPLIER,   -- abap.char
    BUSINESSPARTNERNAME,             -- abap.char
    ISBLOCKED,                       -- Blocked Indicator [WFD_BLOCKED]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [BU_XPCPT]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, WORKASSIGNMENTUUID)
);

Learn More