C_BusinessPartnerPartFunc

DDL: C_BUSINESSPARTNERPARTFUNC SQL: CBUPAPARTFUNCN Type: view CONSUMPTION Package: VDM_MD_BP
34 Fields 1 Data Sources 8 Associations

Consumption view for BUPA Part Func

C_BusinessPartnerPartFunc is a Consumption CDS View that provides data about "Consumption view for BUPA Part Func" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerPartFuncTP) and exposes 34 fields with key fields SalesOrganization, DistributionChannel, Division, PartnerFunction, PartnerCounter. It has 8 associations to related views. Part of development package VDM_MD_BP.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerPartFuncTP BusinessPartnerPartFunc from

Associations (8)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerSalesArea _BusinessPartnerSalesArea $projection.BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner and $projection.SalesOrganization = _BusinessPartnerSalesArea.SalesOrganization and $projection.DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel and $projection.Division = _BusinessPartnerSalesArea.Division
[0..1] I_Customer_VH _PartnerNameValueHelp $projection.BPCustomerNumber = _PartnerNameValueHelp.Customer
[0..1] C_BPPartnerFunctionNumberVH _PartnerNumberValueHelp $projection.BPCustomerNumber = _PartnerNumberValueHelp.BusinessPartner and $projection.PartnerFunctionType = _PartnerNumberValueHelp.PartnerFunctionType
[0..*] C_BPPartnerFunctionNumberText _PartnerNumberValueHelpText $projection.BPCustomerNumber = _PartnerNumberValueHelpText.BusinessPartner and $projection.PartnerFunctionType = _PartnerNumberValueHelpText.PartnerFunctionType
[0..1] I_ContactPerson _ContactPersonValueHelp $projection.ContactPerson = _ContactPersonValueHelp.ContactPerson
[0..*] C_Partfunctextvhtemp _PartFuncText $projection.PartnerFunction = _PartFuncText.PartnerFunction

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CBUPAPARTFUNCN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption view for BUPA Part Func view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Partner Function view
UI.headerInfo.typeNamePlural Partner Function view
UI.headerInfo.title.label Partner Function Description view
UI.headerInfo.title.value PartnerFunctionName view
VDM.viewType #CONSUMPTION view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization I_BusinessPartnerPartFuncTP SalesOrganization Sales Organization
KEY DistributionChannel I_BusinessPartnerPartFuncTP DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_BusinessPartnerPartFuncTP Division Internal Division ID
KEY PartnerFunction I_BusinessPartnerPartFuncTP PartnerFunction Partner Functn
KEY PartnerCounter I_BusinessPartnerPartFuncTP PartnerCounter Partner counter
KEY BusinessPartner I_BusinessPartnerPartFuncTP BusinessPartner Issuing Authority
BusinessPartnerForEdit I_BusinessPartnerPartFuncTP BusinessPartnerForEdit Busn. Partner
PartnerFunctionForEdit I_BusinessPartnerPartFuncTP PartnerFunctionForEdit Partner Funct.
PartnerFunctionName I_BusinessPartnerPartFuncTP PartnerFunctionName Name
PartnerFunctionType I_BusinessPartnerPartFuncTP PartnerFunctionType Partner Type
BPCustomerNumber I_BusinessPartnerPartFuncTP BPCustomerNumber Customer
CustomerPartnerDescription I_BusinessPartnerPartFuncTP CustomerPartnerDescription Partner desc.
DefaultPartner I_BusinessPartnerPartFuncTP DefaultPartner Default Partner
ContactPerson I_BusinessPartnerPartFuncTP ContactPerson Contact Person Key
SalesOrganizationForEdit I_BusinessPartnerPartFuncTP SalesOrganizationForEdit Sales Org.
DistributionChannelForEdit I_BusinessPartnerPartFuncTP DistributionChannelForEdit RefDistCh-Cust/Mat.
DivisionForEdit I_BusinessPartnerPartFuncTP DivisionForEdit Division
PartnerCounterForEdit I_BusinessPartnerPartFuncTP PartnerCounterForEdit Partner counter
Customer I_BusinessPartnerPartFuncTP Customer Sold-to Party
BusinessPartnerUUID I_BusinessPartnerPartFuncTP BusinessPartnerUUID UUID
AddressID I_BusinessPartnerPartFuncTP AddressID Ship-to address
IsMultipleAccountAssignment
AssignedBusinessPartner
PartnerDescription
FormattedAddress I_BusinessPartnerPartFuncTP FormattedAddress
BusinessPartnerGrouping I_BusinessPartnerPartFuncTP BusinessPartnerGrouping Grouping
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BusinessPartnerSalesArea _BusinessPartnerSalesArea
_PartnerNameValueHelp _PartnerNameValueHelp
_PartnerNumberValueHelp _PartnerNumberValueHelp
_PartnerNumberValueHelpText _PartnerNumberValueHelpText
_ContactPersonValueHelp _ContactPersonValueHelp
_PartFuncText _PartFuncText

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 C_BusinessPartnerPartFunc.
-- 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: CBUPAPARTFUNCN

CREATE VIEW C_BusinessPartnerPartFunc AS
SELECT
  BusinessPartnerPartFunc.SalesOrganization AS SalesOrganization,
  BusinessPartnerPartFunc.DistributionChannel AS DistributionChannel,
  BusinessPartnerPartFunc.Division AS Division,
  BusinessPartnerPartFunc.PartnerFunction AS PartnerFunction,
  BusinessPartnerPartFunc.PartnerCounter AS PartnerCounter,
  BusinessPartnerPartFunc.BusinessPartner AS BusinessPartner,
  BusinessPartnerPartFunc.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerPartFunc.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  BusinessPartnerPartFunc.PartnerFunctionName AS PartnerFunctionName,
  BusinessPartnerPartFunc.PartnerFunctionType AS PartnerFunctionType,
  BusinessPartnerPartFunc.BPCustomerNumber AS BPCustomerNumber,
  BusinessPartnerPartFunc.CustomerPartnerDescription AS CustomerPartnerDescription,
  BusinessPartnerPartFunc.DefaultPartner AS DefaultPartner,
  BusinessPartnerPartFunc.ContactPerson AS ContactPerson,
  BusinessPartnerPartFunc.SalesOrganizationForEdit AS SalesOrganizationForEdit,
  BusinessPartnerPartFunc.DistributionChannelForEdit AS DistributionChannelForEdit,
  BusinessPartnerPartFunc.DivisionForEdit AS DivisionForEdit,
  BusinessPartnerPartFunc.PartnerCounterForEdit AS PartnerCounterForEdit,
  BusinessPartnerPartFunc.Customer AS Customer,
  BusinessPartnerPartFunc.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerPartFunc.AddressID AS AddressID,
  cast(' ' as abap_boolean preserving type) AS IsMultipleAccountAssignment,
  cast(' ' as bu_partner) AS AssignedBusinessPartner,
  cast(' ' as vtxtm ) AS PartnerDescription,
  BusinessPartnerPartFunc.FormattedAddress AS FormattedAddress,
  BusinessPartnerPartFunc.BusinessPartnerGrouping AS BusinessPartnerGrouping
FROM I_BusinessPartnerPartFuncTP AS BusinessPartnerPartFunc
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerSalesArea AS _BusinessPartnerSalesArea ON BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner AND SalesOrganization = _BusinessPartnerSalesArea.SalesOrganization AND DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel AND Division = _BusinessPartnerSalesArea.Division  -- association [1..1]
LEFT OUTER JOIN I_Customer_VH AS _PartnerNameValueHelp ON BPCustomerNumber = _PartnerNameValueHelp.Customer  -- association [0..1]
LEFT OUTER JOIN C_BPPartnerFunctionNumberVH AS _PartnerNumberValueHelp ON BPCustomerNumber = _PartnerNumberValueHelp.BusinessPartner AND PartnerFunctionType = _PartnerNumberValueHelp.PartnerFunctionType  -- association [0..1]
LEFT OUTER JOIN C_BPPartnerFunctionNumberText AS _PartnerNumberValueHelpText ON BPCustomerNumber = _PartnerNumberValueHelpText.BusinessPartner AND PartnerFunctionType = _PartnerNumberValueHelpText.PartnerFunctionType  -- association [0..*]
LEFT OUTER JOIN I_ContactPerson AS _ContactPersonValueHelp ON ContactPerson = _ContactPersonValueHelp.ContactPerson  -- association [0..1]
LEFT OUTER JOIN C_Partfunctextvhtemp AS _PartFuncText ON PartnerFunction = _PartFuncText.PartnerFunction  -- association [0..*]
;

Learn More