P_ARCustSalesPartnerFunc

DDL: P_ARCUSTSALESPARTNERFUNC SQL: PARCUSTPRFNC Type: view CONSUMPTION

Customer Sales Area Partner Function

P_ARCustSalesPartnerFunc is a Consumption CDS View that provides data about "Customer Sales Area Partner Function" in SAP S/4HANA. It reads from 1 data source (I_CustSalesPartnerFunc) and exposes 12 fields with key fields Customer, SalesOrganization, DistributionChannel, Division, PartnerCounter. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_CustSalesPartnerFunc _CustSalesPartnerFunc from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer _CustSalesPartnerFunc.BPCustomerNumber = _Customer.Customer
[1] I_Employment _Employee $projection.PersonnelNumber = _Employee.EmploymentInternalID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PARCUSTPRFNC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Customer Sales Area Partner Function view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustSalesPartnerFunc Customer
KEY SalesOrganization I_CustSalesPartnerFunc SalesOrganization
KEY DistributionChannel I_CustSalesPartnerFunc DistributionChannel
KEY Division I_CustSalesPartnerFunc Division
KEY PartnerCounter I_CustSalesPartnerFunc PartnerCounter
KEY PartnerFunction I_CustSalesPartnerFunc PartnerFunction
BPCustomerNumber I_CustSalesPartnerFunc BPCustomerNumber
PersonnelNumber I_CustSalesPartnerFunc PersonnelNumber
CustomerPartnerDescription I_CustSalesPartnerFunc CustomerPartnerDescription
DefaultPartner I_CustSalesPartnerFunc DefaultPartner
BusinessPartnerName
EmployeeFullName 
@AbapCatalog.sqlViewName: 'PARCUSTPRFNC'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Customer Sales Area Partner Function'

@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_ARCustSalesPartnerFunc 
  as select from I_CustSalesPartnerFunc as _CustSalesPartnerFunc

  association [0..1] to I_Customer as _Customer
    on _CustSalesPartnerFunc.BPCustomerNumber = _Customer.Customer
    
  association [1]    to I_Employment                 as _Employee                 on $projection.PersonnelNumber = _Employee.EmploymentInternalID
    
{
  key _CustSalesPartnerFunc.Customer,
  key _CustSalesPartnerFunc.SalesOrganization,
  key _CustSalesPartnerFunc.DistributionChannel,
  key _CustSalesPartnerFunc.Division,
  key _CustSalesPartnerFunc.PartnerCounter,
  key _CustSalesPartnerFunc.PartnerFunction,
      _CustSalesPartnerFunc.BPCustomerNumber,
      _CustSalesPartnerFunc.PersonnelNumber,
      _CustSalesPartnerFunc.CustomerPartnerDescription,
      _CustSalesPartnerFunc.DefaultPartner,
      _Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartnerName,
      _Employee._Employee.EmployeeFullName

}
where 
( _CustSalesPartnerFunc.PartnerFunction = 'ZM' or _CustSalesPartnerFunc.PartnerFunction = 'VE' )

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_CUSTSALESPARTNERFUNC",
"I_EMPLOYEE",
"I_EMPLOYMENT"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_EMPLOYMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More