ENTPROJROLESTF_D

Transparent Table Application Table
12 Fields 1 CDS Views

Draft table for entity R_ENTPROJTEAMROLESTAFFINTTP

ENTPROJROLESTF_D is an SAP database table in S/4HANA. Draft table for entity R_ENTPROJTEAMROLESTAFFINTTP. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_EntProjRoleStaffDraft view_entity from BASIC Enterprise Project Role staffing - Draft

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY projectentitlementuuid /s4ppm/tv_entitlmnt_guid Entitlement
projectuuid /s4ppm/tv_project_guid Project
projectroleuuid /s4ppm/tv_role_guid Role
teammemberuuid /s4ppm/tv_team_member_guid Team Member
projectroletype /s4ppm/tv_role_type Role Type
businesspartneruuid bu_partner_guid BP GUID
businesspartner bu_partner Busn. Partner
createdbyuser /s4ppm/tv_created_by Created By
creationdatetime /s4ppm/tv_created_on Created On
lastchangedbyuser /s4ppm/tv_changed_by Changed By
lastchangedatetime /s4ppm/tv_changed_on Changed On

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_ENTPROJTEAMROLESTAFFINTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ENTPROJROLESTF_D (
    MANDT,                   -- Client [mandt]
    PROJECTENTITLEMENTUUID,  -- Entitlement [/s4ppm/tv_entitlmnt_guid]
    PROJECTUUID,             -- Project [/s4ppm/tv_project_guid]
    PROJECTROLEUUID,         -- Role [/s4ppm/tv_role_guid]
    TEAMMEMBERUUID,          -- Team Member [/s4ppm/tv_team_member_guid]
    PROJECTROLETYPE,         -- Role Type [/s4ppm/tv_role_type]
    BUSINESSPARTNERUUID,     -- BP GUID [bu_partner_guid]
    BUSINESSPARTNER,         -- Busn. Partner [bu_partner]
    CREATEDBYUSER,           -- Created By [/s4ppm/tv_created_by]
    CREATIONDATETIME,        -- Created On [/s4ppm/tv_created_on]
    LASTCHANGEDBYUSER,       -- Changed By [/s4ppm/tv_changed_by]
    LASTCHANGEDATETIME,      -- Changed On [/s4ppm/tv_changed_on]
    PRIMARY KEY (MANDT, PROJECTENTITLEMENTUUID)
);

Learn More