WFD_D_PHOTO

Transparent Table Application Table
8 Fields 3 CDS Views

Workforce Person Photo URL

WFD_D_PHOTO is an SAP database table in S/4HANA. Workforce Person Photo URL. It contains 8 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_WorkerImageURL view_entity from BASIC Image URL of Worker
I_WorkforcePersonImageURL view inner COMPOSITE Workforce person Image URL
I_WorkforcePersonPhoto view_entity from BASIC Workforce Person Photo

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY worker_id wfd_worker_id Worker ID
KEY image_typecode wfd_image_type Photo Type
worker_image_url wfd_worker_image_url Photo URL
image_uri_internal wfd_image_uri_internal Image URI(Internal)
commsyst wfd_cs_id System ID
last_modified wfd_last_modified Last Modified At
block_ind 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.

-- Workforce Person Photo URL
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_PHOTO (
    CLIENT,              -- Client [mandt]
    WORKER_ID,           -- Worker ID [wfd_worker_id]
    IMAGE_TYPECODE,      -- Photo Type [wfd_image_type]
    WORKER_IMAGE_URL,    -- Photo URL [wfd_worker_image_url]
    IMAGE_URI_INTERNAL,  -- Image URI(Internal) [wfd_image_uri_internal]
    COMMSYST,            -- System ID [wfd_cs_id]
    LAST_MODIFIED,       -- Last Modified At [wfd_last_modified]
    BLOCK_IND,           -- Blocked Indicator [wfd_blocked]
    PRIMARY KEY (CLIENT, WORKER_ID, IMAGE_TYPECODE)
);

Learn More