I_ChangeRecordMfgBOMHdrSearch

DDL: I_CHANGERECORDMFGBOMHDRSEARCH SQL: ICRMBOMHDRSRCH Type: view BASIC
9 Fields 2 Data Sources 1 Associations

Change Record Manufacturing BOM Header Search

I_ChangeRecordMfgBOMHdrSearch is a Basic CDS View that provides data about "Change Record Manufacturing BOM Header Search" in SAP S/4HANA. It reads from 2 data sources (P_ChangeRecordBOMHeaderSearch, I_MfgBOMUsage) and exposes 9 fields with key fields BillOfMaterialCategory, BillOfMaterialVariantUsage, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
P_ChangeRecordBOMHeaderSearch bom_header from
I_MfgBOMUsage MfgBOMUsage inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialBOMLink _mast $projection.BillOfMaterial = _mast.BillOfMaterial and $projection.BillOfMaterialVariant = _mast.BillOfMaterialVariant

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICRMBOMHDRSRCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Change Record Manufacturing BOM Header Search view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory P_ChangeRecordBOMHeaderSearch BillOfMaterialCategory BOM category
KEY BillOfMaterialVariantUsage P_ChangeRecordBOMHeaderSearch BillOfMaterialVariantUsage Usage
KEY BillOfMaterial P_ChangeRecordBOMHeaderSearch BillOfMaterial BOM
KEY BillOfMaterialVariant P_ChangeRecordBOMHeaderSearch BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion P_ChangeRecordBOMHeaderSearch BillOfMaterialVersion BOM Version
KEY Plant _mast Plant Valuation Area
KEY Material _mast Material Vehicle Model
BOMVersionStatus P_ChangeRecordBOMHeaderSearch BOMVersionStatus BOM Version Status
BillOfMaterialStatus P_ChangeRecordBOMHeaderSearch BillOfMaterialStatus BOM Status

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 I_ChangeRecordMfgBOMHdrSearch.
-- 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: ICRMBOMHDRSRCH

CREATE VIEW I_ChangeRecordMfgBOMHdrSearch AS
SELECT
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.BillOfMaterial AS BillOfMaterial,
  bom_header.BillOfMaterialVariant AS BillOfMaterialVariant,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  _mast.Plant AS Plant,
  _mast.Material AS Material,
  bom_header.BOMVersionStatus AS BOMVersionStatus,
  bom_header.BillOfMaterialStatus AS BillOfMaterialStatus
FROM P_ChangeRecordBOMHeaderSearch AS bom_header
INNER JOIN I_MfgBOMUsage AS MfgBOMUsage ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialBOMLink AS _mast ON BillOfMaterial = _mast.BillOfMaterial AND BillOfMaterialVariant = _mast.BillOfMaterialVariant  -- association [0..*]
;

Learn More