P_OrglChangeReportNWAtoWBS

DDL: P_ORGLCHANGEREPORTNWATOWBS Type: view_entity CONSUMPTION
49 Fields 1 Data Sources 3 Associations

Dependent NWA to Root WBS Element

P_OrglChangeReportNWAtoWBS is a Consumption CDS View that provides data about "Dependent NWA to Root WBS Element" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToNetworkActy) and exposes 49 fields with key fields ProjectNetwork, NetworkActivity, ValidityStartDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterToNetworkActy _ProfitCenterToNetworkActy from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProfitCenterToWBSElement _ProfitCenterToWBSElement _ProfitCenterToWBSElement.OrganizationalChange = $projection.OrganizationalChange and _ProfitCenterToWBSElement.ValidityStartDate = $projection.ValidityStartDate and _ProfitCenterToWBSElement.ControllingArea = $projection.ControllingArea and _ProfitCenterToWBSElement.SourceWBSElementInternalID = $projection.SourceWBSElementInternalID
[0..*] I_OrglChgReassignmentStsText _OrglChgReassignmentStsText $projection.OrglChangeReassignmentStatus = _OrglChgReassignmentStsText.OrglChangeReassignmentStatus
[1] I_ProjectNetwork _ProjectNetwork $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Dependent NWA to Root WBS Element view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork ProjectNetwork Order
KEY NetworkActivity NetworkActivity Operation/Activity
KEY ValidityStartDate ValidityStartDate Validity Start Date
OrglChgRptDependentObjectType
RootObjectID
OrglChgRptRootObjectType ProfitCenterDerivationSrceType Profit Center Source
SemanticObject
OrganizationalChange OrganizationalChange Organizational Change
ControllingArea ControllingArea Controlling Area
ValidityEndDate ValidityEndDate ValidTo
Segment _ProfitCtr Segment Segment number
SegmentName
SegmentBeforeOrglChange _PrftCtrBfrOrglChgBfrEffctvDte Segment Segment number
SegmentBeforeOrglChangeName
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange Old Profit Center
ProfitCenterBfrOrglChangeName
ProfitCenter ProfitCenter Profit Center
ProfitCenterName
OrglChangeReassignmentStatus OrglChangeReassignmentStatus Status
OrglChgReassignmentStatusName
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType Profit Center Source
SourceOrder SourceOrder
SourceProjectInternalID SourceProjectInternalID
SourceWBSElementInternalID SourceWBSElementInternalID
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID NetworkActivityInternalID Counter
RootWBSElementInternalID _ProfitCenterToWBSElement WBSElementInternalID WBS Internal ID
RootValidityStartDate _ProfitCenterToWBSElement ValidityStartDate Validity Start Date
RootValidityEndDate _ProfitCenterToWBSElement ValidityEndDate ValidTo
RootControllingArea _ProfitCenterToWBSElement ControllingArea Controlling Area
RootCompanyCode _ProfitCenterToWBSElement CompanyCode Receiver Company Code
RootProfitCenterBeforeOrglChng _ProfitCenterToWBSElement ProfitCenterBeforeOrglChange Old Profit Center
RootProfitCenter _ProfitCenterToWBSElement ProfitCenter Profit Center
RootOrganizationalChange _ProfitCenterToWBSElement OrganizationalChange Organizational Change
RootOrglChangeReassignmentSts _ProfitCenterToWBSElement OrglChangeReassignmentStatus Status
RootProfitCenterDrvtnSrceTp _ProfitCenterToWBSElement ProfitCenterDerivationSrceType Profit Center Source
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_OrglChange _OrglChange
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_Order _Order
_ProfitCenterBeforeOrglChange _ProfitCenterBeforeOrglChange
OrglChangeEffectiveDate I_ProfitCenterToNetworkActy OrglChangeEffectiveDate Effective Date
OrglChgLastDateBeforeEffDate I_ProfitCenterToNetworkActy OrglChgLastDateBeforeEffDate
_ProfitCtr _ProfitCtr
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType

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_OrglChangeReportNWAtoWBS.
-- 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 P_OrglChangeReportNWAtoWBS AS
SELECT
  ProjectNetwork,
  NetworkActivity,
  ValidityStartDate,
  cast( 'NV' as finoc_dependent_object_type ) AS OrglChgRptDependentObjectType,
  cast( SourceWBSElementInternalID as finoc_object_id ) AS RootObjectID,
  ProfitCenterDerivationSrceType AS OrglChgRptRootObjectType,
  cast( 'NetworkActivity' as finoc_semantic_object ) AS SemanticObject,
  OrganizationalChange,
  ControllingArea,
  ValidityEndDate,
  _ProfitCtr.Segment AS Segment,
  _ProfitCtr._Segment._Text[1:Language=$session.system_language].SegmentName AS SegmentName,
  _PrftCtrBfrOrglChgBfrEffctvDte.Segment AS SegmentBeforeOrglChange,
  _PrftCtrBfrOrglChgBfrEffctvDte._Segment._Text[1:Language=$session.system_language].SegmentName AS SegmentBeforeOrglChangeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  _ProfitCenterBeforeOrglChange._Text[1:Language=$session.system_language].ProfitCenterName AS ProfitCenterBfrOrglChangeName,
  ProfitCenter,
  _ProfitCtr._Text[1:Language=$session.system_language].ProfitCenterName AS ProfitCenterName,
  OrglChangeReassignmentStatus,
  _OrglChgReassignmentStsText[1:Language=$session.system_language].OrglChgReassignmentStatusName AS OrglChgReassignmentStatusName,
  ProfitCenterDerivationSrceType,
  SourceOrder,
  SourceProjectInternalID,
  SourceWBSElementInternalID,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  _ProfitCenterToWBSElement.WBSElementInternalID AS RootWBSElementInternalID,
  _ProfitCenterToWBSElement.ValidityStartDate AS RootValidityStartDate,
  _ProfitCenterToWBSElement.ValidityEndDate AS RootValidityEndDate,
  _ProfitCenterToWBSElement.ControllingArea AS RootControllingArea,
  _ProfitCenterToWBSElement.CompanyCode AS RootCompanyCode,
  _ProfitCenterToWBSElement.ProfitCenterBeforeOrglChange AS RootProfitCenterBeforeOrglChng,
  _ProfitCenterToWBSElement.ProfitCenter AS RootProfitCenter,
  _ProfitCenterToWBSElement.OrganizationalChange AS RootOrganizationalChange,
  _ProfitCenterToWBSElement.OrglChangeReassignmentStatus AS RootOrglChangeReassignmentSts,
  _ProfitCenterToWBSElement.ProfitCenterDerivationSrceType AS RootProfitCenterDrvtnSrceTp,
  _ProfitCenterToNetworkActy.OrglChangeEffectiveDate AS OrglChangeEffectiveDate,
  _ProfitCenterToNetworkActy.OrglChgLastDateBeforeEffDate AS OrglChgLastDateBeforeEffDate
FROM I_ProfitCenterToNetworkActy AS _ProfitCenterToNetworkActy
LEFT OUTER JOIN I_ProfitCenterToWBSElement AS _ProfitCenterToWBSElement ON _ProfitCenterToWBSElement.OrganizationalChange = OrganizationalChange AND _ProfitCenterToWBSElement.ValidityStartDate = ValidityStartDate AND _ProfitCenterToWBSElement.ControllingArea = ControllingArea AND _ProfitCenterToWBSElement.SourceWBSElementInternalID = SourceWBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_OrglChgReassignmentStsText AS _OrglChgReassignmentStsText ON OrglChangeReassignmentStatus = _OrglChgReassignmentStsText.OrglChangeReassignmentStatus  -- association [0..*]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [1]
;

Learn More