I_PRODNHOLDAFFCDSFIATOPACTY

CDS View

SFI at OA affected when a production hold was applied

I_PRODNHOLDAFFCDSFIATOPACTY is a CDS View in S/4HANA. SFI at OA affected when a production hold was applied. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProdnHoldAffcdSFIAtOpActy view from CONSUMPTION SFI at an OA affected when a production hold was applied

Fields (13)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY ProductionHold ProductionHold 1
KEY ShopFloorItem ShopFloorItem 1
_OpActyInstceOpActyNtwkElmnt _OpActyInstceOpActyNtwkElmnt 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_ProductionHoldBasic _ProductionHoldBasic 1
_SASSchema _SASSchema 1
_SASStatus _SASStatus 1
_ShopFloorItem _ShopFloorItem 1
StatusAndActionSchema StatusAndActionSchema 1
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 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.

-- SFI at OA affected when a production hold was applied
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODNHOLDAFFCDSFIATOPACTY (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PRODUCTIONHOLD,
    SHOPFLOORITEM,
    _OPACTYINSTCEOPACTYNTWKELMNT,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _PRODUCTIONHOLDBASIC,
    _SASSCHEMA,
    _SASSTATUS,
    _SHOPFLOORITEM,
    STATUSANDACTIONSCHEMA,
    STATUSANDACTIONSCHEMASTATUS,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PRODUCTIONHOLD, SHOPFLOORITEM)
);