P_SFIDisassemblyByCompInstce

DDL: P_SFIDISASSEMBLYBYCOMPINSTCE Type: view_entity CONSUMPTION

P_SFIDisassemblyByCompInstce is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_OpActyComponentAssignment, I_SFIDisassemblyByCompInstce) and exposes 17 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_OpActyComponentAssignment OpActyComponentAssignment inner
I_SFIDisassemblyByCompInstce SFIDsassldCompByCompInstce from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_SFIDisassemblyByCompInstce Reservation
KEY ReservationItem I_SFIDisassemblyByCompInstce ReservationItem
KEY RecordType I_SFIDisassemblyByCompInstce RecordType
KEY OpActyNtwkInstance I_SFIDisassemblyByCompInstce OpActyNtwkInstance
KEY OpActyNtwkElement I_SFIDisassemblyByCompInstce OpActyNtwkElement
KEY OriglDgtlMockUpCharcsUUID I_SFIDisassemblyByCompInstce OriglDgtlMockUpCharcsUUID
KEY AssemblyShopFloorItem I_SFIDisassemblyByCompInstce AssemblyShopFloorItem
KEY ShopFloorItem I_SFIDisassemblyByCompInstce ShopFloorItem
KEY Batch I_SFIDisassemblyByCompInstce Batch
MaterialComponentQuantity I_SFIDisassemblyByCompInstce MaterialComponentQuantity
VariableSizeItemQuantity I_SFIDisassemblyByCompInstce VariableSizeItemQuantity
VariableSizeItemUnit I_SFIDisassemblyByCompInstce VariableSizeItemUnit
MaterialBaseUnit I_SFIDisassemblyByCompInstce MaterialBaseUnit
ComponentAssemblyType I_OpActyComponentAssignment ComponentAssemblyType
MfgRefStrucBOMLeafAssgmtUUID OpActyCompInstceAssignment MfgRefStrucBOMLeafAssgmtUUID
MfgRefStructureItemDetailUUID OpActyCompInstceAssignment MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual OpActyCompInstceAssignment MfgRefStrucItmDetIsContextual 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_SFIDisassemblyByCompInstce
  as select from           I_SFIDisassemblyByCompInstce as SFIDsassldCompByCompInstce
    inner join             I_OpActyComponentAssignment  as OpActyComponentAssignment  on  OpActyComponentAssignment.OpActyNtwkInstance = SFIDsassldCompByCompInstce.OpActyNtwkInstance
                                                                                      and OpActyComponentAssignment.OpActyNtwkElement  = SFIDsassldCompByCompInstce.OpActyNtwkElement
                                                                                      and OpActyComponentAssignment.Reservation        = SFIDsassldCompByCompInstce.Reservation
                                                                                      and OpActyComponentAssignment.ReservationItem    = SFIDsassldCompByCompInstce.ReservationItem
                                                                                      and OpActyComponentAssignment.RecordType         = SFIDsassldCompByCompInstce.RecordType
    left outer to one join I_OpActyCompInstceAssignment as OpActyCompInstceAssignment on  OpActyCompInstceAssignment.OpActyNtwkInstance        = SFIDsassldCompByCompInstce.OpActyNtwkInstance
                                                                                      and OpActyCompInstceAssignment.OpActyNtwkElement         = SFIDsassldCompByCompInstce.OpActyNtwkElement
                                                                                      and OpActyCompInstceAssignment.Reservation               = SFIDsassldCompByCompInstce.Reservation
                                                                                      and OpActyCompInstceAssignment.ReservationItem           = SFIDsassldCompByCompInstce.ReservationItem
                                                                                      and OpActyCompInstceAssignment.RecordType                = SFIDsassldCompByCompInstce.RecordType
                                                                                      and OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID = SFIDsassldCompByCompInstce.OriglDgtlMockUpCharcsUUID

{
  key SFIDsassldCompByCompInstce.Reservation                   as Reservation,
  key SFIDsassldCompByCompInstce.ReservationItem               as ReservationItem,
  key SFIDsassldCompByCompInstce.RecordType                    as RecordType,
  key SFIDsassldCompByCompInstce.OpActyNtwkInstance            as OpActyNtwkInstance,
  key SFIDsassldCompByCompInstce.OpActyNtwkElement             as OpActyNtwkElement,
  key SFIDsassldCompByCompInstce.OriglDgtlMockUpCharcsUUID     as OriglDgtlMockUpCharcsUUID,
  key SFIDsassldCompByCompInstce.AssemblyShopFloorItem         as AssemblyShopFloorItem,
  key SFIDsassldCompByCompInstce.ShopFloorItem                 as ShopFloorItem,
  key SFIDsassldCompByCompInstce.Batch                         as Batch,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      SFIDsassldCompByCompInstce.MaterialComponentQuantity     as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      SFIDsassldCompByCompInstce.VariableSizeItemQuantity      as VariableSizeItemQuantity,
      SFIDsassldCompByCompInstce.VariableSizeItemUnit          as VariableSizeItemUnit,
      SFIDsassldCompByCompInstce.MaterialBaseUnit              as MaterialBaseUnit,
      OpActyComponentAssignment.ComponentAssemblyType          as ComponentAssemblyType,

      -- Instance Info
      OpActyCompInstceAssignment.DgtlMockUpCharcsUUID          as DgtlMockUpCharcsUUID,
      OpActyCompInstceAssignment.MfgRefStrucBOMLeafAssgmtUUID  as MfgRefStrucBOMLeafAssgmtUUID,
      OpActyCompInstceAssignment.MfgRefStructureItemDetailUUID as MfgRefStructureItemDetailUUID,
      OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual as MfgRefStrucItmDetIsContextual
}
where
  (
       -- Do not consider temporary disassemblies
       OpActyComponentAssignment.ComponentAssemblyType      =  ''  -- ByProduct
    or OpActyComponentAssignment.ComponentAssemblyType      =  'D' -- Planned Disassembly of a previousely installed componment
  )
  and  SFIDsassldCompByCompInstce.MaterialComponentQuantity <> 0

Learn More