I_MfgOrderCompAssemblyInstce

DDL: I_MFGORDERCOMPASSEMBLYINSTCE SQL: IMPECOMPASSYINST Type: view BASIC
34 Fields 1 Data Sources

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.

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 Document Number
KEY AssemblyDocumentItem I_MfgOrderComponentAssembly AssemblyDocumentItem Item Number
KEY OriglDgtlMockUpCharcsUUID MfgOrderCompInstceAssembly OriglDgtlMockUpCharcsUUID DMU GUID
Reservation I_MfgOrderComponentAssembly Reservation Reservation
ReservationItem I_MfgOrderComponentAssembly ReservationItem Reservation Item
RecordType I_MfgOrderComponentAssembly RecordType Reservation Record Type
OpActyNtwkInstance I_MfgOrderComponentAssembly OpActyNtwkInstance Instance ID
OpActyNtwkElement I_MfgOrderComponentAssembly OpActyNtwkElement Element Number
AssemblyShopFloorItem I_MfgOrderComponentAssembly AssemblyShopFloorItem Parent SFI ID
ShopFloorItem I_MfgOrderComponentAssembly ShopFloorItem Serial.Mat. ID
Batch I_MfgOrderComponentAssembly Batch Lot No.
Material I_MfgOrderComponentAssembly Material Vehicle Model
RequiredQuantity I_MfgOrderComponentAssembly RequiredQuantity Requirement qty
MaterialComponentQuantity I_MfgOrderComponentAssembly MaterialComponentQuantity Value
MaterialBaseUnit I_MfgOrderComponentAssembly MaterialBaseUnit Valuation Unit
QuantityInEntryUnit I_MfgOrderComponentAssembly QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit I_MfgOrderComponentAssembly EntryUnit Unit of Entry
Plant I_MfgOrderComponentAssembly Plant Valuation Area
StorageLocation I_MfgOrderComponentAssembly StorageLocation StorageLocation
InventoryUsabilityCode I_MfgOrderComponentAssembly InventoryUsabilityCode Stock Type
PostingIsRetroactive I_MfgOrderComponentAssembly PostingIsRetroactive Retroactive Action
DebitCreditCode I_MfgOrderComponentAssembly DebitCreditCode Single-Character Flag
IsReversed MfgOrderCompInstceAssembly IsReversed Reversed?
IsReversal MfgOrderCompInstceAssembly IsReversal Reversal doc.
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MfgOrderCompAssemblyInstce.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMPECOMPASSYINST

CREATE VIEW I_MfgOrderCompAssemblyInstce AS
SELECT
  MfgOrderComponentAssembly.AssemblyDocument AS AssemblyDocument,
  MfgOrderComponentAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  MfgOrderCompInstceAssembly.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  MfgOrderComponentAssembly.Reservation AS Reservation,
  MfgOrderComponentAssembly.ReservationItem AS ReservationItem,
  MfgOrderComponentAssembly.RecordType AS RecordType,
  MfgOrderComponentAssembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderComponentAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOrderComponentAssembly.ShopFloorItem AS ShopFloorItem,
  MfgOrderComponentAssembly.Batch AS Batch,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.RequiredQuantity AS RequiredQuantity,
  MfgOrderComponentAssembly.MaterialComponentQuantity AS MaterialComponentQuantity,
  MfgOrderComponentAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  MfgOrderComponentAssembly.QuantityInEntryUnit AS QuantityInEntryUnit,
  MfgOrderComponentAssembly.EntryUnit AS EntryUnit,
  MfgOrderComponentAssembly.Plant AS Plant,
  MfgOrderComponentAssembly.StorageLocation AS StorageLocation,
  MfgOrderComponentAssembly.InventoryUsabilityCode AS InventoryUsabilityCode,
  MfgOrderComponentAssembly.PostingIsRetroactive AS PostingIsRetroactive,
  MfgOrderComponentAssembly.DebitCreditCode AS DebitCreditCode,
  MfgOrderCompInstceAssembly.IsReversed AS IsReversed,
  MfgOrderCompInstceAssembly.IsReversal AS IsReversal,
  MfgOrderCompInstceAssembly.ReversalAssemblyDocument AS ReversalAssemblyDocument,
  MfgOrderCompInstceAssembly.ReversalAssemblyDocumentItem AS ReversalAssemblyDocumentItem,
  MfgOrderComponentAssembly._OpActyNtwkInstance AS _OpActyNtwkInstance,
  MfgOrderComponentAssembly._OperationActivityInstance AS _OperationActivityInstance,
  MfgOrderComponentAssembly._ShopFloorItem AS _ShopFloorItem,
  MfgOrderComponentAssembly._ParentShopFloorItem AS _ParentShopFloorItem,
  MfgOrderComponentAssembly._BatchDistinct AS _BatchDistinct,
  MfgOrderComponentAssembly._Material AS _Material,
  MfgOrderComponentAssembly._Plant AS _Plant,
  MfgOrderComponentAssembly._StorageLocation AS _StorageLocation
FROM I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly
;

Learn More