C_ChangeRecordMasterRcpMatVH

DDL: C_CHANGERECORDMASTERRCPMATVH Type: view_entity CONSUMPTION Package: VDM_PLMB_CR

Master Recipe Value Help by Material

C_ChangeRecordMasterRcpMatVH is a Consumption CDS View that provides data about "Master Recipe Value Help by Material" in SAP S/4HANA. It has 1 association to related views. Part of development package VDM_PLMB_CR.

10 fields

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProductionVersion _ProductionVersion $projection.BillOfOperationsType = _ProductionVersion.BillOfOperationsType and $projection.BillOfOperationsGroup = _ProductionVersion.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _ProductionVersion.BillOfOperationsVariant

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Master Recipe Value Help by Material view
ObjectModel.representativeKey BillOfOperationsGroup view
Analytics.technicalName CMASTERRCPMATVH view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material _ProductionVersion Material Material
KEY Plant _ProductionVersion Plant
KEY BillOfOperationsGroup Recipe Group
KEY BillOfOperationsVariant _BillOfOperations BillOfOperationsVariant Recipe
KEY BillOfOperationsType _BillOfOperations BillOfOperationsType
KEY ProductionVersion _ProductionVersion ProductionVersion Prod. Version
BillOfOperationsProfile Profile
BillOfOperationsUsage
IsMarkedForDeletion _BillOfOperations IsMarkedForDeletion
_ProductionVersion _ProductionVersion 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Master Recipe Value Help by Material'
@ObjectModel.representativeKey: 'BillOfOperationsGroup'
@Analytics.technicalName: 'CMASTERRCPMATVH'
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #S}
@Search.searchable: true
define view entity C_ChangeRecordMasterRcpMatVH
    as select distinct from I_BillOfOperations as _BillOfOperations 
    association [0..*] to I_ProductionVersion            as _ProductionVersion            on $projection.BillOfOperationsType    = _ProductionVersion.BillOfOperationsType
                                                                                         and $projection.BillOfOperationsGroup   = _ProductionVersion.BillOfOperationsGroup
                                                                                         and $projection.BillOfOperationsVariant = _ProductionVersion.BillOfOperationsVariant    
                                                                                        

{
  @EndUserText.label: 'Material'
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  key _ProductionVersion.Material as Material,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  key _ProductionVersion.Plant as Plant,
  @EndUserText.label: 'Recipe Group'
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  key cast( _BillOfOperations.BillOfOperationsGroup as r_plnnr preserving type) as BillOfOperationsGroup,
  @Search.defaultSearchElement: true
  @EndUserText.label: 'Recipe'
  key _BillOfOperations.BillOfOperationsVariant,
  @Search.defaultSearchElement: true
  @UI.hidden: true
  key _BillOfOperations.BillOfOperationsType,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @EndUserText.label: 'Prod. Version'
  key _ProductionVersion.ProductionVersion as ProductionVersion,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @EndUserText.label: 'Profile'
  _BillOfOperations._BillOfOperationsChangeState.BillOfOperationsProfile as BillOfOperationsProfile,
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  cast(_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date 
  and ValidityEndDate >= $session.system_date].BillOfOperationsDesc as r_rbez preserving type) as BillOfOperationsDesc ,
  @Search.defaultSearchElement: true
  _BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date
  and ValidityEndDate >= $session.system_date].BillOfOperationsUsage,
  @Search.defaultSearchElement: true
  cast(_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date
  and ValidityEndDate >= $session.system_date].BillOfOperationsStatus as r_statu preserving type) as BillOfOperationsStatus,
  @Search.defaultSearchElement: true
  _BillOfOperations.IsMarkedForDeletion as IsMarkedForDeletion,
  _ProductionVersion
//  _BOOMaterialAssgmtChangeState

}
    where _BillOfOperations.BillOfOperationsType = '2'

Learn More