ENTPROJ_D

Transparent Table Application Table
59 Fields 3 CDS Views

Draft table for entity I_ENTERPRISEPROJECTTP_2

ENTPROJ_D is an SAP database table in S/4HANA. Draft table for entity I_ENTERPRISEPROJECTTP_2. It contains 59 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CommercialProjectDraft view_entity from EXTENSION Commercial Project - Extension
E_EnterpriseProjectDraft view_entity from EXTENSION Enterprise Project - Extension
R_EnterpriseProjectDraft view_entity from BASIC Enterprise Project Draft

Fields (59)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY projectuuid /s4ppm/tv_entity_guid Entity GUID
projectsummarytaskuuid /s4ppm/tv_entity_guid Entity GUID
projectinternalid ps_s4_proj_pspnr Project Def.
project /s4ppm/project_id Project ID
projectcategory dpr_tv_pro_category Proj. Category
projectdescription /s4ppm/tv_name Name
enterpriseprojecttype ps_prart Proj.type
prioritycode /s4ppm/tv_priority Priority
projectstartdate /s4ppm/tv_ltst_start_date Latest Planned Start
projectenddate /s4ppm/tv_ltst_end_date Ltst Planned Finish
actualstartdate /s4ppm/tv_act_start_date Actual Start
actualenddate /s4ppm/tv_act_end_date Actual Finish
customeruuid bu_partner_guid BP GUID
enterpriseprojectserviceorg /s4ppm/pws_ws_org_unit_id Service Org.
entprojectisconfidential /s4ppm/tv_project_confidential Confidential
restrictedtimeposting /s4ppm/restrict_time_posting Restrict Unstaffed
processingstatus dpr_tv_proc_status_own Proc. Status
responsiblecostcenter ps_fkstl Resp. cost cntr
profitcenter prctr Profit Center
projectprofilecode profidproj Project Profile
functionalarea fkber Functional Area
companycode ps_vbukr Company code
controllingarea ps_vkokr CO area
plant werks_d Plant
location ps_stort Location
taxjurisdiction txjcd Tax Jur.
projectcurrency /s4ppm/tv_project_currency
availabilitycontrolprofile fco_avc_profile Availy Ctrl Prfl
availabilitycontrolisactive ps_s4_avc_ind AVC is Active
functionallocation tplnr Functional loc.
investmentprofile im_profil Invest. Profile
isbillingrelevant ps_fakkz Billing elem.
lastchangedatetime /s4ppm/tv_changed_on Changed On
lastchangedbyuser /s4ppm/tv_changed_by Changed By
projectlastchangeddatetime /s4ppm/tv_proj_changed_on Changed on
projectlastchangedbyuser dpr_tv_last_changed_by Changed by
entprojismultislsorditmsenbld /s4ppm/tv_multi_soi_enabled Project Assigned
entprojprofitabilitysegment /s4ppm/tv_profitabilitysegment
entprojdemandcopyisrequested boole_d TRUE
entprojsettlmtrulecpyisreqd boole_d TRUE
entprojhasprojectstockenabled ps_bestand Project stock
entprojectsettlementtype ps_settlementtype Settlement Type
entprojectsettlementelement ps_settlementelement settlementElement
inventoryspecialstockvalntype /s4ppm/tv_kzbws
createdbyuser /s4ppm/tv_created_by Created By
creationdatetime /s4ppm/tv_created_on Created On
leadingsalesorder vbeln_va Sales Document
leadingsalesorderitem posnr_va Item
resultanalysisinternalid abgr_schl RA Key
wbselementinternalid ps_s4_pspnr WBS Internal ID
factorycalendar stkal Calendar
wbselementobject j_objnr Object number
projectobject j_objnr Object number
costingsheet aufkalsm Costing Sheet
costcenter ps_kostl CCtr posted
isstatistical ps_xstat Statistical
projecttemplateuuid /s4ppm/tv_entity_guid Entity GUID
projectmanager bu_partner Busn. Partner

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 I_ENTERPRISEPROJECTTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ENTPROJ_D (
    MANDT,                          -- Client [mandt]
    PROJECTUUID,                    -- Entity GUID [/s4ppm/tv_entity_guid]
    PROJECTSUMMARYTASKUUID,         -- Entity GUID [/s4ppm/tv_entity_guid]
    PROJECTINTERNALID,              -- Project Def. [ps_s4_proj_pspnr]
    PROJECT,                        -- Project ID [/s4ppm/project_id]
    PROJECTCATEGORY,                -- Proj. Category [dpr_tv_pro_category]
    PROJECTDESCRIPTION,             -- Name [/s4ppm/tv_name]
    ENTERPRISEPROJECTTYPE,          -- Proj.type [ps_prart]
    PRIORITYCODE,                   -- Priority [/s4ppm/tv_priority]
    PROJECTSTARTDATE,               -- Latest Planned Start [/s4ppm/tv_ltst_start_date]
    PROJECTENDDATE,                 -- Ltst Planned Finish [/s4ppm/tv_ltst_end_date]
    ACTUALSTARTDATE,                -- Actual Start [/s4ppm/tv_act_start_date]
    ACTUALENDDATE,                  -- Actual Finish [/s4ppm/tv_act_end_date]
    CUSTOMERUUID,                   -- BP GUID [bu_partner_guid]
    ENTERPRISEPROJECTSERVICEORG,    -- Service Org. [/s4ppm/pws_ws_org_unit_id]
    ENTPROJECTISCONFIDENTIAL,       -- Confidential [/s4ppm/tv_project_confidential]
    RESTRICTEDTIMEPOSTING,          -- Restrict Unstaffed [/s4ppm/restrict_time_posting]
    PROCESSINGSTATUS,               -- Proc. Status [dpr_tv_proc_status_own]
    RESPONSIBLECOSTCENTER,          -- Resp. cost cntr [ps_fkstl]
    PROFITCENTER,                   -- Profit Center [prctr]
    PROJECTPROFILECODE,             -- Project Profile [profidproj]
    FUNCTIONALAREA,                 -- Functional Area [fkber]
    COMPANYCODE,                    -- Company code [ps_vbukr]
    CONTROLLINGAREA,                -- CO area [ps_vkokr]
    PLANT,                          -- Plant [werks_d]
    LOCATION,                       -- Location [ps_stort]
    TAXJURISDICTION,                -- Tax Jur. [txjcd]
    PROJECTCURRENCY,                -- /s4ppm/tv_project_currency
    AVAILABILITYCONTROLPROFILE,     -- Availy Ctrl Prfl [fco_avc_profile]
    AVAILABILITYCONTROLISACTIVE,    -- AVC is Active [ps_s4_avc_ind]
    FUNCTIONALLOCATION,             -- Functional loc. [tplnr]
    INVESTMENTPROFILE,              -- Invest. Profile [im_profil]
    ISBILLINGRELEVANT,              -- Billing elem. [ps_fakkz]
    LASTCHANGEDATETIME,             -- Changed On [/s4ppm/tv_changed_on]
    LASTCHANGEDBYUSER,              -- Changed By [/s4ppm/tv_changed_by]
    PROJECTLASTCHANGEDDATETIME,     -- Changed on [/s4ppm/tv_proj_changed_on]
    PROJECTLASTCHANGEDBYUSER,       -- Changed by [dpr_tv_last_changed_by]
    ENTPROJISMULTISLSORDITMSENBLD,  -- Project Assigned [/s4ppm/tv_multi_soi_enabled]
    ENTPROJPROFITABILITYSEGMENT,    -- /s4ppm/tv_profitabilitysegment
    ENTPROJDEMANDCOPYISREQUESTED,   -- TRUE [boole_d]
    ENTPROJSETTLMTRULECPYISREQD,    -- TRUE [boole_d]
    ENTPROJHASPROJECTSTOCKENABLED,  -- Project stock [ps_bestand]
    ENTPROJECTSETTLEMENTTYPE,       -- Settlement Type [ps_settlementtype]
    ENTPROJECTSETTLEMENTELEMENT,    -- settlementElement [ps_settlementelement]
    INVENTORYSPECIALSTOCKVALNTYPE,  -- /s4ppm/tv_kzbws
    CREATEDBYUSER,                  -- Created By [/s4ppm/tv_created_by]
    CREATIONDATETIME,               -- Created On [/s4ppm/tv_created_on]
    LEADINGSALESORDER,              -- Sales Document [vbeln_va]
    LEADINGSALESORDERITEM,          -- Item [posnr_va]
    RESULTANALYSISINTERNALID,       -- RA Key [abgr_schl]
    WBSELEMENTINTERNALID,           -- WBS Internal ID [ps_s4_pspnr]
    FACTORYCALENDAR,                -- Calendar [stkal]
    WBSELEMENTOBJECT,               -- Object number [j_objnr]
    PROJECTOBJECT,                  -- Object number [j_objnr]
    COSTINGSHEET,                   -- Costing Sheet [aufkalsm]
    COSTCENTER,                     -- CCtr posted [ps_kostl]
    ISSTATISTICAL,                  -- Statistical [ps_xstat]
    PROJECTTEMPLATEUUID,            -- Entity GUID [/s4ppm/tv_entity_guid]
    PROJECTMANAGER,                 -- Busn. Partner [bu_partner]
    PRIMARY KEY (MANDT, PROJECTUUID)
);

Learn More