I_MFGORDERCOMPONENTASSEMBLY

CDS View
34 Fields 27 CDS Views

Manufacturing Order Component Assembly

I_MFGORDERCOMPONENTASSEMBLY is a CDS View in S/4HANA. Manufacturing Order Component Assembly. It contains 34 fields. 27 CDS views read from this table.

CDS Views using this table (27)

ViewTypeJoinVDMDescription
I_MfgOrderCompAssemblyInstce view from BASIC Manufacturing order component assembly instance
I_OpActyAssemblyByComponent view from COMPOSITE OA Assembly by Component, Material and Plant
I_OpActySFIGrpAssyByComponent view_entity inner COMPOSITE SFI at OA Group Assembly by Component
I_SFIAtOpActyAssyByComponent view from COMPOSITE SFI at OA Assembly by Component, Material and Plant
I_SFIDisassemblyByComponent view_entity from COMPOSITE SFI Disassembly by Component
I_SFODisassemblyByComponent view_entity from COMPOSITE Shop Floor Order Disassembly by Component
P_MfgOrdCompAssyByOpActyParSFI view from CONSUMPTION
P_MfgOrderCompAssemblyAction view from COMPOSITE
P_MfgOrderCompAssemblyAggrgn view from COMPOSITE
P_MfgOrderCompAssyWthoutInstce view from COMPOSITE
P_MfgOrderCompInstceAssyQty view inner COMPOSITE
P_MfgOrderComponentAssemblyAgg view from CONSUMPTION
P_MfgOrderOriglComponentAssy view from COMPOSITE
P_OpActyInstanceAssembledComp view from COMPOSITE
P_SFIOpActyUnplndCompAssmblAgg view from CONSUMPTION
P_SFOTrcblPlndCompAssembly view_entity from COMPOSITE
P_ShopFloorItemAssembly view from COMPOSITE
P_ShopFloorItemComponents1 view_entity from COMPOSITE
P_SpltSFITrcblPlndCompAssy view_entity inner CONSUMPTION
P_SpltSFITrcblPlndCompAssyIn view_entity inner CONSUMPTION
P_SpltSFITrcblPlndCompAssyNI view_entity inner CONSUMPTION
P_SpltSFITrcblUnplndCompAssy view_entity inner CONSUMPTION
P_TrcblCompAssyLdngResvn view_entity from CONSUMPTION
P_UnspltSFITrcblPlndCompAssy view_entity inner CONSUMPTION
P_UnspltSFITrcblPlndCompAssyIn view_entity inner CONSUMPTION
P_UnspltSFITrcblPlndCompAssyNI view_entity inner CONSUMPTION
P_UnspltSFITrcblUnplndCompAssy view_entity inner CONSUMPTION

Fields (34)

KeyField CDS FieldsUsed in Views
KEY AssemblyDocument AssemblyDocument 13
KEY AssemblyDocumentItem AssemblyDocumentItem 13
KEY AssemblyShopFloorItem AssemblyShopFloorItem,OriginalReplacedShopFloorItem 19
KEY Batch Batch 14
KEY CreationDateTime CreationDateTime 2
KEY Material Material 19
KEY OpActyNtwkElement OpActyNtwkElement 20
KEY OpActyNtwkInstance OpActyNtwkInstance 20
KEY Plant Plant 19
KEY RecordType RecordType 20
KEY Reservation Reservation 22
KEY ReservationItem ReservationItem 20
KEY ShopFloorItem AssembledShopFloorItem,ShopFloorItem 16
_BatchDistinct _BatchDistinct 3
_Material _Material 15
_MaterialBaseUnit _MaterialBaseUnit 1
_OpActyNtwkInstance _OpActyNtwkInstance 9
_OperationActivityInstance _OperationActivityInstance 7
_ParentShopFloorItem _ParentShopFloorItem 7
_Plant _Plant 4
_Reservation _Reservation 7
_ReservationItem _ReservationItem 3
_ShopFloorItem _ShopFloorItem 5
_StorageLocation _StorageLocation 2
CreatedByUser CreatedByUser 1
DebitCreditCode DebitCreditCode 14
EntryUnit EntryUnit 12
InventoryUsabilityCode InventoryUsabilityCode 11
MaterialBaseUnit MaterialBaseUnit 14
MaterialComponentQuantity MaterialComponentQuantity 12
PostingIsRetroactive PostingIsRetroactive 1
QuantityInEntryUnit QuantityInEntryUnit 11
RequiredQuantity RequiredQuantity 2
StorageLocation StorageLocation 12

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Manufacturing Order Component Assembly
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDERCOMPONENTASSEMBLY (
    ASSEMBLYDOCUMENT,
    ASSEMBLYDOCUMENTITEM,
    ASSEMBLYSHOPFLOORITEM,
    BATCH,
    CREATIONDATETIME,
    MATERIAL,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    SHOPFLOORITEM,
    _BATCHDISTINCT,
    _MATERIAL,
    _MATERIALBASEUNIT,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _PARENTSHOPFLOORITEM,
    _PLANT,
    _RESERVATION,
    _RESERVATIONITEM,
    _SHOPFLOORITEM,
    _STORAGELOCATION,
    CREATEDBYUSER,
    DEBITCREDITCODE,
    ENTRYUNIT,
    INVENTORYUSABILITYCODE,
    MATERIALBASEUNIT,
    MATERIALCOMPONENTQUANTITY,
    POSTINGISRETROACTIVE,
    QUANTITYINENTRYUNIT,
    REQUIREDQUANTITY,
    STORAGELOCATION,
    PRIMARY KEY (ASSEMBLYDOCUMENT, ASSEMBLYDOCUMENTITEM, ASSEMBLYSHOPFLOORITEM, BATCH, CREATIONDATETIME, MATERIAL, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM, SHOPFLOORITEM)
);

Learn More