I_BPSupplierPartnerFunctionTP

DDL: I_BPSUPPLIERPARTNERFUNCTIONTP SQL: IBPSUPPARTFUNCTP Type: view TRANSACTIONAL
22 Fields 1 Data Sources 3 Associations

Supplier Partner Function TP

I_BPSupplierPartnerFunctionTP is a Transactional CDS View that provides data about "Supplier Partner Function TP" in SAP S/4HANA. It reads from 1 data source (I_BPSupplierPartnerFunction) and exposes 22 fields with key fields BusinessPartner, PurchasingOrganization, PartnerFunction, PartnerCounter. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPSupplierPartnerFunction SupplierPartnerFunc from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerPurgOrgTP _BPPurchasingOrg $projection.PurchasingOrganization = _BPPurchasingOrg.PurchasingOrganization and $projection.BusinessPartner = _BPPurchasingOrg.BusinessPartner
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_PartnerFunctionText _PartnerFunctionText $projection.PartnerFunctionForEdit = _PartnerFunctionText.PartnerFunction and _PartnerFunctionText.Language = $session.system_language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IBPSUPPARTFUNCTP 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 TP view
ObjectModel.writeDraftPersistence BPsupl_pf_d view
ObjectModel.draftEnabled true view
VDM.viewType #TRANSACTIONAL view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPSupplierPartnerFunction BusinessPartner Issuing Authority
KEY PurchasingOrganization I_BPSupplierPartnerFunction PurchasingOrganization Purchasing Organization
KEY PartnerFunction I_BPSupplierPartnerFunction PartnerFunction Partner Functn
KEY PartnerCounter I_BPSupplierPartnerFunction PartnerCounter Partner counter
BusinessPartnerForEdit I_BPSupplierPartnerFunction BusinessPartner Issuing Authority
PurchasingOrganizationForEdit I_BPSupplierPartnerFunction PurchasingOrganization Purchasing Organization
PartnerFunctionForEdit I_BPSupplierPartnerFunction PartnerFunction Partner Functn
PartnerCounterForEdit I_BPSupplierPartnerFunction PartnerCounter Partner counter
Supplier I_BPSupplierPartnerFunction Supplier Supplier
BusinessPartnerGrouping _BusinessPartner BusinessPartnerGrouping Grouping
ContactPerson I_BPSupplierPartnerFunction ContactPerson Contact Person Key
DefaultPartner I_BPSupplierPartnerFunction DefaultPartner Default Partner
PartnerFunctionType I_BPSupplierPartnerFunction PartnerFunctionType Partner Type
ReferenceSupplier I_BPSupplierPartnerFunction ReferenceSupplier Ref. to suplr
Plant I_BPSupplierPartnerFunction Plant Valuation Area
SupplierSubrange I_BPSupplierPartnerFunction SupplierSubrange Suppl. Subrange
Partner
BusinessPartnerName
PartnerFunctionName _PartnerFunctionText PartnerFunctionName Name
_BPPurchasingOrg _BPPurchasingOrg
_BusinessPartner _BusinessPartner
_PartnerFunctionText _PartnerFunctionText

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_BPSupplierPartnerFunctionTP.
-- 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: IBPSUPPARTFUNCTP

CREATE VIEW I_BPSupplierPartnerFunctionTP AS
SELECT
  SupplierPartnerFunc.BusinessPartner AS BusinessPartner,
  SupplierPartnerFunc.PurchasingOrganization AS PurchasingOrganization,
  SupplierPartnerFunc.PartnerFunction AS PartnerFunction,
  SupplierPartnerFunc.PartnerCounter AS PartnerCounter,
  SupplierPartnerFunc.BusinessPartner AS BusinessPartnerForEdit,
  SupplierPartnerFunc.PurchasingOrganization AS PurchasingOrganizationForEdit,
  SupplierPartnerFunc.PartnerFunction AS PartnerFunctionForEdit,
  SupplierPartnerFunc.PartnerCounter AS PartnerCounterForEdit,
  SupplierPartnerFunc.Supplier AS Supplier,
  _BusinessPartner.BusinessPartnerGrouping AS BusinessPartnerGrouping,
  SupplierPartnerFunc.ContactPerson AS ContactPerson,
  SupplierPartnerFunc.DefaultPartner AS DefaultPartner,
  SupplierPartnerFunc.PartnerFunctionType AS PartnerFunctionType,
  SupplierPartnerFunc.ReferenceSupplier AS ReferenceSupplier,
  SupplierPartnerFunc.Plant AS Plant,
  SupplierPartnerFunc.SupplierSubrange AS SupplierSubrange,
  _SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS Partner,
  coalesce(_SupplierToBusinessPartner._BusinessPartner.BusinessPartnerName, _SupplierToBusinessPartner._BusinessPartner.BusinessPartnerFullName) AS BusinessPartnerName,
  _PartnerFunctionText.PartnerFunctionName AS PartnerFunctionName
FROM I_BPSupplierPartnerFunction AS SupplierPartnerFunc
LEFT OUTER JOIN I_BusinessPartnerPurgOrgTP AS _BPPurchasingOrg ON PurchasingOrganization = _BPPurchasingOrg.PurchasingOrganization AND BusinessPartner = _BPPurchasingOrg.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON PartnerFunctionForEdit = _PartnerFunctionText.PartnerFunction AND _PartnerFunctionText.Language = $session.system_language  -- association [0..1]
;

Learn More