P_FSITEMUNMAPPEDGLACCOUNTCNT
P_FSITEMUNMAPPEDGLACCOUNTCNT is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_FSITEMMAPPINGHEADERDEF | view | left_outer | COMPOSITE |
@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
;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FSITEMMAPPINGITEM",
"P_FSITEMMAPPINGGLACCOUNTALL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/