I_ChgRecdMstrRcpProdnVersion

DDL: I_CHGRECDMSTRRCPPRODNVERSION Type: view_entity COMPOSITE Package: VDM_PLMB_CR

Production Version for CR Master Recipe

I_ChgRecdMstrRcpProdnVersion is a Composite CDS View that provides data about "Production Version for CR Master Recipe" in SAP S/4HANA. It reads from 1 data source (I_ProductionVersion) and exposes 9 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, Material, Plant. It has 3 associations to related views. Part of development package VDM_PLMB_CR.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersion I_ProductionVersion from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_BillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
EndUserText.label Production Version for CR Master Recipe view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType BillOfOperationsType
KEY BillOfOperationsGroup BillOfOperationsGroup
KEY BillOfOperationsVariant BillOfOperationsVariant
KEY Material Material
KEY Plant Plant
KEY ProductionVersion
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM.viewType:#COMPOSITE
@EndUserText.label: 'Production Version for CR Master Recipe'
define view entity I_ChgRecdMstrRcpProdnVersion as select from I_ProductionVersion
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 BillOfOperationsType,
   @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key BillOfOperationsGroup,
   @ObjectModel.foreignKey.association: '_BillOfOperations'
  key BillOfOperationsVariant,
  key Material,
  key Plant,
  key max(ProductionVersion) as ProductionVersion,
      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsType
}group by BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, 
 Material, Plant

Learn More