SHOPFLOORITEM

5 Fields

SHOPFLOORITEM is an SAP database table in S/4HANA. It contains 5 fields.

Fields (5)

KeyField CDS FieldsUsed in Views
KEY ShopFloorItem ShopFloorItem 6
_SFIProductionStatus _SFIProductionStatus 2
OriginalReplacedShopFloorItem OriginalReplacedShopFloorItem 1
SerialNumber DefectiveSingleUnit,ProducedSerialNumber,SerialNumber 4
ShopFloorItemProductionStatus ShopFloorItemProductionStatus 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SHOPFLOORITEM (
    SHOPFLOORITEM,
    _SFIPRODUCTIONSTATUS,
    ORIGINALREPLACEDSHOPFLOORITEM,
    SERIALNUMBER,
    SHOPFLOORITEMPRODUCTIONSTATUS,
    PRIMARY KEY (SHOPFLOORITEM)
);

Learn More