I_ChgImpactEngBOMMfgBOMHdr

DDL: I_CHGIMPACTENGBOMMFGBOMHDR SQL: ICHEBMMBMHDR Type: view COMPOSITE Package: MPE_PLAN_CIMA
26 Fields 2 Data Sources 4 Associations

Eng BOM Hdrs With Resp Mfg BOM Hdrs

I_ChgImpactEngBOMMfgBOMHdr is a Composite CDS View that provides data about "Eng BOM Hdrs With Resp Mfg BOM Hdrs" in SAP S/4HANA. It reads from 2 data sources (I_EngBOM, I_MfgBOM) and exposes 26 fields. It has 4 associations to related views. Part of development package MPE_PLAN_CIMA.

Data Sources (2)

SourceAliasJoin Type
I_EngBOM EngBOM inner
I_MfgBOM MfgBOM inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_ChgImpactBOMVersStsTxt _ChgImpactBOMVersStsTxt $projection.BOMVersionStatus = _ChgImpactBOMVersStsTxt.BOMVersionStatus and _ChgImpactBOMVersStsTxt.Language = $session.system_language
[0..1] I_BillOfMaterialStatusText _BOMStatusText $projection.BillOfMaterialStatus = _BOMStatusText.BillOfMaterialStatus and _BOMStatusText.Language = $session.system_language
[0..1] I_ChgImpactBOMItem _MfgBOMItem BomItemLinks.MfgBillOfMaterial = _MfgBOMItem.BillOfMaterial and BomItemLinks.MfgBillOfMaterialCategory = _MfgBOMItem.BillOfMaterialCategory and BomItemLinks.MfgBillOfMaterialVariant = _MfgBOMItem.BillOfMaterialVariant and BomItemLinks.MfgBillOfMaterialVersion = _MfgBOMItem.BillOfMaterialVersion and BomItemLinks.MfgBOMItmInhtdNodeNmbr = _MfgBOMItem.InheritedNodeNumberForBOMItem
[0..1] I_ChgImpactBOMItem _EngBOMItem BomItemLinks.EngBillOfMaterial = _EngBOMItem.BillOfMaterial and BomItemLinks.EngBillOfMaterialCategory = _EngBOMItem.BillOfMaterialCategory and BomItemLinks.EngBillOfMaterialVariant = _EngBOMItem.BillOfMaterialVariant and BomItemLinks.EngBillOfMaterialVersion = _EngBOMItem.BillOfMaterialVersion and BomItemLinks.EngBOMItmInhtdNodeNmbr = _EngBOMItem.InheritedNodeNumberForBOMItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHEBMMBMHDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Eng BOM Hdrs With Resp Mfg BOM Hdrs view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (26)

KeyFieldSource TableSource FieldDescription
EngBillOfMaterialCategory BomItemLinks EngBillOfMaterialCategory
EngBillOfMaterial BomItemLinks EngBillOfMaterial
EngBillOfMaterialVariant BomItemLinks EngBillOfMaterialVariant
EngBillOfMaterialVersion BomItemLinks EngBillOfMaterialVersion
MfgBillOfMaterialCategory BomItemLinks MfgBillOfMaterialCategory
MfgBillOfMaterial BomItemLinks MfgBillOfMaterial
MfgBillOfMaterialVariant BomItemLinks MfgBillOfMaterialVariant
MfgBillOfMaterialVersion BomItemLinks MfgBillOfMaterialVersion
MfgBOMItmInhtdNodeNmbr BomItemLinks MfgBOMItmInhtdNodeNmbr
EngBOMItmInhtdNodeNmbr BomItemLinks EngBOMItmInhtdNodeNmbr
InheritedNodeNumberVersionBOM _MfgBOMItem InheritedNodeNumberVersionBOM Item node
InheritedNodeNumberForBOMItem _EngBOMItem InheritedNodeNumberVersionBOM Item node
EngBillOfMaterialHeaderUUID I_EngBOM BillOfMaterialHeaderUUID Guid
SourceMaterial I_EngBOM Material Vehicle Model
MfgBillOfMaterialHeaderUUID I_MfgBOM BillOfMaterialHeaderUUID Guid
TargetMaterial I_MfgBOM Material Vehicle Model
BillOfMaterialVariantUsage I_MfgBOM BillOfMaterialVariantUsage Usage
ValidityStartDate I_MfgBOM HeaderValidityStartDate Valid From
ValidityEndDate I_MfgBOM HeaderValidityEndDate to
ProductionPlant I_MfgBOM Plant Valuation Area
IsLatestBOMVersion I_MfgBOM IsLatestBOMVersion Latest Rel Version
BOMVersionStatus I_MfgBOM BOMVersionStatus BOM Version Status
BOMVersionStatusDescription _ChgImpactBOMVersStsTxt BOMVersionStatusDescription Short Description
BillOfMaterialStatus I_MfgBOM BillOfMaterialStatus BOM Status
_ChgImpactBOMVersStsTxt _ChgImpactBOMVersStsTxt
_BOMStatusText _BOMStatusText

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_ChgImpactEngBOMMfgBOMHdr.
-- 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: ICHEBMMBMHDR

CREATE VIEW I_ChgImpactEngBOMMfgBOMHdr AS
SELECT
  BomItemLinks.EngBillOfMaterialCategory AS EngBillOfMaterialCategory,
  BomItemLinks.EngBillOfMaterial AS EngBillOfMaterial,
  BomItemLinks.EngBillOfMaterialVariant AS EngBillOfMaterialVariant,
  BomItemLinks.EngBillOfMaterialVersion AS EngBillOfMaterialVersion,
  BomItemLinks.MfgBillOfMaterialCategory AS MfgBillOfMaterialCategory,
  BomItemLinks.MfgBillOfMaterial AS MfgBillOfMaterial,
  BomItemLinks.MfgBillOfMaterialVariant AS MfgBillOfMaterialVariant,
  BomItemLinks.MfgBillOfMaterialVersion AS MfgBillOfMaterialVersion,
  BomItemLinks.MfgBOMItmInhtdNodeNmbr AS MfgBOMItmInhtdNodeNmbr,
  BomItemLinks.EngBOMItmInhtdNodeNmbr AS EngBOMItmInhtdNodeNmbr,
  _MfgBOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  _EngBOMItem.InheritedNodeNumberVersionBOM AS InheritedNodeNumberForBOMItem,
  EngBOM.BillOfMaterialHeaderUUID AS EngBillOfMaterialHeaderUUID,
  EngBOM.Material AS SourceMaterial,
  MfgBOM.BillOfMaterialHeaderUUID AS MfgBillOfMaterialHeaderUUID,
  MfgBOM.Material AS TargetMaterial,
  MfgBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MfgBOM.HeaderValidityStartDate AS ValidityStartDate,
  MfgBOM.HeaderValidityEndDate AS ValidityEndDate,
  MfgBOM.Plant AS ProductionPlant,
  MfgBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  MfgBOM.BOMVersionStatus AS BOMVersionStatus,
  _ChgImpactBOMVersStsTxt.BOMVersionStatusDescription AS BOMVersionStatusDescription,
  MfgBOM.BillOfMaterialStatus AS BillOfMaterialStatus
INNER JOIN I_EngBOM AS EngBOM ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgBOM AS MfgBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChgImpactBOMVersStsTxt AS _ChgImpactBOMVersStsTxt ON BOMVersionStatus = _ChgImpactBOMVersStsTxt.BOMVersionStatus AND _ChgImpactBOMVersStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialStatusText AS _BOMStatusText ON BillOfMaterialStatus = _BOMStatusText.BillOfMaterialStatus AND _BOMStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ChgImpactBOMItem AS _MfgBOMItem ON BomItemLinks.MfgBillOfMaterial = _MfgBOMItem.BillOfMaterial AND BomItemLinks.MfgBillOfMaterialCategory = _MfgBOMItem.BillOfMaterialCategory AND BomItemLinks.MfgBillOfMaterialVariant = _MfgBOMItem.BillOfMaterialVariant AND BomItemLinks.MfgBillOfMaterialVersion = _MfgBOMItem.BillOfMaterialVersion AND BomItemLinks.MfgBOMItmInhtdNodeNmbr = _MfgBOMItem.InheritedNodeNumberForBOMItem  -- association [0..1]
LEFT OUTER JOIN I_ChgImpactBOMItem AS _EngBOMItem ON BomItemLinks.EngBillOfMaterial = _EngBOMItem.BillOfMaterial AND BomItemLinks.EngBillOfMaterialCategory = _EngBOMItem.BillOfMaterialCategory AND BomItemLinks.EngBillOfMaterialVariant = _EngBOMItem.BillOfMaterialVariant AND BomItemLinks.EngBillOfMaterialVersion = _EngBOMItem.BillOfMaterialVersion AND BomItemLinks.EngBOMItmInhtdNodeNmbr = _EngBOMItem.InheritedNodeNumberForBOMItem  -- association [0..1]
;

Learn More