C_ServiceDocumentSoldToPartyVH

DDL: C_SERVICEDOCUMENTSOLDTOPARTYVH SQL: CSERVDOCSOLDTOVH Type: view CONSUMPTION

Value Help for Sold To Party

C_ServiceDocumentSoldToPartyVH is a Consumption CDS View that provides data about "Value Help for Sold To Party" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 25 fields with key field BusinessPartner.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner SoldToParty from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSERVDOCSOLDTOVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value Help for Sold To Party view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.dataCategory #VALUE_HELP view
Consumption.ranked true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner Sold-To Party
BusinessPartnerName I_BusinessPartner BusinessPartnerName Name
FirstName I_BusinessPartner FirstName
LastName I_BusinessPartner LastName
GroupBusinessPartnerName1 I_BusinessPartner GroupBusinessPartnerName1
GroupBusinessPartnerName2 I_BusinessPartner GroupBusinessPartnerName2
OrganizationBPName1 I_BusinessPartner OrganizationBPName1
OrganizationBPName2 I_BusinessPartner OrganizationBPName2
PostalCode
CityName
Country Country / Region Key
CountryName Country / Region Name
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
@AbapCatalog.sqlViewName: 'CSERVDOCSOLDTOVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking :#REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@EndUserText.label: 'Value Help for Sold To Party'

@VDM: {
  viewType: #CONSUMPTION
}

@Search: {
  searchable: true
}

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'BusinessPartner'
@ObjectModel.dataCategory: #VALUE_HELP
@Consumption.ranked: true


define view C_ServiceDocumentSoldToPartyVH
  as select from I_BusinessPartner as SoldToParty
  //  association[0..*] to P_SrvcBPComDistrChnl as _SrvcBPComDistrChnl on _SrvcBPComDistrChnl.BusinessPartner = SoldToParty.BusinessPartner


{

      @Search.defaultSearchElement: true
      @EndUserText.label: 'Sold-To Party'
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.text.element:  [ 'BusinessPartnerName' ]
  key SoldToParty.BusinessPartner,
      @Semantics.text:true
      @EndUserText.label: 'Name'
      SoldToParty.BusinessPartnerName,

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

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

      @UI.hidden:true
      @Search: {
       defaultSearchElement: true,
       ranking: #LOW,
       fuzzinessThreshold: 0.8 }
      SoldToParty.GroupBusinessPartnerName1,

      @UI.hidden:true
      @Search: {
       defaultSearchElement: true,
       ranking: #LOW,
       fuzzinessThreshold: 0.8 }
      SoldToParty.GroupBusinessPartnerName2,

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

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

      @Search: {
       defaultSearchElement: true,
       ranking: #LOW }
      _CurrentDefaultAddress._Address.PostalCode,

      @Search: {
       defaultSearchElement: true,
       ranking: #LOW }
      _CurrentDefaultAddress._Address.CityName,

      @Search: {
       defaultSearchElement: true,
       ranking: #LOW }
      @EndUserText.label: 'Country / Region Key'
      _CurrentDefaultAddress._Address.Country,

      @Search: {
       defaultSearchElement: true,
       ranking: #LOW }
      @EndUserText.label: 'Country / Region Name'
      _CurrentDefaultAddress._Address._Country._Text[1:Language=$session.system_language].CountryName,

      @UI.hidden: true
      AuthorizationGroup,

      // _SrvcBPComDistrChnl.SalesOrganization as SalesOrganization,


      // _SrvcBPComDistrChnl.Division as Division,


      // _SrvcBPComDistrChnl.DistributionChannel as DistributionChannel,


      @UI.hidden: true
      IsBusinessPurposeCompleted,

      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController1,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController2,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController3,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController4,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      DataController6,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController7,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController8,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController9,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      DataController10


}
where
  BusinessPartnerIsBlocked != 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_COUNTRY",
"I_COUNTRYTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/