I_BILLOFOPERATIONSVERSION

CDS View

Bill of Operations Version

I_BILLOFOPERATIONSVERSION is a CDS View in S/4HANA. Bill of Operations Version. It contains 21 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 21 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ChangeRecordTmplRtgVH view from CONSUMPTION Template Routing
C_MfgStdTextVersWhereUsedList view inner CONSUMPTION View for ST Where Used List
C_SlsOrdProdnModProdnVersion view_entity inner CONSUMPTION Production Versions
I_BillOfOperationsVersStdVH view_entity from COMPOSITE Bill of Operations Version
I_ChgImpactMBOMRoutingLink view inner COMPOSITE Manufacturing BOMs Linked with Routing
I_ChgImpactOrdSpcfcRtg view left_outer COMPOSITE Order Specific Routings for POs
I_ProductionRoutingVersion view_entity from COMPOSITE Production Routing Version
P_LatestProductionRoutingVers view_entity from COMPOSITE
P_RTGVERSUIWFLHLP view_entity from BASIC

Fields (21)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup BillOfOperationsGroup,OrdSpcfcBOOGroup 6
KEY BillOfOperationsType BillOfOperationsType,OrdSpcfcBOOType 5
KEY BillOfOperationsVariant BillOfOperationsVariant,OrdSpcfcBOOVariant 6
KEY BillOfOperationsVersion BillOfOperationsVersion 4
_BillOfOperations _BillOfOperations 1
_BillOfOperationsGroup _BillOfOperationsGroup 1
_BillOfOperationsType _BillOfOperationsType 1
_BOOVersionStatus _BOOVersionStatus 1
_CreatedByUser _CreatedByUser 1
_LastChangedByUser _LastChangedByUser 1
BillOfOperationsRefGroup BillOfOperationsRefGroup 1
BillOfOperationsRefType BillOfOperationsRefType 1
BillOfOperationsRefVariant BillOfOperationsRefVariant 1
BillOfOperationsVersionStatus BillOfOperationsVersionStatus 1
BOOReferenceVersion BOOReferenceVersion 1
CreatedByUser CreatedByUser 1
IsLatestBOOVersion IsLatestBOOVersion 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
NumberOfBOOVersionSuccessors NumberOfBOOVersionSuccessors 1
OrderID OrderID 2 
@AbapCatalog.sqlViewName: 'IBOOVERSION'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@Analytics: {dataCategory: #DIMENSION}
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.representativeKey: 'BillOfOperationsVersion'
@EndUserText.label: 'Bill of Operations Version'
@Metadata.allowExtensions:true
define view I_BillOfOperationsVersion
  as select from plvk

  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
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
  association [1..1] to I_BOOVersionStatus      as _BOOVersionStatus      on  $projection.BillOfOperationsVersionStatus = _BOOVersionStatus.BillOfOperationsVersionStatus

  association [1..1] to I_User                  as _CreatedByUser         on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                  as _LastChangedByUser     on  $projection.LastChangedByUser = _LastChangedByUser.UserID

{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plnty                                                       as   BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plnnr                                                       as   BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_BillOfOperationsStdVH', element: 'BillOfOperationsVariant' } } ]
  key plnal                                                       as   BillOfOperationsVariant,
  key versn                                                       as   BillOfOperationsVersion,

      @ObjectModel.foreignKey.association: '_BOOVersionStatus'
      status                                                      as   BillOfOperationsVersionStatus,
      last_versn                                                  as   IsLatestBOOVersion,
      num_suc                                                     as   NumberOfBOOVersionSuccessors,

      -- Order specific Routing
      aufnr                                                       as   OrderID,

      -- Reference to Origin
      source_plnty                                                as   BillOfOperationsRefType,
      source_plnnr                                                as   BillOfOperationsRefGroup,
      source_plnal                                                as   BillOfOperationsRefVariant,
      source_versn                                                as   BOOReferenceVersion,

      -- Administrative Data
      @Semantics.user.createdBy: true
      cast(created_by as vdm_createdbyuserid preserving type)     as   CreatedByUser,
      //@Semantics.systemDateTime.createdAt: true

      created_at                                                  as   CreationDateTime,
      @Semantics.user.lastChangedBy: true
      cast(changed_by as vdm_lastchangedbyuserid preserving type) as   LastChangedByUser,
      //@Semantics.systemDateTime.lastChangedAt: true

      changed_at                                                  as   LastChangeDateTime,

      // **************************** Associations *****************************


      _BOOVersionStatus,
      _BillOfOperations,
      _BillOfOperationsGroup,
      _BillOfOperationsType,
      _CreatedByUser,
      _LastChangedByUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PLVK"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_BOOVERSIONSTATUS",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More