I_SHOPFLOORITEM

CDS View
14 Fields 13 CDS Views

Shop Floor Item

I_SHOPFLOORITEM is a CDS View in S/4HANA. Shop Floor Item. It contains 14 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_MfgOrderShopFloorItem view from CONSUMPTION Manufacturing Order Shop Floor Item
C_MfgOrdOpForReworkInsertion view left_outer CONSUMPTION Order operation for rework insertion
C_ShopFloorItemOperation view from CONSUMPTION Shop Floor Item Operation
I_SFIDocInfoRecdObjLink view inner COMPOSITE Shop Floor Item Document Info Record Object Link
I_SFIOfOriginalReplacedSFI view from COMPOSITE Shop Floor Item of original replaced Shop Floor Item
I_ShopFloorItemStdVH view from COMPOSITE Shop Floor Item
P_MfgOrderNmbrOfSFIHolds view from CONSUMPTION Number of active SFI Holds of a Production Order
P_MfgOrderSFIHold view from CONSUMPTION SFI Holds of a Manufacturing Order
P_MfgOrderSFIHoldCount view_entity from COMPOSITE Number of active SFI Holds of a Production Order
P_SFIOpActivityIsOnHold view from COMPOSITE Composite CDS to retrieve tool claim history
P_SFIOpActyPlanInspChar view from CONSUMPTION Operation Activity Based PlannedInspChar
P_SFITrcblComponentAssembly view_entity from COMPOSITE SFI Traceable Component Assembly
P_ShopFloorOrderHoldUnion view inner CONSUMPTION Holds of a Shop Floor Order (active and released)

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 9
KEY ShopFloorItem ShopFloorItem 4
_Equipment _Equipment 1
_LogisticsOrder _LogisticsOrder 1
_Material _Material 3
_MfgOrder _MfgOrder 6
_SFIProductionStatus _SFIProductionStatus 2
CreationDateTime CreationDateTime 1
ManufacturingOrderItem ManufacturingOrderItem 1
Material Material 3
ReplacedShopFloorItem ReplacedShopFloorItem 1
SerialNumber SerialNumber 5
ShopFloorItemExternalID ShopFloorItemExternalID 2
ShopFloorItemProductionStatus ShopFloorItemProductionStatus 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.

-- Shop Floor Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SHOPFLOORITEM (
    MANUFACTURINGORDER,
    SHOPFLOORITEM,
    _EQUIPMENT,
    _LOGISTICSORDER,
    _MATERIAL,
    _MFGORDER,
    _SFIPRODUCTIONSTATUS,
    CREATIONDATETIME,
    MANUFACTURINGORDERITEM,
    MATERIAL,
    REPLACEDSHOPFLOORITEM,
    SERIALNUMBER,
    SHOPFLOORITEMEXTERNALID,
    SHOPFLOORITEMPRODUCTIONSTATUS,
    PRIMARY KEY (MANUFACTURINGORDER, SHOPFLOORITEM)
);

Learn More