P_BillOfMaterialHeader

@AbapCatalog.sqlViewName: 'PBOMHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
define view P_BillOfMaterialHeader
  as select from    I_BillOfMaterial    as materialBOM
//Left Outer Join will get no data

//Only Done to remove cast from SalesOrder field and use it in default search  

    left outer join I_SalesOrderBOMLink as _Kdst on  materialBOM.BillOfMaterialCategory = 'M'
                                                 and materialBOM.BillOfMaterial         = _Kdst.BillOfMaterial
                                                 and materialBOM.BillOfMaterialVariant  = _Kdst.BillOfMaterialVariant

{
  key materialBOM.BillOfMaterialHeaderUUID         as BillOfMaterialHeaderUUID,
  key materialBOM.BillOfMaterialVariantUsage       as BillOfMaterialVariantUsage,
  key materialBOM.BillOfMaterialCategory           as BillOfMaterialCategory,
  key materialBOM.BillOfMaterial                   as BillOfMaterial,
  key materialBOM.BillOfMaterialVariant            as BillOfMaterialVariant,
  key materialBOM.BillOfMaterialVersion            as BillOfMaterialVersion,
  key materialBOM.EngineeringChangeDocument        as EngineeringChangeDocument,
  key _Mast.Material                               as Material,
  key _Mast.Plant                                  as Plant,
      _Kdst.SalesOrder                             as SalesOrder,
    //  cast('' as cs_vbeln ) as SalesOrder,

      cast( '000000' as cs_vbpos preserving type ) as SalesOrderItem,

      //materialBOM.BillOfMaterialVariantUsage                                                                                                                                     as BillOfMaterialVariantUsage,

      // materialBOM.BillOfMaterialHeaderUUID                                                                                                                                        as BillOfMaterialHeaderUUID,

      --      bintohex( materialBOM.BillOfMaterialHeaderUUID )                                                                                                                            as BOMCharUUID,
      materialBOM.BillOfMaterialUUID               as BillOfMaterialUUID,
      materialBOM.IsMultipleBOMAlt                 as IsMultipleBOMAlt,
      //@ObjectModel.readOnly: true

      materialBOM.BOMHeaderInternalChangeCount     as BOMHeaderInternalChangeCount,
      //@ObjectModel.readOnly: true

      materialBOM.BOMPrioritizedVersion            as BOMPrioritizedVersion,
      @Consumption.hidden: true
      //@ObjectModel.readOnly: true

      materialBOM.BOMExplosionApplication          as BOMExplosionApplication,
      //@ObjectModel.readOnly: true

      materialBOM.BOMUsagePriority                 as BOMUsagePriority,
      materialBOM.BillOfMaterialAuthsnGrp          as BillOfMaterialAuthsnGrp,
      materialBOM.BOMVersionStatus                 as BOMVersionStatus,
      _Mast.MaterialToLotSizeQuantity,
      _Mast.MatFromLotSizeQuantity,
      materialBOM.IsVersionBillOfMaterial          as IsVersionBillOfMaterial,
      materialBOM.IsLatestBOMVersion               as IsLatestBOMVersion,
      materialBOM.BOMTechnicalType                 as BOMTechnicalType,
      materialBOM.BOMGroup                         as BOMGroup,
      materialBOM.IndicatorIsBOMWithDateHistory    as IndicatorIsBOMWithDateHistory,
      materialBOM.IndicatorIsBOMChangedWithHist    as IndicatorIsBOMChangedWithHist,
      materialBOM.BOMHeaderText                    as BOMHeaderText,
      materialBOM.BOMAlternativeText               as BOMAlternativeText,
      materialBOM.LongTextLanguage                 as LongTextLanguage,
      cast('' as ltxzu preserving type)            as LongTextExists,
      materialBOM.BillOfMaterialStatus             as BillOfMaterialStatus,
    //  @ObjectModel.readOnly: true

 //     @Semantics.businessDate.to: true

      materialBOM.HeaderValidityEndDate,
      @Semantics.businessDate.from: true
      materialBOM.HeaderValidityStartDate,
      materialBOM.ChgToEngineeringChgDocument      as ChgToEngineeringChgDocument,
      materialBOM.IsMarkedForDeletion              as IsMarkedForDeletion,
      materialBOM.BOMIsArchivedForDeletion,
      materialBOM.IsConfiguredMaterial             as IsConfiguredMaterial, -- MAST-KZKFG
      materialBOM.BOMIsConfigurable                as BOMIsConfigurable, -- MAST-KZKFG
      //@ObjectModel.readOnly: true

      materialBOM.IsALE                            as IsALE,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      materialBOM.BOMHeaderBaseUnit                as BOMHeaderBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
      @DefaultAggregation :#NONE
      materialBOM.BOMHeaderQuantityInBaseUnit      as BOMHeaderQuantityInBaseUnit,
      materialBOM.RecordCreationDate               as RecordCreationDate,
      materialBOM.LastChangeDate                   as LastChangeDate,
      materialBOM.LastChangedByUser                as LastChangedByUser,
      materialBOM.CreatedByUser                    as CreatedByUser,
      materialBOM.BOMIsToBeDeleted                 as BOMIsToBeDeleted,
      materialBOM.DocumentIsCreatedByCAD           as DocumentIsCreatedByCAD,
      materialBOM.LaboratoryOrDesignOffice         as LaboratoryOrDesignOffice,
      materialBOM.LastChangeDateTime               as LastChangeDateTime,
      materialBOM.BOMAssetNtwkHndovrIsRelevant     as BOMAssetNtwkHndovrIsRelevant,
      materialBOM._Mast.MaterialBOMObjectID        as MaterialBOMObjectID,
      --   '' as BOMPredecessorVersion,
      materialBOM.BOMPredecessorVersion
      

}
where
   materialBOM.BillOfMaterialCategory = 'M'

union all select from I_BillOfMaterial as orderBOM
{
  key orderBOM.BillOfMaterialHeaderUUID     as BillOfMaterialHeaderUUID,
  key orderBOM.BillOfMaterialVariantUsage   as BillOfMaterialVariantUsage,
  key orderBOM.BillOfMaterialCategory       as BillOfMaterialCategory,
  key orderBOM.BillOfMaterial               as BillOfMaterial,
  key orderBOM.BillOfMaterialVariant        as BillOfMaterialVariant,
  key orderBOM.BillOfMaterialVersion        as BillOfMaterialVersion,
  key orderBOM.EngineeringChangeDocument    as EngineeringChangeDocument,
  key _Kdst.Material                        as Material,
  key _Kdst.Plant                           as Plant,
      _Kdst.SalesOrder                      as SalesOrder,
      _Kdst.SalesOrderItem                  as SalesOrderItem,

      //orderBOM.BillOfMaterialVariantUsage                                                                                                                                     as BillOfMaterialVariantUsage,

      // orderBOM.BillOfMaterialHeaderUUID                                                                                                                                        as BillOfMaterialHeaderUUID,

      --      bintohex( orderBOM.BillOfMaterialHeaderUUID )                                                                                                                            as BOMCharUUID,
      orderBOM.BillOfMaterialUUID           as BillOfMaterialUUID,
      orderBOM.IsMultipleBOMAlt             as IsMultipleBOMAlt,
      //@ObjectModel.readOnly: true

      orderBOM.BOMHeaderInternalChangeCount as BOMHeaderInternalChangeCount,
      //@ObjectModel.readOnly: true

      orderBOM.BOMPrioritizedVersion        as BOMPrioritizedVersion,
      @Consumption.hidden: true
      //@ObjectModel.readOnly: true

      orderBOM.BOMExplosionApplication      as BOMExplosionApplication,
      //@ObjectModel.readOnly: true

      orderBOM.BOMUsagePriority             as BOMUsagePriority,
      orderBOM.BillOfMaterialAuthsnGrp      as BillOfMaterialAuthsnGrp,
      orderBOM.BOMVersionStatus             as BOMVersionStatus,
      cast( 0 as losvn )                    as MaterialToLotSizeQuantity,
      cast( 0 as losbs )                    as MatFromLotSizeQuantity,
      orderBOM.IsVersionBillOfMaterial      as IsVersionBillOfMaterial,
      orderBOM.IsLatestBOMVersion           as IsLatestBOMVersion,
      orderBOM.BOMTechnicalType             as BOMTechnicalType,
      orderBOM.BOMGroup                     as BOMGroup,
      orderBOM.IndicatorIsBOMWithDateHistory as IndicatorIsBOMWithDateHistory,
      orderBOM.IndicatorIsBOMChangedWithHist as IndicatorIsBOMChangedWithHist,
      orderBOM.BOMHeaderText                as BOMHeaderText,
      orderBOM.BOMAlternativeText           as BOMAlternativeText,
      orderBOM.LongTextLanguage             as LongTextLanguage,
      cast('' as ltxzu )                    as LongTextExists,
      orderBOM.BillOfMaterialStatus         as BillOfMaterialStatus,
      //@ObjectModel.readOnly: true

      @Semantics.businessDate.to: true
      orderBOM.HeaderValidityEndDate,
      @Semantics.businessDate.from: true
      orderBOM.HeaderValidityStartDate,
      orderBOM.ChgToEngineeringChgDocument  as ChgToEngineeringChgDocument,
      orderBOM.IsMarkedForDeletion          as IsMarkedForDeletion,
      orderBOM.BOMIsArchivedForDeletion,
      orderBOM.IsConfiguredMaterial         as IsConfiguredMaterial, -- MAST-KZKFG
      orderBOM.BOMIsConfigurable            as BOMIsConfigurable, -- MAST-KZKFG
      //@ObjectModel.readOnly: true

      orderBOM.IsALE                        as IsALE,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      orderBOM.BOMHeaderBaseUnit            as BOMHeaderBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
      @DefaultAggregation :#NONE
      orderBOM.BOMHeaderQuantityInBaseUnit  as BOMHeaderQuantityInBaseUnit,
      orderBOM.RecordCreationDate           as RecordCreationDate,
      orderBOM.LastChangeDate               as LastChangeDate,
      orderBOM.LastChangedByUser            as LastChangedByUser,
      orderBOM.CreatedByUser                as CreatedByUser,
      orderBOM.BOMIsToBeDeleted             as BOMIsToBeDeleted,
      orderBOM.DocumentIsCreatedByCAD       as DocumentIsCreatedByCAD,
      orderBOM.LaboratoryOrDesignOffice     as LaboratoryOrDesignOffice,
      orderBOM.LastChangeDateTime           as LastChangeDateTime,
      orderBOM.BOMAssetNtwkHndovrIsRelevant as BOMAssetNtwkHndovrIsRelevant,
      cast('' as cs_matbom_key )            as MaterialBOMObjectID,
      --   '' as BOMPredecessorVersion,
      orderBOM.BOMPredecessorVersion
      

}
where
  BillOfMaterialCategory = 'K'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIAL",
"I_MATERIALBOMLINK",
"I_SALESORDERBOMLINK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/