C_NetworkActivityValueHelp

DDL: C_NETWORKACTIVITYVALUEHELP SQL: CNTWKACTYVH Type: view CONSUMPTION Package: ODATA_MM_PUR_REQ_MAINTAIN

Network Activity Value help

C_NetworkActivityValueHelp is a Consumption CDS View that provides data about "Network Activity Value help" in SAP S/4HANA. It reads from 1 data source (I_NetworkActivityValueHelp) and exposes 18 fields with key fields NetworkActivity, ProjectNetwork. It has 2 associations to related views. Part of development package ODATA_MM_PUR_REQ_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_NetworkActivityValueHelp I_NetworkActivityValueHelp from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProjectResponsiblePerson _ResponsiblePerson $projection.responsibleperson = _ResponsiblePerson.ResponsiblePerson
[0..1] I_ProjectApplicant _ProjectApplicant $projection.applicantcode = _ProjectApplicant.ApplicantCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CNTWKACTYVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Network Activity Value help view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY NetworkActivity
KEY ProjectNetwork I_NetworkActivityValueHelp ProjectNetwork
NetworkActivityDescription I_NetworkActivityValueHelp NetworkActivityDescription
NetworkActivityCategory I_NetworkActivityValueHelp NetworkActivityCategory
Plant I_NetworkActivityValueHelp Plant
WorkCenter I_NetworkActivityValueHelp WorkCenter
FreeDefinedAttribute01 I_NetworkActivityValueHelp FreeDefinedAttribute01
FreeDefinedAttribute02 I_NetworkActivityValueHelp FreeDefinedAttribute02
FreeDefinedAttribute03 I_NetworkActivityValueHelp FreeDefinedAttribute03
FreeDefinedAttribute04 I_NetworkActivityValueHelp FreeDefinedAttribute04
FreeDefinedIndicator1 I_NetworkActivityValueHelp FreeDefinedIndicator1
FreeDefinedIndicator2 I_NetworkActivityValueHelp FreeDefinedIndicator2
WBSElementInternalID I_NetworkActivityValueHelp WBSElementInternalID
ResponsiblePerson
ApplicantCode
_ResponsiblePerson _ResponsiblePerson
_ProjectApplicant _ProjectApplicant
_WBSElement I_NetworkActivityValueHelp _WBSElement
@AbapCatalog.sqlViewName: 'CNTWKACTYVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Network Activity Value help'
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

@AccessControl.personalData.blocking : #NOT_REQUIRED
@ObjectModel.dataCategory: #VALUE_HELP


define view C_NetworkActivityValueHelp as select from I_NetworkActivityValueHelp

// DPP Changes

  // Person in Responsible for Project

  association [0..1] to I_ProjectResponsiblePerson   as _ResponsiblePerson        on  $projection.responsibleperson = _ResponsiblePerson.ResponsiblePerson
  // Project Applicant

  association [0..1] to I_ProjectApplicant           as _ProjectApplicant         on  $projection.applicantcode   = _ProjectApplicant.ApplicantCode
 {

key cast( I_NetworkActivityValueHelp.NetworkActivity as ps_s4_vornr )    as NetworkActivity, 
key I_NetworkActivityValueHelp.ProjectNetwork, 
    I_NetworkActivityValueHelp.NetworkActivityDescription,
    @UI.hidden: true
    I_NetworkActivityValueHelp.NetworkActivityCategory,
    @UI.hidden: true
    I_NetworkActivityValueHelp.Plant,
    @UI.hidden: true
    I_NetworkActivityValueHelp.WorkCenter,
    @UI.hidden: true
    I_NetworkActivityValueHelp.FreeDefinedAttribute01,
    @UI.hidden: true
    I_NetworkActivityValueHelp.FreeDefinedAttribute02,
    @UI.hidden: true
    I_NetworkActivityValueHelp.FreeDefinedAttribute03,
    @UI.hidden: true
    I_NetworkActivityValueHelp.FreeDefinedAttribute04,
    @UI.hidden: true
    I_NetworkActivityValueHelp.FreeDefinedIndicator1,
    @UI.hidden: true
    I_NetworkActivityValueHelp.FreeDefinedIndicator2,
    @UI.hidden: true
    @Consumption.hidden: true
    I_NetworkActivityValueHelp.WBSElementInternalID,
    @UI.hidden: true
    I_NetworkActivityValueHelp._WBSElement.ResponsiblePerson,
    @UI.hidden: true
    I_NetworkActivityValueHelp._WBSElement.ApplicantCode,
    @UI.hidden: true
    @Consumption.hidden: true
    _ResponsiblePerson,
    @UI.hidden: true
    @Consumption.hidden: true
    _ProjectApplicant,
    @UI.hidden: true
    @Consumption.hidden: true
    I_NetworkActivityValueHelp._WBSElement
    
}