C_ProjectObjectVersionTP

DDL: C_PROJECTOBJECTVERSIONTP Type: view_entity CONSUMPTION
72 Fields 1 Data Sources

Project Object Version

C_ProjectObjectVersionTP is a Consumption CDS View that provides data about "Project Object Version" in SAP S/4HANA. It reads from 1 data source (R_ProjectObjectVersionTP) and exposes 72 fields with key fields ProjectObjectNode, ProjectObjectNodeType, Version.

Data Sources (1)

SourceAliasJoin Type
R_ProjectObjectVersionTP R_ProjectObjectVersionTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Object Version view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY ProjectObjectNode ProjectObjectNode Object number
KEY ProjectObjectNodeType ProjectObjectNodeType Object Type in PS
KEY Version Version XML Vers.
ProjectObjectExternalID ProjectObjectExternalID ID
ProjectObject ProjectObject Object
ProjectObjectDescription ProjectObjectDescription Name
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID NetworkActivityInternalID Counter
ProjectNetwork ProjectNetwork Order
NetworkActivity NetworkActivity Operation/Activity
BasicStartDate BasicStartDate Basic Start Date
BasicEndDate BasicEndDate Basic Finish Date
SchedldBasicEarliestStartDate SchedldBasicEarliestStartDate Basic Earliest Start Date
SchedldBasicEarliestEndDate SchedldBasicEarliestEndDate Basic Earliest Finish Date
SchedldBasicLatestStartDate SchedldBasicLatestStartDate Basic Latest Start Date
ScheduledBasicLatestEndDate ScheduledBasicLatestEndDate Basic Latest Finish Date
SchedldFcstdEarliestStartDate SchedldFcstdEarliestStartDate Forecast Earliest Start Date
SchedldFcstdEarliestEndDate SchedldFcstdEarliestEndDate Forecast Earliest Finish Date
LatestSchedldFcstdStartDate LatestSchedldFcstdStartDate Forecast Latest Start Date
LatestSchedldFcstdEndDate LatestSchedldFcstdEndDate Forecast Latest Finish Date
ActualStartDate ActualStartDate Actual Start Date
ActualEndDate ActualEndDate Actual Finish Date
StandardDuration StandardDuration Planned Duration
StandardDurationUnit StandardDurationUnit
ActualDuration ActualDuration Actual Duration
ActualDurationCalc ActualDurationCalc
ActualDurationUnit ActualDurationUnit
PlannedWorkQuantity PlannedWorkQuantity Planned Work
ActualWorkQuantity ActualWorkQuantity Actual Work
NtwkActivityWorkQuantityUnit NtwkActivityWorkQuantityUnit
FreeDefinedAttribute01 FreeDefinedAttribute01 Generic Field 1
FreeDefinedAttribute02 FreeDefinedAttribute02 Generic Field 2
FreeDefinedAttribute03 FreeDefinedAttribute03 Generic Field 3
FreeDefinedAttribute04 FreeDefinedAttribute04 Generic Field 4
FreeDefinedQuantity1 FreeDefinedQuantity1 Numeric Field 1
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit
FreeDefinedQuantity2 FreeDefinedQuantity2 Numeric Field 2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit
FreeDefinedAmount1 FreeDefinedAmount1 Numeric Field 3
FreeDefinedAmount1Currency FreeDefinedAmount1Currency
FreeDefinedAmount2 FreeDefinedAmount2 Numeric Field 4
FreeDefinedAmount2Currency FreeDefinedAmount2Currency
FreeDefinedDate1 FreeDefinedDate1 Date Field 1
FreeDefinedDate2 FreeDefinedDate2 Date Field 2
FreeDefinedIndicator1 FreeDefinedIndicator1 Indicator 1
FreeDefinedIndicator2 FreeDefinedIndicator2 Indicator 2
WorkCenter WorkCenter Work Center
PriorityCode PriorityCode Priority
WBSElementHierarchyLevel WBSElementHierarchyLevel
Currency Currency Valuation Crcy
NetworkActivityObjectCurrency NetworkActivityObjectCurrency
TotalFloatForBasicDates TotalFloatForBasicDates
BasicDatesFreeFloat BasicDatesFreeFloat
Plant Plant Valuation Area
CompanyCode CompanyCode Receiver Company Code
ApplicantCode ApplicantCode
WBSElementIsPlanningElement WBSElementIsPlanningElement Planning Element
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement Account Assignment Element
WBSElementIsBillingElement WBSElementIsBillingElement Billing Element
NetworkActivityControlProfile NetworkActivityControlProfile Control Key
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays Planned Delivery Time
ProjectType ProjectType Project Type
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
ResponsiblePerson ResponsiblePerson Responsible Person ID
ResponsiblePersonName ResponsiblePersonName Responsible Person
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
NumberOfAssignedMaterials NumberOfAssignedMaterials Materials
FactoryCalendar FactoryCalendar Factory Calendar
ActualExecutionStartTime ActualExecutionStartTime
ActualExecutionEndTime ActualExecutionEndTime

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 C_ProjectObjectVersionTP.
-- 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 C_ProjectObjectVersionTP AS
SELECT
  ProjectObjectNode,
  ProjectObjectNodeType,
  Version,
  ProjectObjectExternalID,
  ProjectObject,
  ProjectObjectDescription,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  ProjectNetwork,
  NetworkActivity,
  BasicStartDate,
  BasicEndDate,
  SchedldBasicEarliestStartDate,
  SchedldBasicEarliestEndDate,
  SchedldBasicLatestStartDate,
  ScheduledBasicLatestEndDate,
  SchedldFcstdEarliestStartDate,
  SchedldFcstdEarliestEndDate,
  LatestSchedldFcstdStartDate,
  LatestSchedldFcstdEndDate,
  ActualStartDate,
  ActualEndDate,
  StandardDuration,
  StandardDurationUnit,
  ActualDuration,
  ActualDurationCalc,
  ActualDurationUnit,
  PlannedWorkQuantity,
  ActualWorkQuantity,
  NtwkActivityWorkQuantityUnit,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedQuantity1,
  FreeDefinedQuantity1Unit,
  FreeDefinedQuantity2,
  FreeDefinedQuantity2Unit,
  FreeDefinedAmount1,
  FreeDefinedAmount1Currency,
  FreeDefinedAmount2,
  FreeDefinedAmount2Currency,
  FreeDefinedDate1,
  FreeDefinedDate2,
  FreeDefinedIndicator1,
  FreeDefinedIndicator2,
  WorkCenter,
  PriorityCode,
  WBSElementHierarchyLevel,
  Currency,
  NetworkActivityObjectCurrency,
  TotalFloatForBasicDates,
  BasicDatesFreeFloat,
  Plant,
  CompanyCode,
  ApplicantCode,
  WBSElementIsPlanningElement,
  WBSIsAccountAssignmentElement,
  WBSElementIsBillingElement,
  NetworkActivityControlProfile,
  PlannedDeliveryDurationInDays,
  ProjectType,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  ResponsiblePerson,
  ResponsiblePersonName,
  ResponsibleCostCenter,
  NumberOfAssignedMaterials,
  FactoryCalendar,
  ActualExecutionStartTime,
  ActualExecutionEndTime
FROM R_ProjectObjectVersionTP
;

Learn More