C_BusinessPartnerPartFunc
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 32 fields with key fields SalesOrganization, DistributionChannel, Division, PartnerFunction, PartnerCounter. It has 8 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartnerPartFuncTP | BusinessPartnerPartFunc | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 (32)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesOrganization | I_BusinessPartnerPartFuncTP | SalesOrganization | |
| KEY | DistributionChannel | I_BusinessPartnerPartFuncTP | DistributionChannel | |
| KEY | Division | I_BusinessPartnerPartFuncTP | Division | |
| KEY | PartnerFunction | I_BusinessPartnerPartFuncTP | PartnerFunction | |
| KEY | PartnerCounter | I_BusinessPartnerPartFuncTP | PartnerCounter | |
| KEY | BusinessPartner | I_BusinessPartnerPartFuncTP | BusinessPartner | |
| BusinessPartnerForEdit | I_BusinessPartnerPartFuncTP | BusinessPartnerForEdit | ||
| PartnerFunctionForEdit | I_BusinessPartnerPartFuncTP | PartnerFunctionForEdit | ||
| PartnerFunctionName | I_BusinessPartnerPartFuncTP | PartnerFunctionName | ||
| PartnerFunctionType | I_BusinessPartnerPartFuncTP | PartnerFunctionType | ||
| BPCustomerNumber | I_BusinessPartnerPartFuncTP | BPCustomerNumber | ||
| CustomerPartnerDescription | I_BusinessPartnerPartFuncTP | CustomerPartnerDescription | ||
| DefaultPartner | I_BusinessPartnerPartFuncTP | DefaultPartner | ||
| ContactPerson | I_BusinessPartnerPartFuncTP | ContactPerson | ||
| SalesOrganizationForEdit | I_BusinessPartnerPartFuncTP | SalesOrganizationForEdit | ||
| DistributionChannelForEdit | I_BusinessPartnerPartFuncTP | DistributionChannelForEdit | ||
| DivisionForEdit | I_BusinessPartnerPartFuncTP | DivisionForEdit | ||
| PartnerCounterForEdit | I_BusinessPartnerPartFuncTP | PartnerCounterForEdit | ||
| Customer | I_BusinessPartnerPartFuncTP | Customer | ||
| BusinessPartnerUUID | I_BusinessPartnerPartFuncTP | BusinessPartnerUUID | ||
| AddressID | I_BusinessPartnerPartFuncTP | AddressID | ||
| IsMultipleAccountAssignment | ||||
| FormattedAddress | I_BusinessPartnerPartFuncTP | FormattedAddress | ||
| BusinessPartnerGrouping | I_BusinessPartnerPartFuncTP | BusinessPartnerGrouping | ||
| _BusinessPartnerCustomer | _BusinessPartnerCustomer | |||
| _BusinessPartner | _BusinessPartner | |||
| _BusinessPartnerSalesArea | _BusinessPartnerSalesArea | |||
| _PartnerNameValueHelp | _PartnerNameValueHelp | |||
| _PartnerNumberValueHelp | _PartnerNumberValueHelp | |||
| _PartnerNumberValueHelpText | _PartnerNumberValueHelpText | |||
| _ContactPersonValueHelp | _ContactPersonValueHelp | |||
| _PartFuncText | _PartFuncText |
@AbapCatalog.sqlViewName: 'CBUPAPARTFUNCN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Consumption view for BUPA Part Func'
@Metadata.allowExtensions: true
@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel.semanticKey: [ 'SalesOrganization','DistributionChannel','Division','PartnerFunctionForEdit','PartnerCounter','BusinessPartner']
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@UI.headerInfo:{
typeName: 'Partner Function',
typeNamePlural: 'Partner Function',
title: { label:'Partner Function Description', value: 'PartnerFunctionName' }
}
@VDM.viewType: #CONSUMPTION
define view C_BusinessPartnerPartFunc
as select from I_BusinessPartnerPartFuncTP as BusinessPartnerPartFunc
association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
association [1..1] to C_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to C_BusinessPartnerSalesArea as _BusinessPartnerSalesArea on ////$projection.ParentDraftUUID = _BusinessPartnerSalesArea.DraftUUID and
$projection.BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner
and $projection.SalesOrganization = _BusinessPartnerSalesArea.SalesOrganization
and $projection.DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel
and $projection.Division = _BusinessPartnerSalesArea.Division
// association [0..1] to C_PartFuncVHTemp as _PartnerFunctionValueHelp on $projection.PartnerFunctionForEdit = _PartnerFunctionValueHelp.PartnerFunction
//and $projection.BusinessPartnerGrouping = _PartnerFunctionValueHelp.BusinessPartnerGrouping
//Langauage Independent value helps
association [0..1] to I_Customer_VH as _PartnerNameValueHelp on $projection.BPCustomerNumber = _PartnerNameValueHelp.Customer
association [0..1] to C_BPPartnerFunctionNumberVH as _PartnerNumberValueHelp on $projection.BPCustomerNumber = _PartnerNumberValueHelp.BusinessPartner
and $projection.PartnerFunctionType = _PartnerNumberValueHelp.PartnerFunctionType
association [0..*] to C_BPPartnerFunctionNumberText as _PartnerNumberValueHelpText on $projection.BPCustomerNumber = _PartnerNumberValueHelpText.BusinessPartner
and $projection.PartnerFunctionType = _PartnerNumberValueHelpText.PartnerFunctionType
association [0..1] to I_ContactPerson as _ContactPersonValueHelp on $projection.ContactPerson = _ContactPersonValueHelp.ContactPerson
//TExt views
association [0..*] to C_Partfunctextvhtemp as _PartFuncText on $projection.PartnerFunction = _PartFuncText.PartnerFunction
{
key BusinessPartnerPartFunc.SalesOrganization as SalesOrganization,
key BusinessPartnerPartFunc.DistributionChannel as DistributionChannel,
key BusinessPartnerPartFunc.Division as Division,
key BusinessPartnerPartFunc.PartnerFunction as PartnerFunction,
key BusinessPartnerPartFunc.PartnerCounter as PartnerCounter,
key BusinessPartnerPartFunc.BusinessPartner as BusinessPartner,
BusinessPartnerPartFunc.BusinessPartnerForEdit,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
// @ObjectModel: {
// foreignKey.association: '_PartnerFunctionValueHelp'
// }
@ObjectModel.text.association: '_PartFuncText'
BusinessPartnerPartFunc.PartnerFunctionForEdit,
@ObjectModel.readOnly: true
BusinessPartnerPartFunc.PartnerFunctionName, //partner function description
@ObjectModel.readOnly: true
BusinessPartnerPartFunc.PartnerFunctionType,
@ObjectModel: {
foreignKey.association: '_PartnerNumberValueHelp'
}
//@Consumption.valueHelpDefinition: [{entity: { name: 'C_BPPartnerFunctionNumberVH', element: 'BusinessPartner'},
//additionalBinding: [{element: 'PartnerFunctionType', localElement: 'PartnerFunctionType', usage: #FILTER}]}]
// @Consumption.valueHelp: '_PartnerNumberValueHelp'
// @Consumption.valueHelpDefinition: [
// { entity: { name: 'C_BPPartnerFunctionNumberVH',
// element: 'BusinessPartner' }
// }, {label: 'Business Partners'}]
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
// @ObjectModel.text.element: ['_PartnerNumberValueHelp.BusinessPartnerName']
@ObjectModel.text.association: '_PartnerNumberValueHelpText'
BusinessPartnerPartFunc.BPCustomerNumber,
// @ObjectModel.readOnly : true
// @EndUserText.label: 'Partner Number Description'
// _PartnerNumberValueHelpText.BusinessPartnerName, // Partner Number description added for UI Binding.
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
BusinessPartnerPartFunc.CustomerPartnerDescription,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
BusinessPartnerPartFunc.DefaultPartner,
@ObjectModel.readOnly: true
@ObjectModel: {
foreignKey.association: '_ContactPersonValueHelp'
}
BusinessPartnerPartFunc.ContactPerson,
BusinessPartnerPartFunc.SalesOrganizationForEdit,
BusinessPartnerPartFunc.DistributionChannelForEdit,
BusinessPartnerPartFunc.DivisionForEdit,
BusinessPartnerPartFunc.PartnerCounterForEdit,
BusinessPartnerPartFunc.Customer,
BusinessPartnerPartFunc.BusinessPartnerUUID,
BusinessPartnerPartFunc.AddressID,
@ObjectModel.readOnly: true
@ObjectModel.virtualElement
@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_MLTASEXIST_CALC_EXIT'
cast(' ' as abap_boolean preserving type) as IsMultipleAccountAssignment,
// @UI.hidden: #( _BusinessPartner.BPCustMultiAddrIsActive )
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
BusinessPartnerPartFunc.FormattedAddress,
BusinessPartnerPartFunc.BusinessPartnerGrouping as BusinessPartnerGrouping,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_BusinessPartnerCustomer,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_BusinessPartner,
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
_BusinessPartnerSalesArea,
// _PartnerFunctionValueHelp,
_PartnerNameValueHelp,
_PartnerNumberValueHelp,
_PartnerNumberValueHelpText,
_ContactPersonValueHelp,
_PartFuncText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERPARTFUNCTP"
],
"ASSOCIATED":
[
"C_BPPARTNERFUNCTIONNUMBERTEXT",
"C_BPPARTNERFUNCTIONNUMBERVH",
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSALESAREA",
"C_PARTFUNCTEXTVHTEMP",
"I_CONTACTPERSON",
"I_CUSTOMER_VH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA