I_BPSupplierPartnerFunction

DDL: I_BPSUPPLIERPARTNERFUNCTION SQL: IBPSUPLRPARTFUNC Type: view BASIC
13 Fields 2 Data Sources 1 Associations

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.

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 #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner
KEY PurchasingOrganization wyt3 ekorg Purchasing Org.
KEY PartnerFunction wyt3 parvw Task Processor
KEY PartnerCounter wyt3 parza Partner counter
ContactPerson wyt3 parnr Responsible
PartnerFunctionType tpar nrart Partner Type
pernrelseendasReferenceSupplier
Supplier wyt3 lifnr Vendor no.
SupplierSubrange wyt3 ltsnr Suppl. Subrange
Plant wyt3 werks Receiving Plant
DefaultPartner wyt3 defpa Default Partner
BusinessPartnerUUID _SupplierToBusinessPartner BusinessPartnerUUID UUID
_SupplierToBusinessPartner _SupplierToBusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPSupplierPartnerFunction.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IBPSUPLRPARTFUNC

CREATE VIEW I_BPSupplierPartnerFunction AS
SELECT
  _SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  wyt3.ekorg AS PurchasingOrganization,
  wyt3.parvw AS PartnerFunction,
  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 AS pernrelseendasReferenceSupplier,
  wyt3.lifnr AS Supplier,
  wyt3.ltsnr AS SupplierSubrange,
  wyt3.werks AS Plant,
  wyt3.defpa AS DefaultPartner,
  _SupplierToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID
FROM wyt3
INNER JOIN tpar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierToBusinessPartner AS _SupplierToBusinessPartner ON _SupplierToBusinessPartner.Supplier = Supplier  -- association [1..1]
;

Learn More