P_OrglChangeReportRootNWA

DDL: P_ORGLCHANGEREPORTROOTNWA SQL: POCRROOTNWA Type: view CONSUMPTION Package: ODATA_ORGL_CHANGE_REPORT_MD
27 Fields 1 Data Sources 2 Associations

Orgl Change Report Root Cost Center

P_OrglChangeReportRootNWA is a Consumption CDS View that provides data about "Orgl Change Report Root Cost Center" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToNetworkActy) and exposes 27 fields with key fields OrganizationalChange, ProjectNetwork, NetworkActivity, ValidityStartDate. It has 2 associations to related views. Part of development package ODATA_ORGL_CHANGE_REPORT_MD.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterToNetworkActy I_ProfitCenterToNetworkActy from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_OrglChgReassignmentStsText _OrglChgReassignmentStsText $projection.OrglChangeReassignmentStatus = _OrglChgReassignmentStsText.OrglChangeReassignmentStatus
[1] I_ProjectNetwork _ProjectNetwork $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName POCRROOTNWA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 Orgl Change Report Root Cost Center view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange OrganizationalChange Organizational Change
KEY ProjectNetwork ProjectNetwork Order
KEY NetworkActivity NetworkActivity Operation/Activity
KEY ValidityStartDate ValidityStartDate Validity Start Date
OrglChgRptRootObjectType
SemanticObject
ValidityEndDate ValidityEndDate ValidTo
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange Old Profit Center
ProfitCenterBfrOrglChangeName
ProfitCenter ProfitCenter Profit Center
ProfitCenterName
OrglChangeReassignmentStatus OrglChangeReassignmentStatus Status
OrglChgReassignmentStatusName
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType Profit Center Source
SourceOrder SourceOrder
_CompanyCode _CompanyCode
_OrglChange _OrglChange
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_OrglChgReassignmentStsText _OrglChgReassignmentStsText
_ProfitCenterBeforeOrglChange _ProfitCenterBeforeOrglChange
_ProfitCtr _ProfitCtr
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_ProjectNetwork _ProjectNetwork

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_OrglChangeReportRootNWA.
-- 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: POCRROOTNWA

CREATE VIEW P_OrglChangeReportRootNWA AS
SELECT
  OrganizationalChange,
  ProjectNetwork,
  NetworkActivity,
  ValidityStartDate,
  cast( 'NV' as finoc_root_object_type ) AS OrglChgRptRootObjectType,
  cast( 'NetworkActivity' as finoc_semantic_object ) AS SemanticObject,
  ValidityEndDate,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  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
FROM I_ProfitCenterToNetworkActy
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