I_MfgOrderCompAssemblyInstce

DDL: I_MFGORDERCOMPASSEMBLYINSTCE SQL: IMPECOMPASSYINST Type: view BASIC

Manufacturing order component assembly instance

I_MfgOrderCompAssemblyInstce is a Basic CDS View that provides data about "Manufacturing order component assembly instance" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderComponentAssembly) and exposes 34 fields with key fields AssemblyDocument, AssemblyDocumentItem, OriglDgtlMockUpCharcsUUID.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderComponentAssembly MfgOrderComponentAssembly from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPECOMPASSYINST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
EndUserText.label Manufacturing order component assembly instance view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument I_MfgOrderComponentAssembly AssemblyDocument
KEY AssemblyDocumentItem I_MfgOrderComponentAssembly AssemblyDocumentItem
KEY OriglDgtlMockUpCharcsUUID MfgOrderCompInstceAssembly OriglDgtlMockUpCharcsUUID
Reservation I_MfgOrderComponentAssembly Reservation
ReservationItem I_MfgOrderComponentAssembly ReservationItem
RecordType I_MfgOrderComponentAssembly RecordType
OpActyNtwkInstance I_MfgOrderComponentAssembly OpActyNtwkInstance
OpActyNtwkElement I_MfgOrderComponentAssembly OpActyNtwkElement
AssemblyShopFloorItem I_MfgOrderComponentAssembly AssemblyShopFloorItem
ShopFloorItem I_MfgOrderComponentAssembly ShopFloorItem
Batch I_MfgOrderComponentAssembly Batch
Material I_MfgOrderComponentAssembly Material
RequiredQuantity I_MfgOrderComponentAssembly RequiredQuantity
MaterialComponentQuantity I_MfgOrderComponentAssembly MaterialComponentQuantity
MaterialBaseUnit I_MfgOrderComponentAssembly MaterialBaseUnit
QuantityInEntryUnit I_MfgOrderComponentAssembly QuantityInEntryUnit
EntryUnit I_MfgOrderComponentAssembly EntryUnit
Plant I_MfgOrderComponentAssembly Plant
StorageLocation I_MfgOrderComponentAssembly StorageLocation
InventoryUsabilityCode I_MfgOrderComponentAssembly InventoryUsabilityCode
PostingIsRetroactive I_MfgOrderComponentAssembly PostingIsRetroactive
DebitCreditCode I_MfgOrderComponentAssembly DebitCreditCode
IsReversed MfgOrderCompInstceAssembly IsReversed
IsReversal MfgOrderCompInstceAssembly IsReversal
ReversalAssemblyDocument MfgOrderCompInstceAssembly ReversalAssemblyDocument
ReversalAssemblyDocumentItem MfgOrderCompInstceAssembly ReversalAssemblyDocumentItem
_OpActyNtwkInstance I_MfgOrderComponentAssembly _OpActyNtwkInstance
_OperationActivityInstance I_MfgOrderComponentAssembly _OperationActivityInstance
_ShopFloorItem I_MfgOrderComponentAssembly _ShopFloorItem
_ParentShopFloorItem I_MfgOrderComponentAssembly _ParentShopFloorItem
_BatchDistinct I_MfgOrderComponentAssembly _BatchDistinct
_Material I_MfgOrderComponentAssembly _Material
_Plant I_MfgOrderComponentAssembly _Plant
_StorageLocation I_MfgOrderComponentAssembly _StorageLocation 
@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