C_NetworkActivityBasicInfo

DDL: C_NETWORKACTIVITYBASICINFO SQL: CNTWKACTYBSCINFO Type: view CONSUMPTION
56 Fields 1 Data Sources 2 Associations

Network Activity Basic Information

C_NetworkActivityBasicInfo is a Consumption CDS View that provides data about "Network Activity Basic Information" in SAP S/4HANA. It reads from 1 data source (I_NetworkActivityWithVersion) and exposes 56 fields with key fields ProjectNetwork, NetworkActivity, Version. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_NetworkActivityWithVersion _NetworkActivity from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_ProjectStsObjActiveSts _Status _Status.StatusObject = $projection.NetworkActivityObject
[0..1] I_UserAccByObjBsdAuthzn _UsrByObjBsdAuthzn $projection.NetworkActivityObject = _UsrByObjBsdAuthzn.ProjectObject and _UsrByObjBsdAuthzn.ObjectBasedAuthorizationUser = $session.user and _UsrByObjBsdAuthzn.AuthorizationTypeValue > 1

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CNTWKACTYBSCINFO view
EndUserText.label Network Activity Basic Information view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Network Activity view
UI.headerInfo.typeNamePlural Network Activities view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value NetworkActivity view
UI.headerInfo.title.label Network Activity Basic Information view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value NetworkActivityDescription view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork I_NetworkActivityWithVersion ProjectNetwork Order
KEY NetworkActivity I_NetworkActivityWithVersion NetworkActivity Operation/Activity
KEY Version Version XML Vers.
WBSElementInternalID I_NetworkActivityWithVersion WBSElementInternalID WBS Internal ID
ProjectNetworkInternalID I_NetworkActivityWithVersion ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID I_NetworkActivityWithVersion NetworkActivityInternalID Counter
NetworkActivityObject I_NetworkActivityWithVersion NetworkActivityObject
Plant I_NetworkActivityWithVersion Plant Valuation Area
ActyBscStartDateConstraintType I_NetworkActivityWithVersion ActyBscStartDateConstraintType
ActyBscEndDateConstraintType I_NetworkActivityWithVersion ActyBscEndDateConstraintType
OperationControlProfileName I_NetworkActivityWithVersion OperationControlProfileName
NetworkActivityControlProfile I_NetworkActivityWithVersion NetworkActivityControlProfile
PlantName I_NetworkActivityWithVersion PlantName Plant Name
SchedldBasicLatestStartDate I_NetworkActivityWithVersion SchedldBasicLatestStartDate
ScheduledBasicLatestEndDate I_NetworkActivityWithVersion ScheduledBasicLatestEndDate
StandardDuration I_NetworkActivityWithVersion StandardDuration
SchedldBasicEarliestStartDate I_NetworkActivityWithVersion SchedldBasicEarliestStartDate
SchedldBasicEarliestStartTime I_NetworkActivityWithVersion SchedldBasicEarliestStartTime
SchedldBasicEarliestEndDate I_NetworkActivityWithVersion SchedldBasicEarliestEndDate
SchedldBasicEarliestEndTime I_NetworkActivityWithVersion SchedldBasicEarliestEndTime
SchedldBasicLatestStartTime I_NetworkActivityWithVersion SchedldBasicLatestStartTime
SchedldBasicLatestEndTime I_NetworkActivityWithVersion SchedldBasicLatestEndTime
SchedldFcstdEarliestStartDate I_NetworkActivityWithVersion SchedldFcstdEarliestStartDate
SchedldFcstdEarliestStartTime I_NetworkActivityWithVersion SchedldFcstdEarliestStartTime
LatestSchedldFcstdStartDate I_NetworkActivityWithVersion LatestSchedldFcstdStartDate
SchedldFcstdLatestStartTime I_NetworkActivityWithVersion SchedldFcstdLatestStartTime
SchedldFcstdEarliestEndDate I_NetworkActivityWithVersion SchedldFcstdEarliestEndDate
SchedldFcstdEarliestEndTime I_NetworkActivityWithVersion SchedldFcstdEarliestEndTime
LatestSchedldFcstdEndDate I_NetworkActivityWithVersion LatestSchedldFcstdEndDate
SchedldFcstdLatestEndTime I_NetworkActivityWithVersion SchedldFcstdLatestEndTime
ActualStartDate I_NetworkActivityWithVersion ActualStartDate Actual Start
ActualExecutionStartTime I_NetworkActivityWithVersion ActualExecutionStartTime
ActualEndDate I_NetworkActivityWithVersion ActualEndDate Actual Finish
ActualExecutionEndTime I_NetworkActivityWithVersion ActualExecutionEndTime
IsMarkedForDeletion I_NetworkActivityWithVersion IsMarkedForDeletion Purch.org. data
NetworkActivityPriority I_NetworkActivityWithVersion NetworkActivityPriority
WorkCenter I_NetworkActivityWithVersion WorkCenter Work Center
WorkCenterText I_NetworkActivityWithVersion WorkCenterText Work Center Text
FactoryCalendar I_NetworkActivityWithVersion FactoryCalendar Factory Calendar
NtwkActivityWorkQuantityUnit I_NetworkActivityWithVersion NtwkActivityWorkQuantityUnit
NetworkActivityQuantityUnit I_NetworkActivityWithVersion NetworkActivityQuantityUnit
NetworkActivityCurrency I_NetworkActivityWithVersion NetworkActivityCurrency
StandardDurationUnit I_NetworkActivityWithVersion StandardDurationUnit
PlannedWorkQuantity I_NetworkActivityWithVersion PlannedWorkQuantity
ActualWorkQuantity I_NetworkActivityWithVersion ActualWorkQuantity Actual work
RemainingWorkQuantity I_NetworkActivityWithVersion RemainingWorkQuantity
ActivityQuantity I_NetworkActivityWithVersion ActivityQuantity Activity Quantity
ExternalProcessingPrice I_NetworkActivityWithVersion ExternalProcessingPrice
NetworkActivityCost I_NetworkActivityWithVersion NetworkActivityCost
CostElement I_NetworkActivityWithVersion CostElement G/L Account
CostElementName
Supplier I_NetworkActivityWithVersion Supplier Supplier
_Status _Status
_WBSElement I_NetworkActivityWithVersion _WBSElement
_Supplier I_NetworkActivityWithVersion _Supplier
ObjBasedAuthorizationIsActive I_NetworkActivityWithVersion ObjBasedAuthorizationIsActive

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_NetworkActivityBasicInfo.
-- 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: CNTWKACTYBSCINFO

CREATE VIEW C_NetworkActivityBasicInfo AS
SELECT
  _NetworkActivity.ProjectNetwork AS ProjectNetwork,
  _NetworkActivity.NetworkActivity AS NetworkActivity,
  Version,
  _NetworkActivity.WBSElementInternalID AS WBSElementInternalID,
  _NetworkActivity.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  _NetworkActivity.NetworkActivityInternalID AS NetworkActivityInternalID,
  _NetworkActivity.NetworkActivityObject AS NetworkActivityObject,
  _NetworkActivity.Plant AS Plant,
  _NetworkActivity.ActyBscStartDateConstraintType AS ActyBscStartDateConstraintType,
  _NetworkActivity.ActyBscEndDateConstraintType AS ActyBscEndDateConstraintType,
  _NetworkActivity.OperationControlProfileName AS OperationControlProfileName,
  _NetworkActivity.NetworkActivityControlProfile AS NetworkActivityControlProfile,
  _NetworkActivity.PlantName AS PlantName,
  _NetworkActivity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivity.StandardDuration AS StandardDuration,
  _NetworkActivity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivity.SchedldBasicEarliestStartTime AS SchedldBasicEarliestStartTime,
  _NetworkActivity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivity.SchedldBasicEarliestEndTime AS SchedldBasicEarliestEndTime,
  _NetworkActivity.SchedldBasicLatestStartTime AS SchedldBasicLatestStartTime,
  _NetworkActivity.SchedldBasicLatestEndTime AS SchedldBasicLatestEndTime,
  _NetworkActivity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivity.SchedldFcstdEarliestStartTime AS SchedldFcstdEarliestStartTime,
  _NetworkActivity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivity.SchedldFcstdLatestStartTime AS SchedldFcstdLatestStartTime,
  _NetworkActivity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivity.SchedldFcstdEarliestEndTime AS SchedldFcstdEarliestEndTime,
  _NetworkActivity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NetworkActivity.SchedldFcstdLatestEndTime AS SchedldFcstdLatestEndTime,
  _NetworkActivity.ActualStartDate AS ActualStartDate,
  _NetworkActivity.ActualExecutionStartTime AS ActualExecutionStartTime,
  _NetworkActivity.ActualEndDate AS ActualEndDate,
  _NetworkActivity.ActualExecutionEndTime AS ActualExecutionEndTime,
  _NetworkActivity.IsMarkedForDeletion AS IsMarkedForDeletion,
  _NetworkActivity.NetworkActivityPriority AS NetworkActivityPriority,
  _NetworkActivity.WorkCenter AS WorkCenter,
  _NetworkActivity.WorkCenterText AS WorkCenterText,
  _NetworkActivity.FactoryCalendar AS FactoryCalendar,
  _NetworkActivity.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  _NetworkActivity.NetworkActivityQuantityUnit AS NetworkActivityQuantityUnit,
  _NetworkActivity.NetworkActivityCurrency AS NetworkActivityCurrency,
  _NetworkActivity.StandardDurationUnit AS StandardDurationUnit,
  _NetworkActivity.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NetworkActivity.ActualWorkQuantity AS ActualWorkQuantity,
  _NetworkActivity.RemainingWorkQuantity AS RemainingWorkQuantity,
  _NetworkActivity.ActivityQuantity AS ActivityQuantity,
  _NetworkActivity.ExternalProcessingPrice AS ExternalProcessingPrice,
  _NetworkActivity.NetworkActivityCost AS NetworkActivityCost,
  _NetworkActivity.CostElement AS CostElement,
  cast ( _NetworkActivity._CostElementOnChartOfAccounts._Text[1:Language = $session.system_language].CostElementName as fis_mcds2 ) AS CostElementName,
  _NetworkActivity.Supplier AS Supplier,
  _NetworkActivity._WBSElement AS _WBSElement,
  _NetworkActivity._Supplier AS _Supplier,
  _NetworkActivity.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive
FROM I_NetworkActivityWithVersion AS _NetworkActivity
LEFT OUTER JOIN C_ProjectStsObjActiveSts AS _Status ON _Status.StatusObject = NetworkActivityObject  -- association [0..*]
LEFT OUTER JOIN I_UserAccByObjBsdAuthzn AS _UsrByObjBsdAuthzn ON NetworkActivityObject = _UsrByObjBsdAuthzn.ProjectObject AND _UsrByObjBsdAuthzn.ObjectBasedAuthorizationUser = $session.user AND _UsrByObjBsdAuthzn.AuthorizationTypeValue > 1  -- association [0..1]
;

Learn More