I_SHOPFLOORITEMSTATUS

CDS View
16 Fields 33 CDS Views

Shop Floor Item Status

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

CDS Views using this table (33)

ViewTypeJoinVDMDescription
C_OpActyInstcePlndSerialNumber view_entity from CONSUMPTION Plnd Serial Number at OA Instance
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_OpActySFIGrpAssyByComponent view_entity inner COMPOSITE SFI at OA Group Assembly by Component
I_SFIAtOpActyForBackflush view_entity from COMPOSITE SFI at OA relevant for Backflush
I_SFIAtOpActyForBkflshBasic view_entity from COMPOSITE SFI at OA relevant for Backflush
I_SFIAtOpActyInspCharcInfo view_entity inner COMPOSITE IC info of SFI at OAI
I_ShopFloorItemAtOpActy view from COMPOSITE Shop Floor Item At Operation Activity
P_ActvCmpltdSFIGroupMember view_entity inner CONSUMPTION
P_MfgOrderOpSFIAggrgdStsCat view from COMPOSITE
P_MfgOrdOpActiveInQueueSFI view inner COMPOSITE
P_MfgOrdOpNotInitialSFI view inner COMPOSITE
P_OpActNrOfActiveSFI view from COMPOSITE
P_OpActNrOfCmpltdSFI view from COMPOSITE
P_OpActNrOfScrappedSFI view from COMPOSITE
P_OpActNrOfSkippedSFI view from COMPOSITE
P_OpActySFIGrpNrOfGroupedSFI view from COMPOSITE
P_OpActyValdPrdcssrSFIGroupVH view_entity from CONSUMPTION
P_OriglRplcdSFIOpActyStatus view inner CONSUMPTION
P_SFIAssembledComponent view union_all CONSUMPTION
P_SFIAtOANotValdForGrpCopy view_entity from CONSUMPTION
P_SFIAtOANotValdForGrpCopy view_entity inner CONSUMPTION
P_SFIAtOpActyBckflshByOrigComp view inner COMPOSITE
P_SFIAtOpActyCompForBackflush view_entity from CONSUMPTION
P_SFIAtOpActyPlndMatlRetQts view inner CONSUMPTION
P_SFIAtOpActyTestEquipPRTUnion view_entity inner CONSUMPTION
P_SFIAtOperationActivityBasic view_entity from COMPOSITE
P_SFICompletedOpActy view from COMPOSITE
P_SFINotAssldTrcblComponent1 view_entity inner COMPOSITE SFI Not Assembled Traceable Components
P_SFIOperationActivityPlndPRT view_entity inner CONSUMPTION
P_ShopFloorItemAtOpActyComp view inner CONSUMPTION
P_ShopFloorItemComponent view union_all CONSUMPTION

Fields (16)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 15
KEY OpActyNtwkInstance OpActyNtwkInstance 15
KEY OperationActivitySFIGroup OperationActivitySFIGroup 5
KEY ShopFloorItem AssemblyShopFloorItem,ShopFloorItem 25
_OpActyNtwkInstance _OpActyNtwkInstance 8
_OperationActivityInstance _OperationActivityInstance 8
_OperationActivitySFIGroup _OperationActivitySFIGroup 4
_SASSchema _SASSchema 5
_SASStatus _SASStatus 5
_SASStatusText _SASStatusText 3
_SFIOpActyStsLastChgdByDoc _SFIOpActyStsLastChgdByDoc 2
_ShopFloorItem _ShopFloorItem 12
SFIIsInactiveAtOpActy SFIIsInactiveAtOpActy 3
SFIOpActyStsLastChgdByDoc SFIOpActyStsLastChgdByDoc 2
StatusAndActionSchema StatusAndActionSchema 5
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 5

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