R_ProjectNetworkTP

DDL: R_PROJECTNETWORKTP Type: view_entity TRANSACTIONAL
81 Fields 1 Data Sources 3 Associations

Project Network Data - TP

R_ProjectNetworkTP is a Transactional CDS View that provides data about "Project Network Data - TP" in SAP S/4HANA. It reads from 1 data source (I_ProjectNetworkBasicData) and exposes 81 fields with key field ProjectNetwork. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectNetworkBasicData I_ProjectNetworkBasicData from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_LogisticsOrder _Extension $projection.ProjectNetwork = _Extension.OrderID
[0..1] R_WBSElementTP_2 _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
[0..*] R_ProjectNetworkActivityTP _ProjectNetworkActivity

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Network Data - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ProjectNetwork view
ObjectModel.sapObjectNodeType.name ProjectNetwork view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view

Fields (81)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork ProjectNetwork Order
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
ProjectNetworkDescription ProjectNetworkDescription Network Name
ProjectNetworkType ProjectNetworkType Sales Doc. Type
ProjNtwkLangBsdDescription _NetworkShortText LanguageBasedShortText Network Description
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ScheduledReleaseDate ScheduledReleaseDate
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledFcstdReleaseDate ScheduledFcstdReleaseDate Release
ActualReleasedDate ActualReleasedDate Actual release
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
BasicSchedulingType BasicSchedulingType Scheduling type
BasicSchedulingReductionLevel BasicSchedulingReductionLevel Reduction Ind.
FcstSchedulingReductionLevel FcstSchedulingReductionLevel Reduction ind.
OrdIsNotSchedldAutomatically OrdIsNotSchedldAutomatically No auto. cost.
CapacityRqmtHasNotToBeCreated CapacityRqmtHasNotToBeCreated No Cap. Reqmts.
SchedulingIsAllowingForBreaks SchedulingIsAllowingForBreaks Exact breaks
ProjectInternalID ProjectInternalID Project Def.
ProjectExternalIDendasProjectExternalID
WBSElementInternalID WBSElementInternalID WBS Internal ID
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
SuperiorProjectNetwork SuperiorProjectNetwork Subnetwork of
SuperiorProjectNetworkIntID SuperiorProjectNetworkIntID Plan No.f.Oper.
SuperiorNtwkActivityInternalID SuperiorNtwkActivityInternalID Counter
SuperiorNtwkActivityExternalID _NetworkActivityByInternalKey NetworkActivity Operation/Activity
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
ControllingObjectClass ControllingObjectClass Object Class
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
Currency Currency Valuation Crcy
ResponsiblePlannerGroup ResponsiblePlannerGroup Prodn Supervisor
ChangeNumber ChangeNumber Change Number
JointVenture JointVenture Joint venture
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureObjectType JointVentureObjectType JV Object Type
JointVentureClass JointVentureClass JIB/JIBE Class
JointVentureSubClass JointVentureSubClass JIB/JIBE SbClsA
JointVentureOriginalCostObject JointVentureOriginalCostObject Or. Cost Obj.
NetworkProfile NetworkProfile PP/DS Alert Pr.
Plant Plant Valuation Area
MRPController MRPController MRP Controller
PriorityCode PriorityCode Priority
BaseUnit BaseUnit Unit of Measure
PlannedTotalQty PlannedTotalQty Target Quantity
CostingSheet CostingSheet Costing Sheet
PlannedCostsCostingVariant PlannedCostsCostingVariant Plnd Costing Variant
ActualCostsCostingVariant ActualCostsCostingVariant Act. Costing Variant
OverheadCode OverheadCode Overhead Key
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
NetworkIsAccountAssigned NetworkIsAccountAssigned
ProcurementMode ProcurementMode Procurement Mode
StatusCombinationCode StatusCombinationCode Status Comb
ProjectNetworkObject ProjectNetworkObject Val. Obj. No.
ObjBasedAuthorizationIsActive ObjBasedAuthorizationIsActive
_BusinessArea _BusinessArea
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_MRPController _MRPController
_NetworkActivityByInternalKey _NetworkActivityByInternalKey
_OrderType _OrderType
_Plant _Plant
_PriorityCode _PriorityCode
_ProfitCenter _ProfitCenter
_ProjectData _ProjectData
_WBSElementData _WBSElementData
_ProjectNetworkActivity _ProjectNetworkActivity
_NetworkShortText _NetworkShortText
_WBSElement _WBSElement

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_ProjectNetworkTP.
-- 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_ProjectNetworkTP AS
SELECT
  ProjectNetwork,
  ProjectNetworkInternalID,
  ProjectNetworkDescription,
  ProjectNetworkType,
  _NetworkShortText.LanguageBasedShortText AS ProjNtwkLangBsdDescription,
  PlannedStartDate,
  PlannedEndDate,
  ScheduledReleaseDate,
  ScheduledBasicStartDate,
  ScheduledBasicEndDate,
  ScheduledFcstdReleaseDate,
  ActualReleasedDate,
  ActualStartDate,
  ActualEndDate,
  BasicSchedulingType,
  BasicSchedulingReductionLevel,
  FcstSchedulingReductionLevel,
  OrdIsNotSchedldAutomatically,
  CapacityRqmtHasNotToBeCreated,
  SchedulingIsAllowingForBreaks,
  ProjectInternalID,
  case _ProjectData.ProjectExternalID when '' then cast( _ProjectData.Project as ps_pspid_edit preserving type ) else _ProjectData.ProjectExternalID end as ProjectExternalID AS ProjectExternalIDendasProjectExternalID,
  WBSElementInternalID,
  SalesOrder,
  SalesOrderItem,
  SuperiorProjectNetwork,
  SuperiorProjectNetworkIntID,
  SuperiorNtwkActivityInternalID,
  _NetworkActivityByInternalKey.NetworkActivity AS SuperiorNtwkActivityExternalID,
  ControllingArea,
  CompanyCode,
  BusinessArea,
  ProfitCenter,
  FunctionalArea,
  ControllingObjectClass,
  TaxJurisdiction,
  ResponsibleCostCenter,
  Currency,
  ResponsiblePlannerGroup,
  ChangeNumber,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass,
  JointVentureOriginalCostObject,
  NetworkProfile,
  Plant,
  MRPController,
  PriorityCode,
  BaseUnit,
  PlannedTotalQty,
  CostingSheet,
  PlannedCostsCostingVariant,
  ActualCostsCostingVariant,
  OverheadCode,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  IsMarkedForDeletion,
  NetworkIsAccountAssigned,
  ProcurementMode,
  StatusCombinationCode,
  ProjectNetworkObject,
  ObjBasedAuthorizationIsActive
FROM I_ProjectNetworkBasicData
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ProjectNetwork = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN R_WBSElementTP_2 AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN R_ProjectNetworkActivityTP AS _ProjectNetworkActivity ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More