I_ServiceDocumentSoldToPartyVH

DDL: I_SERVICEDOCUMENTSOLDTOPARTYVH Type: view_entity COMPOSITE Package: K_SERVICE_DOC_CORE

Business Partners with Sold To Party role

I_ServiceDocumentSoldToPartyVH is a Composite CDS View that provides data about "Business Partners with Sold To Party role" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, I_BusinessPartner_to_BP_Role) and exposes 15 fields with key field BusinessPartner. Part of development package K_SERVICE_DOC_CORE.

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner BPartner from
I_BusinessPartner_to_BP_Role BPRole inner

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partners with Sold To Party role view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey BusinessPartner view
Analytics.technicalName ISrvDocSoldToPartyVH view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner
BusinessPartnerFullName I_BusinessPartner BusinessPartnerFullName Business Partner Name
AuthorizationGroup I_BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted
DataControllerSet I_BusinessPartner DataControllerSet
DataController1 I_BusinessPartner DataController1
DataController2 I_BusinessPartner DataController2
DataController3 I_BusinessPartner DataController3
DataController4 I_BusinessPartner DataController4
DataController5 I_BusinessPartner DataController5
DataController6 I_BusinessPartner DataController6
DataController7 I_BusinessPartner DataController7
DataController8 I_BusinessPartner DataController8
DataController9 I_BusinessPartner DataController9
DataController10 I_BusinessPartner DataController10
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Business Partners with Sold To Party role'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XL,
  dataClass: #MASTER
}
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.representativeKey: 'BusinessPartner'
@Analytics.technicalName: 'ISrvDocSoldToPartyVH'
@VDM.viewType: #COMPOSITE
@Search.searchable: true
@Consumption.ranked: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view entity I_ServiceDocumentSoldToPartyVH 
  as select from I_BusinessPartner as BPartner
  inner join I_BusinessPartner_to_BP_Role as BPRole 
    on  BPartner.BusinessPartner = BPRole.BusinessPartner
    and BPRole.BusinessPartnerRole = 'CRM000'
{
  @Search: {
    defaultSearchElement: true,
    ranking: #HIGH,
    fuzzinessThreshold: 0.7
  }
  key BPartner.BusinessPartner,
  
  @EndUserText.label: 'Business Partner Name'
  BPartner.BusinessPartnerFullName,
  
  @Consumption.hidden: true
  BPartner.AuthorizationGroup         as AuthorizationGroup,
  @Consumption.hidden: true
  @Semantics.booleanIndicator
  BPartner.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataControllerSet          as DataControllerSet,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController1            as DataController1,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController2            as DataController2,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController3            as DataController3,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController4            as DataController4,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController5            as DataController5,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController6            as DataController6,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController7            as DataController7,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController8            as DataController8,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController9            as DataController9,
  @Consumption.hidden:true
  @UI.hidden:true
  BPartner.DataController10           as DataController10
}

where BPartner.BusinessPartnerIsBlocked = ''
  and BPartner.BusinessPartnerIsNotReleased = ''