Which tables does F_Mmim_Mdoc_Rev_It_Count use?

F_Mmim_Mdoc_Rev_It_Count reads from 1 data source(s): matdoc.

How many fields does F_Mmim_Mdoc_Rev_It_Count have?

F_Mmim_Mdoc_Rev_It_Count has 3 fields.

F_Mmim_Mdoc_Rev_It_Count

DDL: F_MMIM_MDOC_REV_IT_COUNT SQL: FMMIMMDOCREVITCT Type: view

Counter for reversed Material Document Items

F_Mmim_Mdoc_Rev_It_Count is a CDS View that provides data about "Counter for reversed Material Document Items" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 3 fields.

Data Sources (1)

Source	Alias	Join Type
matdoc	matdoc	from

Annotations (9)

Name	Value	Level
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.sqlViewName	FMMIMMDOCREVITCT	view
EndUserText.label	Counter for reversed Material Document Items	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (3)

Key	Field	Source Table	Source Field	Description
	MaterialDocument		mblnr
	MaterialDocumentYear		mjahr
	MaterialDocReversedItemCounter

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'FMMIMMDOCREVITCT'
@EndUserText.label: 'Counter for reversed Material Document Items'
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view F_Mmim_Mdoc_Rev_It_Count
as
select from matdoc 
{
  mblnr as MaterialDocument,
  mjahr as MaterialDocumentYear, 
  count(*) as MaterialDocReversedItemCounter
}
where cancelled = 'X' and xauto = ''
group by mblnr, mjahr


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

Depth:

F_Mmim_Mdoc_Rev_It_Count view

matdoc