I_BPAddlCustPartFuncTP

DDL: I_BPADDLCUSTPARTFUNCTP SQL: IBPADDCSAPFTP Type: view TRANSACTIONAL

BO view for Additional Partner Functions

I_BPAddlCustPartFuncTP is a Transactional CDS View that provides data about "BO view for Additional Partner Functions" in SAP S/4HANA. It reads from 2 data sources (I_BPMultipleAssignment, I_CustSalesPartnerFunc) and exposes 22 fields with key fields BusinessPartner, Customer, SalesOrganization, DistributionChannel, Division. It has 2 associations to related views.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
I_BPMultipleAssignment BPMultipleAssignment inner
I_CustSalesPartnerFunc BusinessPartnerPartFunc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BPAddlCustSalesAreaTP _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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDCSAPFTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO view for Additional Partner Functions view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BPADDCSAPF_D view
ObjectModel.draftEnabled true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPMultipleAssignment BusinessPartner
KEY Customer I_CustSalesPartnerFunc Customer
KEY SalesOrganization I_CustSalesPartnerFunc SalesOrganization
KEY DistributionChannel I_CustSalesPartnerFunc DistributionChannel
KEY Division I_CustSalesPartnerFunc Division
KEY PartnerFunction I_CustSalesPartnerFunc PartnerFunction
KEY PartnerCounter I_CustSalesPartnerFunc PartnerCounter
BusinessPartnerForEdit I_BPMultipleAssignment BusinessPartner
CustomerForEdit I_CustSalesPartnerFunc Customer
SalesOrganizationForEdit I_CustSalesPartnerFunc SalesOrganization
DistributionChannelForEdit I_CustSalesPartnerFunc DistributionChannel
DivisionForEdit I_CustSalesPartnerFunc Division
BusinessPartnerGrouping _BusinessPartner BusinessPartnerGrouping
PartnerFunctionForEdit I_CustSalesPartnerFunc PartnerFunction
PartnerCounterForEdit I_CustSalesPartnerFunc PartnerCounter
PartnerFunctionType I_CustSalesPartnerFunc PartnerFunctionType
BPCustomerNumber I_CustSalesPartnerFunc BPCustomerNumber
CustomerPartnerDescription I_CustSalesPartnerFunc CustomerPartnerDescription
DefaultPartner I_CustSalesPartnerFunc DefaultPartner
ContactPerson I_CustSalesPartnerFunc ContactPerson
_BusinessPartner _BusinessPartner
_BusinessPartnerSalesArea _BusinessPartnerSalesArea 
@AbapCatalog.sqlViewName: 'IBPADDCSAPFTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BO view for Additional Partner Functions'

@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true

@ObjectModel.writeDraftPersistence: 'BPADDCSAPF_D'
@ObjectModel.draftEnabled:true

@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@Search.searchable: true //testing 

//@ObjectModel.semanticKey: ['BusinessPartner', 'Customer', 'SalesOrganization', 'DistributionChannel', 'Division', 'PartnerFunction', 'PartnerCounter']


@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_BPAddlCustPartFuncTP

  as select from I_CustSalesPartnerFunc as BusinessPartnerPartFunc inner join I_BPMultipleAssignment as BPMultipleAssignment on BusinessPartnerPartFunc.Customer = BPMultipleAssignment.BPObjectID
  

  association [1..1] to I_BusinessPartnerTP          as _BusinessPartner          on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  

  association [1..1] to I_BPAddlCustSalesAreaTP as _BusinessPartnerSalesArea on $projection.BusinessPartner     = _BusinessPartnerSalesArea.BusinessPartner
                                                                            and $projection.Customer            = _BusinessPartnerSalesArea.Customer
                                                                            and $projection.SalesOrganization   = _BusinessPartnerSalesArea.SalesOrganization
                                                                           and $projection.DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel
                                                                            and $projection.Division            = _BusinessPartnerSalesArea.Division

  
{
  key BPMultipleAssignment.BusinessPartner                         as BusinessPartner,
  @Search.defaultSearchElement: true
  key BusinessPartnerPartFunc.Customer                             as Customer,
  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,

      BPMultipleAssignment.BusinessPartner                      as BusinessPartnerForEdit,

      BusinessPartnerPartFunc.Customer as CustomerForEdit,

      BusinessPartnerPartFunc.SalesOrganization                    as SalesOrganizationForEdit,

      BusinessPartnerPartFunc.DistributionChannel                  as DistributionChannelForEdit,

      BusinessPartnerPartFunc.Division                             as DivisionForEdit,

      _BusinessPartner.BusinessPartnerGrouping                     as BusinessPartnerGrouping,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPartFunc.PartnerFunction                      as PartnerFunctionForEdit,

      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      BusinessPartnerPartFunc.PartnerCounter                       as PartnerCounterForEdit,
      
      BusinessPartnerPartFunc.PartnerFunctionType,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPartFunc.BPCustomerNumber,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPartFunc.CustomerPartnerDescription,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPartFunc.DefaultPartner,
      
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerPartFunc.ContactPerson,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BusinessPartner,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BusinessPartnerSalesArea
      
    

}where BPMultipleAssignment.IsStandardAssignment <> 'X' and BPMultipleAssignment.BPAssignmentCategory = 'CUST'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPMULTIPLEASSIGNMENT",
"I_BUSINESSPARTNERTP",
"I_CUSTSALESPARTNERFUNC"
],
"ASSOCIATED":
[
"I_BPADDLCUSTSALESAREATP",
"I_BUSINESSPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More