P_PRODNHOLDAFFCDSFIATOPACTY

CDS View
23 Fields 1 CDS Views

P_PRODNHOLDAFFCDSFIATOPACTY is a CDS View in S/4HANA. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ShopFloorItemHold view inner CONSUMPTION Serial Number Hold

Fields (23)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY ProductionHold ProductionHold 1
KEY ShopFloorItem ShopFloorItem 1
_MfgOrder _MfgOrder 1
_MfgOrderOperation _MfgOrderOperation 1
_Notification _Notification 1
_NotificationItem _NotificationItem 1
_OpActyInstceOpActyNtwkElmnt _OpActyInstceOpActyNtwkElmnt 1
_OperationActivityInstance _OperationActivityInstance 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
ManufacturingOrderSequence ManufacturingOrderSequence 1
Material Material 1
MfgOrderOperationText MfgOrderOperationText 1
Notification Notification 1
NotificationItem NotificationItem 1
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 1
OrderInternalID OrderInternalID 1
ProductionHoldEndDateTime ProductionHoldEndDateTime 1
ProductionHoldStartDateTime ProductionHoldStartDateTime 1
ProductionHoldStatus ProductionHoldStatus 1
ProductionPlant ProductionPlant 1
SerialNumber SerialNumber 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRODNHOLDAFFCDSFIATOPACTY (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    PRODUCTIONHOLD,
    SHOPFLOORITEM,
    _MFGORDER,
    _MFGORDEROPERATION,
    _NOTIFICATION,
    _NOTIFICATIONITEM,
    _OPACTYINSTCEOPACTYNTWKELMNT,
    _OPERATIONACTIVITYINSTANCE,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MATERIAL,
    MFGORDEROPERATIONTEXT,
    NOTIFICATION,
    NOTIFICATIONITEM,
    OPACTYNTWKELEMENTEXTERNALID,
    ORDERINTERNALID,
    PRODUCTIONHOLDENDDATETIME,
    PRODUCTIONHOLDSTARTDATETIME,
    PRODUCTIONHOLDSTATUS,
    PRODUCTIONPLANT,
    SERIALNUMBER,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, PRODUCTIONHOLD, SHOPFLOORITEM)
);

Learn More