C_ProfitCenterToNetworkActy

DDL: C_PROFITCENTERTONETWORKACTY Type: view_entity CONSUMPTION Package: ODATA_ORGL_CHG_REPORT_MD_LR
32 Fields 1 Data Sources 6 Associations 2 OData Services

Assgmt of PrftCtr to Network Activity

C_ProfitCenterToNetworkActy is a Consumption CDS View that provides data about "Assgmt of PrftCtr to Network Activity" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToNetworkActy) and exposes 32 fields with key fields OrganizationalChangeObjectType, ProjectNetwork, NetworkActivity, ValidityStartDate, CompanyCode. It has 6 associations to related views. It is exposed through 2 OData services (ASQL_F7047, ORGL_CHANGE_REPORT_MD_LIST). Part of development package ODATA_ORGL_CHG_REPORT_MD_LR.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterToNetworkActy _ProfitCenterToNetworkActy from

Associations (6)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _ProfitCenterBfrOrglChangeText _ProfitCenterToNetworkActy.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea and _ProfitCenterToNetworkActy.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
[0..*] I_ProfitCenterText _ProfitCenterByOrglChangeText _ProfitCenterToNetworkActy.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea and _ProfitCenterToNetworkActy.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'
[0..1] I_WBSElementBasicData _SourceWBSElement _ProfitCenterToNetworkActy.SourceWBSElementInternalID = _SourceWBSElement.WBSElementInternalID
[0..1] I_ProjectBasicData _SourceProjectBasicData _ProfitCenterToNetworkActy.SourceProjectInternalID = _SourceProjectBasicData.ProjectInternalID
[1] I_Order _SourceOrder _ProfitCenterToNetworkActy.SourceOrder = _SourceOrder.OrderID
[1] I_ProjectNetwork _ProjectNetwork $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
EndUserText.label Assgmt of PrftCtr to Network Activity view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7047 ASQL_F7047 C2 NOT_RELEASED
ORGL_CHANGE_REPORT_MD_LIST ORGL_CHANGE_RPT_MD_LIST_O4 V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChangeObjectType
KEY ProjectNetwork ProjectNetwork Order
KEY NetworkActivity NetworkActivity Operation/Activity
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY CompanyCode CompanyCode Receiver Company Code
ValidityEndDate ValidityEndDate ValidTo
ProjectNetworkDescription _ProjectNetwork ProjectNetworkDescription Network Name
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange Old Profit Center
ProfitCenterByOrglChange ProfitCenter Profit Center
OrganizationalChange OrganizationalChange Organizational Change
OrglChangeReassignmentStatus OrglChangeReassignmentStatus Status
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType Profit Center Source
SourceWBSElementInternalID SourceWBSElementInternalID
SourceWBSElementExternalID _SourceWBSElement WBSElementExternalID WBS Element External ID
SourceWBSElementDescription _SourceWBSElement WBSDescription WBS Element Name
SourceProjectInternalID SourceProjectInternalID
SourceProjectExternalID _SourceProjectBasicData ProjectExternalID Project def.
SourceProjectDescription _SourceProjectBasicData ProjectDescription Project Name
SourceOrder SourceOrder
SourceOrderName _SourceOrder OrderDescription
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_OrglChange _OrglChange
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCtr _ProfitCtr
_ProfitCenterBeforeOrglChange _ProfitCenterBeforeOrglChange
_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 C_ProfitCenterToNetworkActy.
-- 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 C_ProfitCenterToNetworkActy AS
SELECT
  'NV' AS OrganizationalChangeObjectType,
  ProjectNetwork,
  NetworkActivity,
  ValidityStartDate,
  CompanyCode,
  ValidityEndDate,
  _ProjectNetwork.ProjectNetworkDescription AS ProjectNetworkDescription,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  ProfitCenter AS ProfitCenterByOrglChange,
  OrganizationalChange,
  OrglChangeReassignmentStatus,
  ProfitCenterDerivationSrceType,
  SourceWBSElementInternalID,
  _SourceWBSElement.WBSElementExternalID AS SourceWBSElementExternalID,
  _SourceWBSElement.WBSDescription AS SourceWBSElementDescription,
  SourceProjectInternalID,
  _SourceProjectBasicData.ProjectExternalID AS SourceProjectExternalID,
  _SourceProjectBasicData.ProjectDescription AS SourceProjectDescription,
  SourceOrder,
  _SourceOrder.OrderDescription AS SourceOrderName
FROM I_ProfitCenterToNetworkActy AS _ProfitCenterToNetworkActy
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterBfrOrglChangeText ON _ProfitCenterToNetworkActy.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea AND _ProfitCenterToNetworkActy.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter AND _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterByOrglChangeText ON _ProfitCenterToNetworkActy.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea AND _ProfitCenterToNetworkActy.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter AND _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _SourceWBSElement ON _ProfitCenterToNetworkActy.SourceWBSElementInternalID = _SourceWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _SourceProjectBasicData ON _ProfitCenterToNetworkActy.SourceProjectInternalID = _SourceProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _SourceOrder ON _ProfitCenterToNetworkActy.SourceOrder = _SourceOrder.OrderID  -- association [1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [1]
;

Learn More