P_FSITEMMAPPINGITEMCNT

CDS View

FSItem Mapping - Total Item Count

P_FSITEMMAPPINGITEMCNT is a CDS View in S/4HANA. FSItem Mapping - Total Item Count. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FSITEMMAPPINGHEADERDEF view left_outer COMPOSITE Financial Statement Item Mapping Header 
@AbapCatalog.sqlViewName: 'PFSMITEMCNT'
@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_FSitemMappingItemCnt
  as select from I_FSItemMappingItem
{

  key FSItemMappingID,

  key ConsolidationChartOfAccounts,

  key ChartOfAccounts,

  key FSItemMappingRevision,

 cast(count(distinct GLAccount) as int4) as TotalNmbrOfMappedGLAccounts

}

group by

  FSItemMappingID,

  ConsolidationChartOfAccounts,

  ChartOfAccounts,

  FSItemMappingRevision

;

Learn More