C_PurgInfoRecordSupplierVH

DDL: C_PURGINFORECORDSUPPLIERVH SQL: CIFRSUPPLVH Type: view CONSUMPTION

Supplier Value Help

C_PurgInfoRecordSupplierVH 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 31 fields with key fields Supplier, CompanyCode, PurchasingOrganization. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Supplier Supplier from

Associations (3)

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

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CIFRSUPPLVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
ObjectModel.representativeKey Supplier view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.preserveKey true view
EndUserText.label Supplier Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_Supplier Supplier
KEY CompanyCode _BusinessPartnerSuplrCo CompanyCode
KEY PurchasingOrganization Purchasing Organization
SupplierName I_Supplier SupplierName
Country
CityName
PostalCode
Region
SortField I_Supplier SortField
FirstName
LastName
OrganizationBPName1
OrganizationBPName2
OrganizationBPName3
OrganizationBPName4
AuthorizationGroup I_Supplier AuthorizationGroup
SupplierAccountGroup I_Supplier SupplierAccountGroup
IsBusinessPurposeCompleted I_Supplier 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
_BusinessPartnerSuplrCo _BusinessPartnerSuplrCo
_CountryText _CountryText
@AbapCatalog.sqlViewName: 'CIFRSUPPLVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.dataCategory: #VALUE_HELP
@Search.searchable: true
@ObjectModel.semanticKey: ['Supplier', 'CompanyCode']
@ObjectModel.representativeKey: 'Supplier'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Supplier Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
define view C_PurgInfoRecordSupplierVH  
 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

  association [0..*] to I_CountryText                 as _CountryText                 on $projection.Country = _CountryText.Country
  
{

         @ObjectModel.text.element:  [ 'SupplierName' ]
         @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1.0 }
  key    Supplier.Supplier                                                  as Supplier,
         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }        
  key    _BusinessPartnerSuplrCo.CompanyCode                                as CompanyCode,
     
   @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
   @EndUserText.label: 'Purchasing Organization'
   key  Supplier._SupplierPurchasingOrg.PurchasingOrganization             as PurchasingOrganization,

         @Semantics.text: true
         Supplier.SupplierName                                              as SupplierName,
        
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         @Semantics.address.country: true
         // commented since re-generation of gateway project is necessary

         //         @ObjectModel.text.association: '_CountryText'

         @UI.textArrangement: #TEXT_ONLY
         Supplier._StandardAddress.Country                                  as Country,
         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         Supplier._StandardAddress.CityName                                 as CityName,
         
         Supplier._StandardAddress.PostalCode                               as PostalCode,

         Supplier._StandardAddress.Region                                   as Region,
         
         @UI.hidden: true
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         Supplier.SortField                                                 as SortField,

         @UI.hidden: true         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         _Supplier_to_BusinessPartner._BusinessPartner.FirstName            as FirstName,

         @UI.hidden: true         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         _Supplier_to_BusinessPartner._BusinessPartner.LastName             as LastName,

         @UI.hidden: true         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName1  as OrganizationBPName1,

         @UI.hidden: true         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName2  as OrganizationBPName2,

         @UI.hidden: true         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName3  as OrganizationBPName3,

         @UI.hidden: true         
         @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
         _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName4  as OrganizationBPName4,

         //for DCL

         @UI.hidden: true
         Supplier.AuthorizationGroup,
         @UI.hidden: true         
         Supplier.SupplierAccountGroup,
         @UI.hidden: true
         @Consumption.filter.hidden: true
         @Consumption.hidden: true         
         Supplier.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,
         
         //@ObjectModel.foreignKey.association: '_BusinessPartnerSuplrCo'

         _BusinessPartnerSuplrCo,        
         _CountryText    
}