I_BusinessPartnerPartFunc

DDL: I_BUSINESSPARTNERPARTFUNC SQL: IBUPAPARTFUNC Type: view BASIC

Core view for BP Partner Functions

I_BusinessPartnerPartFunc is a Basic CDS View that provides data about "Core view for BP Partner Functions" in SAP S/4HANA. It reads from 2 data sources (knvp, tpar) and exposes 15 fields with key fields BusinessPartner, Customer, SalesOrganization, DistributionChannel, Division. It has 1 association to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
knvp knvp from
tpar tpar inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Customer_to_BusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBUPAPARTFUNC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Core view for BP Partner Functions view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY Customer knvp kunnr
KEY SalesOrganization knvp vkorg
KEY DistributionChannel knvp vtweg
KEY Division knvp spart
KEY PartnerCounter knvp parza
KEY PartnerFunction knvp parvw
ContactPerson knvp parnr
PartnerFunctionType tpar nrart
pernrelseendasBPCustomerNumber
CustomerPartnerDescription knvp knref
DefaultPartner knvp defpa
AddressID knvp adrnr
BusinessPartnerUUID _CustomerToBusinessPartner BusinessPartnerUUID
_CustomerToBusinessPartner _CustomerToBusinessPartner 
@AbapCatalog.sqlViewName: 'IBUPAPARTFUNC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Core view for BP Partner Functions'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.personalData.blocking: #REQUIRED

define view I_BusinessPartnerPartFunc
  as select from knvp inner join tpar on knvp.parvw = tpar.parvw
  association [1..1] to I_Customer_to_BusinessPartner as _CustomerToBusinessPartner on $projection.Customer = _CustomerToBusinessPartner.Customer
  
{

  key _CustomerToBusinessPartner._BusinessPartner.BusinessPartner     as BusinessPartner,
  key knvp.kunnr                                                      as Customer,
  key knvp.vkorg                                                      as SalesOrganization,
  key knvp.vtweg                                                      as DistributionChannel,
  key knvp.spart                                                      as Division,
  key knvp.parza                                                      as PartnerCounter,
  key knvp.parvw                                                      as PartnerFunction, //partner role 

      //knvp.kunn2                                                      as BPCustomerNumber,

      knvp.parnr                                                      as ContactPerson,
      //Handling all types of partner functions

      tpar.nrart                                                      as PartnerFunctionType,
      case
        when tpar.nrart = 'KU'
          then knvp.kunn2
        when tpar.nrart = 'LI'
          then knvp.lifnr
        when tpar.nrart = 'AP'
          then knvp.parnr
        when tpar.nrart = 'PE'
          then knvp.pernr
        else ''
      end as BPCustomerNumber,
      knvp.knref                                                      as CustomerPartnerDescription,
      knvp.defpa                                                      as DefaultPartner,
      knvp.adrnr                                                      as AddressID,
     // _CustomerToBusinessPartner._Customer.AuthorizationGroup,                   

      _CustomerToBusinessPartner.BusinessPartnerUUID                  as BusinessPartnerUUID,
      _CustomerToBusinessPartner
}  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER_TO_BUSINESSPARTNER",
"KNVP",
"TPAR"
],
"ASSOCIATED":
[
"I_CUSTOMER_TO_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More