I_Supplier_to_BusinessPartner

DDL: I_SUPPLIER_TO_BUSINESSPARTNER SQL: ICVI_VEND_LINK Type: view BASIC Package: VDM_MD_COMMON

Supplier to BusinessPartner Relationship

I_Supplier_to_BusinessPartner is a Basic CDS View (Dimension) that provides data about "Supplier to BusinessPartner Relationship" in SAP S/4HANA. It reads from 1 data source (cvi_vend_link) and exposes 5 fields with key field BusinessPartnerUUID. It has 2 associations to related views. Part of development package VDM_MD_COMMON.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
cvi_vend_link cvi_vend_link from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (14)

NameValueLevelField
EndUserText.label Supplier to BusinessPartner Relationship view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey BusinessPartnerUUID view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName ICVI_VEND_LINK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
AbapCatalog.preserveKey true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID partner_guid
Supplier cvi_vend_link vendor
_Supplier _Supplier
AuthorizationGroup _BusinessPartner AuthorizationGroup
_BusinessPartner _BusinessPartner 
@EndUserText.label: 'Supplier to BusinessPartner Relationship'
@Analytics.dataCategory: #DIMENSION //or #CUBE or #FACT

@VDM.viewType: #BASIC
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'BusinessPartnerUUID'
@Metadata.ignorePropagatedAnnotations:true 
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE , #CDS_MODELING_DATA_SOURCE , #CDS_MODELING_ASSOCIATION_TARGET]
@AbapCatalog.sqlViewName: 'ICVI_VEND_LINK'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey:true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_Supplier_to_BusinessPartner
  as select from cvi_vend_link
  association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
  association [1..1] to I_Supplier        as _Supplier        on $projection.Supplier = _Supplier.Supplier
{
      // key  CVI_CUST_LINK.client,

  key partner_guid         as BusinessPartnerUUID,
  //    _BusinessPartner.BusinessPartner, 

      cvi_vend_link.vendor as Supplier,

      _Supplier,
      _BusinessPartner.AuthorizationGroup,
      _BusinessPartner
}

Learn More