I_BPCUSTPARTNERFUNCTIONSPROC

CDS View

BP Customer Partner Functions Data

I_BPCUSTPARTNERFUNCTIONSPROC is a CDS View in S/4HANA. BP Customer Partner Functions Data. It contains 10 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 10 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPCustPartnerFunctionGov view_entity from COMPOSITE BP Customer Partner Function Governance
I_BPCustPartnerFunctionsProcTP view_entity from TRANSACTIONAL BP Customer Partner Functions Data - TP
I_BPCustPrtnFuncProcChanges view_entity from TRANSACTIONAL BP Customer Partner Function Changes
I_BPCustPrtnFuncProcChanges view_entity union_all TRANSACTIONAL BP Customer Partner Function Changes

Fields (10)

KeyField CDS FieldsUsed in Views
KEY DistributionChannel DistributionChannel 1
KEY Division Division 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
KEY PartnerCounter PartnerCounter 1
KEY PartnerFunction PartnerFunction 1
KEY SalesOrganization SalesOrganization 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@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