C_ChgRecdVarBOMVH

DDL: C_CHGRECDVARBOMVH SQL: CVARBOMVH Type: view CONSUMPTION Package: VDM_PLMB_CR_O

Change Record BOM

C_ChgRecdVarBOMVH is a Consumption CDS View that provides data about "Change Record BOM" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordBillOfMaterial, I_Material) and exposes 8 fields with key fields Material, Plant, BillOfMaterialVariantUsage, BillOfMaterialVariant. It has 2 associations to related views. Part of development package VDM_PLMB_CR_O.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeRecordBillOfMaterial BOM inner
I_Material Mat from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_BillOfMaterialUsage _BillOfMaterialVariantUsage $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CVARBOMVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Record BOM view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey Material view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Material I_ChangeRecordBillOfMaterial Material
KEY Plant I_ChangeRecordBillOfMaterial Plant
KEY BillOfMaterialVariantUsage I_ChangeRecordBillOfMaterial BillOfMaterialVariantUsage
KEY BillOfMaterialVariant I_ChangeRecordBillOfMaterial BillOfMaterialVariant
HeaderValidityStartDate I_ChangeRecordBillOfMaterial HeaderValidityStartDate
MaterialName
PlantName _Plant PlantName
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc 
@AbapCatalog.sqlViewName: 'CVARBOMVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Change Record BOM'
@ObjectModel.dataCategory: #VALUE_HELP 
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER]
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MASTER,
                         sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType:#CONSUMPTION
@Search.searchable: true
@AbapCatalog.preserveKey:true
@ObjectModel.representativeKey: 'Material'
define view C_ChgRecdVarBOMVH
  as select from I_Material                   as Mat
    inner join   I_ChangeRecordBillOfMaterial as BOM on BOM.Material = Mat.Material
  association [0..1] to I_Plant               as _Plant                      on $projection.Plant = _Plant.Plant
  association [0..1] to I_BillOfMaterialUsage as _BillOfMaterialVariantUsage on $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage
   // association [0..1] to I_BillOfMaterialUsage as _BILLOFMATERIALUSAGETEXT on $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage


{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 1.0
      @ObjectModel.text.element:  [ 'MaterialName' ]
  key BOM.Material,
      @Search.defaultSearchElement: true
  key BOM.Plant,
      @Search.defaultSearchElement: true
  key BOM.BillOfMaterialVariantUsage,
      @Search.defaultSearchElement: true
  key BOM.BillOfMaterialVariant,
//      @UI.hidden: true

//      BOM.BillOfMaterialHeaderUUID,  

      @UI.hidden: true
      BOM.HeaderValidityStartDate,
      @Search.defaultSearchElement: true
      //      @Search.fuzzinessThreshold: 0.8

      //      @Search.ranking: #HIGH

      //      BOM.EngineeringChangeDocument,

      @UI.selectionField.exclude: true
      Mat._Text[1:Language = $session.system_language].MaterialName as MaterialName,
      @Search.defaultSearchElement: false
      _Plant.PlantName,
      @Search.defaultSearchElement: false
      _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc
}
where
      Mat.Material         is not null
  and Mat.Material         <> ''
  and BOM.IsConfiguredMaterial = 'X'

Learn More