I_MFGORDERCOMPASSEMBLYINSTCE

CDS View

Manufacturing order component assembly instance

I_MFGORDERCOMPASSEMBLYINSTCE is a CDS View in S/4HANA. Manufacturing order component assembly instance. It contains 24 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 24 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_AssldReltdComponentInstance view inner COMPOSITE Assembled Related Component Instance
P_SFITrcblComponentAssembly view_entity inner COMPOSITE SFI Traceable Component Assembly
P_SFOTrcblComponentAssembly view_entity from COMPOSITE SFO Assembled or Backflushed Component

Fields (24)

KeyField CDS FieldsUsed in Views
KEY AssemblyDocument AssemblyDocument 2
KEY AssemblyDocumentItem AssemblyDocumentItem 2
KEY AssemblyShopFloorItem AssemblyShopFloorItem 3
KEY Batch Batch 3
KEY Material Material 3
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 2
KEY Plant Plant 3
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
KEY ShopFloorItem ShopFloorItem 3
_BatchDistinct _BatchDistinct 1
_Material _Material 2
_ParentShopFloorItem _ParentShopFloorItem 1
_ShopFloorItem _ShopFloorItem 1
DebitCreditCode DebitCreditCode 2
EntryUnit EntryUnit 2
InventoryUsabilityCode InventoryUsabilityCode 2
MaterialBaseUnit MaterialBaseUnit 2
MaterialComponentQuantity MaterialComponentQuantity 2
QuantityInEntryUnit QuantityInEntryUnit 2
StorageLocation StorageLocation 2 
@AbapCatalog.sqlViewName: 'IMPECOMPASSYINST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
@EndUserText.label: 'Manufacturing order component assembly instance'
define view I_MfgOrderCompAssemblyInstce
  as select from            I_MfgOrderComponentAssembly  as MfgOrderComponentAssembly
    left outer to many join I_MfgOrderCompInstceAssembly as MfgOrderCompInstceAssembly on  MfgOrderCompInstceAssembly.AssemblyDocument     = MfgOrderComponentAssembly.AssemblyDocument
                                                                                       and MfgOrderCompInstceAssembly.AssemblyDocumentItem = MfgOrderComponentAssembly.AssemblyDocumentItem
{
  key MfgOrderComponentAssembly.AssemblyDocument           as AssemblyDocument,
  key MfgOrderComponentAssembly.AssemblyDocumentItem       as AssemblyDocumentItem,
  key MfgOrderCompInstceAssembly.OriglDgtlMockUpCharcsUUID as OriglDgtlMockUpCharcsUUID,
      MfgOrderComponentAssembly.Reservation,
      MfgOrderComponentAssembly.ReservationItem,
      MfgOrderComponentAssembly.RecordType,
      MfgOrderComponentAssembly.OpActyNtwkInstance,
      MfgOrderComponentAssembly.OpActyNtwkElement,
      MfgOrderComponentAssembly.AssemblyShopFloorItem,
      MfgOrderComponentAssembly.ShopFloorItem,
      MfgOrderComponentAssembly.Batch,
      MfgOrderComponentAssembly.Material,
      MfgOrderComponentAssembly.RequiredQuantity,
      MfgOrderComponentAssembly.MaterialComponentQuantity,
      MfgOrderComponentAssembly.MaterialBaseUnit,
      MfgOrderComponentAssembly.QuantityInEntryUnit,
      MfgOrderComponentAssembly.EntryUnit,
      MfgOrderComponentAssembly.Plant,
      MfgOrderComponentAssembly.StorageLocation,
      MfgOrderComponentAssembly.InventoryUsabilityCode,
      MfgOrderComponentAssembly.PostingIsRetroactive,
      MfgOrderComponentAssembly.DebitCreditCode,
      MfgOrderCompInstceAssembly.IsReversed,
      MfgOrderCompInstceAssembly.IsReversal,
      MfgOrderCompInstceAssembly.ReversalAssemblyDocument,
      MfgOrderCompInstceAssembly.ReversalAssemblyDocumentItem,

      MfgOrderComponentAssembly._OpActyNtwkInstance,
      MfgOrderComponentAssembly._OperationActivityInstance,
      MfgOrderComponentAssembly._ShopFloorItem,
      MfgOrderComponentAssembly._ParentShopFloorItem,
      MfgOrderComponentAssembly._BatchDistinct,
      MfgOrderComponentAssembly._Material,
      MfgOrderComponentAssembly._Plant,
      MfgOrderComponentAssembly._StorageLocation
}

Learn More