C_PurCatCreaByValueHelp

DDL: C_PURCATCREABYVALUEHELP SQL: CPURCATCREABYVH Type: view CONSUMPTION

"Created-By" User of Purchasing Category

C_PurCatCreaByValueHelp is a Consumption CDS View that provides data about ""Created-By" User of Purchasing Category" in SAP S/4HANA. It reads from 1 data source (I_BusinessUserBasic) and exposes 17 fields with key field CreatedByUser.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessUserBasic BusinessUser inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPURCATCREABYVH view
EndUserText.label "Created-By" User of Purchasing Category view
ObjectModel.representativeKey CreatedByUser view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CreatedByUser I_BusinessUserBasic UserID
PersonFullName
FirstName I_BusinessUserBasic FirstName
LastName I_BusinessUserBasic LastName
AuthorizationGroup I_BusinessUserBasic AuthorizationGroup
IsBusinessPurposeCompleted I_BusinessUserBasic IsBusinessPurposeCompleted
DataController1 I_BusinessUserBasic DataController1
DataController2 I_BusinessUserBasic DataController2
DataController3 I_BusinessUserBasic DataController3
DataController4 I_BusinessUserBasic DataController4
DataController5 I_BusinessUserBasic DataController5
DataController6 I_BusinessUserBasic DataController6
DataController7 I_BusinessUserBasic DataController7
DataController8 I_BusinessUserBasic DataController8
DataController9 I_BusinessUserBasic DataController9
DataController10 I_BusinessUserBasic DataController10
DataControllerSet I_BusinessUserBasic DataControllerSet 
@AbapCatalog.sqlViewName: 'CPURCATCREABYVH'
@EndUserText.label: '"Created-By" User of Purchasing Category'
@ObjectModel.representativeKey: 'CreatedByUser'
@AccessControl.personalData.blocking: #REQUIRED

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

define view C_PurCatCreaByValueHelp
  as select distinct from I_PurchasingCategory
    inner join            I_BusinessUserBasic as BusinessUser on I_PurchasingCategory.CreatedByUser = BusinessUser.UserID
                                                          and BusinessUser.IsBusinessPurposeCompleted <> 'X'

{
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.element: 'PersonFullName'
  key BusinessUser.UserID                                              as CreatedByUser,

      @Search.defaultSearchElement: true
      @Semantics.text: true
      cast( BusinessUser.PersonFullName as ad_namtext preserving type) as PersonFullName,

      @Search:{defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold:0.7}
      @Semantics.text: true
      BusinessUser.FirstName,

      @Search:{defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold:0.7}
      @Semantics.text: true
      BusinessUser.LastName,

      @Consumption.hidden: true
      BusinessUser.AuthorizationGroup,

      @Consumption.hidden: true
      BusinessUser.IsBusinessPurposeCompleted,

      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController1,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController2,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController3,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController4,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController5,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController6,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController7,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController8,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController9,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataController10,
      @Consumption.hidden: true
      @UI.hidden: true
      BusinessUser.DataControllerSet

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERBASIC",
"I_PURCHASINGCATEGORY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More