C_ChgImpactPlngRoutingMBOM

DDL: C_CHGIMPACTPLNGROUTINGMBOM SQL: CCHGIMPLNGROUMBM Type: view CONSUMPTION

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.

1 data source(s) 25 fields

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
KEY BillOfOperationsType BillOfOperationsType
KEY BOOMatlInternalVersionCounter BOOMatlInternalVersionCounter
KEY BillOfOperationsVariant BillOfOperationsVariant
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY Plant Plant
Material Material
MaterialName
BillOfMaterialVariantUsageDesc
PlantName _PlantText PlantName
BillOfMaterialCategory BillOfMaterialCategory
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
ChangeNumber ChangeNumber
IsDeleted IsDeleted
BOMVersionStatus BOMVersionStatus
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
BillOfMaterialVersion BillOfMaterialVersion
BOMVersionStatusDescription _VersionStatus BOMVersionStatusDescription
_MaterialText _MaterialText
_PlantText _PlantText
_BOMUsageText _BOMUsageText
_VersionStatus _VersionStatus 
@AbapCatalog.sqlViewName: 'CCHGIMPLNGROUMBM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Planning Routing MBOM Details'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@UI.presentationVariant.requestAtLeast: ['BOMVersionStatus', 'BillOfMaterialVersion']
define view C_ChgImpactPlngRoutingMBOM
  as select from I_BOOPlngBOMAssignment as BOOPlngBOMAssignment
  association [0..*] to I_MaterialText            as _MaterialText  on  $projection.Material = _MaterialText.Material
  association [0..1] to I_Plant                   as _PlantText     on  $projection.Plant = _PlantText.Plant
  association [0..*] to I_BillOfMaterialUsageText as _BOMUsageText  on  $projection.BillOfMaterialVariantUsage = _BOMUsageText.BillOfMaterialVariantUsage
  association [0..1] to I_VersionStatus           as _VersionStatus on  $projection.BOMVersionStatus = _VersionStatus.BOMVersionStatus
                                                                    and _VersionStatus.Language      = $session.system_language

{
          @UI.hidden: true
  key     BOOToMaterialInternalID,
  key     BillOfOperationsGroup,
  key     BillOfOperationsType,

          @UI.hidden: true
  key     BOOMatlInternalVersionCounter,
  key     BillOfOperationsVariant,

          @EndUserText.label: 'BOM'
          @EndUserText.quickInfo: 'Bill Of Material'
          @UI.lineItem.position:10
  key     BillOfMaterial,

          @UI.lineItem.position:20
  key     BillOfMaterialVariant,

          @UI.lineItem.position:50
          @ObjectModel.text.element:  [ 'PlantName' ]
  key     Plant,

          @UI.lineItem.position:40
          @ObjectModel.text: {
            element: 'MaterialName'
          }
          Material,

          @UI.hidden: true
          _MaterialText[1:Language = $session.system_language].MaterialName                   as MaterialName,
          @UI.hidden: true
          _BOMUsageText[1:Language = $session.system_language].BillOfMaterialVariantUsageDesc as BillOfMaterialVariantUsageDesc,
          @UI.hidden: true
          _PlantText.PlantName,


          BillOfMaterialCategory,
          @UI.lineItem.position:30
          @ObjectModel.text.element: [ 'BillOfMaterialVariantUsageDesc']
          BillOfMaterialVariantUsage,

          ChangeNumber,
          @UI.hidden: true
          IsDeleted,
          
          @ObjectModel.text.element:  [ 'BOMVersionStatusDescription' ]
          BOMVersionStatus,

          @Semantics.businessDate: {
            from: true
          }
          @UI.lineItem.position:60
          ValidityStartDate,
          @Semantics.businessDate: {
          to: true
          }
          @UI.lineItem.position:70
          ValidityEndDate,
          
          BillOfMaterialVersion,

          @UI.hidden: true
          _VersionStatus.BOMVersionStatusDescription,

          _MaterialText,
          _PlantText,
          _BOMUsageText,
          _VersionStatus
}

Learn More