C_BOMMassMaintItem

DDL: C_BOMMASSMAINTITEM Type: view_entity CONSUMPTION
102 Fields 1 Data Sources 1 OData Services

Consumption for Mass Maint Item

C_BOMMassMaintItem is a Consumption CDS View that provides data about "Consumption for Mass Maint Item" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialItemTP) and exposes 102 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, BillOfMaterialItemNodeNumber. It is exposed through 1 OData service (BOMMASSMAINT).

Data Sources (1)

SourceAliasJoin Type
R_BillOfMaterialItemTP R_BillOfMaterialItemTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true 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 Item view
Consumption.semanticObject MaterialBOM view
UI.headerInfo.typeName Bill Of Material Items view
UI.headerInfo.typeNamePlural Bill Of Material Items view

OData Services (1)

ServiceBindingVersionContractRelease
BOMMASSMAINT BOM_MASS_MAINT V4 C1 NOT_RELEASED

Fields (102)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM 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
BillOfMaterialItemUUID BillOfMaterialItemUUID ID for Item Change Status
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID ID for BOM Header Change Status
BOMItemInternalChangeCount BOMItemInternalChangeCount Counter
ItemValidityStartDate ValidityStartDate Validity Start Date
ItemValidityEndDate ValidityEndDate ValidTo
EngineeringChangeDocForEdit EngineeringChangeDocForEdit Change Number
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
EngineeringChangeDocument EngineeringChangeDocument Change Number
ChgToEngineeringChgDocument ChgToEngineeringChgDocument Change No. To
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem Item Node
BOMItemRecordCreationDate BOMItemRecordCreationDate Created On
BOMItemCreatedByUser BOMItemCreatedByUser Created by
BOMItemLastChangeDate BOMItemLastChangeDate Changed On
BOMItemLastChangedByUser BOMItemLastChangedByUser Changed By
BillOfMaterialComponent BillOfMaterialComponent Component
BillOfMaterialItemCategory BillOfMaterialItemCategory Item Category
BillOfMaterialItemNumber BillOfMaterialItemNumber Item
BillOfMaterialItemUnit BillOfMaterialItemUnit Component UoM
BillOfMaterialItemQuantity BillOfMaterialItemQuantity Quantity
IsAssembly IsAssembly Single-Character Flag
IsSubItem IsSubItem Sub-item Indicator
BOMItemSorter BOMItemSorter Sort String
BOMItemHasFixedQuantity BOMItemHasFixedQuantity Fixed Quantity
PurchasingGroup PurchasingGroup Purchasing Group
Currency Currency Valuation Crcy
MaterialComponentPrice MaterialComponentPrice Price
IdentifierBOMItem IdentifierBOMItem Item Identification
MaterialPriceUnitQty MaterialPriceUnitQty Price Unit
ComponentScrapInPercent ComponentScrapInPercent Component Scrap
OperationScrapInPercent OperationScrapInPercent Operation Scrap
IsNetScrap IsNetScrap Net Indicator
VariableSizeItemQuantity VariableSizeItemQuantity Number of Variable-Size Items
VariableSizeCompUnitOfMeasure VariableSizeCompUnitOfMeasure Unit Of Measure For Variable-Size Item
QuantityVariableSizeItem QuantityVariableSizeItem Quantity of Variable-Size Item
FormulaKey FormulaKey Formula Key
ComponentDescription ComponentDescription Component Description
BOMItemDescription BOMItemDescription Item Text
BOMItemText2 BOMItemText2 Item Text
MaterialGroup MaterialGroup Product Group
DocumentType DocumentType Order Type
DocNumber DocNumber Document Number
DocumentVersion DocumentVersion Docu. Version
DocumentPart DocumentPart Document Part
ClassNumber ClassNumber Class
ClassType ClassType X Flag
ResultingItemCategory ResultingItemCategory Resulting Item Category
DependencyObjectNumber DependencyObjectNumber Assignment Number
IsClassificationRelevant IsClassificationRelevant Class Selection Indicator
IsBulkMaterial IsBulkMaterial Bulk material
BOMItemIsSparePart BOMItemIsSparePart Spare Part ID
BOMItemIsSalesRelevant BOMItemIsSalesRelevant Relevant to Sales
IsProductionRelevant IsProductionRelevant Production Relevant
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant Plant Maintenance
BOMItemIsCostingRelevant BOMItemIsCostingRelevant Relevancy to Costing
IsEngineeringRelevant IsEngineeringRelevant Engineering/Design
SpecialProcurementType SpecialProcurementType SpecProcurement
IsBOMRecursiveAllowed IsBOMRecursiveAllowed Recursion Allowed
OperationLeadTimeOffset OperationLeadTimeOffset Operation LTO
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit Oper. LTO unit
IsMaterialProvision IsMaterialProvision Material Provision Indicator
BOMIsRecursive BOMIsRecursive Recursive
DocumentIsCreatedByCAD DocumentIsCreatedByCAD CAD Indicator
DistrKeyCompConsumption DistrKeyCompConsumption Distribution Key
DeliveryDurationInDays DeliveryDurationInDays Delivery Time (days)
Creditor Creditor Supplier
CostElement CostElement Cost Element
Size1 Size1 Size 1
Size2 Size2 Size 2
Size3 Size3 Size 3
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3 Size Unit
GoodsReceiptDuration GoodsReceiptDuration GR Processing Time
PurchasingOrganization PurchasingOrganization Purchasing Organization
RequiredComponent RequiredComponent Reqd Component
MultipleSelectionAllowed MultipleSelectionAllowed Multiple Sel.
ProdOrderIssueLocation ProdOrderIssueLocation StorageLocation
MaterialIsCoProduct MaterialIsCoProduct Co-product
ExplosionType ExplosionType Explosion Type
AlternativeItemGroup AlternativeItemGroup Alternative Item Group
AlternativeItemPriority AlternativeItemPriority Priority
AlternativeItemStrategy AlternativeItemStrategy Strategy
UsageProbabilityPercent UsageProbabilityPercent Usage Prob.
FollowUpGroup FollowUpGroup Follow-up Group
DiscontinuationGroup DiscontinuationGroup Discontinuation Group
IsConfigurableBOM IsConfigurableBOM Selection Indicator
ReferencePoint ReferencePoint Reference Point
LeadTimeOffset LeadTimeOffset Lead-Time Offset
ProductionSupplyArea ProductionSupplyArea Production Supply Area
IsDeleted IsDeleted TRUE
IsALE IsALE ALE Indicator
LastChangeDateTime LastChangeDateTime Timestamp
PreliminaryComponent PreliminaryComponent Preliminary Component
_BOMItemCategory _BOMItemCategory
_BOMItmObjDependencyAssignment _BOMItmObjDependencyAssignment
_BOMSubItems _BOMSubItems

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_BOMMassMaintItem.
-- 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.

CREATE VIEW C_BOMMassMaintItem AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialItemNodeNumber,
  HeaderChangeDocument,
  Material,
  Plant,
  BillOfMaterialItemUUID,
  BillOfMaterialHeaderUUID,
  BOMItemInternalChangeCount,
  ValidityStartDate AS ItemValidityStartDate,
  ValidityEndDate AS ItemValidityEndDate,
  EngineeringChangeDocForEdit,
  BillOfMaterialVariantUsage,
  EngineeringChangeDocument,
  ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  BillOfMaterialComponent,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  BillOfMaterialItemUnit,
  BillOfMaterialItemQuantity,
  IsAssembly,
  IsSubItem,
  BOMItemSorter,
  BOMItemHasFixedQuantity,
  PurchasingGroup,
  Currency,
  MaterialComponentPrice,
  IdentifierBOMItem,
  MaterialPriceUnitQty,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  IsNetScrap,
  VariableSizeItemQuantity,
  VariableSizeCompUnitOfMeasure,
  QuantityVariableSizeItem,
  FormulaKey,
  ComponentDescription,
  BOMItemDescription,
  BOMItemText2,
  MaterialGroup,
  DocumentType,
  DocNumber,
  DocumentVersion,
  DocumentPart,
  ClassNumber,
  ClassType,
  ResultingItemCategory,
  DependencyObjectNumber,
  IsClassificationRelevant,
  IsBulkMaterial,
  BOMItemIsSparePart,
  BOMItemIsSalesRelevant,
  IsProductionRelevant,
  BOMItemIsPlantMaintRelevant,
  BOMItemIsCostingRelevant,
  IsEngineeringRelevant,
  SpecialProcurementType,
  IsBOMRecursiveAllowed,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  IsMaterialProvision,
  BOMIsRecursive,
  DocumentIsCreatedByCAD,
  DistrKeyCompConsumption,
  DeliveryDurationInDays,
  Creditor,
  CostElement,
  Size1,
  Size2,
  Size3,
  UnitOfMeasureForSize1To3,
  GoodsReceiptDuration,
  PurchasingOrganization,
  RequiredComponent,
  MultipleSelectionAllowed,
  ProdOrderIssueLocation,
  MaterialIsCoProduct,
  ExplosionType,
  AlternativeItemGroup,
  AlternativeItemPriority,
  AlternativeItemStrategy,
  UsageProbabilityPercent,
  FollowUpGroup,
  DiscontinuationGroup,
  IsConfigurableBOM,
  ReferencePoint,
  LeadTimeOffset,
  ProductionSupplyArea,
  IsDeleted,
  IsALE,
  LastChangeDateTime,
  PreliminaryComponent
FROM R_BillOfMaterialItemTP
;

Learn More