P_FSITEMMAPPINGITEMCNT
P_FSITEMMAPPINGITEMCNT 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: '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
;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FSITEMMAPPINGITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/