P_SALESORDERBOMHEADER

CDS View

Private view for Sales order BoM header

P_SALESORDERBOMHEADER is a CDS View in S/4HANA. Private view for Sales order BoM header. It contains 48 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 48 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesOrderBOMHeader view from BASIC Sales Order Bill Of Material Header

Fields (48)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialCategory BillOfMaterialCategory 1
KEY BillOfMaterialVariant BillOfMaterialVariant 1
KEY EngineeringChangeDocument EngineeringChangeDocument 1
KEY Material Material 1
KEY Plant Plant 1
BillOfMaterialAuthsnGrp BillOfMaterialAuthsnGrp 1
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
BillOfMaterialStatus BillOfMaterialStatus 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfMaterialVersion BillOfMaterialVersion 1
BOMAlternativeText BOMAlternativeText 1
BOMAssetNtwkHndovrIsRelevant BOMAssetNtwkHndovrIsRelevant 1
BOMExplosionApplication BOMExplosionApplication 1
BOMGroup BOMGroup 1
BOMHeaderBaseUnit BOMHeaderBaseUnit 1
BOMHeaderInternalChangeCount BOMHeaderInternalChangeCount 1
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit 1
BOMHeaderText BOMHeaderText 1
BOMIsArchivedForDeletion BOMIsArchivedForDeletion 1
BOMIsToBeDeleted BOMIsToBeDeleted 1
BOMPrioritizedVersion BOMPrioritizedVersion 1
BOMTechnicalType BOMTechnicalType 1
BOMUsagePriority BOMUsagePriority 1
BOMVersionStatus BOMVersionStatus 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 1
CreatedByUser CreatedByUser 1
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 1
HeaderValidityEndDate HeaderValidityEndDate 1
HeaderValidityStartDate HeaderValidityStartDate 1
IndicatorIsBOMChangedWithHist IndicatorIsBOMChangedWithHist 1
IndicatorIsBOMWithDateHistory IndicatorIsBOMWithDateHistory 1
IsConfiguredMaterial IsConfiguredMaterial 1
IsLatestBOMVersion IsLatestBOMVersion 1
IsMarkedForDeletion IsMarkedForDeletion 1
IsMultipleBOMAlt IsMultipleBOMAlt 1
IsVersionBillOfMaterial IsVersionBillOfMaterial 1
LaboratoryOrDesignOffice LaboratoryOrDesignOffice 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LongTextExists LongTextExists 1
LongTextLanguage LongTextLanguage 1
MaterialBOMObjectID MaterialBOMObjectID 1
MaterialToLotSizeQuantity MaterialToLotSizeQuantity 1
MatFromLotSizeQuantity MatFromLotSizeQuantity 1
RecordCreationDate RecordCreationDate 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1 
@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":""
}
}*/

Learn More