P_FSITEMUNMAPPEDGLACCOUNTCNT
FSItem Mapping - Unmapped GL Account Count
P_FSITEMUNMAPPEDGLACCOUNTCNT is a CDS View in S/4HANA. FSItem Mapping - Unmapped GL Account Count. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_FSITEMMAPPINGHEADERDEF | view | left_outer | COMPOSITE | Financial Statement Item Mapping Header |
@AbapCatalog.sqlViewName: 'PFSMUMGLACNT'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
dataClass: #MASTER,
serviceQuality: #B,
sizeCategory: #XL
}
define view P_FSItemUnmappedGLAccountCnt
as select from P_FSItemMappingGLAccountAll
{
key FSItemMappingID,
key ConsolidationChartOfAccounts,
key ChartOfAccounts,
key FSItemMappingRevision,
cast(sum(Counts) as int4) as TotalNmbrOfNotMappedGLAccounts
}
where
_Item.GLAccount is null
and GLAccount is not null
group by
FSItemMappingID,
ConsolidationChartOfAccounts,
ChartOfAccounts,
FSItemMappingRevision
;