I_MFGORDERCOMPASSEMBLYINSTCE

CDS View
25 Fields 4 CDS Views

Manufacturing order component assembly instance

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SFIDisassemblyByCompInstce view_entity from COMPOSITE SFI Disassembly by Component Instance
I_SFODisassemblyByCompInstce view_entity from COMPOSITE Shop Floor Order Disassembly by Component Instance
P_AssldReltdComponentInstance view inner COMPOSITE
P_SFITrcblComponentAssembly view_entity inner COMPOSITE

Fields (25)

KeyField CDS FieldsUsed in Views
KEY AssemblyDocument AssemblyDocument 1
KEY AssemblyDocumentItem AssemblyDocumentItem 1
KEY AssemblyShopFloorItem AssemblyShopFloorItem 3
KEY Batch Batch 4
KEY Material Material 2
KEY OpActyNtwkElement OpActyNtwkElement 3
KEY OpActyNtwkInstance OpActyNtwkInstance 3
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 3
KEY Plant Plant 2
KEY RecordType RecordType 3
KEY Reservation Reservation 3
KEY ReservationItem ReservationItem 3
KEY ShopFloorItem ShopFloorItem 4
_BatchDistinct _BatchDistinct 1
_Material _Material 1
_OpActyNtwkInstance _OpActyNtwkInstance 2
_ParentShopFloorItem _ParentShopFloorItem 1
_ShopFloorItem _ShopFloorItem 1
DebitCreditCode DebitCreditCode 1
EntryUnit EntryUnit 1
InventoryUsabilityCode InventoryUsabilityCode 1
MaterialBaseUnit MaterialBaseUnit 1
MaterialComponentQuantity MaterialComponentQuantity 1
QuantityInEntryUnit QuantityInEntryUnit 1
StorageLocation StorageLocation 1

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 instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDERCOMPASSEMBLYINSTCE (
    ASSEMBLYDOCUMENT,
    ASSEMBLYDOCUMENTITEM,
    ASSEMBLYSHOPFLOORITEM,
    BATCH,
    MATERIAL,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORIGLDGTLMOCKUPCHARCSUUID,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    SHOPFLOORITEM,
    _BATCHDISTINCT,
    _MATERIAL,
    _OPACTYNTWKINSTANCE,
    _PARENTSHOPFLOORITEM,
    _SHOPFLOORITEM,
    DEBITCREDITCODE,
    ENTRYUNIT,
    INVENTORYUSABILITYCODE,
    MATERIALBASEUNIT,
    MATERIALCOMPONENTQUANTITY,
    QUANTITYINENTRYUNIT,
    STORAGELOCATION,
    PRIMARY KEY (ASSEMBLYDOCUMENT, ASSEMBLYDOCUMENTITEM, ASSEMBLYSHOPFLOORITEM, BATCH, MATERIAL, OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, ORIGLDGTLMOCKUPCHARCSUUID, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM, SHOPFLOORITEM)
);

Learn More