A_CustSalesPartnerFunc

DDL: A_CUSTSALESPARTNERFUNC SQL: ACUSTPARTNERFUNC Type: view BASIC

Sales Partner Functions

A_CustSalesPartnerFunc is a Basic CDS View that provides data about "Sales Partner Functions" in SAP S/4HANA. It reads from 1 data source (I_CustSalesPartnerFunc) and exposes 15 fields with key fields Customer, SalesOrganization, DistributionChannel, Division, PartnerCounter.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_CustSalesPartnerFunc I_CustSalesPartnerFunc from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACUSTPARTNERFUNC view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Sales Partner Functions view
AbapCatalog.preserveKey true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY SalesOrganization SalesOrganization
KEY DistributionChannel DistributionChannel
KEY Division Division
KEY PartnerCounter PartnerCounter
KEY PartnerFunction PartnerFunction
BPCustomerNumber BPCustomerNumber
CustomerPartnerDescription CustomerPartnerDescription
DefaultPartner DefaultPartner
Supplier Supplier
PersonnelNumber PersonnelNumber
ContactPerson ContactPerson
AddressID AddressID
AuthorizationGroup
_CustomerSalesArea _CustomerSalesArea 
@AbapCatalog.sqlViewName: 'ACUSTPARTNERFUNC'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Sales Partner Functions'
@AbapCatalog.preserveKey:true
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true

define view A_CustSalesPartnerFunc as select from I_CustSalesPartnerFunc 

  association[1..1] to A_CustomerSalesArea as _CustomerSalesArea on  $projection.Customer = _CustomerSalesArea.Customer 
                                                                 and $projection.SalesOrganization = _CustomerSalesArea.SalesOrganization 
                                                                 and $projection.DistributionChannel = _CustomerSalesArea.DistributionChannel
                                                                 and $projection.Division = _CustomerSalesArea.Division
                                                                 
{
  key Customer, 
  key SalesOrganization, 
  key DistributionChannel, 
  key Division, 
  key PartnerCounter, 
  key PartnerFunction, 
      BPCustomerNumber, 
      CustomerPartnerDescription, 
      DefaultPartner,
      Supplier,
      PersonnelNumber,
      ContactPerson,
      AddressID,
      _CustomerSalesArea._Customer.AuthorizationGroup,
      _CustomerSalesArea        
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_CUSTOMER",
"A_CUSTOMERSALESAREA",
"I_CUSTSALESPARTNERFUNC"
],
"ASSOCIATED":
[
"A_CUSTOMERSALESAREA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More