I_CustomerPartnerFunction

DDL: I_CUSTOMERPARTNERFUNCTION SQL: ICUSTAPARTFUNC Type: view BASIC

Core for BP Partner Functions

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

2 data source(s) 16 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 ICUSTAPARTFUNC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Core 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 (16)

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
ContactPerson knvp parnr
PartnerFunctionType tpar nrart
pernrelseendasBPCustomerNumber
CustomerPartnerDescription knvp knref
DefaultPartner knvp defpa
AddressID knvp adrnr
BusinessPartnerUUID _CustomerToBusinessPartner BusinessPartnerUUID
BusinessPartnerGrouping
_CustomerToBusinessPartner _CustomerToBusinessPartner 
@AbapCatalog.sqlViewName: 'ICUSTAPARTFUNC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Core for BP Partner Functions'

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

@AccessControl.personalData.blocking: #REQUIRED

define view I_CustomerPartnerFunction
  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 cast(knvp.parvw as parvw_unv)                                       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._BusinessPartner.BusinessPartnerGrouping as BusinessPartnerGrouping,
      _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