C_SSPPurchasingGroup

DDL: C_SSPPURCHASINGGROUP SQL: CSSPPURCHGROUP Type: view CONSUMPTION

Purchasing Group

C_SSPPurchasingGroup is a Consumption CDS View that provides data about "Purchasing Group" in SAP S/4HANA. It reads from 1 data source (I_PurchasingGroup) and exposes 11 fields with key fields PurchasingGroup, Material, MaterialGroup, Plant.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingGroup I_PurchasingGroup from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSSPPURCHGROUP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchasing Group view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchasingGroup PurchasingGroup
KEY Material
KEY MaterialGroup
KEY Plant
PurchasingGroupName PurchasingGroupName
PurchasingGroupPhoneNumber PurchasingGroupPhoneNumber
FaxNumber FaxNumber
PhoneNumber PhoneNumber
PhoneNumberExtension PhoneNumberExtension
EmailAddress EmailAddress
ProcurementHubSourceSystem 
@AbapCatalog.sqlViewName: 'CSSPPURCHGROUP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.dataCategory: #VALUE_HELP
@Search.searchable: true
@ObjectModel.semanticKey:  [ 'PurchasingGroup' ]
@ObjectModel.representativeKey: [ 'PurchasingGroup' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchasing Group'
define view C_SSPPurchasingGroup
  as select from I_PurchasingGroup
{

       @ObjectModel.text.element : 'PurchasingGroupName'

       @Consumption.labelElement: 'PurchasingGroupName'
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.9
       
  key  PurchasingGroup,

       @UI.hidden : true
  key  cast ('  ' as matnr )               as  Material,

       @UI.hidden : true
  key  cast ('  ' as matkl )               as  MaterialGroup,

       @UI.hidden : true
  key  cast ('  ' as ewerk )               as  Plant,
 
       @Semantics.text: true
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.9
       PurchasingGroupName,

       PurchasingGroupPhoneNumber,

       FaxNumber,

       PhoneNumber,

       PhoneNumberExtension,

       EmailAddress,
       
   //  @UI.hidden : true

       cast ('  ' as abap.char( 10 ) )     as  ProcurementHubSourceSystem
   //ProcurementHubSourceSystem shifted to last since it is hidden in UI resulting in blank space when placed in between...


}

Learn More