P_SlsDocItemNonStdPartnerCount

DDL: P_SLSDOCITEMNONSTDPARTNERCOUNT SQL: PSLSDOCITMNSPTCT Type: view CONSUMPTION Package: SD_CHANGE_COCKPIT_ODATA

Count of non Std Partners in Sls Doc Item

P_SlsDocItemNonStdPartnerCount is a Consumption CDS View that provides data about "Count of non Std Partners in Sls Doc Item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocItemCompletePartner) and exposes 3 fields with key fields SalesDocument, SalesDocumentItem. Part of development package SD_CHANGE_COCKPIT_ODATA.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocItemCompletePartner I_SalesDocItemCompletePartner from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSLSDOCITMNSPTCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Count of non Std Partners in Sls Doc Item view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
KEY SalesDocumentItem SalesDocumentItem
NumberOfAdditionalPartners 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.sqlViewName: 'PSLSDOCITMNSPTCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: { 
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@EndUserText.label: 'Count of non Std Partners in Sls Doc Item'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view P_SlsDocItemNonStdPartnerCount
  as select from I_SalesDocItemCompletePartner
{
  key SalesDocument,
  key SalesDocumentItem,
      count ( * ) as NumberOfAdditionalPartners

}
where // SDDocumentItem != '000000' and

      PartnerFunction != 'AG'
  and PartnerFunction != 'WE'
  and PartnerFunction != 'RE'
  and PartnerFunction != 'RG'
  and PartnerFunction != 'VE'
  and PartnerFunction != 'ZM'
group by
  SalesDocument,
  SalesDocumentItem

Learn More