P_PRODUCTIONHOLDTP

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_PRODUCTIONHOLDTP (
    PRODUCTIONHOLD,
    _DEFECT,
    _MATERIAL,
    _MFGORDER,
    _MFGORDEROPERATION,
    _NOTIFICATION,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _OPERATIONACTIVITYSFIGROUP,
    _PRODUCTIONHOLDSTATUS,
    _PRODUCTIONPLANT,
    _SHOPFLOORITEM,
    _WORKCENTER,
    _WORKCENTERBYSEMANTICKEY,
    CALENDARBASEDNETDURNINSECONDS,
    HOLDDURATIONINSECONDS,
    MANUFACTURINGORDER,
    MANUFACTURINGORDEROPERATION,
    MANUFACTURINGORDERSEQUENCE,
    MATERIAL,
    MFGEXECDOCNOTEISEXISTING,
    MFGOBJECTTYPE,
    NOTIFICATION,
    NOTIFICATIONITEM,
    OPACTYNTWKELEMENT,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKINSTANCE,
    OPACTYSFIGROUPNAME,
    OPERATIONACTIVITYNAME,
    OPERATIONACTIVITYSFIGROUP,
    OPERATIONTEXT,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRODNHOLDAPPLYLASTCHGDBYUSR,
    PRODNHOLDAPPLYLASTCHGDDTETME,
    PRODNHOLDAPPLYREASONCODENAME,
    PRODNHOLDAPPLYRSNCODEGROUP,
    PRODNHOLDAPPLYRSNCODEGRPCTLG,
    PRODNHOLDISAPPLDFORORDERCHG,
    PRODNHOLDRELEASELASTCHGDBYUSR,
    PRODNHOLDRELEASELASTCHGDDTETME,
    PRODNHOLDRELREASONCODENAME,
    PRODNHOLDRELRSNCODEGROUP,
    PRODNHOLDRELRSNCODEGRPCTLG,
    PRODUCTIONHOLDAPPLYNOTE,
    PRODUCTIONHOLDAPPLYREASONCODE,
    PRODUCTIONHOLDENDDATETIME,
    PRODUCTIONHOLDOBJECTTYPE,
    PRODUCTIONHOLDRELEASENOTE,
    PRODUCTIONHOLDRELREASONCODE,
    PRODUCTIONHOLDSTARTDATETIME,
    PRODUCTIONHOLDSTATUS,
    PRODUCTIONHOLDSTATUSNAME,
    PRODUCTIONPLANT,
    SERIALNUMBER,
    SHOPFLOORITEM,
    STATUSISACTIVE,
    WORKCENTER,
    WORKCENTERBSDNETDURNINSECONDS,
    WORKCENTERINTERNALID,
    WORKCENTERTEXT,
    WORKCENTERTYPECODE,
    PRIMARY KEY (PRODUCTIONHOLD)
);