P_ProjSchedProjNtwkVersAttrib

DDL: P_PROJSCHEDPROJNTWKVERSATTRIB SQL: PPRNTWKVERSATTR Type: view COMPOSITE
25 Fields 1 Data Sources 2 Associations

P_ProjSchedProjNtwkVersAttrib is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ProjectNetworkVersBasicData) and exposes 25 fields with key fields ProjectNetwork, Version. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectNetworkVersBasicData ProjectNetwork from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StsObjConcatActiveStsILL _Status $projection.ProjectNetworkObject = _Status.StatusObject
[1..1] E_ProjectNetworkVersion _VersionExtension $projection.Version = _VersionExtension.Version and $projection.ProjectNetwork = _VersionExtension.ProjectNetwork

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPRNTWKVERSATTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork I_ProjectNetworkVersBasicData ProjectNetwork Order
KEY Version Version XML Vers.
ProjectNetworkInternalID I_ProjectNetworkVersBasicData ProjectNetworkInternalID Plan No.f.Oper.
RelatedProjectNetwork I_ProjectNetworkVersBasicData RelatedProjectNetwork Order
ProjectNetworkObject I_ProjectNetworkVersBasicData ProjectNetworkObject Val. Obj. No.
ProjectObject
ObjectType
ProjectNetworkDescription I_ProjectNetworkVersBasicData ProjectNetworkDescription Network Name
PlannedStartDate I_ProjectNetworkVersBasicData PlannedStartDate Latest Planned Start
PlannedEndDate I_ProjectNetworkVersBasicData PlannedEndDate Ltst Planned Finish
ScheduledBasicStartDate I_ProjectNetworkVersBasicData ScheduledBasicStartDate Sched. start
ScheduledBasicEndDate I_ProjectNetworkVersBasicData ScheduledBasicEndDate Sched. finish
ActualStartDate I_ProjectNetworkVersBasicData ActualStartDate Actual Start
ActualEndDate I_ProjectNetworkVersBasicData ActualEndDate Actual Finish
PriorityCode I_ProjectNetworkVersBasicData PriorityCode Priority
Plant I_ProjectNetworkVersBasicData Plant Valuation Area
CompanyCode I_ProjectNetworkVersBasicData CompanyCode Receiver Company Code
CreationDate I_ProjectNetworkVersBasicData CreationDate Time Stamp
CreatedByUser I_ProjectNetworkVersBasicData CreatedByUser User Name
LastChangeDate I_ProjectNetworkVersBasicData LastChangeDate Time Stamp
MRPController I_ProjectNetworkVersBasicData MRPController MRP Controller
CostCenter I_ProjectNetworkVersBasicData CostCenter Cost Center
ResponsibleCostCenter I_ProjectNetworkVersBasicData ResponsibleCostCenter Responsible Cost Center
FactoryCalendar
_Status _Status

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 P_ProjSchedProjNtwkVersAttrib.
-- 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: PPRNTWKVERSATTR

CREATE VIEW P_ProjSchedProjNtwkVersAttrib AS
SELECT
  ProjectNetwork.ProjectNetwork AS ProjectNetwork,
  Version,
  ProjectNetwork.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  ProjectNetwork.RelatedProjectNetwork AS RelatedProjectNetwork,
  ProjectNetwork.ProjectNetworkObject AS ProjectNetworkObject,
  ProjectNetwork._Project.ProjectObject AS ProjectObject,
  'V3' AS ObjectType,
  ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  ProjectNetwork.PlannedStartDate AS PlannedStartDate,
  ProjectNetwork.PlannedEndDate AS PlannedEndDate,
  ProjectNetwork.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  ProjectNetwork.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  ProjectNetwork.ActualStartDate AS ActualStartDate,
  ProjectNetwork.ActualEndDate AS ActualEndDate,
  ProjectNetwork.PriorityCode AS PriorityCode,
  ProjectNetwork.Plant AS Plant,
  ProjectNetwork.CompanyCode AS CompanyCode,
  ProjectNetwork.CreationDate AS CreationDate,
  ProjectNetwork.CreatedByUser AS CreatedByUser,
  ProjectNetwork.LastChangeDate AS LastChangeDate,
  ProjectNetwork.MRPController AS MRPController,
  ProjectNetwork.CostCenter AS CostCenter,
  ProjectNetwork.ResponsibleCostCenter AS ResponsibleCostCenter,
  ProjectNetwork._Plant.FactoryCalendar AS FactoryCalendar
FROM I_ProjectNetworkVersBasicData AS ProjectNetwork
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _Status ON ProjectNetworkObject = _Status.StatusObject  -- association [0..1]
LEFT OUTER JOIN E_ProjectNetworkVersion AS _VersionExtension ON Version = _VersionExtension.Version AND ProjectNetwork = _VersionExtension.ProjectNetwork  -- association [1..1]
;

Learn More