I_BPCustPartnerFunctionsProc

DDL: I_BPCUSTPARTNERFUNCTIONSPROC Type: view_entity BASIC

BP Customer Partner Functions Data

I_BPCustPartnerFunctionsProc is a Basic CDS View that provides data about "BP Customer Partner Functions Data" in SAP S/4HANA. It reads from 2 data sources (knvp_prc, tpar) and exposes 23 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 1 association to related views.

2 data source(s) 23 fields

Data Sources (2)

SourceAliasJoin Type
knvp_prc knvp_prc from
tpar tpar inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BPCustomerProcess _Customer $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject and $projection.BPAssignmentID = _Customer.BPAssignmentID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Partner Functions Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess knvp_prc process_id
KEY MDChgProcessStep knvp_prc process_step_no
KEY MDChgProcessSrceSystem knvp_prc source_system
KEY MDChgProcessSrceObject knvp_prc source_id
KEY SalesOrganization knvp_prc vkorg
KEY DistributionChannel knvp_prc vtweg
KEY Division knvp_prc spart
KEY PartnerFunction
KEY PartnerCounter knvp_prc parza
KEY BPAssignmentID knvp_prc assignment_id
Customer knvp_prc kunnr
PartnerFunctionType tpar nrart
BPCustomerNumber knvp_prc kunn2
Supplier knvp_prc lifnr
PersonnelNumber knvp_prc pernr
ContactPerson knvp_prc parnr
CustomerPartnerDescription knvp_prc knref
DefaultPartner knvp_prc defpa
AddressID knvp_prc adrnr
MDChgProcSrceLastChgdDateTime knvp_prc source_recency
MDChgProcessSourceModified knvp_prc source_modified
MDChgProcessSourceModifBinary knvp_prc source_modification_blip
_Customer _Customer 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Partner Functions Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_BPCustPartnerFunctionsProc
  as select from knvp_prc
    inner join tpar on knvp_prc.parvw = tpar.parvw
  association [0..1] to I_BPCustomerProcess as _Customer on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                         and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                         and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                         and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
                                                         and $projection.BPAssignmentID          = _Customer.BPAssignmentID
{
  key knvp_prc.process_id               as MasterDataChangeProcess,
  key knvp_prc.process_step_no          as MDChgProcessStep,
  key knvp_prc.source_system            as MDChgProcessSrceSystem,
  key knvp_prc.source_id                as MDChgProcessSrceObject,
  key knvp_prc.vkorg                    as SalesOrganization,
  key knvp_prc.vtweg                    as DistributionChannel,
  key knvp_prc.spart                    as Division,
  key cast(knvp_prc.parvw as parvw_unv) as PartnerFunction,
  key knvp_prc.parza                    as PartnerCounter,
  key knvp_prc.assignment_id            as BPAssignmentID,
      knvp_prc.kunnr                    as Customer,
      tpar.nrart                        as PartnerFunctionType,
      knvp_prc.kunn2                    as BPCustomerNumber,
      knvp_prc.lifnr                    as Supplier,
      knvp_prc.pernr                    as PersonnelNumber,
      knvp_prc.parnr                    as ContactPerson,
      knvp_prc.knref                    as CustomerPartnerDescription,
      knvp_prc.defpa                    as DefaultPartner,
      knvp_prc.adrnr                    as AddressID,
      knvp_prc.source_recency           as MDChgProcSrceLastChgdDateTime,
      knvp_prc.source_modified          as MDChgProcessSourceModified,
      knvp_prc.source_modification_blip as MDChgProcessSourceModifBinary,
      case
        when tpar.nrart = 'KU'
          then knvp_prc.kunn2
        when tpar.nrart = 'AP'
          then knvp_prc.parnr
        when tpar.nrart = 'PE'
          then knvp_prc.pernr
        when tpar.nrart = 'LI'
          then knvp_prc.lifnr
        else '          '
       end                              as PartnerFunctionPartnerNumber,
      _Customer
}
where
     knvp_prc.assignment_id = '000000000002'
  or knvp_prc.assignment_id is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNVP_PRC",
"TPAR"
],
"ASSOCIATED":
[
"I_BPCUSTOMERPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More