I_SalesOrderBOMHeader

DDL: I_SALESORDERBOMHEADER Type: view_entity BASIC Package: CS_MODEL_API

Sales Order Bill Of Material Header

I_SalesOrderBOMHeader is a Basic CDS View that provides data about "Sales Order Bill Of Material Header" in SAP S/4HANA. It reads from 2 data sources (P_SalesOrderBOMHeader, I_SalesDocument) and exposes 56 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, EngineeringChangeDocument, Material. It has 2 associations to related views. Part of development package CS_MODEL_API.

2 data source(s) 56 fields

Data Sources (2)

SourceAliasJoin Type
P_SalesOrderBOMHeader bom_header from
I_SalesDocument I_SalesDocument inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..*] I_BomChanges _BOMChangeNumbers $projection.BillOfMaterial = _BOMChangeNumbers.BillOfMaterial and $projection.BillOfMaterialCategory = _BOMChangeNumbers.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BOMChangeNumbers.BillOfMaterialVariant and $projection.Material = _BOMChangeNumbers.Material and $projection.Plant = _BOMChangeNumbers.Plant and $projection.BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales Order Bill Of Material Header view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory P_SalesOrderBOMHeader BillOfMaterialCategory
KEY BillOfMaterial
KEY BillOfMaterialVariant P_SalesOrderBOMHeader BillOfMaterialVariant
KEY EngineeringChangeDocument P_SalesOrderBOMHeader EngineeringChangeDocument
KEY Material P_SalesOrderBOMHeader Material
KEY Plant P_SalesOrderBOMHeader Plant
BillOfMaterialVariantUsage P_SalesOrderBOMHeader BillOfMaterialVariantUsage
BillOfMaterialHeaderUUID P_SalesOrderBOMHeader BillOfMaterialHeaderUUID
BillOfMaterialVersion P_SalesOrderBOMHeader BillOfMaterialVersion
SalesOrder P_SalesOrderBOMHeader SalesOrder
SalesOrderItem P_SalesOrderBOMHeader SalesOrderItem
SoldToParty I_SalesDocument SoldToParty
PurchaseOrderByCustomer I_SalesDocument PurchaseOrderByCustomer
BOMCharUUID
IsMultipleBOMAlt P_SalesOrderBOMHeader IsMultipleBOMAlt
BOMHeaderInternalChangeCount P_SalesOrderBOMHeader BOMHeaderInternalChangeCount
BOMPrioritizedVersion P_SalesOrderBOMHeader BOMPrioritizedVersion
BOMExplosionApplication P_SalesOrderBOMHeader BOMExplosionApplication
BOMUsagePriority P_SalesOrderBOMHeader BOMUsagePriority
BillOfMaterialAuthsnGrp P_SalesOrderBOMHeader BillOfMaterialAuthsnGrp
BOMVersionStatus P_SalesOrderBOMHeader BOMVersionStatus
MaterialToLotSizeQuantity P_SalesOrderBOMHeader MaterialToLotSizeQuantity
MatFromLotSizeQuantity P_SalesOrderBOMHeader MatFromLotSizeQuantity
IsVersionBillOfMaterial P_SalesOrderBOMHeader IsVersionBillOfMaterial
IsLatestBOMVersion P_SalesOrderBOMHeader IsLatestBOMVersion
BOMTechnicalType P_SalesOrderBOMHeader BOMTechnicalType
BOMGroup P_SalesOrderBOMHeader BOMGroup
IndicatorIsBOMWithDateHistory P_SalesOrderBOMHeader IndicatorIsBOMWithDateHistory
IndicatorIsBOMChangedWithHist P_SalesOrderBOMHeader IndicatorIsBOMChangedWithHist
BOMHeaderText P_SalesOrderBOMHeader BOMHeaderText
BOMAlternativeText P_SalesOrderBOMHeader BOMAlternativeText
LongTextLanguage P_SalesOrderBOMHeader LongTextLanguage
LongTextExists P_SalesOrderBOMHeader LongTextExists
BillOfMaterialStatus P_SalesOrderBOMHeader BillOfMaterialStatus
HeaderValidityEndDate P_SalesOrderBOMHeader HeaderValidityEndDate
HeaderValidityStartDate P_SalesOrderBOMHeader HeaderValidityStartDate
ChgToEngineeringChgDocument P_SalesOrderBOMHeader ChgToEngineeringChgDocument
IsMarkedForDeletion P_SalesOrderBOMHeader IsMarkedForDeletion
BOMIsArchivedForDeletion P_SalesOrderBOMHeader BOMIsArchivedForDeletion
IsConfiguredMaterial P_SalesOrderBOMHeader IsConfiguredMaterial
BOMIsConfigurableasBOMIsConfigurable
IsALEasIsALE
BOMHeaderBaseUnit P_SalesOrderBOMHeader BOMHeaderBaseUnit
BOMHeaderQuantityInBaseUnit P_SalesOrderBOMHeader BOMHeaderQuantityInBaseUnit
RecordCreationDate P_SalesOrderBOMHeader RecordCreationDate
LastChangeDate P_SalesOrderBOMHeader LastChangeDate
LastChangedByUser P_SalesOrderBOMHeader LastChangedByUser
CreatedByUser P_SalesOrderBOMHeader CreatedByUser
BOMIsToBeDeleted P_SalesOrderBOMHeader BOMIsToBeDeleted
DocumentIsCreatedByCAD P_SalesOrderBOMHeader DocumentIsCreatedByCAD
LaboratoryOrDesignOffice P_SalesOrderBOMHeader LaboratoryOrDesignOffice
LastChangeDateTime P_SalesOrderBOMHeader LastChangeDateTime
BOMAssetNtwkHndovrIsRelevant P_SalesOrderBOMHeader BOMAssetNtwkHndovrIsRelevant
MaterialBOMObjectID P_SalesOrderBOMHeader MaterialBOMObjectID
_Plant _Plant
_BOMChangeNumbers _BOMChangeNumbers 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Sales Order Bill Of Material Header'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
define view entity I_SalesOrderBOMHeader
  as select from P_SalesOrderBOMHeader as bom_header
    inner join   I_SalesDocument on bom_header.SalesOrder = I_SalesDocument.SalesDocument
  //association [0..1] to I_Material            as _Material                  on  $projection.Material = _Material.Material

  // association [0..1] to I_BillOfMaterialUsage as _BillOfMaterialVariantUsage on  $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage

  //                                                                            and _BillOfMaterialVariantUsage.Language = $session.system_language

  association [0..1] to I_Plant      as _Plant            on  $projection.Plant = _Plant.Plant
  // association [0..1] to I_UnitOfMeasure       as _UnitOfMeasure              on  $projection.BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure

  association [0..*] to I_BomChanges as _BOMChangeNumbers on  $projection.BillOfMaterial             = _BOMChangeNumbers.BillOfMaterial
                                                          and $projection.BillOfMaterialCategory     = _BOMChangeNumbers.BillOfMaterialCategory
                                                          and $projection.BillOfMaterialVariant      = _BOMChangeNumbers.BillOfMaterialVariant
                                                          and $projection.Material                   = _BOMChangeNumbers.Material
                                                          and $projection.Plant                      = _BOMChangeNumbers.Plant
                                                          and $projection.BillOfMaterialVariantUsage = _BOMChangeNumbers.BillOfMaterialVariantUsage
  // association [0..1] to I_ChangeMaster        as _ChangeNumbers              on  $projection.EngineeringChangeDocument = _ChangeNumbers.ChangeNumber


  //  association [0..1] to I_Product             as _Product                    on  $projection.Material = _Product.Product


{
  key bom_header.BillOfMaterialCategory                          as BillOfMaterialCategory,
      //key bom_header.BillOfMaterial                                        as BillOfMaterial,

  key cast( bom_header.BillOfMaterial as char8 preserving type ) as BillOfMaterial,
  key bom_header.BillOfMaterialVariant                           as BillOfMaterialVariant,
  key bom_header.EngineeringChangeDocument                       as EngineeringChangeDocument,
  key bom_header.Material                                        as Material,
  key bom_header.Plant                                           as Plant,
      bom_header.BillOfMaterialVariantUsage                      as BillOfMaterialVariantUsage,
      bom_header.BillOfMaterialHeaderUUID                        as BillOfMaterialHeaderUUID,
      bom_header.BillOfMaterialVersion                           as BillOfMaterialVersion,
      bom_header.SalesOrder                                      as SalesOrder,
      bom_header.SalesOrderItem                                  as SalesOrderItem,
      //@ObjectModel.foreignKey.association: '_SoldToParty'

      I_SalesDocument.SoldToParty                                as SoldToParty,
      I_SalesDocument.PurchaseOrderByCustomer                    as PurchaseOrderByCustomer,
      //bom_header.BillOfMaterialVariantUsage                                                                                                                                     as BillOfMaterialVariantUsage,

      // bom_header.BillOfMaterialHeaderUUID                                                                                                                                        as BillOfMaterialHeaderUUID,

      --      bintohex( bom_header.BillOfMaterialHeaderUUID )                                                                                                                            as BOMCharUUID,
      //bom_header.BillOfMaterialUUID                                                                                                                                              as BillOfMaterialUUID,

      bom_header.IsMultipleBOMAlt                                as IsMultipleBOMAlt,
      //@ObjectModel.readOnly: true

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

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

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

      bom_header.BOMUsagePriority                                as BOMUsagePriority,
      bom_header.BillOfMaterialAuthsnGrp                         as BillOfMaterialAuthsnGrp,
      bom_header.BOMVersionStatus                                as BOMVersionStatus,
      @Semantics.quantity.unitOfMeasure: 'BOMHEADERBASEUNIT' 
bom_header.MaterialToLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BOMHEADERBASEUNIT' 
bom_header.MatFromLotSizeQuantity,
      bom_header.IsVersionBillOfMaterial                         as IsVersionBillOfMaterial,
      bom_header.IsLatestBOMVersion                              as IsLatestBOMVersion,
      bom_header.BOMTechnicalType                                as BOMTechnicalType,
      bom_header.BOMGroup                                        as BOMGroup,
      bom_header.IndicatorIsBOMWithDateHistory                   as IndicatorIsBOMWithDateHistory,
      bom_header.IndicatorIsBOMChangedWithHist                   as IndicatorIsBOMChangedWithHist,
      bom_header.BOMHeaderText                                   as BOMHeaderText,
      bom_header.BOMAlternativeText                              as BOMAlternativeText,
      bom_header.LongTextLanguage                                as LongTextLanguage,
      bom_header.LongTextExists                                  as LongTextExists,
      bom_header.BillOfMaterialStatus                            as BillOfMaterialStatus,
      //@ObjectModel.readOnly: true

      // @Semantics.businessDate.to: true

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

      bom_header.IsALE                                           as IsALE,
      //@ObjectModel.foreignKey.association: '_UnitOfMeasure'

      bom_header.BOMHeaderBaseUnit                               as BOMHeaderBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
      @DefaultAggregation :#NONE
      bom_header.BOMHeaderQuantityInBaseUnit                     as BOMHeaderQuantityInBaseUnit,
      bom_header.RecordCreationDate                              as RecordCreationDate,
      bom_header.LastChangeDate                                  as LastChangeDate,
      bom_header.LastChangedByUser                               as LastChangedByUser,
      bom_header.CreatedByUser                                   as CreatedByUser,
      bom_header.BOMIsToBeDeleted                                as BOMIsToBeDeleted,
      bom_header.DocumentIsCreatedByCAD                          as DocumentIsCreatedByCAD,
      bom_header.LaboratoryOrDesignOffice                        as LaboratoryOrDesignOffice,
      bom_header.LastChangeDateTime                              as LastChangeDateTime,
      bom_header.BOMAssetNtwkHndovrIsRelevant                    as BOMAssetNtwkHndovrIsRelevant,
      bom_header.MaterialBOMObjectID                             as MaterialBOMObjectID,
      // _Material,

      // _BillOfMaterialVariantUsage,

      // _UnitOfMeasure,

      _Plant,
      _BOMChangeNumbers
      // _Product

}

Learn More