C_ChgImpactPlngRoutingMBOM

DDL: C_CHGIMPACTPLNGROUTINGMBOM SQL: CCHGIMPLNGROUMBM Type: view CONSUMPTION Package: MPE_PLAN_CIMA
25 Fields 1 Data Sources 4 Associations

Planning Routing MBOM Details

C_ChgImpactPlngRoutingMBOM is a Consumption CDS View that provides data about "Planning Routing MBOM Details" in SAP S/4HANA. It reads from 1 data source (I_BOOPlngBOMAssignment) and exposes 25 fields with key fields BOOToMaterialInternalID, BillOfOperationsGroup, BillOfOperationsType, BOOMatlInternalVersionCounter, BillOfOperationsVariant. It has 4 associations to related views. Part of development package MPE_PLAN_CIMA.

Data Sources (1)

SourceAliasJoin Type
I_BOOPlngBOMAssignment BOOPlngBOMAssignment from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] I_Plant _PlantText $projection.Plant = _PlantText.Plant
[0..*] I_BillOfMaterialUsageText _BOMUsageText $projection.BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage
[0..1] I_VersionStatus _VersionStatus $projection.BOMVersionStatus = _VersionStatus.BOMVersionStatus and _VersionStatus.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCHGIMPLNGROUMBM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Planning Routing MBOM Details view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY BOOToMaterialInternalID BOOToMaterialInternalID
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BOOMatlInternalVersionCounter BOOMatlInternalVersionCounter
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY Plant Plant Valuation Area
Material Material Vehicle Model
MaterialName
BillOfMaterialVariantUsageDesc
PlantName _PlantText PlantName Plant Name
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
ChangeNumber ChangeNumber Change Number
IsDeleted IsDeleted TRUE
BOMVersionStatus BOMVersionStatus BOM Version Status
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
BillOfMaterialVersion BillOfMaterialVersion BOM Version
BOMVersionStatusDescription _VersionStatus BOMVersionStatusDescription Short Description
_MaterialText _MaterialText
_PlantText _PlantText
_BOMUsageText _BOMUsageText
_VersionStatus _VersionStatus

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_ChgImpactPlngRoutingMBOM.
-- 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: CCHGIMPLNGROUMBM

CREATE VIEW C_ChgImpactPlngRoutingMBOM AS
SELECT
  BOOToMaterialInternalID,
  BillOfOperationsGroup,
  BillOfOperationsType,
  BOOMatlInternalVersionCounter,
  BillOfOperationsVariant,
  BillOfMaterial,
  BillOfMaterialVariant,
  Plant,
  Material,
  _MaterialText[1:Language = $session.system_language].MaterialName AS MaterialName,
  _BOMUsageText[1:Language = $session.system_language].BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  _PlantText.PlantName AS PlantName,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  ChangeNumber,
  IsDeleted,
  BOMVersionStatus,
  ValidityStartDate,
  ValidityEndDate,
  BillOfMaterialVersion,
  _VersionStatus.BOMVersionStatusDescription AS BOMVersionStatusDescription
FROM I_BOOPlngBOMAssignment AS BOOPlngBOMAssignment
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _PlantText ON Plant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsageText AS _BOMUsageText ON BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage  -- association [0..*]
LEFT OUTER JOIN I_VersionStatus AS _VersionStatus ON BOMVersionStatus = _VersionStatus.BOMVersionStatus AND _VersionStatus.Language = $session.system_language  -- association [0..1]
;

Learn More