_OPERATIONPLANNINGVALUES

33 Fields

_OPERATIONPLANNINGVALUES is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
_DurationUnitOfMeasure _DurationUnitOfMeasure 1
_OperationQtyUnitOfMeasure _OperationQtyUnitOfMeasure 2
_PlannedWorkUnitOfMeasure _PlannedWorkUnitOfMeasure 4
ActyConfFcstdEndDate ActyConfFcstdEndDate 1
ActyConfFcstdEndTime ActyConfFcstdEndTime 1
ConfirmationTotalQuantity ActualWorkQuantity,ConfirmationTotalQuantity 4
ConstraintDateForBscFinishDate ConstraintDateForBscFinishDate 2
ConstraintDateForBscStartDate ConstraintDateForBscStartDate 2
ConstraintTimeForBscFinishTime ConstraintTimeForBscFinishTime 2
ConstraintTimeForBscStartTime ConstraintTimeForBscStartTime 2
ForecastedWorkQty ForecastedWorkQty,ForecastWorkQuantity 3
MaintOrdOperationExecutionRate MaintOrdOperationExecutionRate 1
OpActualExecutionEndDate OpActualExecutionEndDate 4
OpActualExecutionEndTime OpActualExecutionEndTime 3
OpActualExecutionStartDate OpActualExecutionStartDate 4
OpActualExecutionStartTime OpActualExecutionStartTime 3
OpBscEndDateConstraintType OpBscEndDateConstraintType 2
OpBscStartDateConstraintType OpBscStartDateConstraintType 2
OperationDuration MaintOrderOperationDuration,OperationDuration 7
OperationDurationUnit MaintOrdOperationDurationUnit,OperationDurationUnit 7
OperationPlannedWork MaintOrdOperationWorkDuration,OperationPlannedWork 10
OperationPlannedWorkUnit ActualWorkQuantityUnit,MaintOrdOpWorkDurationUnit,OperationPlannedWorkUnit 10
OperationQuantity MaintOrderOperationQuantity,OperationQuantity 2
OperationQuantityUnit MaintOrdOperationQuantityUnit,OperationQuantityUnit 2
OpErlstSchedldExecEndDte OpErlstSchedldExecEndDte 8
OpErlstSchedldExecEndTme OpErlstSchedldExecEndTme 5
OpErlstSchedldExecStrtDte OpErlstSchedldExecStrtDte 8
OpErlstSchedldExecStrtTme OpErlstSchedldExecStrtTme 5
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte 8
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme 5
OpLtstSchedldExecStrtDte OpLtstSchedldExecStrtDte 8
OpLtstSchedldExecStrtTme OpLtstSchedldExecStrtTme 5
OpPlndDeliveryDurationInDays DeliveryTimeInDays 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 _OPERATIONPLANNINGVALUES (
    _DURATIONUNITOFMEASURE,
    _OPERATIONQTYUNITOFMEASURE,
    _PLANNEDWORKUNITOFMEASURE,
    ACTYCONFFCSTDENDDATE,
    ACTYCONFFCSTDENDTIME,
    CONFIRMATIONTOTALQUANTITY,
    CONSTRAINTDATEFORBSCFINISHDATE,
    CONSTRAINTDATEFORBSCSTARTDATE,
    CONSTRAINTTIMEFORBSCFINISHTIME,
    CONSTRAINTTIMEFORBSCSTARTTIME,
    FORECASTEDWORKQTY,
    MAINTORDOPERATIONEXECUTIONRATE,
    OPACTUALEXECUTIONENDDATE,
    OPACTUALEXECUTIONENDTIME,
    OPACTUALEXECUTIONSTARTDATE,
    OPACTUALEXECUTIONSTARTTIME,
    OPBSCENDDATECONSTRAINTTYPE,
    OPBSCSTARTDATECONSTRAINTTYPE,
    OPERATIONDURATION,
    OPERATIONDURATIONUNIT,
    OPERATIONPLANNEDWORK,
    OPERATIONPLANNEDWORKUNIT,
    OPERATIONQUANTITY,
    OPERATIONQUANTITYUNIT,
    OPERLSTSCHEDLDEXECENDDTE,
    OPERLSTSCHEDLDEXECENDTME,
    OPERLSTSCHEDLDEXECSTRTDTE,
    OPERLSTSCHEDLDEXECSTRTTME,
    OPLTSTSCHEDLDEXECENDDTE,
    OPLTSTSCHEDLDEXECENDTME,
    OPLTSTSCHEDLDEXECSTRTDTE,
    OPLTSTSCHEDLDEXECSTRTTME,
    OPPLNDDELIVERYDURATIONINDAYS
);

Learn More