I_MATLPLNTCOMPASSEMBLECONTROL

CDS View

Component Assemble Control of a Material in a Plant

I_MATLPLNTCOMPASSEMBLECONTROL is a CDS View in S/4HANA. Component Assemble Control of a Material in a Plant. It contains 7 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
P_MfgOrderOperationCompMatl view inner CONSUMPTION Manufacturing Order Operation Component Material
P_MfgProcgExecBatchStock view inner COMPOSITE Batch Stock in Manufacturing Processing Execution
P_MfgProcgExecNonAssySrlNmbr view inner COMPOSITE Manufacturing Processing Execution Serial Number
P_MfgProcgExecNonSrlzdBatch view inner COMPOSITE Manufacturing Processing Execution Batch
P_OpActyInstanceAssembledComp2 view inner COMPOSITE Component explicitly assembled or backflushed at an OA
P_OpActyPlndMatlRetForMnlAssy view inner CONSUMPTION OA Planned Material Return for Manual Assembly
P_OperationActivityComponent view inner CONSUMPTION OA Planned Component, Incl. Unplanned Assemblies
P_ProcgExecOpActySFIGrpCompCns view inner CONSUMPTION Component of SFI at OA Group
P_SFIAssembledComponent2 view inner CONSUMPTION Component assembled into a SFI (manual and backflushed)
P_SFITraceableAssldComp view_entity inner CONSUMPTION SFI Assembled Traceable Component
P_SFOTraceableAssldComp view_entity inner CONSUMPTION SFO Assembled Traceable Component
P_ShopFloorItemAtOpActyComp2 view inner CONSUMPTION SFI Planned Component at OA, Incl. Unplanned Assemblies
P_ShopFloorItemComponents view inner COMPOSITE SFI componenets per SFI and batch

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Plant Plant 1
_MatlCompAssembleControl _MatlCompAssembleControl 2
IsBatchManagementRequired IsBatchManagementRequired 6
MatlCompAssembleControl MatlCompAssembleControl 3
SerialNumberIsRqdForAssembly SerialNumberIsRqdForAssembly 6
SerialNumberProfile SerialNumberProfile 6
StockCheckMessageType StockCheckMessageType 6

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.

-- Component Assemble Control of a Material in a Plant
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATLPLNTCOMPASSEMBLECONTROL (
    PLANT,
    _MATLCOMPASSEMBLECONTROL,
    ISBATCHMANAGEMENTREQUIRED,
    MATLCOMPASSEMBLECONTROL,
    SERIALNUMBERISRQDFORASSEMBLY,
    SERIALNUMBERPROFILE,
    STOCKCHECKMESSAGETYPE,
    PRIMARY KEY (PLANT)
);