I_BPSupplierPartnerFunction

DDL: I_BPSUPPLIERPARTNERFUNCTION SQL: IBPSUPLRPARTFUNC Type: view BASIC

Supplier Partner Function WYT3

I_BPSupplierPartnerFunction is a Basic CDS View that provides data about "Supplier Partner Function WYT3" in SAP S/4HANA. It reads from 2 data sources (tpar, wyt3) and exposes 13 fields with key fields BusinessPartner, PurchasingOrganization, PartnerFunction, PartnerCounter. It has 1 association to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
tpar tpar inner
wyt3 wyt3 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SupplierToBusinessPartner _SupplierToBusinessPartner _SupplierToBusinessPartner.Supplier = $projection.Supplier

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPSUPLRPARTFUNC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Supplier Partner Function WYT3 view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY PurchasingOrganization wyt3 ekorg
KEY PartnerFunction wyt3 parvw
KEY PartnerCounter wyt3 parza
ContactPerson wyt3 parnr
PartnerFunctionType tpar nrart
pernrelseendasReferenceSupplier
Supplier wyt3 lifnr
SupplierSubrange wyt3 ltsnr
Plant wyt3 werks
DefaultPartner wyt3 defpa
BusinessPartnerUUID _SupplierToBusinessPartner BusinessPartnerUUID
_SupplierToBusinessPartner _SupplierToBusinessPartner 
@AbapCatalog.sqlViewName: 'IBPSUPLRPARTFUNC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Supplier Partner Function WYT3'
@VDM.viewType: #BASIC

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

define view I_BPSupplierPartnerFunction
  as select from wyt3
    inner join   tpar on wyt3.parvw = tpar.parvw                                                                                  
  association [1..1] to I_SupplierToBusinessPartner as _SupplierToBusinessPartner on _SupplierToBusinessPartner.Supplier = $projection.Supplier
  
{
  key _SupplierToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartner,
  key wyt3.ekorg                                                  as PurchasingOrganization,
  key wyt3.parvw                                                  as PartnerFunction,
  key wyt3.parza                                                  as PartnerCounter,
      wyt3.parnr                                                  as ContactPerson,
      tpar.nrart                                                  as PartnerFunctionType,
      case
        when tpar.nrart = 'LI'
          then wyt3.lifn2
        when tpar.nrart = 'WK'
          then wyt3.werks
        when tpar.nrart = 'AP'
          then wyt3.parnr
        when tpar.nrart = 'PE'
          then wyt3.pernr
        else ''
      end                                                         as ReferenceSupplier,
      wyt3.lifnr                                                  as Supplier,
      wyt3.ltsnr                                                  as SupplierSubrange,
      wyt3.werks                                                  as Plant,
      wyt3.defpa                                                  as DefaultPartner,

      _SupplierToBusinessPartner.BusinessPartnerUUID              as BusinessPartnerUUID,
      _SupplierToBusinessPartner
}

Learn More