P_ARCustSalesPartnerFunc

DDL: P_ARCUSTSALESPARTNERFUNC SQL: PARCUSTPRFNC Type: view CONSUMPTION Package: ODATA_CUSTOMER_LIST

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. Part of development package ODATA_CUSTOMER_LIST.

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_PersonWorkAgreement_1 _Employee $projection.PersonnelNumber = _Employee.PersonWorkAgreement

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 _Employee PersonFullName 
@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_PersonWorkAgreement_1                 as _Employee                 on $projection.PersonnelNumber = _Employee.PersonWorkAgreement
    
{
  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.PersonFullName as EmployeeFullName

}
where 
( _CustSalesPartnerFunc.PartnerFunction = 'ZM' or _CustSalesPartnerFunc.PartnerFunction = 'VE' )
and
_CustSalesPartnerFunc.PersonnelNumber is not initial

Learn More