C_BPAddlCustPartFunc

DDL: C_BPADDLCUSTPARTFUNC SQL: CBPADDCSAPF Type: view CONSUMPTION
26 Fields 1 Data Sources 6 Associations

C view for Additional Partner Functions

C_BPAddlCustPartFunc is a Consumption CDS View that provides data about "C view for Additional Partner Functions" in SAP S/4HANA. It reads from 1 data source (I_BPAddlCustPartFuncTP) and exposes 26 fields with key fields BusinessPartner, Customer, SalesOrganization, DistributionChannel, Division. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPAddlCustPartFuncTP BusinessPartnerPartFunc from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BPAddlCustSalesArea _BusinessPartnerSalesArea $projection.BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner and $projection.Customer = _BusinessPartnerSalesArea.Customer 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] I_ContactPerson _ContactPersonValueHelp $projection.ContactPerson = _ContactPersonValueHelp.ContactPerson
[0..*] C_Partfunctextvhtemp _PartFuncText $projection.PartnerFunction = _PartFuncText.PartnerFunction

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CBPADDCSAPF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label C view for Additional Partner Functions view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C 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 (26)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPAddlCustPartFuncTP BusinessPartner Issuing Authority
KEY Customer I_BPAddlCustPartFuncTP Customer Sold-to Party
KEY SalesOrganization I_BPAddlCustPartFuncTP SalesOrganization Sales Organization
KEY DistributionChannel I_BPAddlCustPartFuncTP DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_BPAddlCustPartFuncTP Division Internal Division ID
KEY PartnerFunction I_BPAddlCustPartFuncTP PartnerFunction Partner Functn
KEY PartnerCounter I_BPAddlCustPartFuncTP PartnerCounter Partner counter
BusinessPartnerForEdit I_BPAddlCustPartFuncTP BusinessPartnerForEdit Busn. Partner
CustomerForEdit I_BPAddlCustPartFuncTP CustomerForEdit Customer
SalesOrganizationForEdit I_BPAddlCustPartFuncTP SalesOrganizationForEdit Sales Org.
DistributionChannelForEdit I_BPAddlCustPartFuncTP DistributionChannelForEdit RefDistCh-Cust/Mat.
DivisionForEdit I_BPAddlCustPartFuncTP DivisionForEdit Division
PartnerCounterForEdit I_BPAddlCustPartFuncTP PartnerCounterForEdit Partner counter
PartnerFunctionForEdit I_BPAddlCustPartFuncTP PartnerFunctionForEdit Partner Funct.
PartnerFunctionType I_BPAddlCustPartFuncTP PartnerFunctionType Partner Type
BPCustomerNumber I_BPAddlCustPartFuncTP BPCustomerNumber Customer
CustomerPartnerDescription I_BPAddlCustPartFuncTP CustomerPartnerDescription Partner desc.
DefaultPartner I_BPAddlCustPartFuncTP DefaultPartner Default Partner
ContactPerson I_BPAddlCustPartFuncTP ContactPerson Contact Person Key
BusinessPartnerGrouping I_BPAddlCustPartFuncTP BusinessPartnerGrouping Grouping
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BusinessPartnerSalesArea _BusinessPartnerSalesArea
_PartnerNameValueHelp _PartnerNameValueHelp
_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_BPAddlCustPartFunc.
-- 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: CBPADDCSAPF

CREATE VIEW C_BPAddlCustPartFunc AS
SELECT
  BusinessPartnerPartFunc.BusinessPartner AS BusinessPartner,
  BusinessPartnerPartFunc.Customer AS Customer,
  BusinessPartnerPartFunc.SalesOrganization AS SalesOrganization,
  BusinessPartnerPartFunc.DistributionChannel AS DistributionChannel,
  BusinessPartnerPartFunc.Division AS Division,
  BusinessPartnerPartFunc.PartnerFunction AS PartnerFunction,
  BusinessPartnerPartFunc.PartnerCounter AS PartnerCounter,
  BusinessPartnerPartFunc.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerPartFunc.CustomerForEdit AS CustomerForEdit,
  BusinessPartnerPartFunc.SalesOrganizationForEdit AS SalesOrganizationForEdit,
  BusinessPartnerPartFunc.DistributionChannelForEdit AS DistributionChannelForEdit,
  BusinessPartnerPartFunc.DivisionForEdit AS DivisionForEdit,
  BusinessPartnerPartFunc.PartnerCounterForEdit AS PartnerCounterForEdit,
  BusinessPartnerPartFunc.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  BusinessPartnerPartFunc.PartnerFunctionType AS PartnerFunctionType,
  BusinessPartnerPartFunc.BPCustomerNumber AS BPCustomerNumber,
  BusinessPartnerPartFunc.CustomerPartnerDescription AS CustomerPartnerDescription,
  BusinessPartnerPartFunc.DefaultPartner AS DefaultPartner,
  BusinessPartnerPartFunc.ContactPerson AS ContactPerson,
  BusinessPartnerPartFunc.BusinessPartnerGrouping AS BusinessPartnerGrouping
FROM I_BPAddlCustPartFuncTP AS BusinessPartnerPartFunc
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BPAddlCustSalesArea AS _BusinessPartnerSalesArea ON BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner AND Customer = _BusinessPartnerSalesArea.Customer 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 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