C_SupplierValHelp

DDL: C_SUPPLIERVALHELP SQL: CSUPL_VH Type: view CONSUMPTION

Supplier Value Help

C_SupplierValHelp 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 25 fields with key fields Supplier, CompanyCode. It has 2 associations to related views.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_Supplier Supplier from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_BusinessPartnerSuplrCo _BusinessPartnerSuplrCo $projection.Supplier = _BusinessPartnerSuplrCo.Supplier
[1..1] I_Supplier_to_BusinessPartner _Supplier_to_BusinessPartner $projection.Supplier = _Supplier_to_BusinessPartner.Supplier

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSUPL_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey Supplier view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Supplier Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #NONE view
VDM.lifecycle.status #DEPRECATED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY CompanyCode _BusinessPartnerSuplrCo CompanyCode
SupplierName SupplierName
Country Country
FirstName
LastName
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
OrganizationBPName3
OrganizationBPName4
PurchasingIsBlocked I_Supplier PurchasingIsBlocked
AuthorizationGroup AuthorizationGroup
SupplierAccountGroup SupplierAccountGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet I_Supplier DataControllerSet
DataController1 I_Supplier DataController1
DataController2 I_Supplier DataController2
DataController3 I_Supplier DataController3
DataController4 I_Supplier DataController4
DataController5 I_Supplier DataController5
DataController6 I_Supplier DataController6
DataController7 I_Supplier DataController7
DataController8 I_Supplier DataController8
DataController9 I_Supplier DataController9
DataController10 I_Supplier DataController10 
@AbapCatalog.sqlViewName: 'CSUPL_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY

@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: ['Supplier', 'CompanyCode']
@ObjectModel.representativeKey: 'Supplier'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S

@EndUserText.label: 'Supplier Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED 
@VDM.lifecycle.contract.type : #NONE 
@VDM.lifecycle.status: #DEPRECATED
define view C_SupplierValHelp
  as select from I_Supplier as Supplier

  association [0..*] to I_BusinessPartnerSuplrCo      as _BusinessPartnerSuplrCo      on $projection.Supplier = _BusinessPartnerSuplrCo.Supplier

  association [1..1] to I_Supplier_to_BusinessPartner as _Supplier_to_BusinessPartner on $projection.Supplier = _Supplier_to_BusinessPartner.Supplier

{

         @ObjectModel.text.element:  [ 'SupplierName' ]
         @Search: { defaultSearchElement: true, ranking: #HIGH }
  key    Supplier,

  key    _BusinessPartnerSuplrCo.CompanyCode,

         @Semantics.text: true
         SupplierName,

         Country,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         _Supplier_to_BusinessPartner._BusinessPartner.FirstName,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         _Supplier_to_BusinessPartner._BusinessPartner.LastName,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         OrganizationBPName1,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         OrganizationBPName2,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName3,

         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
         _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName4,
         
          Supplier.PurchasingIsBlocked,
         
          //for DCL

         AuthorizationGroup,
         SupplierAccountGroup,
         
         @UI.hidden: true
         IsBusinessPurposeCompleted,
         
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataControllerSet,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController1,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController2,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController3,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController4,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController5,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController6,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController7,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController8,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController9,
         @Consumption.hidden:true
         @UI.hidden:true
         Supplier.DataController10

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNERSUPLRCO",
"I_SUPPLIER",
"I_SUPPLIER_TO_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERSUPLRCO",
"I_SUPPLIER_TO_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More