OPERATIONCAPACITYPERSHIFT

71 Fields

OPERATIONCAPACITYPERSHIFT is an SAP database table in S/4HANA. It contains 71 fields.

Fields (71)

KeyField CDS FieldsUsed in Views
KEY AvailableCapacityShift AvailableCapacityShift 7
KEY CalendarDate CalendarDate 3
KEY CapacityActiveVersion CapacityActiveVersion 3
KEY CapacityCategoryAllocation CapacityCategoryAllocation 4
KEY CapacityInternalID CapacityInternalID 6
KEY CapacityRequirement CapacityRequirement 5
KEY CapacityStartTime CapacityStartTime 5
KEY MaintenanceOrder MaintenanceOrder 2
KEY MaintenanceOrderOperation MaintenanceOrderOperation 2
KEY MaintenanceOrderSubOperation MaintenanceOrderSubOperation 2
KEY Operation Operation 5
KEY ShiftName ShiftName 5
KEY ValidityEndDate ValidityEndDate 3
KEY WeekDay WeekDay 3
KEY WorkCenterInternalID WorkCenterInternalID 6
KEY WorkCenterTypeCode WorkCenterTypeCode 6
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn 2
BaseUnit BaseUnit 5
CalendarMonth CalendarMonth 1
CalendarWeek CalendarWeek 1
CalendarYear CalendarYear 1
CapacityEndTime CapacityEndTime 4
CapacityRequirementOrigin CapacityRequirementOrigin 5
CapacityRequirementsAreDtmnd RequirementHours 2
CapacityRequirementUnit CapacityRequirementUnit 5
FactoryCalendar FactoryCalendar 5
FactoryCalendarDate FactoryCalendarDate 2
MaintenanceActivityType MaintenanceActivityType 2
MaintPriority MaintPriority 2
MaintPriorityColorCode MaintPriorityColorCode 2
MaintPriorityType MaintPriorityType 2
Material Material 3
MRPController MRPController 5
NightSplitDate NightSplitDate 2
OperatingDurationInSeconds OperatingDurationInSeconds 3
OperationControlKey OperationControlKey 2
OperationDayCount OperationDayCount 2
OperationLatestEndDate OperationLatestEndDate 5
OperationLatestEndTime OperationLatestEndTime 5
OperationLatestStartDate OperationLatestStartDate 5
OperationLatestStartTime OperationLatestStartTime 5
OperationPersonResponsible OperationPersonResponsible 2
OperationPlannedWork OperationPlannedWork 2
OperationPlanningStatusCode OperationPlanningStatusCode 5
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme 5
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme 5
OpLtstSchedldProcgStrtDte OpLtstSchedldProcgStrtDte 5
OpLtstSchedldProcgStrtTme OpLtstSchedldProcgStrtTme 5
OpLtstSchedldTrdwnStrtDte OpLtstSchedldTrdwnStrtDte 5
OpLtstSchedldTrdwnStrtTme OpLtstSchedldTrdwnStrtTme 5
OrderCategory OrderCategory 3
OrderFirmingStatusCode OrderFirmingStatusCode 3
OrderID OrderID 3
OrderInternalID OrderInternalID 5
OrderPlannedTotalQty OrderPlannedTotalQty 5
OrderStatusCode OrderStatusCode 5
OrderType OrderType 7
Plant Plant 6
ProcessingStatus ProcessingStatus 2
ProductionVersion ProductionVersion 5
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn 5
RemainingCapReqOpSegSetupDurn RemainingCapReqOpSegSetupDurn 5
RemainingCapReqOpSegTrdwnDurn RemainingCapReqOpSegTrdwnDurn 5
RequirementHours RequirementHours 3
TotOperatingDurationInSeconds TotOperatingDurationInSeconds 3
TotRequirementInSeconds TotRequirementInSeconds 2
WorkCenter WorkCenter 6
WorkCenterCapacityUnit WorkCenterCapacityUnit 1
WorkCenterCategoryCode WorkCenterCategoryCode 6
WorkCenterResponsible WorkCenterResponsible 4
WorkDayRule WorkDayRule 3

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 OPERATIONCAPACITYPERSHIFT (
    AVAILABLECAPACITYSHIFT,
    CALENDARDATE,
    CAPACITYACTIVEVERSION,
    CAPACITYCATEGORYALLOCATION,
    CAPACITYINTERNALID,
    CAPACITYREQUIREMENT,
    CAPACITYSTARTTIME,
    MAINTENANCEORDER,
    MAINTENANCEORDEROPERATION,
    MAINTENANCEORDERSUBOPERATION,
    OPERATION,
    SHIFTNAME,
    VALIDITYENDDATE,
    WEEKDAY,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    AVAILABLECAPACITYINTERVALDURN,
    BASEUNIT,
    CALENDARMONTH,
    CALENDARWEEK,
    CALENDARYEAR,
    CAPACITYENDTIME,
    CAPACITYREQUIREMENTORIGIN,
    CAPACITYREQUIREMENTSAREDTMND,
    CAPACITYREQUIREMENTUNIT,
    FACTORYCALENDAR,
    FACTORYCALENDARDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTPRIORITY,
    MAINTPRIORITYCOLORCODE,
    MAINTPRIORITYTYPE,
    MATERIAL,
    MRPCONTROLLER,
    NIGHTSPLITDATE,
    OPERATINGDURATIONINSECONDS,
    OPERATIONCONTROLKEY,
    OPERATIONDAYCOUNT,
    OPERATIONLATESTENDDATE,
    OPERATIONLATESTENDTIME,
    OPERATIONLATESTSTARTDATE,
    OPERATIONLATESTSTARTTIME,
    OPERATIONPERSONRESPONSIBLE,
    OPERATIONPLANNEDWORK,
    OPERATIONPLANNINGSTATUSCODE,
    OPLTSTSCHEDLDEXECENDTME,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPLTSTSCHEDLDPROCGSTRTDTE,
    OPLTSTSCHEDLDPROCGSTRTTME,
    OPLTSTSCHEDLDTRDWNSTRTDTE,
    OPLTSTSCHEDLDTRDWNSTRTTME,
    ORDERCATEGORY,
    ORDERFIRMINGSTATUSCODE,
    ORDERID,
    ORDERINTERNALID,
    ORDERPLANNEDTOTALQTY,
    ORDERSTATUSCODE,
    ORDERTYPE,
    PLANT,
    PROCESSINGSTATUS,
    PRODUCTIONVERSION,
    REMAININGCAPREQOPSEGPROCGDURN,
    REMAININGCAPREQOPSEGSETUPDURN,
    REMAININGCAPREQOPSEGTRDWNDURN,
    REQUIREMENTHOURS,
    TOTOPERATINGDURATIONINSECONDS,
    TOTREQUIREMENTINSECONDS,
    WORKCENTER,
    WORKCENTERCAPACITYUNIT,
    WORKCENTERCATEGORYCODE,
    WORKCENTERRESPONSIBLE,
    WORKDAYRULE,
    PRIMARY KEY (AVAILABLECAPACITYSHIFT, CALENDARDATE, CAPACITYACTIVEVERSION, CAPACITYCATEGORYALLOCATION, CAPACITYINTERNALID, CAPACITYREQUIREMENT, CAPACITYSTARTTIME, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, OPERATION, SHIFTNAME, VALIDITYENDDATE, WEEKDAY, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More