DPR_PRO_TYPE

Transparent Table Customizing (protected)
52 Fields 3 CDS Views

Project Type

DPR_PRO_TYPE is an SAP database table in S/4HANA. Project Type. It contains 52 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_DevelopmentProjectType view_entity from BASIC Development Project Type
I_EnterpriseProjectType view from BASIC Internal Project Type
I_PPM_ProjectType view from BASIC Project Type

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY pro_type DPR_TV_PRO_TYPE Proj. Type
pro_category DPR_TV_PRO_CATEGORY Proj. Category
repl_allowed DPR_TV_FIN_INT_SCENARIO Acct. Intgrtn Scen.
repl_kind DPR_TV_REPLICATION_KIND Transfer Type
default_unit DPR_TV_UNIT Unit
use_documents DPR_TV_USE_DOCUMENTS Documents
use_colls DPR_TV_USE_COLLABORATIONS cFolders
use_object_links DPR_TV_USE_OBJECT_LINKS Object Links
use_ctrl_plans DPR_TV_USE_CONTROL_PLANS Control Plans
use_checklists DPR_TV_USE_CHECKLISTS Checklists
use_tasks DPR_TV_USE_TASKS Tasks
use_subtasks DPR_TV_USE_SUBTASKS Task Hierarchy
use_res_search DPR_TV_USE_RESOURCE_SEARCH Resource Search
use_res_assignmt DPR_TV_USE_RESOURCE_ASSIGNMENT Obsolete
use_subprojects DPR_TV_USE_SUBPROJECTS Subprojects
use_mirrored DPR_TV_USE_MIRRORED Mirrored Tasks
conf_cats DPR_TV_CONF_CATS Time CATS/SRM Tr FIN
conf_proj_elem DPR_TV_CONF_PROJ_ELEM Time Recording for
conf_proj_def DPR_TV_CONF_PROJ_DEF TimeRecord.Proj.Def.
use_stat_reports DPR_TV_USE_STATUS_REPORTS Status Reports
r3dms_stat_rep DPR_TV_USE_R3DMS_STATUS_REPS StatusReport SAP DMS
thld_check DPR_TV_THLD_CHECK Check
thld_aggregate DPR_TV_THLD_AGGREGATE Aggregate
use_versions DPR_TV_USE_VERSIONS Versions
use_appr_cert DPR_TV_SIGN_PHASE_CERTIFICATE Signature Certif.
use_r3dms_doc DPR_TV_USE_R3DMS_DOCUMENTS Documents in SAP DMS
use_skills DPR_TV_USE_SKILLS Qualifications
schedule_type DPR_TV_SCHEDULE_TYPE Scheduling Type
field_control DPR_TV_FC Field Control
use_phases DPR_TV_USE_PHASES Phases
cl_below_tsk DPR_TV_CL_BELOW_TSK Checkl.f.Tasks
tsk_cl_proj_def DPR_TV_TSK_CL_PROJECT_DEF Tsks/Chckl.f.ProjDef
use_dashboard DPR_TV_USE_DASHBOARD Use Dashboard
use_croom DPR_TV_USE_CROOM Virtual Rooms
use_srm DPR_TV_SRM_INTEGRATION Shopping in SRM
active DPR_TV_PRO_TYPE_ACTIVE Activate Proj.Type
use_project_char DPR_TV_USE_PROJECT_CHARTER Project Charter
use_xrpm DPR_TV_USE_XRPM Portf. Mgmt
proj_integ_type DPR_TRA_PROJ_INTEG_TYPE Proj Type
imp_actual DPR_TRA_IMPORT_ACTUAL Import Actual
acc2forecasted DPR_TV_FORECASTED_DATES_ACCESS Forecasted Dates
vrsn_header_int DPR_TV_INT_VRSN_HEADER_NR Version Header Sel.
use_mta DPR_TV_USE_MTA Milest.Trend Analys.
set_user_auth DPR_TV_SET_USER_AUTH Set dist. user auth.
include_roles_only DPR_TV_INCLUDE_ROLES_ONLY Incl. Only
data_aggregate DPR_TV_DATA_AGGREGATE Aggregate Data
evaluation_view EVE_TV_VIEW Evaluation Layout
profidproj PROFIDPROJ Project Profile
obl_projdef DPR_TV_OBL_TYPE Object Type
obl_rootwbs DPR_TV_OBL_TYPE Object Type
risk_profile_id /CPD/RM_PROFILE_ID Risk Profile 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.

-- Project Type
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPR_PRO_TYPE (
    CLIENT,              -- Client [MANDT]
    PRO_TYPE,            -- Proj. Type [DPR_TV_PRO_TYPE]
    PRO_CATEGORY,        -- Proj. Category [DPR_TV_PRO_CATEGORY]
    REPL_ALLOWED,        -- Acct. Intgrtn Scen. [DPR_TV_FIN_INT_SCENARIO]
    REPL_KIND,           -- Transfer Type [DPR_TV_REPLICATION_KIND]
    DEFAULT_UNIT,        -- Unit [DPR_TV_UNIT]
    USE_DOCUMENTS,       -- Documents [DPR_TV_USE_DOCUMENTS]
    USE_COLLS,           -- cFolders [DPR_TV_USE_COLLABORATIONS]
    USE_OBJECT_LINKS,    -- Object Links [DPR_TV_USE_OBJECT_LINKS]
    USE_CTRL_PLANS,      -- Control Plans [DPR_TV_USE_CONTROL_PLANS]
    USE_CHECKLISTS,      -- Checklists [DPR_TV_USE_CHECKLISTS]
    USE_TASKS,           -- Tasks [DPR_TV_USE_TASKS]
    USE_SUBTASKS,        -- Task Hierarchy [DPR_TV_USE_SUBTASKS]
    USE_RES_SEARCH,      -- Resource Search [DPR_TV_USE_RESOURCE_SEARCH]
    USE_RES_ASSIGNMT,    -- Obsolete [DPR_TV_USE_RESOURCE_ASSIGNMENT]
    USE_SUBPROJECTS,     -- Subprojects [DPR_TV_USE_SUBPROJECTS]
    USE_MIRRORED,        -- Mirrored Tasks [DPR_TV_USE_MIRRORED]
    CONF_CATS,           -- Time CATS/SRM Tr FIN [DPR_TV_CONF_CATS]
    CONF_PROJ_ELEM,      -- Time Recording for [DPR_TV_CONF_PROJ_ELEM]
    CONF_PROJ_DEF,       -- TimeRecord.Proj.Def. [DPR_TV_CONF_PROJ_DEF]
    USE_STAT_REPORTS,    -- Status Reports [DPR_TV_USE_STATUS_REPORTS]
    R3DMS_STAT_REP,      -- StatusReport SAP DMS [DPR_TV_USE_R3DMS_STATUS_REPS]
    THLD_CHECK,          -- Check [DPR_TV_THLD_CHECK]
    THLD_AGGREGATE,      -- Aggregate [DPR_TV_THLD_AGGREGATE]
    USE_VERSIONS,        -- Versions [DPR_TV_USE_VERSIONS]
    USE_APPR_CERT,       -- Signature Certif. [DPR_TV_SIGN_PHASE_CERTIFICATE]
    USE_R3DMS_DOC,       -- Documents in SAP DMS [DPR_TV_USE_R3DMS_DOCUMENTS]
    USE_SKILLS,          -- Qualifications [DPR_TV_USE_SKILLS]
    SCHEDULE_TYPE,       -- Scheduling Type [DPR_TV_SCHEDULE_TYPE]
    FIELD_CONTROL,       -- Field Control [DPR_TV_FC]
    USE_PHASES,          -- Phases [DPR_TV_USE_PHASES]
    CL_BELOW_TSK,        -- Checkl.f.Tasks [DPR_TV_CL_BELOW_TSK]
    TSK_CL_PROJ_DEF,     -- Tsks/Chckl.f.ProjDef [DPR_TV_TSK_CL_PROJECT_DEF]
    USE_DASHBOARD,       -- Use Dashboard [DPR_TV_USE_DASHBOARD]
    USE_CROOM,           -- Virtual Rooms [DPR_TV_USE_CROOM]
    USE_SRM,             -- Shopping in SRM [DPR_TV_SRM_INTEGRATION]
    ACTIVE,              -- Activate Proj.Type [DPR_TV_PRO_TYPE_ACTIVE]
    USE_PROJECT_CHAR,    -- Project Charter [DPR_TV_USE_PROJECT_CHARTER]
    USE_XRPM,            -- Portf. Mgmt [DPR_TV_USE_XRPM]
    PROJ_INTEG_TYPE,     -- Proj Type [DPR_TRA_PROJ_INTEG_TYPE]
    IMP_ACTUAL,          -- Import Actual [DPR_TRA_IMPORT_ACTUAL]
    ACC2FORECASTED,      -- Forecasted Dates [DPR_TV_FORECASTED_DATES_ACCESS]
    VRSN_HEADER_INT,     -- Version Header Sel. [DPR_TV_INT_VRSN_HEADER_NR]
    USE_MTA,             -- Milest.Trend Analys. [DPR_TV_USE_MTA]
    SET_USER_AUTH,       -- Set dist. user auth. [DPR_TV_SET_USER_AUTH]
    INCLUDE_ROLES_ONLY,  -- Incl. Only [DPR_TV_INCLUDE_ROLES_ONLY]
    DATA_AGGREGATE,      -- Aggregate Data [DPR_TV_DATA_AGGREGATE]
    EVALUATION_VIEW,     -- Evaluation Layout [EVE_TV_VIEW]
    PROFIDPROJ,          -- Project Profile [PROFIDPROJ]
    OBL_PROJDEF,         -- Object Type [DPR_TV_OBL_TYPE]
    OBL_ROOTWBS,         -- Object Type [DPR_TV_OBL_TYPE]
    RISK_PROFILE_ID,     -- Risk Profile ID [/CPD/RM_PROFILE_ID]
    PRIMARY KEY (CLIENT, PRO_TYPE)
);

Learn More