C_BOMMassMaintHeader

DDL: C_BOMMASSMAINTHEADER Type: view_entity CONSUMPTION
33 Fields 1 Data Sources

Consumption for Mass Maint Header

C_BOMMassMaintHeader is a Consumption CDS View that provides data about "Consumption for Mass Maint Header" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialTP) and exposes 33 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument.

Data Sources (1)

SourceAliasJoin Type
R_BillOfMaterialTP R_BillOfMaterialTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption for Mass Maint Header view
Consumption.semanticObject MaterialBOM view
UI.headerInfo.typeName Bill Of Material view
UI.headerInfo.typeNamePlural Bills Of Material view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM Category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY Material Material Material
KEY Plant Plant Valuation Area
MaterialDescription ProductDescription Material Description
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVariantUsageDesc _BillOfMaterialUsage BillOfMaterialVariantUsageDesc
BOMVersionStatus BOMVersionStatus BOM Version Status
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID ID for BOM Header Change Status
BOMUsagePriority BOMUsagePriority Selection Priority
BOMHeaderText BOMHeaderText BOM Description
BOMAlternativeText BOMAlternativeText Alt Text
BillOfMaterialStatus BillOfMaterialStatus BOM Status
HeaderValidityStartDate HeaderValidityStartDate Valid From
HeaderValidityEndDate HeaderValidityEndDate to
BOMHeaderBaseUnit BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit Base Quantity
LastChangeDate LastChangeDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
PlantName PlantName Plant Name
LastChangeDateTime LastChangeDateTime Timestamp
BillOfMaterialHdrDetailsText BillOfMaterialHdrDetailsText BOM Header Details
LaboratoryOrDesignOffice LaboratoryOrDesignOffice Lab/Office
BOMGroup BOMGroup BOM Group
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp Authorization Group
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
BOMIsArchivedForDeletion BOMIsArchivedForDeletion Deletion flag
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant BOM to AIN Handover
_BillOfMaterialUsage _BillOfMaterialUsage

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_BOMMassMaintHeader.
-- 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_BOMMassMaintHeader AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  Material,
  Plant,
  ProductDescription AS MaterialDescription,
  BillOfMaterialVariantUsage,
  _BillOfMaterialUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  BOMVersionStatus,
  BillOfMaterialHeaderUUID,
  BOMUsagePriority,
  BOMHeaderText,
  BOMAlternativeText,
  BillOfMaterialStatus,
  HeaderValidityStartDate,
  HeaderValidityEndDate,
  BOMHeaderBaseUnit,
  BOMHeaderQuantityInBaseUnit,
  LastChangeDate,
  CreatedByUser,
  LastChangedByUser,
  PlantName,
  LastChangeDateTime,
  BillOfMaterialHdrDetailsText,
  LaboratoryOrDesignOffice,
  BOMGroup,
  BillOfMaterialAuthsnGrp,
  IsMarkedForDeletion,
  BOMIsArchivedForDeletion,
  BOMAssetNtwkHndovrIsRelevant
FROM R_BillOfMaterialTP
;

Learn More