I_ChgImpactEBOMReltdObj

DDL: I_CHGIMPACTEBOMRELTDOBJ SQL: ICHEBOMRELTDOBJ Type: view COMPOSITE Package: MPE_PLAN_CIMA
44 Fields 1 Associations

Eng BOM Hdrs With Links to Its Rel Obj

I_ChgImpactEBOMReltdObj is a Composite CDS View that provides data about "Eng BOM Hdrs With Links to Its Rel Obj" in SAP S/4HANA. It has 1 association to related views. Part of development package MPE_PLAN_CIMA.

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ChgImpactEngBOMMfgBOMHdr _MfgBOMLinked $projection.BillOfMaterialHeaderUUID = _MfgBOMLinked.EngBillOfMaterialHeaderUUID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ICHEBOMRELTDOBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Eng BOM Hdrs With Links to Its Rel Obj view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory EngBOM BillOfMaterialCategory BOM category
KEY BillOfMaterial EngBOM BillOfMaterial BOM
KEY BillOfMaterialVariant EngBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion EngBOM BillOfMaterialVersion BOM Version
KEY Material EngBOM Material Vehicle Model
KEY Plant EngBOM Plant Valuation Area
BillOfMaterialHeaderUUID EngBOM BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage EngBOM BillOfMaterialVariantUsage Usage
BillOfMaterialUUID EngBOM BillOfMaterialUUID Character Field of Length 12
IsMultipleBOMAlt EngBOM IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount EngBOM BOMHeaderInternalChangeCount Counter
BOMPrioritizedVersion EngBOM BOMPrioritizedVersion Selection ID
BOMExplosionApplication EngBOM BOMExplosionApplication BOM Application
BOMUsagePriority EngBOM BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp EngBOM BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus EngBOM BOMVersionStatus BOM Version Status
IsVersionBillOfMaterial EngBOM IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion EngBOM IsLatestBOMVersion Latest Rel Version
IsConfiguredMaterial EngBOM IsConfiguredMaterial Configured matl
BOMTechnicalType EngBOM BOMTechnicalType Tech type
BOMGroup EngBOM BOMGroup BOM group
BOMHeaderText EngBOM BOMHeaderText BOM Description
BOMAlternativeText EngBOM BOMAlternativeText Alt Text
BillOfMaterialStatus EngBOM BillOfMaterialStatus BOM Status
HeaderValidityStartDate EngBOM HeaderValidityStartDate Valid From
HeaderValidityEndDate EngBOM HeaderValidityEndDate to
EngineeringChangeDocument EngBOM EngineeringChangeDocument Change Number
ChgToEngineeringChgDocument EngBOM ChgToEngineeringChgDocument Change No. To
IsMarkedForDeletion EngBOM IsMarkedForDeletion Purch.org. data
IsALE EngBOM IsALE ALE indicator
BOMHeaderBaseUnit EngBOM BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit EngBOM BOMHeaderQuantityInBaseUnit Base quantity
RecordCreationDate EngBOM RecordCreationDate Created On
LastChangeDate EngBOM LastChangeDate Time Stamp
CreatedByUser EngBOM CreatedByUser User Name
LastChangedByUser EngBOM LastChangedByUser User Name
BOMIsToBeDeleted EngBOM BOMIsToBeDeleted Handling Del. Flag
DocumentIsCreatedByCAD EngBOM DocumentIsCreatedByCAD CAD Indicator
LaboratoryOrDesignOffice EngBOM LaboratoryOrDesignOffice Lab/Office
EffectivityType UnitizedMatl EffectivityType
_BillOfMaterialItem EngBOM _BillOfMaterialItem
_BillOfMaterialVariantUsage EngBOM _BillOfMaterialVariantUsage
_UnitOfMeasure EngBOM _UnitOfMeasure
_MfgBOMLinked _MfgBOMLinked

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_ChgImpactEBOMReltdObj.
-- 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: ICHEBOMRELTDOBJ

CREATE VIEW I_ChgImpactEBOMReltdObj AS
SELECT
  EngBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  EngBOM.BillOfMaterial AS BillOfMaterial,
  EngBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  EngBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  EngBOM.Material AS Material,
  EngBOM.Plant AS Plant,
  EngBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  EngBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  EngBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  EngBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  EngBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  EngBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  EngBOM.BOMExplosionApplication AS BOMExplosionApplication,
  EngBOM.BOMUsagePriority AS BOMUsagePriority,
  EngBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  EngBOM.BOMVersionStatus AS BOMVersionStatus,
  EngBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  EngBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  EngBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  EngBOM.BOMTechnicalType AS BOMTechnicalType,
  EngBOM.BOMGroup AS BOMGroup,
  EngBOM.BOMHeaderText AS BOMHeaderText,
  EngBOM.BOMAlternativeText AS BOMAlternativeText,
  EngBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  EngBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  EngBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  EngBOM.EngineeringChangeDocument AS EngineeringChangeDocument,
  EngBOM.ChgToEngineeringChgDocument AS ChgToEngineeringChgDocument,
  EngBOM.IsMarkedForDeletion AS IsMarkedForDeletion,
  EngBOM.IsALE AS IsALE,
  EngBOM.BOMHeaderBaseUnit AS BOMHeaderBaseUnit,
  EngBOM.BOMHeaderQuantityInBaseUnit AS BOMHeaderQuantityInBaseUnit,
  EngBOM.RecordCreationDate AS RecordCreationDate,
  EngBOM.LastChangeDate AS LastChangeDate,
  EngBOM.CreatedByUser AS CreatedByUser,
  EngBOM.LastChangedByUser AS LastChangedByUser,
  EngBOM.BOMIsToBeDeleted AS BOMIsToBeDeleted,
  EngBOM.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  EngBOM.LaboratoryOrDesignOffice AS LaboratoryOrDesignOffice,
  UnitizedMatl.EffectivityType AS EffectivityType,
  EngBOM._BillOfMaterialItem AS _BillOfMaterialItem,
  EngBOM._BillOfMaterialVariantUsage AS _BillOfMaterialVariantUsage,
  EngBOM._UnitOfMeasure AS _UnitOfMeasure
LEFT OUTER JOIN I_ChgImpactEngBOMMfgBOMHdr AS _MfgBOMLinked ON BillOfMaterialHeaderUUID = _MfgBOMLinked.EngBillOfMaterialHeaderUUID  -- association [1..*]
;

Learn More