I_CHGRECDMSTRRCPMATLASSGMT

CDS View

Change Record Master Recipe Material

I_CHGRECDMSTRRCPMATLASSGMT is a CDS View in S/4HANA. Change Record Master Recipe Material. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecdRefMstrRcpMatl view_entity inner COMPOSITE Change Record Master Rcp Mat assignment

Fields (1)

KeyField CDS FieldsUsed in Views
Material Material 1 
@VDM.viewType:#COMPOSITE
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Master Recipe Material'
define view entity I_ChgRecdMstrRcpMatlAssgmt as select from I_BOOMaterialAssignment as MatAssgnmnt
association [1..1] to I_BillOfOperationsType    as _BillOfOperationsType  on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  association [1..1] to I_BillOfOperationsGroup   as _BillOfOperationsGroup on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                            and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
  association [1..1] to I_BillOfOperations        as _BillOfOperations      on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                            and $projection.BillOfOperationsGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                            and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant

{
   @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key MatAssgnmnt.BillOfOperationsType,
   @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key MatAssgnmnt.BillOfOperationsGroup,
   @ObjectModel.foreignKey.association: '_BillOfOperations'
  key MatAssgnmnt.BillOfOperationsVariant,
  min( Material ) as Material,
  _BillOfOperations,
  _BillOfOperationsGroup,
  _BillOfOperationsType
      
}
group by MatAssgnmnt.BillOfOperationsType,
 MatAssgnmnt.BillOfOperationsGroup, MatAssgnmnt.BillOfOperationsVariant

Learn More