I_ChgImpactMBOMReltdObj

DDL: I_CHGIMPACTMBOMRELTDOBJ SQL: ICHIMPMBOMRELOB Type: view COMPOSITE

Mfg BOM Hdrs With Links To Its Reltd Obj

I_ChgImpactMBOMReltdObj is a Composite CDS View that provides data about "Mfg BOM Hdrs With Links To Its Reltd Obj" in SAP S/4HANA.

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHIMPMBOMRELOB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Mfg BOM Hdrs With Links To Its Reltd Obj view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory MfgBOM BillOfMaterialCategory BOM category
KEY BillOfMaterial MfgBOM BillOfMaterial BOM
KEY BillOfMaterialVariant MfgBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion MfgBOM BillOfMaterialVersion BOM Version
KEY Plant MfgBOM Plant Valuation Area
KEY Material MfgBOM Material Vehicle Model
BillOfMaterialHeaderUUID MfgBOM BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage MfgBOM BillOfMaterialVariantUsage Usage
BillOfMaterialUUID MfgBOM BillOfMaterialUUID Character Field of Length 12
IsMultipleBOMAlt MfgBOM IsMultipleBOMAlt Alt.det. MBOM
BOMHeaderInternalChangeCount MfgBOM BOMHeaderInternalChangeCount Counter
BOMPrioritizedVersion MfgBOM BOMPrioritizedVersion Selection ID
BOMExplosionApplication MfgBOM BOMExplosionApplication BOM Application
BOMUsagePriority MfgBOM BOMUsagePriority Sel. priority
BillOfMaterialAuthsnGrp MfgBOM BillOfMaterialAuthsnGrp Auth group
BOMVersionStatus MfgBOM BOMVersionStatus BOM Version Status
IsVersionBillOfMaterial MfgBOM IsVersionBillOfMaterial Versioning Relevant
IsLatestBOMVersion MfgBOM IsLatestBOMVersion Latest Rel Version
IsConfiguredMaterial MfgBOM IsConfiguredMaterial Configured matl
BOMTechnicalType MfgBOM BOMTechnicalType Tech type
BOMGroup MfgBOM BOMGroup BOM group
BOMHeaderText MfgBOM BOMHeaderText BOM Description
BOMAlternativeText MfgBOM BOMAlternativeText Alt Text
BillOfMaterialStatus MfgBOM BillOfMaterialStatus BOM Status
HeaderValidityStartDate MfgBOM HeaderValidityStartDate Valid From
HeaderValidityEndDate MfgBOM HeaderValidityEndDate to
EffectivityType EffectivityType

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_ChgImpactMBOMReltdObj.
-- 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: ICHIMPMBOMRELOB

CREATE VIEW I_ChgImpactMBOMReltdObj AS
SELECT
  MfgBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MfgBOM.BillOfMaterial AS BillOfMaterial,
  MfgBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MfgBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MfgBOM.Plant AS Plant,
  MfgBOM.Material AS Material,
  MfgBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MfgBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MfgBOM.BillOfMaterialUUID AS BillOfMaterialUUID,
  MfgBOM.IsMultipleBOMAlt AS IsMultipleBOMAlt,
  MfgBOM.BOMHeaderInternalChangeCount AS BOMHeaderInternalChangeCount,
  MfgBOM.BOMPrioritizedVersion AS BOMPrioritizedVersion,
  MfgBOM.BOMExplosionApplication AS BOMExplosionApplication,
  MfgBOM.BOMUsagePriority AS BOMUsagePriority,
  MfgBOM.BillOfMaterialAuthsnGrp AS BillOfMaterialAuthsnGrp,
  MfgBOM.BOMVersionStatus AS BOMVersionStatus,
  MfgBOM.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  MfgBOM.IsLatestBOMVersion AS IsLatestBOMVersion,
  MfgBOM.IsConfiguredMaterial AS IsConfiguredMaterial,
  MfgBOM.BOMTechnicalType AS BOMTechnicalType,
  MfgBOM.BOMGroup AS BOMGroup,
  MfgBOM.BOMHeaderText AS BOMHeaderText,
  MfgBOM.BOMAlternativeText AS BOMAlternativeText,
  MfgBOM.BillOfMaterialStatus AS BillOfMaterialStatus,
  MfgBOM.HeaderValidityStartDate AS HeaderValidityStartDate,
  MfgBOM.HeaderValidityEndDate AS HeaderValidityEndDate,
  EffectivityType
;