R_OrglChangeNetworkActivityTP

DDL: R_ORGLCHANGENETWORKACTIVITYTP Type: view_entity TRANSACTIONAL

Organizational Change NetworkActivity

R_OrglChangeNetworkActivityTP is a Transactional CDS View that provides data about "Organizational Change NetworkActivity" in SAP S/4HANA. It reads from 1 data source (I_OrglChangeNetworkActivity) and exposes 20 fields with key fields OrganizationalChange, ProjectNetwork, NetworkActivity. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OrglChangeNetworkActivity I_OrglChangeNetworkActivity from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ProjectNetwork _ProjectNetworkForEdit $projection.ProjectNetworkForEdit = _ProjectNetworkForEdit.ProjectNetwork
[1] I_NetworkActivity _NetworkActivityForEdit $projection.NetworkActivityForEdit = _NetworkActivityForEdit.NetworkActivity and $projection.ProjectNetworkForEdit = _NetworkActivityForEdit.ProjectNetwork

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey NetworkActivity view
EndUserText.label Organizational Change NetworkActivity view
Metadata.ignorePropagatedAnnotations true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange OrganizationalChange Organizational Change
KEY ProjectNetwork ProjectNetwork Order
KEY NetworkActivity NetworkActivity Operation/Activity
ProjectNetworkForEdit ProjectNetwork Order
NetworkActivityForEdit NetworkActivity Operation/Activity
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
ProfitCenterByOrglChange ProfitCenterByOrglChange New Profit Center
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_OrganizationalChange _OrganizationalChange
_ProjectNetwork _ProjectNetwork
_ProjectNetworkForEdit _ProjectNetworkForEdit
_ProfitCtr _ProfitCtr
_ProfitCtrNew _ProfitCtrNew
_ProfitCenterBfrOrglChangeText _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText _ProfitCenterByOrglChangeText
_NetworkActivity _NetworkActivity
_NetworkActivityForEdit _NetworkActivityForEdit
_ControllingArea _ControllingArea

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 R_OrglChangeNetworkActivityTP.
-- 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 R_OrglChangeNetworkActivityTP AS
SELECT
  OrganizationalChange,
  ProjectNetwork,
  NetworkActivity,
  ProjectNetwork AS ProjectNetworkForEdit,
  NetworkActivity AS NetworkActivityForEdit,
  ControllingArea,
  ProfitCenter,
  ProfitCenterByOrglChange,
  LastChangeDateTime,
  LastChangedByUser
FROM I_OrglChangeNetworkActivity
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetworkForEdit ON ProjectNetworkForEdit = _ProjectNetworkForEdit.ProjectNetwork  -- association [1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivityForEdit ON NetworkActivityForEdit = _NetworkActivityForEdit.NetworkActivity AND ProjectNetworkForEdit = _NetworkActivityForEdit.ProjectNetwork  -- association [1]
;