P_OrglChangeReportNWAtoORD

DDL: P_ORGLCHANGEREPORTNWATOORD SQL: POCRNWA2ORD Type: view CONSUMPTION
43 Fields 1 Data Sources 3 Associations

Purchase Order Item to Root Order

P_OrglChangeReportNWAtoORD is a Consumption CDS View that provides data about "Purchase Order Item to Root Order" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToNetworkActy) and exposes 43 fields with key fields OrganizationalChange, ProjectNetwork, NetworkActivity, ValidityStartDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterToNetworkActy I_ProfitCenterToNetworkActy from

Associations (3)

CardinalityTargetAliasCondition
[1] I_ProfitCenterToOrder _RootProfitCenterToOrder _RootProfitCenterToOrder.OrganizationalChange = $projection.OrganizationalChange and _RootProfitCenterToOrder.OrderID = $projection.SourceOrder and _RootProfitCenterToOrder.ValidityStartDate = $projection.ValidityStartDate
[0..*] I_OrglChgReassignmentStsText _OrglChgReassignmentStsText $projection.OrglChangeReassignmentStatus = _OrglChgReassignmentStsText.OrglChangeReassignmentStatus
[1] I_ProjectNetwork _ProjectNetwork $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName POCRNWA2ORD 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 Purchase Order Item to Root Order view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange OrganizationalChange Organizational Change
KEY ProjectNetwork ProjectNetwork Order
KEY NetworkActivity NetworkActivity Operation/Activity
KEY ValidityStartDate ValidityStartDate Validity Start Date
OrglChgRptDependentObjectType
SemanticObject
RootObjectID
ValidityEndDate ValidityEndDate ValidTo
ControllingArea ControllingArea Controlling Area
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
OrderDescription
SourceOrder SourceOrder
OrderID _RootProfitCenterToOrder OrderID Order ID
OrderCategory _RootProfitCenterToOrder OrderCategory Order Category
RootOrderID _RootProfitCenterToOrder OrderID Order ID
RootOrderCategory _RootProfitCenterToOrder OrderCategory Order Category
RootValidityStartDate _RootProfitCenterToOrder ValidityStartDate Validity Start Date
RootValidityEndDate _RootProfitCenterToOrder ValidityEndDate ValidTo
RootControllingArea _RootProfitCenterToOrder ControllingArea Controlling Area
RootCompanyCode _RootProfitCenterToOrder CompanyCode Receiver Company Code
RootProfitCenterBeforeOrglChng _RootProfitCenterToOrder ProfitCenterBeforeOrglChange Old Profit Center
RootProfitCenter _RootProfitCenterToOrder ProfitCenter Profit Center
RootOrganizationalChange _RootProfitCenterToOrder OrganizationalChange Organizational Change
RootOrglChangeReassignmentSts _RootProfitCenterToOrder OrglChangeReassignmentStatus Status
RootProfitCenterDrvtnSrceTp _RootProfitCenterToOrder ProfitCenterDerivationSrceType Profit Center Source
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_OrglChange _OrglChange
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_ProfitCenterBeforeOrglChange _ProfitCenterBeforeOrglChange
_ProfitCtr _ProfitCtr
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_Order _Order
_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_OrglChangeReportNWAtoORD.
-- 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: POCRNWA2ORD

CREATE VIEW P_OrglChangeReportNWAtoORD AS
SELECT
  OrganizationalChange,
  ProjectNetwork,
  NetworkActivity,
  ValidityStartDate,
  cast( 'NV' as finoc_dependent_object_type ) AS OrglChgRptDependentObjectType,
  cast( 'NetworkActivity' as finoc_semantic_object ) AS SemanticObject,
  cast ( SourceOrder as finoc_object_id ) AS RootObjectID,
  ValidityEndDate,
  ControllingArea,
  _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,
  _RootProfitCenterToOrder._Order.OrderDescription AS OrderDescription,
  SourceOrder,
  _RootProfitCenterToOrder.OrderID AS OrderID,
  _RootProfitCenterToOrder.OrderCategory AS OrderCategory,
  _RootProfitCenterToOrder.OrderID AS RootOrderID,
  _RootProfitCenterToOrder.OrderCategory AS RootOrderCategory,
  _RootProfitCenterToOrder.ValidityStartDate AS RootValidityStartDate,
  _RootProfitCenterToOrder.ValidityEndDate AS RootValidityEndDate,
  _RootProfitCenterToOrder.ControllingArea AS RootControllingArea,
  _RootProfitCenterToOrder.CompanyCode AS RootCompanyCode,
  _RootProfitCenterToOrder.ProfitCenterBeforeOrglChange AS RootProfitCenterBeforeOrglChng,
  _RootProfitCenterToOrder.ProfitCenter AS RootProfitCenter,
  _RootProfitCenterToOrder.OrganizationalChange AS RootOrganizationalChange,
  _RootProfitCenterToOrder.OrglChangeReassignmentStatus AS RootOrglChangeReassignmentSts,
  _RootProfitCenterToOrder.ProfitCenterDerivationSrceType AS RootProfitCenterDrvtnSrceTp
FROM I_ProfitCenterToNetworkActy
LEFT OUTER JOIN I_ProfitCenterToOrder AS _RootProfitCenterToOrder ON _RootProfitCenterToOrder.OrganizationalChange = OrganizationalChange AND _RootProfitCenterToOrder.OrderID = SourceOrder AND _RootProfitCenterToOrder.ValidityStartDate = ValidityStartDate  -- association [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