I_SHOPFLOORITEMSTATUS

CDS View
16 Fields 23 CDS Views

Shop Floor Item Status

I_SHOPFLOORITEMSTATUS is a CDS View in S/4HANA. Shop Floor Item Status. It contains 16 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
C_SFIOpActyPRTAssignment view inner CONSUMPTION Shop Floor Item At Operation Activity
C_ShopFloorItemAtOpActyVH view from CONSUMPTION Shop floor items at operation activity
C_ShopFloorItemSkippedOpActy view from CONSUMPTION Shop Floor Item Skipped OA
I_ActiveShopFloorItemAtOpActy view from BASIC Active shop floor item at operation activity
I_ShopFloorItemAtOpActy view from COMPOSITE Shop Floor Item At Operation Activity
P_MfgOrderOpSFIAggrgdStsCat view from COMPOSITE Aggregated Status Category of SFI
P_MfgOrdOpActiveInQueueSFI view inner COMPOSITE SFI active and In Queue at at least one OA of an Operation
P_MfgOrdOpNotInitialSFI view inner COMPOSITE SFI not Initial at at least one OA of an Operation
P_OpActNrOfActiveSFI view from COMPOSITE Operation Activity Number of Active SFI
P_OpActNrOfCmpltdSFI view from COMPOSITE Operation Activity Number of completed SFI
P_OpActNrOfScrappedSFI view from COMPOSITE Operation Activity Number of Scrapped SFI
P_OpActNrOfSkippedSFI view from COMPOSITE Number of Opearion activity of skipped SFI
P_OpActySFIGrpNrOfGroupedSFI view from COMPOSITE Number Of grouped SFIs in SFI@OA-Group
P_OriglRplcdSFIOpActyStatus view inner CONSUMPTION Original Replaced SFI Operation Activity Status
P_SFIAssembledComponent view union_all CONSUMPTION Component assembled into a SFI (manual and backflushed)
P_SFIAtOpActyBckflshByOrigComp view inner COMPOSITE SFI@OA backflushed Component by Original Component Assembly
P_SFIAtOpActyForBackflush view_entity from COMPOSITE SFI at Operation Activity relevant for Backflush
P_SFIAtOpActyPlndMatlRetQts view inner CONSUMPTION SFI at OA Planned Material Return with Quantities
P_SFIAtOperationActivityBasic view_entity from COMPOSITE Basic data of a Shop Floor Item at an Operation Activity
P_SFICmpltdOpActyNonTrcblComp view_entity from COMPOSITE SFI at Operation Activity relevant for Backflush
P_SFICompletedOpActy view from COMPOSITE Operation Activities being completed for a SFI
P_ShopFloorItemAtOpActyComp view inner CONSUMPTION SFI Planned Component at OA, Incl. Unplanned Assemblies
P_ShopFloorItemComponent view union_all CONSUMPTION SFI Component (Manual and Backflushed) per SFI and Batch

Fields (16)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 10
KEY OpActyNtwkInstance OpActyNtwkInstance 10
KEY OperationActivitySFIGroup OperationActivitySFIGroup 4
KEY ShopFloorItem AssemblyShopFloorItem,ShopFloorItem 18
_OpActyNtwkInstance _OpActyNtwkInstance 5
_OperationActivityInstance _OperationActivityInstance 5
_OperationActivitySFIGroup _OperationActivitySFIGroup 4
_SASSchema _SASSchema 4
_SASStatus _SASStatus 4
_SASStatusText _SASStatusText 2
_SFIOpActyStsLastChgdByDoc _SFIOpActyStsLastChgdByDoc 1
_ShopFloorItem _ShopFloorItem 9
SFIIsInactiveAtOpActy SFIIsInactiveAtOpActy 3
SFIOpActyStsLastChgdByDoc SFIOpActyStsLastChgdByDoc 1
StatusAndActionSchema StatusAndActionSchema 4
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 4

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 Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SHOPFLOORITEMSTATUS (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    OPERATIONACTIVITYSFIGROUP,
    SHOPFLOORITEM,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _OPERATIONACTIVITYSFIGROUP,
    _SASSCHEMA,
    _SASSTATUS,
    _SASSTATUSTEXT,
    _SFIOPACTYSTSLASTCHGDBYDOC,
    _SHOPFLOORITEM,
    SFIISINACTIVEATOPACTY,
    SFIOPACTYSTSLASTCHGDBYDOC,
    STATUSANDACTIONSCHEMA,
    STATUSANDACTIONSCHEMASTATUS,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, OPERATIONACTIVITYSFIGROUP, SHOPFLOORITEM)
);

Learn More