I_SFIDISASSEMBLYBYCOMPINSTCE

CDS View

SFI Disassembly by Component Instance

I_SFIDISASSEMBLYBYCOMPINSTCE is a CDS View in S/4HANA. SFI Disassembly by Component Instance. It contains 13 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 13 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SFIDisassemblyByCompInstce view_entity from CONSUMPTION

Fields (13)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 1
KEY Batch Batch 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
KEY ShopFloorItem ShopFloorItem 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialComponentQuantity MaterialComponentQuantity 1
VariableSizeItemQuantity VariableSizeItemQuantity 1
VariableSizeItemUnit VariableSizeItemUnit 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'SFI Disassembly by Component Instance'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_SFIDisassemblyByCompInstce
  as select from      I_MfgOrderCompAssemblyInstce as MfgOrderCompAssemblyInstce
    inner to one join I_OrderComponentBasic        as OrderComponentBasic on  OrderComponentBasic.Reservation     = MfgOrderCompAssemblyInstce.Reservation
                                                                          and OrderComponentBasic.ReservationItem = MfgOrderCompAssemblyInstce.ReservationItem
                                                                          and OrderComponentBasic.RecordType      = MfgOrderCompAssemblyInstce.RecordType
{
  key MfgOrderCompAssemblyInstce.Reservation                                                   as Reservation,
  key MfgOrderCompAssemblyInstce.ReservationItem                                               as ReservationItem,
  key MfgOrderCompAssemblyInstce.RecordType                                                    as RecordType,
  key MfgOrderCompAssemblyInstce.OpActyNtwkInstance                                            as OpActyNtwkInstance,
  key MfgOrderCompAssemblyInstce.OpActyNtwkElement                                             as OpActyNtwkElement,
  key MfgOrderCompAssemblyInstce.OriglDgtlMockUpCharcsUUID                                     as OriglDgtlMockUpCharcsUUID,
  key MfgOrderCompAssemblyInstce.AssemblyShopFloorItem                                         as AssemblyShopFloorItem,
  key MfgOrderCompAssemblyInstce.ShopFloorItem                                                 as ShopFloorItem,
  key MfgOrderCompAssemblyInstce.Batch                                                         as Batch,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(sum(MfgOrderCompAssemblyInstce.MaterialComponentQuantity) as kmpmg preserving type) as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeItemUnit'
      cast(sum(MfgOrderCompAssemblyInstce.QuantityInEntryUnit) as erfmgv preserving type)      as VariableSizeItemQuantity,
      OrderComponentBasic.VariableSizeItemUnit                                                 as VariableSizeItemUnit,
      OrderComponentBasic.BaseUnit                                                             as MaterialBaseUnit,

      MfgOrderCompAssemblyInstce._OpActyNtwkInstance
}
where
      OrderComponentBasic.DebitCreditCode             = 'S'
  and OrderComponentBasic.MatlCompIsMarkedForDeletion = ''
group by
  MfgOrderCompAssemblyInstce.Reservation,
  MfgOrderCompAssemblyInstce.ReservationItem,
  MfgOrderCompAssemblyInstce.RecordType,
  MfgOrderCompAssemblyInstce.OpActyNtwkInstance,
  MfgOrderCompAssemblyInstce.OpActyNtwkElement,
  MfgOrderCompAssemblyInstce.OriglDgtlMockUpCharcsUUID,
  MfgOrderCompAssemblyInstce.AssemblyShopFloorItem,
  MfgOrderCompAssemblyInstce.ShopFloorItem,
  MfgOrderCompAssemblyInstce.Batch,
  OrderComponentBasic.BaseUnit,
  OrderComponentBasic.VariableSizeItemUnit

Learn More