C_BusinessPartnerPartFunc

DDL: C_BUSINESSPARTNERPARTFUNC SQL: CBUPAPARTFUNCN Type: view CONSUMPTION

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)

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 (32)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/