P_SFIATOPERATIONACTIVITYBASIC

CDS View
11 Fields 1 CDS Views

Basic data of a Shop Floor Item at an Operation Activity

P_SFIATOPERATIONACTIVITYBASIC is a CDS View in S/4HANA. Basic data of a Shop Floor Item at an Operation Activity. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SFIAtOperationActivityBasic view_entity from COMPOSITE Basic data of a Shop Floor Item at an Operation Activity

Fields (11)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY ShopFloorItem ShopFloorItem 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_ShopFloorItem _ShopFloorItem 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
OpActyNtwkSegmentType OpActyNtwkSegmentType 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
SFIIsInactiveAtOpActy SFIIsInactiveAtOpActy 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.

-- Basic data of a Shop Floor Item at an Operation Activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SFIATOPERATIONACTIVITYBASIC (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    SHOPFLOORITEM,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _SHOPFLOORITEM,
    MANUFACTURINGORDEROPERATION,
    OPACTYNTWKSEGMENTTYPE,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    SFIISINACTIVEATOPACTY,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, SHOPFLOORITEM)
);

Learn More