DPR_PRO_TYPE

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)
);