C_BOMComparison

DDL: C_BOMCOMPARISON Type: view_entity CONSUMPTION Package: CS_MODEL
41 Fields 1 Data Sources 2 OData Services

BOM Comparison

C_BOMComparison is a Consumption CDS View that provides data about "BOM Comparison" in SAP S/4HANA. It reads from 1 data source (R_BillOfMaterialTP) and exposes 41 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It is exposed through 2 OData services (ASQL_F5938, BOMCOMPARISON). Part of development package CS_MODEL.

Data Sources (1)

SourceAliasJoin Type
R_BillOfMaterialTP R_BillOfMaterialTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label BOM Comparison view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Explode Bills of Material view
UI.headerInfo.typeNamePlural Bills of Materials view
UI.headerInfo.title.label Bill Of Material view
UI.headerInfo.title.valueQualifier Material view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F5938 ASQL_F5938 C2 NOT_RELEASED
BOMCOMPARISON BOM_COMPARISON V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (41)

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 Vehicle Model
KEY Plant Plant Valuation Area
ProductDescription Description
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID Guid
PlantName PlantName Plant Name
BillOfMaterialHdrDetailsText BillOfMaterialHdrDetailsText
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
EngineeringChangeDocForEdit EngineeringChangeDocForEdit Change Number
IsMultipleBOMAlt IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount Counter
BOMUsagePriority BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus BOMVersionStatus BOM Version Status
IsVersionBillOfMaterial IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion IsLatestBOMVersion Latest Rel Version
IsConfiguredMaterial IsConfiguredMaterial Configured matl
BOMTechnicalType BOMTechnicalType Tech type
BOMGroup BOMGroup BOM group
BOMAlternativeText BOMAlternativeText Alt Text
BillOfMaterialStatus BillOfMaterialStatus BOM Status
HeaderValidityStartDate HeaderValidityStartDate Valid From
HeaderValidityEndDate HeaderValidityEndDate to
ChgToEngineeringChgDocument ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
IsALE IsALE ALE indicator
BOMHeaderBaseUnit BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate RecordCreationDate Created On
LastChangeDate LastChangeDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
BOMIsToBeDeleted BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice LaboratoryOrDesignOffice Lab/Office
LastChangeDateTime LastChangeDateTime Timestamp
SelectedBillOfMaterialVersion SelectedBillOfMaterialVersion

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_BOMComparison.
-- 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_BOMComparison AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  Material,
  Plant,
  cast(ProductDescription as maktx preserving type ) AS ProductDescription,
  BillOfMaterialHeaderUUID,
  PlantName,
  BillOfMaterialHdrDetailsText,
  BillOfMaterialVariantUsage,
  EngineeringChangeDocForEdit,
  IsMultipleBOMAlt,
  BOMHeaderInternalChangeCount,
  BOMUsagePriority,
  BillOfMaterialAuthsnGrp,
  BOMVersionStatus,
  IsVersionBillOfMaterial,
  IsLatestBOMVersion,
  IsConfiguredMaterial,
  BOMTechnicalType,
  BOMGroup,
  BOMAlternativeText,
  BillOfMaterialStatus,
  HeaderValidityStartDate,
  HeaderValidityEndDate,
  ChgToEngineeringChgDocument,
  IsMarkedForDeletion,
  IsALE,
  BOMHeaderBaseUnit,
  BOMHeaderQuantityInBaseUnit,
  RecordCreationDate,
  LastChangeDate,
  CreatedByUser,
  LastChangedByUser,
  BOMIsToBeDeleted,
  DocumentIsCreatedByCAD,
  LaboratoryOrDesignOffice,
  LastChangeDateTime,
  SelectedBillOfMaterialVersion
FROM R_BillOfMaterialTP
;

Learn More