P_FSITEMMAPPINGITEMCNTD

CDS View

P_FSITEMMAPPINGITEMCNTD is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FSITEMMAPPINGHEADERDEF view left_outer COMPOSITE

Fields (1)

KeyField CDS FieldsUsed 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

;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FSITEMMAPPINGITEMDRAFT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More