P_PRODUCTIONHOLDOPANDOPACTY

CDS View
36 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProductionHoldEnhcd view union_all COMPOSITE

Fields (36)

KeyField CDS FieldsUsed in Views
KEY ProductionHold ProductionHold 1
_Defect _Defect 1
_Material _Material 1
_Notification _Notification 1
_NotificationItem _NotificationItem 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_OperationActivitySFIGroup _OperationActivitySFIGroup 1
_ProductionHoldObjectType _ProductionHoldObjectType 1
_ProductionPlant _ProductionPlant 1
_ShopFloorItem _ShopFloorItem 1
_WorkCenter _WorkCenter 1
CalendarBasedNetDurnInSeconds CalendarBasedNetDurnInSeconds 1
DefectInternalID DefectInternalID 1
HoldDurationInSeconds HoldDurationInSeconds 1
ManufacturingOrder ManufacturingOrder 1
Material Material 1
Notification Notification 1
NotificationItem NotificationItem 1
OpActyNtwkElement OpActyNtwkElement 1
OpActyNtwkElementExternalID OpActyNtwkElementExternalID 1
OpActyNtwkInstance OpActyNtwkInstance 1
OperationActivityName OperationActivityName 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
ProdnHoldIsAppldForOrderChg ProdnHoldIsAppldForOrderChg 1
ProductionHoldEndDateTime ProductionHoldEndDateTime 1
ProductionHoldObjectType ProductionHoldObjectType 1
ProductionHoldStartDateTime ProductionHoldStartDateTime 1
ProductionHoldStatus ProductionHoldStatus 1
ProductionPlant ProductionPlant 1
ShopFloorItem ShopFloorItem 1
WorkCenterBsdNetDurnInSeconds WorkCenterBsdNetDurnInSeconds 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 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_PRODUCTIONHOLDOPANDOPACTY (
    PRODUCTIONHOLD,
    _DEFECT,
    _MATERIAL,
    _NOTIFICATION,
    _NOTIFICATIONITEM,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYINSTANCE,
    _OPERATIONACTIVITYSFIGROUP,
    _PRODUCTIONHOLDOBJECTTYPE,
    _PRODUCTIONPLANT,
    _SHOPFLOORITEM,
    _WORKCENTER,
    CALENDARBASEDNETDURNINSECONDS,
    DEFECTINTERNALID,
    HOLDDURATIONINSECONDS,
    MANUFACTURINGORDER,
    MATERIAL,
    NOTIFICATION,
    NOTIFICATIONITEM,
    OPACTYNTWKELEMENT,
    OPACTYNTWKELEMENTEXTERNALID,
    OPACTYNTWKINSTANCE,
    OPERATIONACTIVITYNAME,
    OPERATIONACTIVITYSFIGROUP,
    ORDERINTERNALID,
    ORDEROPERATIONINTERNALID,
    PRODNHOLDISAPPLDFORORDERCHG,
    PRODUCTIONHOLDENDDATETIME,
    PRODUCTIONHOLDOBJECTTYPE,
    PRODUCTIONHOLDSTARTDATETIME,
    PRODUCTIONHOLDSTATUS,
    PRODUCTIONPLANT,
    SHOPFLOORITEM,
    WORKCENTERBSDNETDURNINSECONDS,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (PRODUCTIONHOLD)
);

Learn More