R_EnterpriseProjectDraft

DDL: R_ENTERPRISEPROJECTDRAFT Type: view_entity BASIC
63 Fields 1 Data Sources 2 Associations

Enterprise Project Draft

R_EnterpriseProjectDraft is a Basic CDS View that provides data about "Enterprise Project Draft" in SAP S/4HANA. It reads from 1 data source (entproj_d) and exposes 63 fields with key field ProjectUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
entproj_d EnterpriseProjectDraft from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_EnterpriseProject _Project $projection.ProjectUUID = _Project.ProjectUUID ---Extension
[1..1] E_EnterpriseProjectDraft _ProjectExtension $projection.ProjectUUID = _ProjectExtension.ProjectUUID

Annotations (14)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.dataMaintenance #RESTRICTED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix PPH view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 2040 view
EndUserText.label Enterprise Project Draft view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID projectuuid Project UUID
ProjectSummaryTaskUUID projectsummarytaskuuid Entity GUID
ProjectInternalID projectinternalid Project Def.
Project project WBS Element
ProjectCategory projectcategory Proj. Category
ProjectDescription projectdescription Project Name
EnterpriseProjectType enterpriseprojecttype Proj.type
PriorityCode prioritycode Priority
ProjectStartDate projectstartdate Latest Planned Start
ProjectEndDate projectenddate Ltst Planned Finish
ActualStartDate actualstartdate Actual Start
ActualEndDate actualenddate Actual Finish
CustomerUUID customeruuid NodeID
EnterpriseProjectServiceOrg enterpriseprojectserviceorg Service Org.
EntProjectIsConfidential entprojectisconfidential Confidential
RestrictedTimePosting restrictedtimeposting Restrict Unstaffed
ProcessingStatus processingstatus Worklist Status
ResponsibleCostCenter responsiblecostcenter Responsible Cost Center
ProfitCenter profitcenter Profit Center
ProjectProfileCode projectprofilecode Project Profile
FunctionalArea functionalarea Sendr Fctl Area
CompanyCode companycode Receiver Company Code
ControllingArea controllingarea Controlling Area
Plant plant Valuation Area
Location location Text
TaxJurisdiction taxjurisdiction Tax Jurisdiction
ProjectCurrency projectcurrency Project Currency
AvailabilityControlProfile availabilitycontrolprofile Budget Availability Control Profile
AvailabilityControlIsActive availabilitycontrolisactive Budget Availability Control is Active
FunctionalLocation functionallocation Object ID
InvestmentProfile investmentprofile Investment Measure Profile
IsBillingRelevant isbillingrelevant Billing elem.
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
ProjectLastChangedDateTime projectlastchangeddatetime Time Stamp
ProjectLastChangedByUser projectlastchangedbyuser Changed by
EntProjIsMultiSlsOrdItmsEnbld entprojismultislsorditmsenbld Project Assigned
EntProjDemandCopyIsRequested entprojdemandcopyisrequested TRUE
EntProjSettlmtRuleCpyIsReqd entprojsettlmtrulecpyisreqd TRUE
EntProjHasProjectStockEnabled entprojhasprojectstockenabled Project stock
EntProjectSettlementType entprojectsettlementtype Settlement Type
EntProjectSettlementElement entprojectsettlementelement settlementElement
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LeadingSalesOrder leadingsalesorder Sales Document
LeadingSalesOrderItem leadingsalesorderitem Item
ResultAnalysisInternalID resultanalysisinternalid Results Analysis Key
WBSElementInternalID wbselementinternalid WBS Internal ID
FactoryCalendar factorycalendar Factory Calendar
WBSElementObject wbselementobject Object number
ProjectObject projectobject Object number
CostingSheet costingsheet Costing Sheet
CostCenter costcenter Cost Center
IsStatistical isstatistical Statistical
ProjectTemplateUUID projecttemplateuuid Entity GUID
ProjectManager projectmanager Busn. Partner
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftFieldChanges draftfieldchanges Field Changes
HasActiveEntity hasactiveentity TRUE
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
_Project _Project

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_EnterpriseProjectDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_EnterpriseProjectDraft AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjectInternalID,
  Project,
  ProjectCategory,
  ProjectDescription,
  EnterpriseProjectType,
  PriorityCode,
  ProjectStartDate,
  ProjectEndDate,
  ActualStartDate,
  ActualEndDate,
  CustomerUUID,
  EnterpriseProjectServiceOrg,
  EntProjectIsConfidential,
  RestrictedTimePosting,
  ProcessingStatus,
  ResponsibleCostCenter,
  ProfitCenter,
  ProjectProfileCode,
  FunctionalArea,
  CompanyCode,
  ControllingArea,
  Plant,
  Location,
  TaxJurisdiction,
  ProjectCurrency,
  AvailabilityControlProfile,
  AvailabilityControlIsActive,
  FunctionalLocation,
  InvestmentProfile,
  IsBillingRelevant,
  LastChangeDateTime,
  LastChangedByUser,
  ProjectLastChangedDateTime,
  ProjectLastChangedByUser,
  EntProjIsMultiSlsOrdItmsEnbld,
  EntProjDemandCopyIsRequested,
  EntProjSettlmtRuleCpyIsReqd,
  EntProjHasProjectStockEnabled,
  EntProjectSettlementType,
  EntProjectSettlementElement,
  CreatedByUser,
  CreationDateTime,
  LeadingSalesOrder,
  LeadingSalesOrderItem,
  ResultAnalysisInternalID,
  WBSElementInternalID,
  FactoryCalendar,
  WBSElementObject,
  ProjectObject,
  CostingSheet,
  CostCenter,
  IsStatistical,
  ProjectTemplateUUID,
  ProjectManager,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftFieldChanges,
  HasActiveEntity,
  DraftEntityOperationCode
FROM entproj_d AS EnterpriseProjectDraft
LEFT OUTER JOIN R_EnterpriseProject AS _Project ON ProjectUUID = _Project.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN E_EnterpriseProjectDraft AS _ProjectExtension ON ProjectUUID = _ProjectExtension.ProjectUUID  -- association [1..1]
;

Learn More