ENTPROJ_D

Transparent Table Application Table
64 Fields 2 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 64 fields. 2 CDS views read from this table.

CDS Views using this table (2)

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

Fields (64)

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/TV_EXTERNAL_ID Number
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 PS_S4_WAERS Custom Project Curr
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
entprojdemandcopyisrequested BOOLE_D TRUE
entprojsettlmtrulecpyisreqd BOOLE_D TRUE
entprojhasprojectstockenabled PS_BESTAND Project stock
entprojectsettlementtype PS_SETTLEMENTTYPE Settlement Type
entprojectsettlementelement PS_SETTLEMENTELEMENT settlementElement
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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_project_incl_eew_ps /S4PPM/TV_INCL_EEW Dummy

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,                        -- Number [/S4PPM/TV_EXTERNAL_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,                -- Custom Project Curr [PS_S4_WAERS]
    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]
    ENTPROJDEMANDCOPYISREQUESTED,   -- TRUE [BOOLE_D]
    ENTPROJSETTLMTRULECPYISREQD,    -- TRUE [BOOLE_D]
    ENTPROJHASPROJECTSTOCKENABLED,  -- Project stock [PS_BESTAND]
    ENTPROJECTSETTLEMENTTYPE,       -- Settlement Type [PS_SETTLEMENTTYPE]
    ENTPROJECTSETTLEMENTELEMENT,    -- settlementElement [PS_SETTLEMENTELEMENT]
    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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_PROJECT_INCL_EEW_PS,      -- Dummy [/S4PPM/TV_INCL_EEW]
    PRIMARY KEY (MANDT, PROJECTUUID)
);

Learn More