C_SuplrActySuplrValueHelp

DDL: C_SUPLRACTYSUPLRVALUEHELP SQL: CSUPLRACTYSUPLVH Type: view CONSUMPTION Package: ODATA_SLC_CMN

Suppliers Affected by Activity

C_SuplrActySuplrValueHelp is a Consumption CDS View that provides data about "Suppliers Affected by Activity" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 14 fields with key field Supplier. Part of development package ODATA_SLC_CMN.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_Supplier Supplier left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CSUPLRACTYSUPLVH view
EndUserText.label Suppliers Affected by Activity view
ObjectModel.representativeKey Supplier view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Supplier Activity Supplier
SupplierName
AuthorizationGroup Activity AuthorizationGroup
DataController1 Activity DataController1
DataController2 Activity DataController2
DataController3 Activity DataController3
DataController4 Activity DataController4
DataController5 Activity DataController5
DataController6 Activity DataController6
DataController7 Activity DataController7
DataController8 Activity DataController8
DataController9 Activity DataController9
DataController10 Activity DataController10
DataControllerSet Activity DataControllerSet 
@AbapCatalog.sqlViewName: 'CSUPLRACTYSUPLVH'
@EndUserText.label: 'Suppliers Affected by Activity'
@ObjectModel.representativeKey: 'Supplier'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.dataCategory: #VALUE_HELP

define view C_SuplrActySuplrValueHelp 
  as select distinct from I_SupplierActivitySuplrParty as Activity
    left outer join       I_Supplier as Supplier on Activity.Supplier = Supplier.Supplier
{
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.element: 'SupplierName'
      key Activity.Supplier,
      @Search.defaultSearchElement: true
      @Semantics.text: true
      cast(Activity._Supplier.OrganizationBPName1 as md_supp_name) as SupplierName,
      
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.AuthorizationGroup ,
      
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      Activity.DataControllerSet
}

Learn More