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