I_BPSuplrPartnerFunctionProc

DDL: I_BPSUPLRPARTNERFUNCTIONPROC Type: view_entity BASIC

BP Supplier Partner Function Proc Data

I_BPSuplrPartnerFunctionProc is a Basic CDS View that provides data about "BP Supplier Partner Function Proc Data" in SAP S/4HANA. It reads from 2 data sources (tpar, wyt3_prc) and exposes 21 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, PurchasingOrganization. It has 2 associations to related views.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
tpar tpar inner
wyt3_prc wyt3_prc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BPSupplierProcess _Supplier wyt3_prc.process_id = _Supplier.MasterDataChangeProcess and wyt3_prc.process_step_no = _Supplier.MDChgProcessStep and wyt3_prc.source_system = _Supplier.MDChgProcessSrceSystem and wyt3_prc.source_id = _Supplier.MDChgProcessSrceObject
[1..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Supplier Partner Function Proc 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 (21)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess wyt3_prc process_id
KEY MDChgProcessStep wyt3_prc process_step_no
KEY MDChgProcessSrceSystem wyt3_prc source_system
KEY MDChgProcessSrceObject wyt3_prc source_id
KEY PurchasingOrganization wyt3_prc ekorg
KEY SupplierSubrange wyt3_prc ltsnr
KEY Plant wyt3_prc werks
KEY PartnerFunction
KEY PartnerCounter wyt3_prc parza
KEY BPAssignmentID wyt3_prc assignment_id
DefaultPartner wyt3_prc defpa
PersonnelNumber wyt3_prc pernr
ContactPerson wyt3_prc parnr
MDChgProcSrceLastChgdDateTime wyt3_prc source_recency
MDChgProcessSourceModified wyt3_prc source_modified
MDChgProcessSourceModifBinary wyt3_prc source_modification_blip
Supplier wyt3_prc lifnr
ReferenceSupplier wyt3_prc lifn2
PartnerFunctionType tpar nrart
_PartnerFunction _PartnerFunction
_Supplier _Supplier 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Supplier Partner Function Proc Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC

define view entity I_BPSuplrPartnerFunctionProc
  as select from wyt3_prc
    inner join   tpar on wyt3_prc.parvw = tpar.parvw

  association [1..1] to I_BPSupplierProcess as _Supplier        on  wyt3_prc.process_id      = _Supplier.MasterDataChangeProcess
                                                                and wyt3_prc.process_step_no = _Supplier.MDChgProcessStep
                                                                and wyt3_prc.source_system   = _Supplier.MDChgProcessSrceSystem
                                                                and wyt3_prc.source_id       = _Supplier.MDChgProcessSrceObject
  association [1..1] to I_PartnerFunction   as _PartnerFunction on  $projection.PartnerFunction = _PartnerFunction.PartnerFunction

{
  key wyt3_prc.process_id               as MasterDataChangeProcess,
  key wyt3_prc.process_step_no          as MDChgProcessStep,
  key wyt3_prc.source_system            as MDChgProcessSrceSystem,
  key wyt3_prc.source_id                as MDChgProcessSrceObject,
  key wyt3_prc.ekorg                    as PurchasingOrganization,
  key wyt3_prc.ltsnr                    as SupplierSubrange,
  key wyt3_prc.werks                    as Plant,
  key cast(wyt3_prc.parvw as parvw_unv) as PartnerFunction,
  key wyt3_prc.parza                    as PartnerCounter,
  key wyt3_prc.assignment_id            as BPAssignmentID,
      wyt3_prc.defpa                    as DefaultPartner,
      wyt3_prc.pernr                    as PersonnelNumber,
      wyt3_prc.parnr                    as ContactPerson,
      wyt3_prc.source_recency           as MDChgProcSrceLastChgdDateTime,
      wyt3_prc.source_modified          as MDChgProcessSourceModified,
      wyt3_prc.source_modification_blip as MDChgProcessSourceModifBinary,
      wyt3_prc.lifnr                    as Supplier,
      wyt3_prc.lifn2                    as ReferenceSupplier,
      tpar.nrart                        as PartnerFunctionType,
      case
        when tpar.nrart = 'LI'
          then wyt3_prc.lifn2
        when tpar.nrart = 'AP'
          then wyt3_prc.parnr
        when tpar.nrart = 'PE'
          then wyt3_prc.pernr
        else '          '
       end                              as PartnerFunctionPartnerNumber,

      /*associations*/
      _PartnerFunction,
      _Supplier
}
where
     wyt3_prc.assignment_id = '000000000001'
  or wyt3_prc.assignment_id is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TPAR",
"WYT3_PRC"
],
"ASSOCIATED":
[
"I_BPSUPPLIERPROCESS",
"I_PARTNERFUNCTION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More