I_CustSalesPartnerFunc_2

DDL: I_CUSTSALESPARTNERFUNC_2 SQL: ICUSTPARTFUNC2 Type: view BASIC

Customer Sales Area Partner Function

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

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
knvp knvp from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_Division _Division $projection.Division = _Division.Division
[0..1] I_CustSalesPartnerCounter _CustSalesPartnerCounter $projection.PartnerCounter = _CustSalesPartnerCounter.PartnerCounter

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPARTFUNC2 view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey PartnerFunction view
Analytics.internalName #LOCAL view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Customer Sales Area Partner Function view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Customer knvp kunnr
KEY SalesOrganization knvp vkorg
KEY DistributionChannel knvp vtweg
KEY Division knvp spart
KEY PartnerCounter knvp parza
KEY PartnerFunction
BPCustomerNumber knvp kunn2
CustomerPartnerDescription knvp knref
DefaultPartner knvp defpa
Supplier knvp lifnr
PersonnelNumber knvp pernr
ContactPerson knvp parnr
AddressID knvp adrnr
_CustomerSalesArea _CustomerSalesArea
_Customer _Customer
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_CustSalesPartnerCounter _CustSalesPartnerCounter 
@AbapCatalog.sqlViewName: 'ICUSTPARTFUNC2'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey:'PartnerFunction'
@Analytics.internalName:#LOCAL 
@AbapCatalog.preserveKey:true 
@AccessControl.privilegedAssociations:  [ '_CustSalesPartnerCounter']
@AccessControl.personalData.blockingIndicator: ['_CustomerSalesArea.IsBusinessPurposeCompleted'] 
@Metadata.allowExtensions:true
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]                                     
@ObjectModel.modelingPattern: #NONE                                     
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Customer Sales Area Partner Function'
@Metadata.ignorePropagatedAnnotations: true

define view I_CustSalesPartnerFunc_2 as select from knvp

association[1..1] to I_CustomerSalesArea as _CustomerSalesArea on $projection.Customer =  _CustomerSalesArea.Customer 
                                                               and $projection.SalesOrganization =  _CustomerSalesArea.SalesOrganization 
                                                               and $projection.DistributionChannel =  _CustomerSalesArea.DistributionChannel
                                                               and $projection.Division =  _CustomerSalesArea.Division 

association[1..1] to I_Customer as _Customer on $projection.Customer =  _Customer.Customer
association [0..1] to I_SalesOrganization    as _SalesOrganization   on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization  
association [0..1] to I_DistributionChannel  as _DistributionChannel on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel
association [0..1] to I_Division             as _Division            on  $projection.Division = _Division.Division
association [0..1] to I_CustSalesPartnerCounter      as _CustSalesPartnerCounter     on $projection.PartnerCounter = _CustSalesPartnerCounter.PartnerCounter  
{
 @ObjectModel.foreignKey.association: '_Customer'
  key knvp.kunnr                                                      as Customer,
  @ObjectModel.foreignKey.association: '_SalesOrganization'
  key knvp.vkorg                                                      as SalesOrganization,
  @ObjectModel.foreignKey.association: '_DistributionChannel'
  key knvp.vtweg                                                      as DistributionChannel,
  @ObjectModel.foreignKey.association: '_Division'
  key knvp.spart                                                      as Division,
  @ObjectModel.foreignKey.association: '_CustSalesPartnerCounter'
  key knvp.parza                                                      as PartnerCounter,
  key cast(knvp.parvw as parvw_unv)                                   as PartnerFunction, //partner role

      knvp.kunn2                                                      as BPCustomerNumber,
      knvp.knref                                                      as CustomerPartnerDescription,
      knvp.defpa                                                      as DefaultPartner,
      knvp.lifnr                                                      as Supplier,
      knvp.pernr                                                      as PersonnelNumber,
      knvp.parnr                                                      as ContactPerson,
      knvp.adrnr                                                      as AddressID,
      //_CustomerSalesArea._Customer.AuthorizationGroup, *Field removed to reduce complexity, use from association instead*

      _CustomerSalesArea,
      _Customer,
      _SalesOrganization,
      _DistributionChannel,
      _Division,    
      _CustSalesPartnerCounter
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNVP"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_CUSTOMERSALESAREA",
"I_CUSTSALESPARTNERCOUNTER",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESORGANIZATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More