P_SalesOrderBOMHeader

@AbapCatalog.sqlViewName: 'PKBOMHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Private view for Sales order BoM header'
define view P_SalesOrderBOMHeader as 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,
      _Kdst,
      _UnitOfMeasure
}
where
  BillOfMaterialCategory = 'K'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIAL",
"I_SALESORDERBOMLINK"
],
"ASSOCIATED":
[
"I_SALESORDERBOMLINK",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_BILLOFMATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/