P_FSITEMCOUNT

CDS View

P_FSITEMCOUNT is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FSITEMMAPPINGHEADERDEF view left_outer COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
TotalNmbrOfFinStmntItems TotalNmbrOfFinStmntItems 1 
@AbapCatalog.sqlViewName: 'PFSITEMCNT'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #L
}

define view P_FSITEMCOUNT
  as select from I_GroupReportingFSItem
{

  key ConsolidationChartOfAccounts,

  cast(count(distinct FinancialStatementItem) as int4) as TotalNmbrOfFinStmntItems

}

group by
  ConsolidationChartOfAccounts

;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GROUPREPORTINGFSITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More