I_BPCustPartnerFunctionsProc

DDL: I_BPCUSTPARTNERFUNCTIONSPROC Type: view_entity BASIC Package: MDC_CUST_STAGING_BO

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 1 data source (knvp_prc) and exposes 24 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 2 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
knvp_prc knvp_prc from

Associations (2)

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
[0..1] I_BPCustomerSalesAreaProcess _CustomerSales $projection.MasterDataChangeProcess = _CustomerSales.MasterDataChangeProcess and $projection.MDChgProcessStep = _CustomerSales.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _CustomerSales.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _CustomerSales.MDChgProcessSrceObject and $projection.BPAssignmentID = _CustomerSales.BPAssignmentID and $projection.SalesOrganization = _CustomerSales.SalesOrganization and $projection.DistributionChannel = _CustomerSales.DistributionChannel and $projection.Division = _CustomerSales.Division

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 (24)

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
_CustomerSales _CustomerSales 
@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
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustPartnerFunctionsProc
  as select from           knvp_prc
    left outer to one 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
  association [0..1] to I_BPCustomerSalesAreaProcess as _CustomerSales on  $projection.MasterDataChangeProcess = _CustomerSales.MasterDataChangeProcess
                                                                       and $projection.MDChgProcessStep        = _CustomerSales.MDChgProcessStep
                                                                       and $projection.MDChgProcessSrceSystem  = _CustomerSales.MDChgProcessSrceSystem
                                                                       and $projection.MDChgProcessSrceObject  = _CustomerSales.MDChgProcessSrceObject
                                                                       and $projection.BPAssignmentID          = _CustomerSales.BPAssignmentID
                                                                       and $projection.SalesOrganization       = _CustomerSales.SalesOrganization
                                                                       and $projection.DistributionChannel     = _CustomerSales.DistributionChannel
                                                                       and $projection.Division                = _CustomerSales.Division
{
  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,
      _CustomerSales
}
where
     knvp_prc.assignment_id = '000000000002'
  or knvp_prc.assignment_id is initial

Learn More