C_OrderBOMExplosion

DDL: C_ORDERBOMEXPLOSION Type: view_entity CONSUMPTION Package: CS_MODEL
42 Fields 1 Data Sources 2 OData Services

Consumption for Order BOM Explosion

C_OrderBOMExplosion is a Consumption CDS View that provides data about "Consumption for Order BOM Explosion" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderBillOfMaterialTP) and exposes 42 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, EngineeringChangeDocument, Material. It is exposed through 2 OData services (ASQL_F4584, BOMEXPLOSION). Part of development package CS_MODEL.

Data Sources (1)

SourceAliasJoin Type
R_SalesOrderBillOfMaterialTP R_SalesOrderBillOfMaterialTP projection

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consumption for Order BOM Explosion view
Search.searchable true view
OData.entitySet.name ExplodeOrderBOMList view
VDM.viewType #CONSUMPTION view
Consumption.semanticObject OrderExplodeBOM view
UI.headerInfo.typeName Explode Order Bills of Material view
UI.headerInfo.typeNamePlural Order Bills of Materials view
UI.headerInfo.title.label Order Bill Of Material view
UI.headerInfo.title.valueQualifier Material view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4584 ASQL_F4584 C2 NOT_RELEASED
BOMEXPLOSION BOM_EXPLOSION_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
IsVersionBillOfMaterial IsVersionBillOfMaterial Versioning Relevant
LastChangeDateTime LastChangeDateTime Timestamp
EngineeringChangeDocForEdit EngineeringChangeDocForEdit Change Number
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount Counter
BOMHeaderText BOMHeaderText BOM Description
BOMExplosionApplication BOMExplosionApplication BOM Application
BOMUsagePriority BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp Auth group
BOMTechnicalType BOMTechnicalType Tech type
BOMGroup BOMGroup BOM group
BOMAlternativeText BOMAlternativeText Alt Text
BillOfMaterialStatus BillOfMaterialStatus BOM Status
ChgToEngineeringChgDocument ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
BOMIsArchivedForDeletion BOMIsArchivedForDeletion Deletion flag
IsConfiguredMaterial IsConfiguredMaterial Configured matl
BOMIsConfigurable BOMIsConfigurable ConfigurableBOM
IsALE IsALE ALE indicator
BOMHeaderBaseUnit BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate RecordCreationDate Created On
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
CreatedByUser CreatedByUser User Name
BOMIsToBeDeleted BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice LaboratoryOrDesignOffice Lab/Office
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant BOM to AIN Handover
_Plant _Plant

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_OrderBOMExplosion.
-- 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_OrderBOMExplosion AS
SELECT
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  EngineeringChangeDocument,
  Material,
  Plant,
  _Plant.PlantName AS PlantName,
  SalesOrder,
  SalesOrderItem,
  IsVersionBillOfMaterial,
  LastChangeDateTime,
  EngineeringChangeDocForEdit,
  BillOfMaterialHeaderUUID,
  BillOfMaterialVariantUsage,
  ValidityStartDate,
  ValidityEndDate,
  BOMHeaderInternalChangeCount,
  BOMHeaderText,
  BOMExplosionApplication,
  BOMUsagePriority,
  BillOfMaterialAuthsnGrp,
  BOMTechnicalType,
  BOMGroup,
  BOMAlternativeText,
  BillOfMaterialStatus,
  ChgToEngineeringChgDocument,
  IsMarkedForDeletion,
  BOMIsArchivedForDeletion,
  IsConfiguredMaterial,
  BOMIsConfigurable,
  IsALE,
  BOMHeaderBaseUnit,
  BOMHeaderQuantityInBaseUnit,
  RecordCreationDate,
  LastChangeDate,
  LastChangedByUser,
  CreatedByUser,
  BOMIsToBeDeleted,
  DocumentIsCreatedByCAD,
  LaboratoryOrDesignOffice,
  BOMAssetNtwkHndovrIsRelevant
FROM R_SalesOrderBillOfMaterialTP
;

Learn More