I_BOOCharacteristic

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bill Of Operations Characteristic'
@ObjectModel.representativeKey: 'BOOCharacteristic'
@Analytics.technicalName: 'IPPBOOCHARC'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }

define view entity I_BOOCharacteristic
  as select distinct from plmk

  // --------------------------------------------------------------------------------------------------------

  // General Foreign Key Associations

  // --------------------------------------------------------------------------------------------------------

  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_BOOOperationInternalID as _BOOOperationInternalID on  $projection.BillOfOperationsType   = _BOOOperationInternalID.BillOfOperationsType
                                                                            and $projection.BillOfOperationsGroup  = _BOOOperationInternalID.BillOfOperationsGroup
                                                                            and $projection.BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID
{
      // --------------------------------------------------------------------------------------------------------

      // Key

      // --------------------------------------------------------------------------------------------------------

      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plmk.plnty                                            as BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plmk.plnnr                                            as BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key plmk.plnkn                                            as BOOOperationInternalID,
      // Field plmk.kzeinstell is an obsolete key field and no longer in use but as a non-representative key field it would require a foreign

      // key association pointing to a separate but empty domain fix value view (there are no domain fix values at all for this domain)

      // Thus the field is removed from the key and a projection on the only possible value (WHERE ... = ' ') is added instead

      //  key plmk.kzeinstell                                       as BOOCharacteristicType, // Indicator for charc. type (setup, inspection)

  key plmk.merknr                                           as BOOCharacteristic,

      plmk.versn                                            as BillOfOperationsVersion,

      // --------------------------------------------------------------------------------------------------------

      // Associations

      // --------------------------------------------------------------------------------------------------------

      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BOOOperationInternalID
}
where
  plmk.kzeinstell = ' '
group by
  plmk.plnty,
  plmk.plnnr,
  plmk.plnkn,
  plmk.kzeinstell,
  plmk.merknr,
  plmk.versn