P_SFOTRACEABLEASSLDCOMP

CDS View

SFO Assembled Traceable Component

P_SFOTRACEABLEASSLDCOMP is a CDS View in S/4HANA. SFO Assembled Traceable Component. It contains 44 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 44 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SFOAssldTraceableComponent view_entity from CONSUMPTION Shop floor order assembled traceable component
C_SFODsassldTrcblComponent view_entity from CONSUMPTION Shop floor order disassembled traceable material
C_SFORetdTraceableMaterial view_entity from CONSUMPTION Shop floor item returned traceable material

Fields (44)

KeyField CDS FieldsUsed in Views
KEY DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID 3
KEY OpActyNtwkElement OpActyNtwkElement 3
KEY OpActyNtwkInstance OpActyNtwkInstance 3
KEY Plant Plant 3
KEY RecordType RecordType 3
KEY Reservation Reservation 3
KEY ReservationItem ReservationItem 3
KEY ShopFloorItem ShopFloorItem 3
_Material _Material 3
Assembly Assembly 3
BillOfMaterialCategory BillOfMaterialCategory 3
BillOfMaterialInternalID BillOfMaterialInternalID 3
BillOfMaterialItemNumber BillOfMaterialItemNumber 3
BillOfMaterialVariant BillOfMaterialVariant 3
BillOfMaterialVersion BillOfMaterialVersion 3
BOMItem BOMItem 3
BOMItemCategory BOMItemCategory 3
BOMItemInternalChangeCount BOMItemInternalChangeCount 3
EffectivityParameterVariant EffectivityParameterVariant 3
EntryUnit EntryUnit 3
FormulaKey FormulaKey 3
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 3
InheritedNodeNumberVersionBOM InheritedNodeNumberVersionBOM 3
ManufacturerSerialNumber ManufacturerSerialNumber 3
ManufacturingOrder ManufacturingOrder 3
MaterialBaseUnit MaterialBaseUnit 3
MaterialComponentQuantity MaterialComponentQuantity 1
MatlCompAssembleControl MatlCompAssembleControl 3
MfgRefStrucItmDetIsContextual MfgRefStrucItmDetIsContextual 3
MfgRefStructureItemDetailUUID MfgRefStructureItemDetailUUID 3
OperationText MfgOrderOperationText 3
OrderInternalID OrderInternalID 3
OrderOperationInternalID OrderOperationInternalID 3
ReferenceDesignatorValue ReferenceDesignatorValue 3
RequiredQuantity RequiredQuantity 1
RequiredQuantityInBaseUnit RequiredQuantityInBaseUnit 3
ResvnItmTotalWithdrawnQty ResvnItmTotalWithdrawnQty 3
ResvnItmWithdrawnQtyInBaseUnit ResvnItmWithdrawnQtyInBaseUnit 2
VariableSizeComponentQuantity VariableSizeComponentQuantity 3
VariableSizeComponentUnit VariableSizeComponentUnit 3
VariableSizeDimension1 VariableSizeDimension1 3
VariableSizeDimension2 VariableSizeDimension2 3
VariableSizeDimension3 VariableSizeDimension3 3
VariableSizeDimensionUnit VariableSizeDimensionUnit 3 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_SFOTraceableAssldComp
  as select from           P_SFOAssldTrcblCompByLdngResvn as SFOAssldTrcblCompByLdngResvn
    inner join             P_SFOAssldCompByLdngResvnNoIn  as SFOAssldCompByLdngResvnNoIn on  SFOAssldCompByLdngResvnNoIn.Reservation        = SFOAssldTrcblCompByLdngResvn.Reservation
                                                                                         and SFOAssldCompByLdngResvnNoIn.ReservationItem    = SFOAssldTrcblCompByLdngResvn.ReservationItem
                                                                                         and SFOAssldCompByLdngResvnNoIn.RecordType         = SFOAssldTrcblCompByLdngResvn.RecordType
                                                                                         and SFOAssldCompByLdngResvnNoIn.OpActyNtwkInstance = SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance
                                                                                         and SFOAssldCompByLdngResvnNoIn.OpActyNtwkElement  = SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement
                                                                                         and SFOAssldCompByLdngResvnNoIn.Material           = SFOAssldTrcblCompByLdngResvn.Material
                                                                                         and SFOAssldCompByLdngResvnNoIn.Plant              = SFOAssldTrcblCompByLdngResvn.Plant
    inner join             I_MatlPlntCompAssembleControl  as MatlPlntCompAssembleControl on  MatlPlntCompAssembleControl.Product = SFOAssldTrcblCompByLdngResvn.Material
                                                                                         and MatlPlntCompAssembleControl.Plant   = SFOAssldTrcblCompByLdngResvn.Plant
    left outer to one join I_OpActyInstceComponentDetail  as OpActyInstceComponentDetail on  OpActyInstceComponentDetail.OpActyNtwkInstance = SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance
                                                                                         and OpActyInstceComponentDetail.OpActyNtwkElement  = SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement
                                                                                         and OpActyInstceComponentDetail.Reservation        = SFOAssldTrcblCompByLdngResvn.Reservation
                                                                                         and OpActyInstceComponentDetail.ReservationItem    = SFOAssldTrcblCompByLdngResvn.ReservationItem
                                                                                         and OpActyInstceComponentDetail.RecordType         = SFOAssldTrcblCompByLdngResvn.RecordType
    left outer to one join I_OpActyNtwkInstanceBasic      as OpActyNtwkInstanceBasic     on OpActyNtwkInstanceBasic.OpActyNtwkInstance = SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance
    left outer to one join I_OrderOperationBasic          as OrderOperationBasic         on  OpActyNtwkInstanceBasic.OrderInternalID          = OrderOperationBasic.OrderInternalID
                                                                                         and OpActyNtwkInstanceBasic.OrderOperationInternalID = OrderOperationBasic.OrderOperationInternalID
    left outer to one join I_InstanceReferenceDesignator  as InstanceReferenceDesignator on InstanceReferenceDesignator.DgtlMockUpCharcsUUID = SFOAssldTrcblCompByLdngResvn.DgtlMockUpCharcsUUID

  association [0..1] to I_ReservationDocumentHeader as _Reservation               on  $projection.Reservation = _Reservation.Reservation
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance        on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OperationActivityInstance as _OperationActivityInstance on  $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OperationActivityInstance.OpActyNtwkElement
  association [1..1] to I_ShopFloorItem             as _ShopFloorItem             on  $projection.ShopFloorItem = _ShopFloorItem.ShopFloorItem

  association [0..1] to I_BillOfMaterialItemBasic   as _BillOfMaterialItemBasic   on  $projection.BillOfMaterialCategory     = _BillOfMaterialItemBasic.BillOfMaterialCategory
                                                                                  and $projection.BillOfMaterialInternalID   = _BillOfMaterialItemBasic.BillOfMaterial
                                                                                  and $projection.BOMItem                    = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber
                                                                                  and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount
  association [0..1] to I_MfgBOMItemWithPhantomHier as _MfgBOMItemWithPhantomHier on  $projection.BillOfMaterialCategory   = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory
                                                                                  and $projection.BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial
                                                                                  and $projection.BillOfMaterialVariant    = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant
                                                                                  and $projection.BillOfMaterialVersion    = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion
                                                                                  and $projection.InheritedBOMItemNode     = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr
{
  key SFOAssldTrcblCompByLdngResvn.Reservation,
  key SFOAssldTrcblCompByLdngResvn.ReservationItem,
  key SFOAssldTrcblCompByLdngResvn.RecordType,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement,
  key SFOAssldTrcblCompByLdngResvn.ShopFloorItem,
  key SFOAssldTrcblCompByLdngResvn.Batch,
  key cast(SFOAssldTrcblCompByLdngResvn.Material as mpe_component_matnr preserving type )                           as Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key SFOAssldTrcblCompByLdngResvn.Plant,
  key SFOAssldTrcblCompByLdngResvn.DgtlMockUpCharcsUUID,
  key SFOAssldTrcblCompByLdngResvn.MfgRefStrucBOMLeafAssgmtUUID,
  key SFOAssldTrcblCompByLdngResvn.MfgRefStructureItemDetailUUID,
  key SFOAssldTrcblCompByLdngResvn.MfgRefStrucItmDetIsContextual,
      OpActyInstceComponentDetail.BillOfMaterialItemNumber                                                          as BillOfMaterialItemNumber,
      OpActyInstceComponentDetail.BillOfMaterialCategory                                                            as BillOfMaterialCategory,
      OpActyInstceComponentDetail.BillOfMaterialInternalID                                                          as BillOfMaterialInternalID,
      OpActyInstceComponentDetail.BOMItem                                                                           as BOMItem,
      OpActyInstceComponentDetail.BOMItemInternalChangeCount                                                        as BOMItemInternalChangeCount,
      OpActyInstceComponentDetail.BillOfMaterialVariant                                                             as BillOfMaterialVariant,
      OpActyInstceComponentDetail.BillOfMaterialVersion                                                             as BillOfMaterialVersion,
      OpActyInstceComponentDetail.BOMItemCategory                                                                   as BOMItemCategory,
      OpActyInstceComponentDetail.InheritedBOMItemNode                                                              as InheritedBOMItemNode,
      OpActyInstceComponentDetail.EffectivityParameterVariant                                                       as EffectivityParameterVariant,
      _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem                                                        as InheritedNodeNumberForBOMItem,
      _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM                                                        as InheritedNodeNumberVersionBOM,
      OpActyInstceComponentDetail.Assembly                                                                          as Assembly,

      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      OpActyInstceComponentDetail.RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      OpActyInstceComponentDetail.RequiredQuantityInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      cast(case OpActyInstceComponentDetail.MaterialCompIsVariableSized
        when 'X' then SFOAssldTrcblCompByLdngResvn.QuantityInEntryUnit
        else SFOAssldTrcblCompByLdngResvn.MaterialComponentQuantity
      end as mpe_consumed_qty preserving type)                                                                      as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(SFOAssldTrcblCompByLdngResvn.MaterialComponentQuantity as mpe_consumed_qty_in_base_unit preserving type) as ResvnItmWithdrawnQtyInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(SFOAssldCompByLdngResvnNoIn.MaterialComponentQuantity as enmng preserving type)                          as ResvnItmTotalWithdrawnQty,
      SFOAssldTrcblCompByLdngResvn.MaterialBaseUnit,
      SFOAssldTrcblCompByLdngResvn.EntryUnit,

      -- Variable-Size Item Fields
      OpActyInstceComponentDetail.MaterialCompIsVariableSized,
      OpActyInstceComponentDetail.FormulaKey,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension1,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension2,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension3,
      OpActyInstceComponentDetail.VariableSizeDimensionUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      OpActyInstceComponentDetail.VariableSizeComponentQuantity,
      OpActyInstceComponentDetail.VariableSizeComponentUnit,

      SFOAssldTrcblCompByLdngResvn.ManufacturingOrder,
      cast(OrderOperationBasic.Operation_2 as mpe_vornr_char preserving type)                                       as Operation,
      OrderOperationBasic.OperationText,
      OpActyNtwkInstanceBasic.OrderInternalID,
      OpActyNtwkInstanceBasic.OrderOperationInternalID,
      OpActyNtwkInstanceBasic.OperationActivityNetwork,
      OpActyNtwkInstanceBasic.OpActyNtwkVersionCounter,
      _ShopFloorItem.SerialNumber,
      cast(_ShopFloorItem._Equipment.ManufacturerSerialNumber as mpe_mfr_sernr preserving type)                     as ManufacturerSerialNumber,
      InstanceReferenceDesignator.ReferenceDesignatorValue,
      @ObjectModel.foreignKey.association: '_MatlCompAssembleControl'
      MatlPlntCompAssembleControl.MatlCompAssembleControl,
      OpActyInstceComponentDetail.DebitCreditCode,

      _Reservation,
      _OpActyNtwkInstance,
      _OperationActivityInstance,
      SFOAssldTrcblCompByLdngResvn._ManufacturingOrder,
      _ShopFloorItem,
      SFOAssldTrcblCompByLdngResvn._Material,
      SFOAssldTrcblCompByLdngResvn._Plant,
      SFOAssldTrcblCompByLdngResvn._ProductPlantBasic,
      MatlPlntCompAssembleControl._MatlCompAssembleControl,
      OpActyInstceComponentDetail._BOMItemCategory,
      _MfgBOMItemWithPhantomHier
}

Learn More