C_EngineeringRedlineBOM

DDL: C_ENGINEERINGREDLINEBOM Type: view_entity CONSUMPTION

Bill of Material Redlining

C_EngineeringRedlineBOM is a Consumption CDS View that provides data about "Bill of Material Redlining" in SAP S/4HANA. It reads from 1 data source (I_MaterialBOM) and exposes 20 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialBOM _BOMHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_EngineeringRedlineBOMItem _BOMItem $projection.BillOfMaterialCategory = _BOMItem.BillOfMaterialCategory and $projection.BillOfMaterial = _BOMItem.BillOfMaterial and $projection.BillOfMaterialVariant = _BOMItem.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BOMItem.BillOfMaterialVersion

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of Material Redlining view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
UI.headerInfo.typeName "Bill Of Material" view
Metadata.allowExtensions true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory BillOfMaterialCategory
KEY BillOfMaterial
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY BillOfMaterialVersion BillOfMaterialVersion
KEY EngineeringChangeDocument EngineeringChangeDocument
KEY Material Material
KEY Plant Plant
MaterialName
PlantName _Plant PlantName
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID
BOMAlternativeText BOMAlternativeText
BillOfMaterialStatus BillOfMaterialStatus
CreatedByUser CreatedByUser
RecordCreationDate RecordCreationDate
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
_BOMItem _BOMItem
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bill of Material Redlining'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@Search.searchable: true
@UI.headerInfo:{typeName:'"Bill Of Material"'}
@Metadata.allowExtensions: true

define view entity C_EngineeringRedlineBOM
  as select from I_MaterialBOM as _BOMHeader

  association [0..*] to C_EngineeringRedlineBOMItem as _BOMItem on  $projection.BillOfMaterialCategory = _BOMItem.BillOfMaterialCategory
                                                                and $projection.BillOfMaterial         = _BOMItem.BillOfMaterial
                                                                and $projection.BillOfMaterialVariant  = _BOMItem.BillOfMaterialVariant
                                                                and $projection.BillOfMaterialVersion  = _BOMItem.BillOfMaterialVersion

{
  key BillOfMaterialCategory,
  key cast( BillOfMaterial as bom_id preserving type ) as BillOfMaterial,
  key BillOfMaterialVariant,
  key BillOfMaterialVersion,
  key EngineeringChangeDocument,
  key Material,
  key Plant,
  
  _Material._Text[Language = $session.system_language].MaterialName,
  _Plant.PlantName,
  BillOfMaterialVariantUsage,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc,
  BillOfMaterialHeaderUUID,
  BOMAlternativeText,
  BillOfMaterialStatus,
  CreatedByUser,
  RecordCreationDate,
  LastChangeDate,
  LastChangedByUser,
  
   _BOMItem,
   _BillOfMaterialVariantUsage
}
where
      HeaderValidityStartDate <= $session.system_date
  and HeaderValidityEndDate   > $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIALUSAGE",
"I_MATERIAL",
"I_MATERIALBOM",
"I_MATERIALTEXT",
"I_PLANT"
],
"ASSOCIATED":
[
"C_ENGINEERINGREDLINEBOMITEM",
"I_BILLOFMATERIALUSAGE"
],
"BASE":
[
"I_MATERIALBOM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More