P_SalesDocumentItemCount

DDL: P_SALESDOCUMENTITEMCOUNT SQL: PSLSDOCITMCOUNT Type: view CONSUMPTION

Number of Sales Document Items

P_SalesDocumentItemCount is a Consumption CDS View that provides data about "Number of Sales Document Items" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItemBasic) and exposes 2 fields with key field SalesDocument.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItemBasic I_SalesDocumentItemBasic from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSLSDOCITMCOUNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Number of Sales Document Items view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
NmbrOfSlsDocItems 
@AbapCatalog.sqlViewName: 'PSLSDOCITMCOUNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Number of Sales Document Items'

@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_SalesDocumentItemCount
  as select from I_SalesDocumentItemBasic
{

  key SalesDocument,

      count(*) as NmbrOfSlsDocItems

}
group by
  SalesDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTITEMBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More