What is C_BOMMassMaintFilter in SAP S/4HANA?

C_BOMMassMaintFilter is a consumption CDS view in SAP S/4HANA. Consumption for Mass Maint Filter It contains 55 fields.

Which tables does C_BOMMassMaintFilter read from?

C_BOMMassMaintFilter reads data from: R_BillOfMaterialItemTP.

What VDM layer is C_BOMMassMaintFilter?

C_BOMMassMaintFilter is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BOMMassMaintFilter

DDL: C_BOMMASSMAINTFILTER SQL: CBOMMASSMNTFTR Type: view CONSUMPTION

55 Fields 1 Data Sources 3 Associations 1 OData Services

Consumption for Mass Maint Filter

C_BOMMassMaintFilter is a Consumption CDS View that provides data about "Consumption for Mass Maint Filter" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialItemTP) and exposes 55 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It has 3 associations to related views. It is exposed through 1 OData service (BOMMASSMAINT).

Data Sources (1)

Source	Alias	Join Type
R_BillOfMaterialItemTP	R_BillOfMaterialItemTP	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	R_BillOfMaterialTP	_MassMaintHeader	`$projection.BillOfMaterial = _MassMaintHeader.BillOfMaterial and $projection.BillOfMaterialCategory = _MassMaintHeader.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _MassMaintHeader.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _MassMaintHeader.BillOfMaterialVersion and $projection.HeaderChangeDocument = _MassMaintHeader.EngineeringChangeDocument and $projection.Material = _MassMaintHeader.Material and $projection.Plant = _MassMaintHeader.Plant`
[0..1]	I_DocumentInfoRecordDocPrtVH	_BOMDocInfoRecord	`$projection.DocumentType = _BOMDocInfoRecord.DocumentInfoRecordDocPart and $projection.DocumentPart = _BOMDocInfoRecord.DocumentInfoRecordDocType and $projection.DocumentVersion =_BOMDocInfoRecord.DocumentInfoRecordDocVersion and $projection.DocNumber = _BOMDocInfoRecord.DocumentInfoRecordDocNumber`
[0..1]	I_BillOfMaterialItemCategory	_BOMResultingItemCategory	`$projection.ResultingItemCategory = _BOMResultingItemCategory.BillOfMaterialItemCategory`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CBOMMASSMNTFTR	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
Search.searchable	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	Consumption for Mass Maint Filter	view

OData Services (1)

Service	Binding	Version	Contract	Release
BOMMASSMAINT	BOM_MASS_MAINT	V4	C1	NOT_RELEASED

Fields (55)

Key	Field	Source Table	Source Field	Description
KEY	BillOfMaterial		BillOfMaterial	Bill of Material
KEY	BillOfMaterialCategory		BillOfMaterialCategory	Bill of Material Category
KEY	BillOfMaterialVariant		BillOfMaterialVariant	AlternativeBOM
KEY	BillOfMaterialVersion		BillOfMaterialVersion	BOM Version
KEY	BillOfMaterialItemNodeNumber		BillOfMaterialItemNodeNumber	Item Node Number
KEY	HeaderChangeDocument		HeaderChangeDocument	Change Number
KEY	Material		Material	Material
KEY	Plant		Plant	Valuation Area
	EngineeringChangeDocument		EngineeringChangeDocument	Item Change Number
	ChangeNumberDescription	_ChangeNumber	ChangeNumberDescription
	BillOfMaterialComponent		BillOfMaterialComponent	Component
	BillOfMaterialItemQuantity		BillOfMaterialItemQuantity	Quantity
	ComponentDescription		ComponentDescription	Component Description
	ItemValidityStartDate		ValidityStartDate	Item Valid From
	ItemValidityEndDate		ValidityEndDate	Item Valid To
	BillOfMaterialItemUUID		BillOfMaterialItemUUID	ID for Item Change Status
	BillOfMaterialItemUnit		BillOfMaterialItemUnit	Component UoM
	BOMItemDescription		BOMItemDescription	Item Text
	BillOfMaterialItemCategory		BillOfMaterialItemCategory	Item Category
	MaterialDescription	_MassMaintHeader	ProductDescription	Description
	BillOfMaterialVariantUsage		BillOfMaterialVariantUsage	Usage
	BillOfMaterialVariantUsageDesc	_BillOfMaterialUsage	BillOfMaterialVariantUsageDesc
	BOMVersionStatus	_MassMaintHeader	BOMVersionStatus	BOM Version Status
	BillOfMaterialHeaderUUID	_MassMaintHeader	BillOfMaterialHeaderUUID	ID for BOM Header Change Status
	BOMUsagePriority	_MassMaintHeader	BOMUsagePriority	Selection Priority
	BOMHeaderText	_MassMaintHeader	BOMHeaderText	BOM Description
	BOMAlternativeText	_MassMaintHeader	BOMAlternativeText	Alternative Text
	BillOfMaterialStatus	_MassMaintHeader	BillOfMaterialStatus	BOM Status
	HeaderValidityStartDate	_MassMaintHeader	HeaderValidityStartDate	Valid From
	HeaderValidityEndDate	_MassMaintHeader	HeaderValidityEndDate	Header Valid To
	BOMHeaderBaseUnit	_MassMaintHeader	BOMHeaderBaseUnit	Base Unit of Measure
	BOMHeaderQuantityInBaseUnit	_MassMaintHeader	BOMHeaderQuantityInBaseUnit	Base Quantity
	LastChangeDate	_MassMaintHeader	LastChangeDate	Time Stamp
	CreatedByUser	_MassMaintHeader	CreatedByUser	User Name
	LastChangedByUser	_MassMaintHeader	LastChangedByUser	User Name
	PlantName	_MassMaintHeader	PlantName	Plant Name
	LastChangeDateTime	_MassMaintHeader	LastChangeDateTime	Last Change Date-Time
	BillOfMaterialHdrDetailsText	_MassMaintHeader	BillOfMaterialHdrDetailsText	BOM Header Details
	DocumentType		DocumentType	Order Type
	DocumentDescription	_BOMDocInfoRecord	DocumentDescription	Doc. Name
	DocNumber		DocNumber	Document Number
	DocumentVersion		DocumentVersion	Docu. Version
	DocumentPart		DocumentPart	Document Part
	ClassNumber		ClassNumber	Class
	ClassType		ClassType	X Flag
	ResultingItemCategory		ResultingItemCategory	Resulting Item Category
	Currency		Currency	Valuation Crcy
	MaterialGroup		MaterialGroup	Product Group
	MaterialPriceUnitQty		MaterialPriceUnitQty	Price Unit
	PurchasingGroup		PurchasingGroup	Purchasing Group
	VariableSizeItemQuantity		VariableSizeItemQuantity	Number of Variable-Size Item Required
	VariableSizeCompUnitOfMeasure		VariableSizeCompUnitOfMeasure	Variable-Size Item (VSI) UoM
	QuantityVariableSizeItem		QuantityVariableSizeItem	Variable-Size Item Quantity per Peice
	Size1		Size1	Size 1
	BillOfMaterialItemNumber		BillOfMaterialItemNumber	Item Number

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_BOMMassMaintFilter.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CBOMMASSMNTFTR

CREATE VIEW C_BOMMassMaintFilter AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  EngineeringChangeDocument,
  _ChangeNumber.ChangeNumberDescription AS ChangeNumberDescription,
  BillOfMaterialComponent,
  BillOfMaterialItemQuantity,
  ComponentDescription,
  ValidityStartDate AS ItemValidityStartDate,
  ValidityEndDate AS ItemValidityEndDate,
  BillOfMaterialItemUUID,
  BillOfMaterialItemUnit,
  BOMItemDescription,
  BillOfMaterialItemCategory,
  _MassMaintHeader.ProductDescription AS MaterialDescription,
  BillOfMaterialVariantUsage,
  _BillOfMaterialUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  _MassMaintHeader.BOMVersionStatus AS BOMVersionStatus,
  _MassMaintHeader.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  _MassMaintHeader.BOMUsagePriority AS BOMUsagePriority,
  _MassMaintHeader.BOMHeaderText AS BOMHeaderText,
  _MassMaintHeader.BOMAlternativeText AS BOMAlternativeText,
  _MassMaintHeader.BillOfMaterialStatus AS BillOfMaterialStatus,
  _MassMaintHeader.HeaderValidityStartDate AS HeaderValidityStartDate,
  _MassMaintHeader.HeaderValidityEndDate AS HeaderValidityEndDate,
  _MassMaintHeader.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  _MassMaintHeader.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  _MassMaintHeader.LastChangeDate AS LastChangeDate,
  _MassMaintHeader.CreatedByUser AS CreatedByUser,
  _MassMaintHeader.LastChangedByUser AS LastChangedByUser,
  _MassMaintHeader.PlantName AS PlantName,
  _MassMaintHeader.LastChangeDateTime AS LastChangeDateTime,
  _MassMaintHeader.BillOfMaterialHdrDetailsText AS BillOfMaterialHdrDetailsText,
  DocumentType,
  _BOMDocInfoRecord.DocumentDescription AS DocumentDescription,
  DocNumber,
  DocumentVersion,
  DocumentPart,
  ClassNumber,
  ClassType,
  ResultingItemCategory,
  Currency,
  MaterialGroup,
  MaterialPriceUnitQty,
  PurchasingGroup,
  VariableSizeItemQuantity,
  VariableSizeCompUnitOfMeasure,
  QuantityVariableSizeItem,
  Size1,
  BillOfMaterialItemNumber
FROM R_BillOfMaterialItemTP
LEFT OUTER JOIN R_BillOfMaterialTP AS _MassMaintHeader ON BillOfMaterial = _MassMaintHeader.BillOfMaterial AND BillOfMaterialCategory = _MassMaintHeader.BillOfMaterialCategory AND BillOfMaterialVariant = _MassMaintHeader.BillOfMaterialVariant AND BillOfMaterialVersion = _MassMaintHeader.BillOfMaterialVersion AND HeaderChangeDocument = _MassMaintHeader.EngineeringChangeDocument AND Material = _MassMaintHeader.Material AND Plant = _MassMaintHeader.Plant  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocPrtVH AS _BOMDocInfoRecord ON DocumentType = _BOMDocInfoRecord.DocumentInfoRecordDocPart AND DocumentPart = _BOMDocInfoRecord.DocumentInfoRecordDocType AND DocumentVersion =_BOMDocInfoRecord.DocumentInfoRecordDocVersion AND DocNumber = _BOMDocInfoRecord.DocumentInfoRecordDocNumber  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMResultingItemCategory ON ResultingItemCategory = _BOMResultingItemCategory.BillOfMaterialItemCategory  -- association [0..1]
;

Depth:

C_BOMMassMaintFilter view

R_BillOfMaterialItemTP view_entity