P_FSITEMMAPPINGITEMCNTD
FSItem Mapping Draft - Total Item Count
P_FSITEMMAPPINGITEMCNTD is a CDS View in S/4HANA. FSItem Mapping Draft - Total Item Count. It contains 1 fields. 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 |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| TotalNmbrOfMappedGLAccounts | TotalNmbrOfMappedGLAccounts | 1 |
@AbapCatalog.sqlViewName: 'PFSMITEMCNTD'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
dataClass: #MASTER,
serviceQuality: #B,
sizeCategory: #L
}
define view P_FSITEMMAPPINGITEMCNTD
as select from P_FSitemMappingItemDraft
{
key FSItemMappingID,
key ConsolidationChartOfAccounts,
key ChartOfAccounts,
key FSItemMappingRevision,
access_type,
cast(count(distinct GLAccount) as int4) as TotalNmbrOfMappedGLAccounts
}
where GLAccount <> '' and FinancialStatementItem <> ''
group by
FSItemMappingID,
ConsolidationChartOfAccounts,
ChartOfAccounts,
FSItemMappingRevision,
access_type
;