I_SUPPLIER_TO_BUSINESSPARTNER

CDS View

Supplier to BusinessPartner Relationship

I_SUPPLIER_TO_BUSINESSPARTNER is a CDS View in S/4HANA. Supplier to BusinessPartner Relationship. It contains 3 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 3 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
/SCMTMS/CV_BPOrgRelshp view inner BOPF: /SCMTMS/BuPa Org Relationship
C_ChmlSuplrMatlSupplierVH view inner CONSUMPTION Value Help for Supplier
C_SLCMgmtSupplierPortfolio view left_outer CONSUMPTION Display Suppliers
cic_supplierdata view_entity inner Proj. on Supplier (Industry Cloud Solutions)
FAC_DART_Z3_S_BP_ADDRESS view inner Business Partner Address for Supplier
I_ContingentWorker_1 view from COMPOSITE Contingent Worker
I_PurchasingCategorySupplier view inner COMPOSITE Purchasing Category Supplier
I_SLC_SupplierValueHelp view left_outer COMPOSITE Supplier
I_SupplierActivitySuplrParty view left_outer COMPOSITE Supplier Activity Supplier Party
I_SupplierActivityTaskSupplier view left_outer COMPOSITE Supplier Activity Task Supplier
I_SupplierEvalRespSuplrParty view inner COMPOSITE Supplier Evaluation Response Supplier Party
I_WorkForcePersonPayt view left_outer COMPOSITE Workforce Person Payment Details for Object Page
P_JP_CentralBkPaytWithItems view left_outer CONSUMPTION View for Japan Central Bank Payment Detail Items
R_WorkAssgmtPaymentTP view_entity inner TRANSACTIONAL TP View for Payment for Workforce Person

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Supplier Supplier 1
AuthorizationGroup AuthorizationGroup 1
BusinessPartnerUUID BusinessPartnerUUID,partner_guid 2 
@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: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey:true
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"CVI_VEND_LINK"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More