I_SalesBOMItemHdrChangeState

@AbapCatalog.sqlViewName: 'IKBOMITEMHDRCHG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Sales Order BOM Item change state'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
define view I_SalesBOMItemHdrChangeState as select from I_BillOfMaterialComponent as valid_items
                 inner join I_BillOfMaterial as stko on
                            valid_items.BillOfMaterial = stko.BillOfMaterial and
                            valid_items.BillOfMaterialCategory = stko.BillOfMaterialCategory and
                            valid_items.BillOfMaterialVariant = stko.BillOfMaterialVariant and
                            valid_items.BillOfMaterialVersion = stko.BillOfMaterialVersion and 
                            valid_items.BillOfMaterialCategory = 'K'
                 association [0..1] to I_SalesOrderBOMLink   as _SalesOrderBOMLink                
                            on $projection.BillOfMaterialCategory = _SalesOrderBOMLink .BillOfMaterialCategory
                            and $projection.BillOfMaterial         = _SalesOrderBOMLink .BillOfMaterial
                            and $projection.BillOfMaterialVariant  = _SalesOrderBOMLink .BillOfMaterialVariant
{
  key  valid_items.BillOfMaterialCategory,
  //key  valid_items.BillOfMaterial,

  key cast( valid_items.BillOfMaterial as char8 preserving type ) as BillOfMaterial,
     //@ObjectModel.readOnly: true

      //@ObjectModel.readOnly: true

  key    valid_items.BillOfMaterialVariant,
  key    valid_items.BillOfMaterialVersion,
      --stko.Plant,
      
  key    valid_items.BillOfMaterialItemNodeNumber,
     // @ObjectModel.readOnly: true

  key valid_items.BillOfMaterialItemUUID,
  key stko.EngineeringChangeDocument as HeaderChangeDocument,
      _SalesOrderBOMLink.Material as Material, 
      _SalesOrderBOMLink.Plant as Plant,
      stko.BillOfMaterialVariantUsage,
      stko.BillOfMaterialHeaderUUID as BillOfMaterialHeaderUUID,
      stko.IsVersionBillOfMaterial,
      //@ObjectModel.readOnly: true

      --@EndUserText.label: ''
      valid_items.BOMItemInternalChangeCount,
      //@ObjectModel.readOnly: true

      @Semantics.businessDate.from: true
      valid_items.ValidityStartDate,
      //@ObjectModel.readOnly: true

      @Semantics.businessDate.to: true
      valid_items.ValidityEndDate,
      //@ObjectModel.readOnly: true

      valid_items.EngineeringChangeDocument,
      //@ObjectModel.readOnly: true

      valid_items.ChgToEngineeringChgDocument,
      //@ObjectModel.readOnly: true

      valid_items.InheritedNodeNumberForBOMItem,
      @ObjectModel.readOnly: true
      valid_items.InheritedNodeNumberVersionBOM,
      --@ObjectModel.readOnly: true
      //valid_items.BOMItemNodeCount,

      //@ObjectModel.readOnly: true

     -- @Semantics.businessDate.createdAt: true
      valid_items.BOMItemRecordCreationDate,
      
      valid_items.BOMItemCreatedByUser,
      valid_items.BOMItemLastChangeDate,
      valid_items.BOMItemLastChangedByUser,
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
      valid_items.BillOfMaterialComponent,
      @ObjectModel.foreignKey.association: '_BOMItemCategory'
      valid_items.BillOfMaterialItemCategory,
      //valid_items.BillOfMaterialItemNumber,

      cast(  valid_items.BillOfMaterialItemNumber as char4 preserving type ) as  BillOfMaterialItemNumber,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      valid_items.BillOfMaterialItemUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      @DefaultAggregation :#NONE
    --  @ObjectModel.updateEnabled: true
      valid_items.BillOfMaterialItemQuantity,
      cast( valid_items.IsAssembly as stlkz preserving type )      as IsAssembly,
      //'' as AssemblyIndicator,

      valid_items.IsSubItem,
      valid_items.BOMItemSorter,
      //valid_items.FixedQuantity,

      valid_items.BOMItemHasFixedQuantity,
      valid_items.PurchasingGroup,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_Currency'
      valid_items.Currency,
      @Semantics.amount.currencyCode : 'Currency'
      @DefaultAggregation :#NONE
     -- @ObjectModel.updateEnabled: true
      valid_items.MaterialComponentPrice,
      valid_items.IdentifierBOMItem,
    --  @ObjectModel.updateEnabled: true
      valid_items.MaterialPriceUnitQty,
    --  @ObjectModel.updateEnabled: true
      valid_items.ComponentScrapInPercent,
    --  @ObjectModel.updateEnabled: true
      valid_items.OperationScrapInPercent,
   --   @ObjectModel.updateEnabled: true
      valid_items.IsNetScrap,
   --   @ObjectModel.updateEnabled: true
     // valid_items.NumberOfVariableSizeItem,

//       @Semantics.quantity.unitOfMeasure: 'NumberOfVariableSizeItem'

      cast( valid_items.NumberOfVariableSizeItem as abap.dec( 13, 3 ) ) as NumberOfVariableSizeItem,
     -- @ObjectModel.updateEnabled: true
      valid_items.QuantityVariableSizeItem,
   --   @ObjectModel.updateEnabled: true
      valid_items.FormulaKey,
   --   @ObjectModel.updateEnabled: true
      valid_items.BOMItemDescription,
  --    @ObjectModel.updateEnabled: true
      valid_items.BOMItemText2,
      valid_items.LongTextLanguage,
      valid_items.ComponentDescription,
      valid_items.MaterialGroup,
   --   @ObjectModel.updateEnabled: true
      valid_items.DocumentType,
    --  @ObjectModel.updateEnabled: true
      valid_items.DocNumber,
    --  @ObjectModel.updateEnabled: true
      valid_items.DocumentVersion,
    --  @ObjectModel.updateEnabled: true
      valid_items.DocumentPart,
      valid_items.ClassNumber,
      valid_items.ClassType,
      valid_items.ResultingItemCategory,
      valid_items.DependencyObjectNumber,
      valid_items.ObjectType as BillOfMaterialObjectType,
      valid_items.IsClassificationRelevant,
      valid_items.IsBulkMaterial,
      valid_items.BOMItemIsSparePart,
      valid_items.BOMItemIsSalesRelevant,
      valid_items.IsProductionRelevant,
      valid_items.BOMItemIsPlantMaintRelevant,
      valid_items.BOMItemIsCostingRelevant,
      valid_items.IsEngineeringRelevant,
      valid_items.SpecialProcurementType,
      valid_items.IsBOMRecursiveAllowed,
      valid_items.OperationLeadTimeOffset,
      valid_items.OpsLeadTimeOffsetUnit,
      valid_items.IsMaterialProvision,
      valid_items.BOMIsRecursive,
      valid_items.DocumentIsCreatedByCAD,
      valid_items.DistrKeyCompConsumption,
      valid_items.DeliveryDurationInDays,
      valid_items.Creditor,
      valid_items.CostElement,
      valid_items.Size1,
      valid_items.Size2,
      valid_items.Size3,
      valid_items.VariableSizeCompUnitOfMeasure,
      //valid_items.UnitOfMeasureForVarSizeItem,

      valid_items.UnitOfMeasureForSize1To3,
      valid_items.GoodsReceiptDuration,
      valid_items.PurchasingOrganization,
      valid_items.RequiredComponent,
      valid_items.MultipleSelectionAllowed,
      valid_items.ProdOrderIssueLocation,
      valid_items.MaterialIsCoProduct,
      valid_items.ExplosionType,
      valid_items.FollowUpGroup,
      valid_items.DiscontinuationGroup,
      valid_items.IsConfigurableBOM,
      valid_items.ReferencePoint,
      valid_items.LeadTimeOffset,
      valid_items.IsSoftwareComponent,
      valid_items.ProductionSupplyArea,
      valid_items.IsDeleted,
      valid_items.IsALE,
      valid_items.MaterialComponentIsPhantomItem,
      valid_items.IsPhantomItem,
      valid_items.BillOfMaterialItemCategoryDesc as BillOfMaterialItemCategoryDesc,
      valid_items.LastChangeDateTime             as LastChangeDateTime,
      //Alternative Item Fields

      valid_items.AlternativeItemGroup,
      valid_items.AlternativeItemPriority,
      valid_items.AlternativeItemStrategy,
      valid_items.UsageProbabilityPercent,
      valid_items.IsPMAssemblyRelevant,
      valid_items.OrigSalesOrderBOMItmCategory,
      //valid_items.OrigSalesOrderBOM,

      cast( valid_items.OrigSalesOrderBOM as char8 preserving type ) as OrigSalesOrderBOM,
      valid_items.OrigSalesOrderBOMItmNodeNumber,
      valid_items.OrigSalesOrderBOMItmNumber,
      valid_items.PreliminaryMaterial,
     // valid_items.BOMItemGroup,

      valid_items._BOMItemCategory,
      //_Material,

      valid_items._UnitOfMeasure,
      _Currency,
      //_BillOfMaterialVariantUsage,

     // valid_items._Kdst 

      _SalesOrderBOMLink 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIAL",
"I_BILLOFMATERIALCOMPONENT",
"I_SALESORDERBOMLINK"
],
"ASSOCIATED":
[
"I_BILLOFMATERIALITEMCATEGORY",
"I_CURRENCY",
"I_SALESORDERBOMLINK",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_BILLOFMATERIALCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/