I_BOOOperationPRTInternalID

DDL: I_BOOOPERATIONPRTINTERNALID SQL: IPPBOOOPPRTID Type: view_entity BASIC

BOO Operation Production Resource/Tool Internal ID

I_BOOOperationPRTInternalID is a Basic CDS View (Dimension) that provides data about "BOO Operation Production Resource/Tool Internal ID" in SAP S/4HANA. It has 5 associations to related views.

Associations (5)

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
[1..1] I_BOOOperationInternalID _BOOOperationInternalID $projection.BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup and $projection.BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID
[1..1] I_BillOfOperationsSequence _BillOfOperationsSequence $projection.BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey BOOOperationPRTInternalID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
EndUserText.label BOO Operation Production Resource/Tool Internal ID view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plfh plnty
KEY BillOfOperationsGroup plfh plnnr
KEY BillOfOperationsVariant plfh plnal
KEY BillOfOperationsSequence plfh plnfl
KEY BOOOperationInternalID plfh plnkn
KEY BOOOperationPRTInternalID plfh pzlfh
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations
_BOOOperationInternalID _BOOOperationInternalID
_BillOfOperationsSequence _BillOfOperationsSequence
//@AbapCatalog.sqlViewName: 'IPPBOOOPPRTID'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@Analytics.dataCategory: #DIMENSION
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'BOOOperationPRTInternalID'
//@AbapCatalog.compiler.compareFilter: true

@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@Search.searchable: true
@EndUserText.label: 'BOO Operation Production Resource/Tool Internal ID'
@Metadata.allowExtensions:true
//@AbapCatalog.preserveKey:true 


/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
//define view I_BOOOperationPRTInternalID

define view entity I_BOOOperationPRTInternalID
  as select distinct from plfh

  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

  association [1..1] to I_BOOOperationInternalID   as _BOOOperationInternalID   on  $projection.BillOfOperationsType   = _BOOOperationInternalID.BillOfOperationsType
                                                                                and $projection.BillOfOperationsGroup  = _BOOOperationInternalID.BillOfOperationsGroup
                                                                                and $projection.BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID

  association [1..1] to I_BillOfOperationsSequence as _BillOfOperationsSequence on  $projection.BillOfOperationsType     = _BillOfOperationsSequence.BillOfOperationsType
                                                                                and $projection.BillOfOperationsGroup    = _BillOfOperationsSequence.BillOfOperationsGroup
                                                                                and $projection.BillOfOperationsVariant  = _BillOfOperationsSequence.BillOfOperationsVariant
                                                                                and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence

{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plfh.plnty     as   BillOfOperationsType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key plfh.plnnr     as   BillOfOperationsGroup,

      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key plfh.plnal     as   BillOfOperationsVariant,

      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key plfh.plnfl     as   BillOfOperationsSequence,

      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key plfh.plnkn     as   BOOOperationInternalID,

  key plfh.pzlfh     as   BOOOperationPRTInternalID,

      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperations,
      _BOOOperationInternalID,
      _BillOfOperationsSequence

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PLFH"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSSEQUENCE",
"I_BILLOFOPERATIONSTYPE",
"I_BOOOPERATIONINTERNALID"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/