C_SupplierValueHelp

DDL: C_SUPPLIERVALUEHELP SQL: CSUPVH Type: view CONSUMPTION

Supplier Value Help

C_SupplierValueHelp is a Consumption CDS View that provides data about "Supplier Value Help" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 29 fields with key fields Supplier, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSUPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Supplier Value Help view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY CompanyCode _SupplierCompany CompanyCode
SupplierName SupplierName
AuthorizationGroup AuthorizationGroup
SupplierAccountGroup SupplierAccountGroup
Country Country
StreetName StreetName
CityName CityName
PostalCode PostalCode
PhoneNumber1 PhoneNumber1
EmailAddress
SupplierClerk _SupplierCompany SupplierClerk
SupplierClerkURL _SupplierCompany SupplierClerkURL
AccountingClerkPhoneNumber _SupplierCompany AccountingClerkPhoneNumber
AccountingClerkFaxNumber _SupplierCompany AccountingClerkFaxNumber
AccountingClerk _SupplierCompany AccountingClerk
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
_SupplierCompany _SupplierCompany
@AbapCatalog.sqlViewName: 'CSUPVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
//@AccessControl.privilegedAssociations:  [ '_UserContactCard' ] 

@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.dataCategory: #VALUE_HELP 
@EndUserText.label: 'Supplier Value Help'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #L,
   usageType.dataClass: #MIXED
}
@Search.searchable: true

define view C_SupplierValueHelp as 
select from I_Supplier 
{
      @Search: { defaultSearchElement:  true, ranking: #HIGH }
      @Consumption.semanticObject: 'Supplier'
      @UI.lineItem.position:10
  key Supplier,
      @Search: { defaultSearchElement:  true, ranking: #HIGH }
      @UI.lineItem.position:30
  key _SupplierCompany.CompanyCode, // no association->no VH handling

      @UI.lineItem.position:20
      SupplierName,
      AuthorizationGroup,
      SupplierAccountGroup,
      @Search: { defaultSearchElement:  true, ranking: #HIGH }
      Country,
      StreetName,
      @Search: { defaultSearchElement:  true, ranking: #HIGH }
      CityName,
      @Search: { defaultSearchElement:  true, ranking: #HIGH }
      PostalCode,
      PhoneNumber1,
      cast (_StandardAddress._DefaultEmailAddress.EmailAddress as supplist_smtpadr preserving type) as EmailAddress,
      _SupplierCompany.SupplierClerk,
      _SupplierCompany.SupplierClerkURL,
      _SupplierCompany.AccountingClerkPhoneNumber,
      _SupplierCompany.AccountingClerkFaxNumber,
      _SupplierCompany.AccountingClerk,    
       
       @UI.hidden: true
       IsBusinessPurposeCompleted, 
       
       @Consumption.hidden: true   
      DataControllerSet,   
      
      @Consumption.hidden: true
      DataController1,
      
      @Consumption.hidden: true
      DataController2,
      
      @Consumption.hidden: true
      DataController3,
      
      @Consumption.hidden: true
      DataController4,
      
      @Consumption.hidden: true
      DataController5,
      
      @Consumption.hidden: true
      DataController6,
      
      @Consumption.hidden: true
      DataController7,
      
      @Consumption.hidden: true
      DataController8,
      
      @Consumption.hidden: true
      DataController9,
 
      @Consumption.hidden: true
      DataController10,
       
      _SupplierCompany
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_ADDRESSEMAILADDRESS",
"I_SUPPLIER",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_SUPPLIERCOMPANY"
],
"BASE":
[
"I_SUPPLIER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/