I_BPSUPPLIERPARTNERFUNCTION

CDS View

Supplier Partner Function WYT3

I_BPSUPPLIERPARTNERFUNCTION is a CDS View in S/4HANA. Supplier Partner Function WYT3. It contains 11 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 11 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPSupplierPartnerFunctionTP view from TRANSACTIONAL Supplier Partner Function TP

Fields (11)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit 1
KEY PartnerCounter PartnerCounter,PartnerCounterForEdit 1
KEY PartnerFunction PartnerFunction,PartnerFunctionForEdit 1
KEY PurchasingOrganization PurchasingOrganization,PurchasingOrganizationForEdit 1
ContactPerson ContactPerson 1
DefaultPartner DefaultPartner 1
PartnerFunctionType PartnerFunctionType 1
Plant Plant 1
ReferenceSupplier ReferenceSupplier 1
Supplier Supplier 1
SupplierSubrange SupplierSubrange 1 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SUPPLIERTOBUSINESSPARTNER",
"TPAR",
"WYT3"
],
"ASSOCIATED":
[
"I_SUPPLIERTOBUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More