I_ProjNetworkWithVersion

DDL: I_PROJNETWORKWITHVERSION SQL: IPROJNETWITHVERS Type: view COMPOSITE
94 Fields 1 Data Sources 8 Associations

Project Network and Version Details

I_ProjNetworkWithVersion is a Composite CDS View that provides data about "Project Network and Version Details" in SAP S/4HANA. It reads from 1 data source (P_ProjNetworkWithVersion) and exposes 94 fields with key fields ProjectNetwork, Version. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProjNetworkWithVersion ProjNetworkWithVersion from

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_ProjectWithVersion _Project $projection.ProjectInternalID = _Project.ProjectInternalID and $projection.Version = _Project.Version
[0..1] I_WBSElementWithVersion _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID and $projection.Version = _WBSElement.Version
[0..1] I_StsObjConcatActiveStsILL _StsObjConcatActiveStsILL $projection.ProjectNetworkObject = _StsObjConcatActiveStsILL.StatusObject
[0..1] I_TaxJurisdiction _TaxJurisdiction $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction and $projection.taxcalculationprocedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure
[1..1] E_LogisticsOrder _Extension ProjNetworkWithVersion.ProjectNetwork = _Extension.OrderID
[1..1] E_ProjectNetworkVersion _VersionExtension ProjNetworkWithVersion.Version = _VersionExtension.Version and ProjNetworkWithVersion.ProjectNetwork = _VersionExtension.ProjectNetwork
[0..*] I_ProjectVersionVH _ProjectVersionVH $projection.Project = _ProjectVersionVH.ProjectObjectExternalID and $projection.Version = _ProjectVersionVH.Version
[0..1] I_ProjectVersionHeader _ProjectVersionHeader $projection.Project = _ProjectVersionHeader.Project and $projection.Version = _ProjectVersionHeader.Version

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPROJNETWITHVERS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Project Network and Version Details view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (94)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork P_ProjNetworkWithVersion ProjectNetwork Order
KEY Version P_ProjNetworkWithVersion Version XML Vers.
IsProjectVersionObject P_ProjNetworkWithVersion IsProjectVersionObject
ProjectNetworkDescription P_ProjNetworkWithVersion ProjectNetworkDescription Network Name
ProjectInternalID P_ProjNetworkWithVersion ProjectInternalID Project Def.
WBSElementInternalID P_ProjNetworkWithVersion WBSElementInternalID WBS Internal ID
ProjectNetworkInternalID P_ProjNetworkWithVersion ProjectNetworkInternalID Plan No.f.Oper.
BusinessArea P_ProjNetworkWithVersion BusinessArea Business Area
CompanyCode P_ProjNetworkWithVersion CompanyCode Receiver Company Code
ControllingArea P_ProjNetworkWithVersion ControllingArea Controlling Area
ProfitCenter P_ProjNetworkWithVersion ProfitCenter Profit Center
CostCenter P_ProjNetworkWithVersion CostCenter Cost Center
Plant P_ProjNetworkWithVersion Plant Valuation Area
SalesOrder P_ProjNetworkWithVersion SalesOrder SD Document
SalesOrderItem P_ProjNetworkWithVersion SalesOrderItem Sales Order Item
MRPController P_ProjNetworkWithVersion MRPController MRP Controller
ResponsiblePlannerGroup P_ProjNetworkWithVersion ResponsiblePlannerGroup
ChangeNumber P_ProjNetworkWithVersion ChangeNumber Change Number
PriorityCode P_ProjNetworkWithVersion PriorityCode Priority
SuperiorProjectNetwork P_ProjNetworkWithVersion SuperiorProjectNetwork Subnetwork of
ProductConfiguration P_ProjNetworkWithVersion ProductConfiguration
LastScheduledDate P_ProjNetworkWithVersion LastScheduledDate
ConfirmedEndDate P_ProjNetworkWithVersion ConfirmedEndDate
ScheduledReleaseDate P_ProjNetworkWithVersion ScheduledReleaseDate
ActualReleasedDate P_ProjNetworkWithVersion ActualReleasedDate
ActualStartDate P_ProjNetworkWithVersion ActualStartDate Actual Start
ActualEndDate P_ProjNetworkWithVersion ActualEndDate Actual Finish
PlannedStartDate P_ProjNetworkWithVersion PlannedStartDate Latest Planned Start
PlannedEndDate P_ProjNetworkWithVersion PlannedEndDate Ltst Planned Finish
ScheduledFcstdReleaseDate P_ProjNetworkWithVersion ScheduledFcstdReleaseDate
ScheduledBasicStartDate P_ProjNetworkWithVersion ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate P_ProjNetworkWithVersion ScheduledBasicEndDate Sched. finish
Reservation P_ProjNetworkWithVersion Reservation Reservation
CreationDate P_ProjNetworkWithVersion CreationDate Time Stamp
CreationTime P_ProjNetworkWithVersion CreationTime Time of Change
CreatedByUser P_ProjNetworkWithVersion CreatedByUser User Name
LastChangeDate P_ProjNetworkWithVersion LastChangeDate Time Stamp
LastChangeTime P_ProjNetworkWithVersion LastChangeTime Time changed
LastChangedByUser P_ProjNetworkWithVersion LastChangedByUser User Name
ProjectNetworkType P_ProjNetworkWithVersion ProjectNetworkType Order Type
OrderCategory P_ProjNetworkWithVersion OrderCategory Order Category
JointVentureOriginalCostObject P_ProjNetworkWithVersion JointVentureOriginalCostObject Or. Cost Obj.
JointVentureObjectType P_ProjNetworkWithVersion JointVentureObjectType JV Object Type
JointVenture P_ProjNetworkWithVersion JointVenture Joint venture
JointVentureClass P_ProjNetworkWithVersion JointVentureClass JIB/JIBE Class
JointVentureSubClass P_ProjNetworkWithVersion JointVentureSubClass JIB/JIBE SbClsA
TaxJurisdiction P_ProjNetworkWithVersion TaxJurisdiction Tax Jurisdiction
CostingSheet P_ProjNetworkWithVersion CostingSheet Costing Sheet
CostElement P_ProjNetworkWithVersion CostElement G/L Account
ProjectNetworkObject P_ProjNetworkWithVersion ProjectNetworkObject
Currency P_ProjNetworkWithVersion Currency Valuation Crcy
OverheadCode P_ProjNetworkWithVersion OverheadCode Overhead Key
ProjNtwkInterestCalcProfile P_ProjNetworkWithVersion ProjNtwkInterestCalcProfile
NetworkActivityConfirmation P_ProjNetworkWithVersion NetworkActivityConfirmation
IsMarkedForDeletion P_ProjNetworkWithVersion IsMarkedForDeletion Purch.org. data
ActualCostsCostingVariant P_ProjNetworkWithVersion ActualCostsCostingVariant Act. Costing Variant
PlannedCostsCostingVariant P_ProjNetworkWithVersion PlannedCostsCostingVariant Plnd Costing Variant
BasicSchedulingType P_ProjNetworkWithVersion BasicSchedulingType Scheduling type
BaseUnit P_ProjNetworkWithVersion BaseUnit Unit of Measure
NetworkIsAccountAssigned P_ProjNetworkWithVersion NetworkIsAccountAssigned
NetworkProfile P_ProjNetworkWithVersion NetworkProfile
FunctionalArea P_ProjNetworkWithVersion FunctionalArea Sendr Fctl Area
CapacityRequirement P_ProjNetworkWithVersion CapacityRequirement
ControllingObjectClass P_ProjNetworkWithVersion ControllingObjectClass Object Class
OrderID P_ProjNetworkWithVersion OrderID Order ID
OrderIsNotCostedAutomatically
OrdIsNotSchedldAutomatically
TaxCalculationProcedure
Project _Project Project WBS Element
ProjectWithCodingMask _Project ProjectWithCodingMask
ObjBasedAuthorizationIsActive P_ProjNetworkWithVersion ObjBasedAuthorizationIsActive
_BusinessArea P_ProjNetworkWithVersion _BusinessArea
_CompanyCode P_ProjNetworkWithVersion _CompanyCode
_ControllingArea P_ProjNetworkWithVersion _ControllingArea
_CostCenter P_ProjNetworkWithVersion _CostCenter
_Currency P_ProjNetworkWithVersion _Currency
_FunctionalArea P_ProjNetworkWithVersion _FunctionalArea
_MRPController P_ProjNetworkWithVersion _MRPController
_NetworkProfile P_ProjNetworkWithVersion _NetworkProfile
_ControllingObjectClass P_ProjNetworkWithVersion _ControllingObjectClass
_OrderCategory P_ProjNetworkWithVersion _OrderCategory
_Plant P_ProjNetworkWithVersion _Plant
_Prioritycode P_ProjNetworkWithVersion _Prioritycode
_ProfitCenter P_ProjNetworkWithVersion _ProfitCenter
_ResponsiblePlannerGroup P_ProjNetworkWithVersion _ResponsiblePlannerGroup
_SalesOrder P_ProjNetworkWithVersion _SalesOrder
_SalesOrderItem P_ProjNetworkWithVersion _SalesOrderItem
_OrderType P_ProjNetworkWithVersion _OrderType
_TaxJurisdiction _TaxJurisdiction
_Project _Project
_WBSElement _WBSElement
_ProjectVersionVH _ProjectVersionVH
_ProjectVersionHeader _ProjectVersionHeader
_NetworkShortText P_ProjNetworkWithVersion _NetworkShortText

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 I_ProjNetworkWithVersion.
-- 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.
-- SQL view name: IPROJNETWITHVERS

CREATE VIEW I_ProjNetworkWithVersion AS
SELECT
  ProjNetworkWithVersion.ProjectNetwork AS ProjectNetwork,
  ProjNetworkWithVersion.Version AS Version,
  ProjNetworkWithVersion.IsProjectVersionObject AS IsProjectVersionObject,
  ProjNetworkWithVersion.ProjectNetworkDescription AS ProjectNetworkDescription,
  ProjNetworkWithVersion.ProjectInternalID AS ProjectInternalID,
  ProjNetworkWithVersion.WBSElementInternalID AS WBSElementInternalID,
  ProjNetworkWithVersion.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  ProjNetworkWithVersion.BusinessArea AS BusinessArea,
  ProjNetworkWithVersion.CompanyCode AS CompanyCode,
  ProjNetworkWithVersion.ControllingArea AS ControllingArea,
  ProjNetworkWithVersion.ProfitCenter AS ProfitCenter,
  ProjNetworkWithVersion.CostCenter AS CostCenter,
  ProjNetworkWithVersion.Plant AS Plant,
  ProjNetworkWithVersion.SalesOrder AS SalesOrder,
  ProjNetworkWithVersion.SalesOrderItem AS SalesOrderItem,
  ProjNetworkWithVersion.MRPController AS MRPController,
  ProjNetworkWithVersion.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  ProjNetworkWithVersion.ChangeNumber AS ChangeNumber,
  ProjNetworkWithVersion.PriorityCode AS PriorityCode,
  ProjNetworkWithVersion.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  ProjNetworkWithVersion.ProductConfiguration AS ProductConfiguration,
  ProjNetworkWithVersion.LastScheduledDate AS LastScheduledDate,
  ProjNetworkWithVersion.ConfirmedEndDate AS ConfirmedEndDate,
  ProjNetworkWithVersion.ScheduledReleaseDate AS ScheduledReleaseDate,
  ProjNetworkWithVersion.ActualReleasedDate AS ActualReleasedDate,
  ProjNetworkWithVersion.ActualStartDate AS ActualStartDate,
  ProjNetworkWithVersion.ActualEndDate AS ActualEndDate,
  ProjNetworkWithVersion.PlannedStartDate AS PlannedStartDate,
  ProjNetworkWithVersion.PlannedEndDate AS PlannedEndDate,
  ProjNetworkWithVersion.ScheduledFcstdReleaseDate AS ScheduledFcstdReleaseDate,
  ProjNetworkWithVersion.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  ProjNetworkWithVersion.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  ProjNetworkWithVersion.Reservation AS Reservation,
  ProjNetworkWithVersion.CreationDate AS CreationDate,
  ProjNetworkWithVersion.CreationTime AS CreationTime,
  ProjNetworkWithVersion.CreatedByUser AS CreatedByUser,
  ProjNetworkWithVersion.LastChangeDate AS LastChangeDate,
  ProjNetworkWithVersion.LastChangeTime AS LastChangeTime,
  ProjNetworkWithVersion.LastChangedByUser AS LastChangedByUser,
  ProjNetworkWithVersion.ProjectNetworkType AS ProjectNetworkType,
  ProjNetworkWithVersion.OrderCategory AS OrderCategory,
  ProjNetworkWithVersion.JointVentureOriginalCostObject AS JointVentureOriginalCostObject,
  ProjNetworkWithVersion.JointVentureObjectType AS JointVentureObjectType,
  ProjNetworkWithVersion.JointVenture AS JointVenture,
  ProjNetworkWithVersion.JointVentureClass AS JointVentureClass,
  ProjNetworkWithVersion.JointVentureSubClass AS JointVentureSubClass,
  ProjNetworkWithVersion.TaxJurisdiction AS TaxJurisdiction,
  ProjNetworkWithVersion.CostingSheet AS CostingSheet,
  ProjNetworkWithVersion.CostElement AS CostElement,
  ProjNetworkWithVersion.ProjectNetworkObject AS ProjectNetworkObject,
  ProjNetworkWithVersion.Currency AS Currency,
  ProjNetworkWithVersion.OverheadCode AS OverheadCode,
  ProjNetworkWithVersion.ProjNtwkInterestCalcProfile AS ProjNtwkInterestCalcProfile,
  ProjNetworkWithVersion.NetworkActivityConfirmation AS NetworkActivityConfirmation,
  ProjNetworkWithVersion.IsMarkedForDeletion AS IsMarkedForDeletion,
  ProjNetworkWithVersion.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  ProjNetworkWithVersion.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  ProjNetworkWithVersion.BasicSchedulingType AS BasicSchedulingType,
  ProjNetworkWithVersion.BaseUnit AS BaseUnit,
  ProjNetworkWithVersion.NetworkIsAccountAssigned AS NetworkIsAccountAssigned,
  ProjNetworkWithVersion.NetworkProfile AS NetworkProfile,
  ProjNetworkWithVersion.FunctionalArea AS FunctionalArea,
  ProjNetworkWithVersion.CapacityRequirement AS CapacityRequirement,
  ProjNetworkWithVersion.ControllingObjectClass AS ControllingObjectClass,
  ProjNetworkWithVersion.OrderID AS OrderID,
  cast(ProjNetworkWithVersion.OrderIsNotCostedAutomatically as co_naucost) AS OrderIsNotCostedAutomatically,
  cast(ProjNetworkWithVersion.OrdIsNotSchedldAutomatically as co_nauterm) AS OrdIsNotSchedldAutomatically,
  ProjNetworkWithVersion._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  _Project.Project AS Project,
  _Project.ProjectWithCodingMask AS ProjectWithCodingMask,
  ProjNetworkWithVersion.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  ProjNetworkWithVersion._BusinessArea AS _BusinessArea,
  ProjNetworkWithVersion._CompanyCode AS _CompanyCode,
  ProjNetworkWithVersion._ControllingArea AS _ControllingArea,
  ProjNetworkWithVersion._CostCenter AS _CostCenter,
  ProjNetworkWithVersion._Currency AS _Currency,
  ProjNetworkWithVersion._FunctionalArea AS _FunctionalArea,
  ProjNetworkWithVersion._MRPController AS _MRPController,
  ProjNetworkWithVersion._NetworkProfile AS _NetworkProfile,
  ProjNetworkWithVersion._ControllingObjectClass AS _ControllingObjectClass,
  ProjNetworkWithVersion._OrderCategory AS _OrderCategory,
  ProjNetworkWithVersion._Plant AS _Plant,
  ProjNetworkWithVersion._Prioritycode AS _Prioritycode,
  ProjNetworkWithVersion._ProfitCenter AS _ProfitCenter,
  ProjNetworkWithVersion._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  ProjNetworkWithVersion._SalesOrder AS _SalesOrder,
  ProjNetworkWithVersion._SalesOrderItem AS _SalesOrderItem,
  ProjNetworkWithVersion._OrderType AS _OrderType,
  ProjNetworkWithVersion._NetworkShortText AS _NetworkShortText
FROM P_ProjNetworkWithVersion AS ProjNetworkWithVersion
LEFT OUTER JOIN I_ProjectWithVersion AS _Project ON ProjectInternalID = _Project.ProjectInternalID AND Version = _Project.Version  -- association [1..1]
LEFT OUTER JOIN I_WBSElementWithVersion AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [0..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _StsObjConcatActiveStsILL ON ProjectNetworkObject = _StsObjConcatActiveStsILL.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction AND taxcalculationprocedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure  -- association [0..1]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ProjNetworkWithVersion.ProjectNetwork = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN E_ProjectNetworkVersion AS _VersionExtension ON ProjNetworkWithVersion.Version = _VersionExtension.Version AND ProjNetworkWithVersion.ProjectNetwork = _VersionExtension.ProjectNetwork  -- association [1..1]
LEFT OUTER JOIN I_ProjectVersionVH AS _ProjectVersionVH ON Project = _ProjectVersionVH.ProjectObjectExternalID AND Version = _ProjectVersionVH.Version  -- association [0..*]
LEFT OUTER JOIN I_ProjectVersionHeader AS _ProjectVersionHeader ON Project = _ProjectVersionHeader.Project AND Version = _ProjectVersionHeader.Version  -- association [0..1]
;

Learn More