C_SSPNetworkActivityVH

DDL: C_SSPNETWORKACTIVITYVH SQL: CSSPNTACTVH Type: view CONSUMPTION

Purchasing Network Activity Value Help

C_SSPNetworkActivityVH is a Consumption CDS View that provides data about "Purchasing Network Activity Value Help" in SAP S/4HANA. It reads from 1 data source (I_MM_NetworkActivityVH) and exposes 15 fields with key fields ProjectNetwork, NetworkActivity, ProcurementHubSourceSystem.

Data Sources (1)

SourceAliasJoin Type
I_MM_NetworkActivityVH NetworkActivity from

Annotations (13)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Purchasing Network Activity Value Help view
AbapCatalog.sqlViewName CSSPNTACTVH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey NetworkActivity view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProjectNetwork I_MM_NetworkActivityVH ProjectNetwork Order
KEY NetworkActivity I_MM_NetworkActivityVH NetworkActivity Operation/Activity
KEY ProcurementHubSourceSystem
NetworkActivityDescription NetworkActivityDescription
NetworkActivityCategory I_MM_NetworkActivityVH NetworkActivityCategory
FreeDefinedAttribute01 I_MM_NetworkActivityVH FreeDefinedAttribute01 Attribute 1
WorkCenter I_MM_NetworkActivityVH WorkCenter Work Center
Plant I_MM_NetworkActivityVH Plant Valuation Area
FreeDefinedIndicator1 I_MM_NetworkActivityVH FreeDefinedIndicator1
FreeDefinedIndicator2 I_MM_NetworkActivityVH FreeDefinedIndicator2
FreeDefinedAttribute02 I_MM_NetworkActivityVH FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 I_MM_NetworkActivityVH FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 I_MM_NetworkActivityVH FreeDefinedAttribute04 Attribute 4
WBSElementInternalID I_MM_NetworkActivityVH WBSElementInternalID WBS Internal ID
_WBSElement _WBSElement

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_SSPNetworkActivityVH.
-- 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: CSSPNTACTVH

CREATE VIEW C_SSPNetworkActivityVH AS
SELECT
  NetworkActivity.ProjectNetwork AS ProjectNetwork,
  NetworkActivity.NetworkActivity AS NetworkActivity,
  cast ( '' as abap.char(10) ) AS ProcurementHubSourceSystem,
  NetworkActivityDescription,
  NetworkActivity.NetworkActivityCategory AS NetworkActivityCategory,
  NetworkActivity.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  NetworkActivity.WorkCenter AS WorkCenter,
  NetworkActivity.Plant AS Plant,
  NetworkActivity.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  NetworkActivity.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  NetworkActivity.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  NetworkActivity.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  NetworkActivity.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  NetworkActivity.WBSElementInternalID AS WBSElementInternalID
FROM I_MM_NetworkActivityVH AS NetworkActivity
;