P_MfgOrderOpAdaptedDatesBasic
Order Operation wtih adapted dates for time 24:00
P_MfgOrderOpAdaptedDatesBasic is a Composite CDS View that provides data about "Order Operation wtih adapted dates for time 24:00" in SAP S/4HANA. It reads from 1 data source (I_OrderOperation) and exposes 277 fields with key fields OrderInternalID, OrderOperationInternalID. Part of development package MPE_EXEC_COMMON.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_OrderOperation | I_OrderOperation | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PORDOPERADPTDTS | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| AbapCatalog.compiler.compareFilter | true | view |
Fields (277)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OrderInternalID | OrderInternalID | Plan No.f.Oper. | |
| KEY | OrderOperationInternalID | OrderOperationInternalID | Plan No.f.Oper. | |
| Sequence | Sequence | Visit Sequence | ||
| Operation | Operation | Transaction | ||
| BillOfOperationsSequence | BillOfOperationsSequence | Sequence | ||
| BillOfOperationsType | BillOfOperationsType | Task List Type | ||
| BillOfOperationsGroup | BillOfOperationsGroup | Group | ||
| BillOfOperationsVariant | BillOfOperationsVariant | Group Counter | ||
| BOOOperationInternalID | BOOOperationInternalID | Task list node | ||
| BillOfOperationsVersion | BillOfOperationsVersion | Routing Version | ||
| BillOfMaterialCategory | BillOfMaterialCategory | BOM category | ||
| BillOfMaterialInternalID | BillOfMaterialInternalID | BOM | ||
| BillOfMaterialItemNodeNumber | BillOfMaterialItemNodeNumber | Item node | ||
| BOMItemNodeCount | BOMItemNodeCount | Counter | ||
| SuperiorOperationInternalID | SuperiorOperationInternalID | Sup. Op. Node | ||
| OperationControlProfile | OperationControlProfile | Control Key | ||
| WorkCenterInternalID | WorkCenterInternalID | Work Center | ||
| WorkCenterTypeCode | WorkCenterTypeCode_2 | |||
| Plant | Plant | Valuation Area | ||
| FactoryCalendar | FactoryCalendar | Factory Calendar | ||
| CapacityRequirement | CapacityRequirement | Id number | ||
| CapacityRequirementItem | CapacityRequirementItem | Counter | ||
| ActualNumberOfSplits | ActualNumberOfSplits | No. of splits | ||
| NumberOfCapacities | NumberOfCapacities | Number | ||
| OperationIsToBeDeleted | OperationIsToBeDeleted | Status | ||
| NetworkActivityPriority | NetworkActivityPriority | Priority | ||
| OperationImportance | OperationImportance | Priority | ||
| OperationWorkPercent | OperationWorkPercent | Percent | ||
| UsageCode | UsageCode | Usage | ||
| Assembly | Assembly | Pegged Reqmt | ||
| ProjectInternalID | ProjectInternalID | Project Def. | ||
| ObjectInternalID | ObjectInternalID | Object number | ||
| OperationConfirmation | OperationConfirmation | Return Agmt | ||
| NumberOfOperationConfirmations | NumberOfOperationConfirmations | Counter | ||
| NumberOfOperationExecutions | NumberOfOperationExecutions | Execution Fact. | ||
| OperationSystemCondition | OperationSystemCondition | SystemCondition | ||
| ChangeNumber | ChangeNumber | Change Number | ||
| StandardTextInternalID | StandardTextInternalID | Std Text Key | ||
| OperationText | OperationText | Description | ||
| Language | Language | Report Text Language | ||
| NumberOfTimeTickets | NumberOfTimeTickets | No.TimeTickets | ||
| EmployeeWageType | EmployeeWageType | Wage type | ||
| EmployeeWageGroup | EmployeeWageGroup | Wage Group | ||
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | No. of Conf. Slips | ||
| EmployeeSuitability | EmployeeSuitability | Suitability | ||
| Personnel | Personnel | Personnel No. | ||
| NumberOfEmployees | NumberOfEmployees | No. employees | ||
| OperationSetupGroupCategory | OperationSetupGroupCategory | Setup group cat | ||
| OperationSetupGroup | OperationSetupGroup | Setup group key | ||
| OperationSetupType | OperationSetupType | Setup Type Key | ||
| OperationScrapPercent | OperationScrapPercent | Scrap | ||
| OperationOverlappingIsRequired | OperationOverlappingIsRequired | Req.Overlapping | ||
| OperationOverlappingIsPossible | OperationOverlappingIsPossible | Opt.Overlapping | ||
| OperationsIsAlwaysOverlapping | OperationsIsAlwaysOverlapping | Flow Manufact. | ||
| OperationSplitIsRequired | OperationSplitIsRequired | Splitting Reqd | ||
| MaximumNumberOfSplits | MaximumNumberOfSplits | Maximum Splits | ||
| LeadTimeReductionStrategy | LeadTimeReductionStrategy | Red. Strategy | ||
| OverheadCode | OverheadCode | Overhead Key | ||
| OperationPurgInfoRecdSearchTxt | OperationPurgInfoRecdSearchTxt | Sort Term | ||
| ExtProcgOperationHasSubcontrg | ExtProcgOperationHasSubcontrg | Subcontracting | ||
| Supplier | Supplier | Supplier | ||
| OpExternalProcessingPrice | OpExternalProcessingPrice | Price | ||
| OpExternalProcessingPriceUnit | ||||
| Currency | Currency | Valuation Crcy | ||
| PurgInfoRecdDataIsFixed | PurgInfoRecdDataIsFixed | Price_fixed | ||
| PurchasingInfoRecord | PurchasingInfoRecord | Info Record | ||
| PurchasingInfoRecordCategory | PurchasingInfoRecordCategory | Infotype | ||
| PurchasingOrganization | PurchasingOrganization | Purchasing Organization | ||
| PurchasingGroup | PurchasingGroup | Purchasing Group | ||
| PurchaseRequisition | PurchaseRequisition | Requisition | ||
| PurchaseRequisitionItem | PurchaseRequisitionItem | Requisn. item | ||
| PurchasingDocument | PurchasingDocument | Purchasing Document | ||
| PurchasingDocumentItem | PurchasingDocumentItem | Purchasing Doc. Item | ||
| MaterialGroup | MaterialGroup | Product Group | ||
| GoodsRecipientName | GoodsRecipientName | Recipient Name | ||
| UnloadingPointName | UnloadingPointName | Unloading Point Name | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| BusinessArea | BusinessArea | Business Area | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| CostElement | CostElement | G/L Account | ||
| CostingVariant | CostingVariant | Costing Variant | ||
| CostEstimate | CostEstimate | Cost EstimateNo | ||
| CostingSheet | CostingSheet | Costing Sheet | ||
| RequestingCostCenter | RequestingCostCenter | Req.cost center | ||
| OperationCalculationControl | OperationCalculationControl | Calculation key | ||
| OperationCostingRelevancyType | OperationCostingRelevancyType | Operation Costing Relevancy Type | ||
| NetworkActivityCost | NetworkActivityCost | Amount | ||
| NtwkAccountAssignmentCode | NtwkAccountAssignmentCode | |||
| ActyIsTakenAcctForProjSmmry | ActyIsTakenAcctForProjSmmry | |||
| ControllingObjectCurrency | ControllingObjectCurrency | CO Object Currency | ||
| ControllingObjectClass | ControllingObjectClass | Object Class | ||
| TaxJurisdiction | TaxJurisdiction | Tax Jurisdiction | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| BusinessProcessConfirmedQty | BusinessProcessConfirmedQty | Process Quantity | ||
| BusinessProcessEntryUnit | BusinessProcessEntryUnit | Process Unit | ||
| NoFurtherBusinessProcQtyIsExpd | NoFurtherBusinessProcQtyIsExpd | No Remain. Act. | ||
| BusinessProcessRemainingQty | BusinessProcessRemainingQty | Remaining Proc. | ||
| BusinessProcRemainingQtyUnit | BusinessProcRemainingQtyUnit | RemainProc.Unit | ||
| CostCtrActivityType1 | CostCtrActivityType1 | Activity Type | ||
| CostCtrActivityType2 | CostCtrActivityType2 | Activity Type | ||
| CostCtrActivityType3 | CostCtrActivityType3 | Activity Type | ||
| CostCtrActivityType4 | CostCtrActivityType4 | Activity Type | ||
| CostCtrActivityType5 | CostCtrActivityType5 | Activity Type | ||
| CostCtrActivityType6 | CostCtrActivityType6 | Activity Type | ||
| CostCtrActivityType | CostCtrActivityType | Activity Type | ||
| NoFurtherOpWorkQuantity1IsExpd | NoFurtherOpWorkQuantity1IsExpd | |||
| NoFurtherOpWorkQuantity2IsExpd | NoFurtherOpWorkQuantity2IsExpd | No Remain. Act. | ||
| NoFurtherOpWorkQuantity3IsExpd | NoFurtherOpWorkQuantity3IsExpd | No Remain. Act. | ||
| NoFurtherOpWorkQuantity4IsExpd | NoFurtherOpWorkQuantity4IsExpd | No Remain. Act. | ||
| NoFurtherOpWorkQuantity5IsExpd | NoFurtherOpWorkQuantity5IsExpd | No Remain. Act. | ||
| NoFurtherOpWorkQuantity6IsExpd | NoFurtherOpWorkQuantity6IsExpd | No Remain. Act. | ||
| NoFurtherWorkQuantityIsExpd | NoFurtherWorkQuantityIsExpd | No Remain. Work | ||
| WorkCenterStandardWorkQty1 | WorkCenterStandardWorkQty1 | |||
| WorkCenterStandardWorkQty2 | WorkCenterStandardWorkQty2 | Standard Value | ||
| WorkCenterStandardWorkQty3 | WorkCenterStandardWorkQty3 | Standard Value | ||
| WorkCenterStandardWorkQty4 | WorkCenterStandardWorkQty4 | Standard Value | ||
| WorkCenterStandardWorkQty5 | WorkCenterStandardWorkQty5 | Standard Value | ||
| WorkCenterStandardWorkQty6 | WorkCenterStandardWorkQty6 | Standard Value | ||
| OpPlannedWorkQuantity | OpPlannedWorkQuantity | Work | ||
| WorkCenterStandardWorkQtyUnit1 | WorkCenterStandardWorkQtyUnit1 | |||
| WorkCenterStandardWorkQtyUnit2 | WorkCenterStandardWorkQtyUnit2 | Std value unit | ||
| WorkCenterStandardWorkQtyUnit3 | WorkCenterStandardWorkQtyUnit3 | Std value unit | ||
| WorkCenterStandardWorkQtyUnit4 | WorkCenterStandardWorkQtyUnit4 | Std value unit | ||
| WorkCenterStandardWorkQtyUnit5 | WorkCenterStandardWorkQtyUnit5 | Std value unit | ||
| WorkCenterStandardWorkQtyUnit6 | WorkCenterStandardWorkQtyUnit6 | Std value unit | ||
| OpWorkQuantityUnit1 | OpWorkQuantityUnit1 | Unit/activity | ||
| OpWorkQuantityUnit2 | OpWorkQuantityUnit2 | Unit/activity | ||
| OpWorkQuantityUnit3 | OpWorkQuantityUnit3 | Unit/activity | ||
| OpWorkQuantityUnit4 | OpWorkQuantityUnit4 | Unit/activity | ||
| OpWorkQuantityUnit5 | OpWorkQuantityUnit5 | Unit/activity | ||
| OpWorkQuantityUnit6 | OpWorkQuantityUnit6 | Unit/activity | ||
| OpWorkQuantityUnit | OpWorkQuantityUnit | Unit for work | ||
| OpConfirmedWorkQuantity1 | OpConfirmedWorkQuantity1 | |||
| OpConfirmedWorkQuantity2 | OpConfirmedWorkQuantity2 | Conf. Activity | ||
| OpConfirmedWorkQuantity3 | OpConfirmedWorkQuantity3 | Conf. Activity | ||
| OpConfirmedWorkQuantity4 | OpConfirmedWorkQuantity4 | Conf. Activity | ||
| OpConfirmedWorkQuantity5 | OpConfirmedWorkQuantity5 | Conf. Activity | ||
| OpConfirmedWorkQuantity6 | OpConfirmedWorkQuantity6 | Conf. Activity | ||
| ActualWorkQuantity | ActualWorkQuantity | Actual work | ||
| OrderIntBillOfOpItemOfPhase | OrderIntBillOfOpItemOfPhase | Node | ||
| MfgOrderOperationIsPhase | MfgOrderOperationIsPhase | Ind.: Phase | ||
| ControlRecipeDestination | ControlRecipeDestination | CtrlRec.Destin. | ||
| DependencyObjectNumber | DependencyObjectNumber | Assgmt no. | ||
| LineHierarchyInternalID | LineHierarchyInternalID | Object ID | ||
| OpSchedldReductionLevel | OpSchedldReductionLevel | Reduction Level | ||
| InspectionSubSystem | InspectionSubSystem | QDR System | ||
| ServicePackage | ServicePackage | Package number | ||
| MaterialPlanningRelevance | MaterialPlanningRelevance | Res./Purc. req. | ||
| ProductConfiguration | ProductConfiguration | Int. object no. | ||
| ProgressAnlysAggregationWeight | ProgressAnlysAggregationWeight | POC weight | ||
| OperationRequisitionerName | OperationRequisitionerName | Requisitioner | ||
| OperationTrackingNumber | OperationTrackingNumber | Tracking Number | ||
| InspectionLotType | InspectionLotType | Inspection Type | ||
| ExchangeRate | ExchangeRate | Exchange rate | ||
| BillingPlan | BillingPlan | Bill. Plan No. | ||
| ReferencePoint | ReferencePoint | Reference point | ||
| OperationUnit | OperationUnit | Act/op UoM | ||
| OperationReferenceQuantity | OperationReferenceQuantity | Base Quantity | ||
| OpQtyToBaseQtyDnmntr | OpQtyToBaseQtyDnmntr | Denominator | ||
| OpQtyToBaseQtyNmrtr | OpQtyToBaseQtyNmrtr | Numerator | ||
| OpPlannedTotalQuantity | OpPlannedTotalQuantity | Operation Qty | ||
| OpPlannedScrapQuantity | OpPlannedScrapQuantity | Planned Scrap | ||
| OpTotalConfirmedYieldQty | OpTotalConfirmedYieldQty | Yield Quantity | ||
| OpTotalConfirmedScrapQty | OpTotalConfirmedScrapQty | Scrap Quantity | ||
| OperationConfirmedReworkQty | OperationConfirmedReworkQty | Rework Quantity | ||
| OpTotConfdYieldQtyInOrdQtyUnit | OpTotConfdYieldQtyInOrdQtyUnit | Yield in Order Unit | ||
| BreakDurationUnit | BreakDurationUnit | Break Time Unit | ||
| PlannedBreakDuration | PlannedBreakDuration | Break Time | ||
| ConfirmedBreakDuration | ConfirmedBreakDuration | Conf Break Time | ||
| OverlapMinimumDurationUnit | OverlapMinimumDurationUnit | Min.Overlap Tme | ||
| OverlapMinimumDuration | OverlapMinimumDuration | Minimum Overlap | ||
| MaximumWaitDurationUnit | MaximumWaitDurationUnit | Max. Wait Unit | ||
| MaximumWaitDuration | MaximumWaitDuration | Max. Wait Time | ||
| MinimumWaitDurationUnit | MinimumWaitDurationUnit | Req. Wait Unit | ||
| MinimumWaitDuration | MinimumWaitDuration | Min. Wait Time | ||
| StandardMoveDurationUnit | StandardMoveDurationUnit | StdMoveTime Un | ||
| StandardMoveDuration | StandardMoveDuration | Std Move Time | ||
| StandardQueueDurationUnit | StandardQueueDurationUnit | Std Queue Unit | ||
| StandardQueueDuration | StandardQueueDuration | Std Queue Time | ||
| MinimumQueueDurationUnit | MinimumQueueDurationUnit | Min. Queue Unit | ||
| MinimumQueueDuration | MinimumQueueDuration | Min. Queue Time | ||
| MinimumMoveDurationUnit | MinimumMoveDurationUnit | MinMoveTime Un | ||
| MinimumMoveDuration | MinimumMoveDuration | Min. Move Time | ||
| OperationStandardDuration | OperationStandardDuration | Normal duration | ||
| OperationStandardDurationUnit | OperationStandardDurationUnit | Norm.duratn un. | ||
| MinimumDuration | MinimumDuration | Min. duration | ||
| MinimumDurationUnit | MinimumDurationUnit | Min. dur. unit | ||
| ScheduledMoveDuration | ScheduledMoveDuration | Move Time | ||
| ScheduledMoveDurationUnit | ScheduledMoveDurationUnit | Move Time Unit | ||
| ScheduledQueueDuration | ScheduledQueueDuration | Queue Time | ||
| ScheduledQueueDurationUnit | ScheduledQueueDurationUnit | Queue Time Unit | ||
| ScheduledWaitDuration | ScheduledWaitDuration | Wait Time | ||
| ScheduledWaitDurationUnit | ScheduledWaitDurationUnit | Wait Time Unit | ||
| PlannedDeliveryDuration | PlannedDeliveryDuration | Pl. Deliv. Time | ||
| OpPlannedSetupDurn | OpPlannedSetupDurn | Setup Time | ||
| OpPlannedSetupDurnUnit | OpPlannedSetupDurnUnit | Setup Unit | ||
| OpPlannedProcessingDurn | OpPlannedProcessingDurn | Processing Time | ||
| OpPlannedProcessingDurnUnit | OpPlannedProcessingDurnUnit | Proc. time unit | ||
| OpPlannedTeardownDurn | OpPlannedTeardownDurn | Teardown | ||
| OpPlannedTeardownDurnUnit | OpPlannedTeardownDurnUnit | Teardown Unit | ||
| ActyBscStartDateConstraintType | ActyBscStartDateConstraintType | StartConstraint | ||
| ActyBscEndDateConstraintType | ActyBscEndDateConstraintType | Fin. constraint | ||
| ActyFcstEndDateConstraintType | ActyFcstEndDateConstraintType | Fin. constraint | ||
| ActyFcstStartDteConstraintType | ActyFcstStartDteConstraintType | StartConstraint | ||
| FcstdStandardDurationUnit | FcstdStandardDurationUnit | Unit/NrmDur(F) | ||
| OpErlstSchedldExecStrtDte | OpErlstSchedldExecStrtDte | Earl.start date | ||
| OpErlstSchedldExecStrtTme | OpErlstSchedldExecStrtTme | Earl.start time | ||
| OpErlstSchedldProcgStrtDte | OpErlstSchedldProcgStrtDte | Earl.start date | ||
| OpErlstSchedldProcgStrtTme | OpErlstSchedldProcgStrtTme | Earl.start time | ||
| OpErlstSchedldTrdwnStrtDte | OpErlstSchedldTrdwnStrtDte | Earl.start date | ||
| OpErlstSchedldTrdwnStrtTme | OpErlstSchedldTrdwnStrtTme | Earl.start time | ||
| OpErlstSchedldExecEndDte | OpErlstSchedldExecEndDte | EarliestEndDate | ||
| OpErlstSchedldExecEndTme | OpErlstSchedldExecEndTme | Earliest finish | ||
| OpLtstSchedldExecStrtDte | OpLtstSchedldExecStrtDte | Latest start | ||
| OpLtstSchedldExecStrtTme | OpLtstSchedldExecStrtTme | Lat. start time | ||
| OpLtstSchedldProcgStrtDte | OpLtstSchedldProcgStrtDte | Lat.start date | ||
| OpLtstSchedldProcgStrtTme | OpLtstSchedldProcgStrtTme | Lat. start time | ||
| OpLtstSchedldTrdwnStrtDte | OpLtstSchedldTrdwnStrtDte | Lat.start date | ||
| OpLtstSchedldTrdwnStrtTme | OpLtstSchedldTrdwnStrtTme | Lat. start time | ||
| OpLtstSchedldExecEndDte | OpLtstSchedldExecEndDte | Lat.finish date | ||
| OpLtstSchedldExecEndTme | OpLtstSchedldExecEndTme | Latest fin.time | ||
| OperationConfirmedStartDate | OperationConfirmedStartDate | Operation Start Date | ||
| OperationConfirmedEndDate | OperationConfirmedEndDate | Operation End Date | ||
| OpActualExecutionStartDate | OpActualExecutionStartDate | Execution Start Date | ||
| OpActualExecutionStartTime | OpActualExecutionStartTime | Execution Start Time | ||
| OpActualSetupEndDate | OpActualSetupEndDate | Setup End Date | ||
| OpActualSetupEndTime | OpActualSetupEndTime | Setup End Time | ||
| OpActualProcessingStartDate | OpActualProcessingStartDate | Start of Proc. | ||
| OpActualProcessingStartTime | OpActualProcessingStartTime | Start of Proc. | ||
| OpActualProcessingEndDate | OpActualProcessingEndDate | Processing End Date | ||
| OpActualProcessingEndTime | OpActualProcessingEndTime | Processing End Time | ||
| OpActualTeardownStartDate | OpActualTeardownStartDate | Teardown Start Date | ||
| OpActualTeardownStartTme | OpActualTeardownStartTme | Teardown Start Time | ||
| OpActualExecutionEndDate | OpActualExecutionEndDate | Execution End Date | ||
| OpActualExecutionEndTime | OpActualExecutionEndTime | Execution End Time | ||
| SchedldFcstdEarliestStartDate | SchedldFcstdEarliestStartDate | Earliest start date | ||
| SchedldFcstdEarliestStartTime | SchedldFcstdEarliestStartTime | Earliest start time | ||
| SchedldFcstdEarliestEndDate | SchedldFcstdEarliestEndDate | Earliest finish | ||
| SchedldFcstdEarliestEndTime | SchedldFcstdEarliestEndTime | Earliest Finish | ||
| LatestSchedldFcstdStartDate | LatestSchedldFcstdStartDate | LateSchdStartDt | ||
| SchedldFcstdLatestStartTime | SchedldFcstdLatestStartTime | Latest start | ||
| LatestSchedldFcstdEndDate | LatestSchedldFcstdEndDate | Latest end | ||
| SchedldFcstdLatestEndTime | SchedldFcstdLatestEndTime | Latest finish | ||
| ConstraintDateForBscStartDate | ConstraintDateForBscStartDate | Start constr. | ||
| ConstraintTimeForBscStartTime | ConstraintTimeForBscStartTime | StartTimeConstr | ||
| OpDispatchedExecStartDate | OpDispatchedExecStartDate | Disptched start | ||
| OpDispatchedExecStartTime | OpDispatchedExecStartTime | DispatchedStart | ||
| OpDispatchedExecEndDate | OpDispatchedExecEndDate | DsptchFinish | ||
| OpDispatchedExecEndTime | OpDispatchedExecEndTime | DsptchdFinish | ||
| BasicDatesFreeFloat | ||||
| TotalFloatForBasicDates | ||||
| StartDateOffsetReferenceCode | StartDateOffsetReferenceCode | Reference Date | ||
| StartDateOffsetDurationUnit | StartDateOffsetDurationUnit | Unit | ||
| StartDateOffsetDuration | StartDateOffsetDuration | Offset | ||
| EndDateOffsetReferenceCode | EndDateOffsetReferenceCode | Reference | ||
| EndDateOffsetDuration | EndDateOffsetDuration | Offset to finsh | ||
| EndDateOffsetDurationUnit | EndDateOffsetDurationUnit | Unit | ||
| FreeDefinedTableFieldSemantic | FreeDefinedTableFieldSemantic | Field key PS | ||
| FreeDefinedAttribute01 | FreeDefinedAttribute01 | Attribute 1 | ||
| FreeDefinedAttribute02 | FreeDefinedAttribute02 | Attribute 2 | ||
| FreeDefinedAttribute03 | FreeDefinedAttribute03 | Attribute 3 | ||
| FreeDefinedAttribute04 | FreeDefinedAttribute04 | Attribute 4 | ||
| FreeDefinedQuantity1 | FreeDefinedQuantity1 | User field qty. | ||
| FreeDefinedQuantity2 | FreeDefinedQuantity2 | User field qty. | ||
| FreeDefinedAmount1 | FreeDefinedAmount1 | User fld 7-amt | ||
| FreeDefinedAmount2 | FreeDefinedAmount2 | User fld 8-amt | ||
| FreeDefinedDate1 | FreeDefinedDate1 | User field date | ||
| FreeDefinedDate2 | FreeDefinedDate2 | User field date | ||
| FreeDefinedIndicator1 | FreeDefinedIndicator1 | User field ind. | ||
| FreeDefinedIndicator2 | FreeDefinedIndicator2 | User field ind. | ||
| SetupOpActyNtwkInstance | SetupOpActyNtwkInstance | Instance ID | ||
| ProduceOpActyNtwkInstance | ProduceOpActyNtwkInstance | Instance ID | ||
| TeardownOpActyNtwkInstance | TeardownOpActyNtwkInstance | Instance ID | ||
| _OrderInternalID | _OrderInternalID | |||
| _WorkCenter | _WorkCenter | |||
| _WorkCenterType | _WorkCenterType |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view P_MfgOrderOpAdaptedDatesBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PORDOPERADPTDTS
CREATE VIEW P_MfgOrderOpAdaptedDatesBasic AS
SELECT
OrderInternalID,
OrderOperationInternalID,
Sequence,
Operation,
BillOfOperationsSequence,
BillOfOperationsType,
BillOfOperationsGroup,
BillOfOperationsVariant,
BOOOperationInternalID,
BillOfOperationsVersion,
BillOfMaterialCategory,
BillOfMaterialInternalID,
BillOfMaterialItemNodeNumber,
BOMItemNodeCount,
SuperiorOperationInternalID,
OperationControlProfile,
WorkCenterInternalID,
WorkCenterTypeCode_2 AS WorkCenterTypeCode,
Plant,
FactoryCalendar,
CapacityRequirement,
CapacityRequirementItem,
ActualNumberOfSplits,
NumberOfCapacities,
OperationIsToBeDeleted,
NetworkActivityPriority,
OperationImportance,
OperationWorkPercent,
UsageCode,
Assembly,
ProjectInternalID,
ObjectInternalID,
OperationConfirmation,
NumberOfOperationConfirmations,
NumberOfOperationExecutions,
OperationSystemCondition,
ChangeNumber,
StandardTextInternalID,
OperationText,
Language,
NumberOfTimeTickets,
EmployeeWageType,
EmployeeWageGroup,
NumberOfConfirmationSlips,
EmployeeSuitability,
Personnel,
NumberOfEmployees,
OperationSetupGroupCategory,
OperationSetupGroup,
OperationSetupType,
OperationScrapPercent,
OperationOverlappingIsRequired,
OperationOverlappingIsPossible,
OperationsIsAlwaysOverlapping,
OperationSplitIsRequired,
MaximumNumberOfSplits,
LeadTimeReductionStrategy,
OverheadCode,
OperationPurgInfoRecdSearchTxt,
ExtProcgOperationHasSubcontrg,
Supplier,
OpExternalProcessingPrice,
Currency,
PurgInfoRecdDataIsFixed,
PurchasingInfoRecord,
PurchasingInfoRecordCategory,
PurchasingOrganization,
PurchasingGroup,
PurchaseRequisition,
PurchaseRequisitionItem,
PurchasingDocument,
PurchasingDocumentItem,
MaterialGroup,
GoodsRecipientName,
UnloadingPointName,
CompanyCode,
BusinessArea,
ProfitCenter,
CostElement,
CostingVariant,
CostEstimate,
CostingSheet,
RequestingCostCenter,
OperationCalculationControl,
OperationCostingRelevancyType,
NetworkActivityCost,
NtwkAccountAssignmentCode,
ActyIsTakenAcctForProjSmmry,
ControllingObjectCurrency,
ControllingObjectClass,
TaxJurisdiction,
FunctionalArea,
BusinessProcess,
BusinessProcessConfirmedQty,
BusinessProcessEntryUnit,
NoFurtherBusinessProcQtyIsExpd,
BusinessProcessRemainingQty,
BusinessProcRemainingQtyUnit,
CostCtrActivityType1,
CostCtrActivityType2,
CostCtrActivityType3,
CostCtrActivityType4,
CostCtrActivityType5,
CostCtrActivityType6,
CostCtrActivityType,
NoFurtherOpWorkQuantity1IsExpd,
NoFurtherOpWorkQuantity2IsExpd,
NoFurtherOpWorkQuantity3IsExpd,
NoFurtherOpWorkQuantity4IsExpd,
NoFurtherOpWorkQuantity5IsExpd,
NoFurtherOpWorkQuantity6IsExpd,
NoFurtherWorkQuantityIsExpd,
WorkCenterStandardWorkQty1,
WorkCenterStandardWorkQty2,
WorkCenterStandardWorkQty3,
WorkCenterStandardWorkQty4,
WorkCenterStandardWorkQty5,
WorkCenterStandardWorkQty6,
OpPlannedWorkQuantity,
WorkCenterStandardWorkQtyUnit1,
WorkCenterStandardWorkQtyUnit2,
WorkCenterStandardWorkQtyUnit3,
WorkCenterStandardWorkQtyUnit4,
WorkCenterStandardWorkQtyUnit5,
WorkCenterStandardWorkQtyUnit6,
OpWorkQuantityUnit1,
OpWorkQuantityUnit2,
OpWorkQuantityUnit3,
OpWorkQuantityUnit4,
OpWorkQuantityUnit5,
OpWorkQuantityUnit6,
OpWorkQuantityUnit,
OpConfirmedWorkQuantity1,
OpConfirmedWorkQuantity2,
OpConfirmedWorkQuantity3,
OpConfirmedWorkQuantity4,
OpConfirmedWorkQuantity5,
OpConfirmedWorkQuantity6,
ActualWorkQuantity,
OrderIntBillOfOpItemOfPhase,
MfgOrderOperationIsPhase,
ControlRecipeDestination,
DependencyObjectNumber,
LineHierarchyInternalID,
OpSchedldReductionLevel,
InspectionSubSystem,
ServicePackage,
MaterialPlanningRelevance,
ProductConfiguration,
ProgressAnlysAggregationWeight,
OperationRequisitionerName,
OperationTrackingNumber,
InspectionLotType,
ExchangeRate,
BillingPlan,
ReferencePoint,
OperationUnit,
OperationReferenceQuantity,
OpQtyToBaseQtyDnmntr,
OpQtyToBaseQtyNmrtr,
OpPlannedTotalQuantity,
OpPlannedScrapQuantity,
OpTotalConfirmedYieldQty,
OpTotalConfirmedScrapQty,
OperationConfirmedReworkQty,
OpTotConfdYieldQtyInOrdQtyUnit,
BreakDurationUnit,
PlannedBreakDuration,
ConfirmedBreakDuration,
OverlapMinimumDurationUnit,
OverlapMinimumDuration,
MaximumWaitDurationUnit,
MaximumWaitDuration,
MinimumWaitDurationUnit,
MinimumWaitDuration,
StandardMoveDurationUnit,
StandardMoveDuration,
StandardQueueDurationUnit,
StandardQueueDuration,
MinimumQueueDurationUnit,
MinimumQueueDuration,
MinimumMoveDurationUnit,
MinimumMoveDuration,
OperationStandardDuration,
OperationStandardDurationUnit,
MinimumDuration,
MinimumDurationUnit,
ScheduledMoveDuration,
ScheduledMoveDurationUnit,
ScheduledQueueDuration,
ScheduledQueueDurationUnit,
ScheduledWaitDuration,
ScheduledWaitDurationUnit,
PlannedDeliveryDuration,
OpPlannedSetupDurn,
OpPlannedSetupDurnUnit,
OpPlannedProcessingDurn,
OpPlannedProcessingDurnUnit,
OpPlannedTeardownDurn,
OpPlannedTeardownDurnUnit,
ActyBscStartDateConstraintType,
ActyBscEndDateConstraintType,
ActyFcstEndDateConstraintType,
ActyFcstStartDteConstraintType,
FcstdStandardDurationUnit,
OpErlstSchedldExecStrtDte,
OpErlstSchedldExecStrtTme,
OpErlstSchedldProcgStrtDte,
OpErlstSchedldProcgStrtTme,
OpErlstSchedldTrdwnStrtDte,
OpErlstSchedldTrdwnStrtTme,
OpErlstSchedldExecEndDte,
OpErlstSchedldExecEndTme,
OpLtstSchedldExecStrtDte,
OpLtstSchedldExecStrtTme,
OpLtstSchedldProcgStrtDte,
OpLtstSchedldProcgStrtTme,
OpLtstSchedldTrdwnStrtDte,
OpLtstSchedldTrdwnStrtTme,
OpLtstSchedldExecEndDte,
OpLtstSchedldExecEndTme,
OperationConfirmedStartDate,
OperationConfirmedEndDate,
OpActualExecutionStartDate,
OpActualExecutionStartTime,
OpActualSetupEndDate,
OpActualSetupEndTime,
OpActualProcessingStartDate,
OpActualProcessingStartTime,
OpActualProcessingEndDate,
OpActualProcessingEndTime,
OpActualTeardownStartDate,
OpActualTeardownStartTme,
OpActualExecutionEndDate,
OpActualExecutionEndTime,
SchedldFcstdEarliestStartDate,
SchedldFcstdEarliestStartTime,
SchedldFcstdEarliestEndDate,
SchedldFcstdEarliestEndTime,
LatestSchedldFcstdStartDate,
SchedldFcstdLatestStartTime,
LatestSchedldFcstdEndDate,
SchedldFcstdLatestEndTime,
ConstraintDateForBscStartDate,
ConstraintTimeForBscStartTime,
OpDispatchedExecStartDate,
OpDispatchedExecStartTime,
OpDispatchedExecEndDate,
OpDispatchedExecEndTime,
StartDateOffsetReferenceCode,
StartDateOffsetDurationUnit,
StartDateOffsetDuration,
EndDateOffsetReferenceCode,
EndDateOffsetDuration,
EndDateOffsetDurationUnit,
FreeDefinedTableFieldSemantic,
FreeDefinedAttribute01,
FreeDefinedAttribute02,
FreeDefinedAttribute03,
FreeDefinedAttribute04,
FreeDefinedQuantity1,
FreeDefinedQuantity2,
FreeDefinedAmount1,
FreeDefinedAmount2,
FreeDefinedDate1,
FreeDefinedDate2,
FreeDefinedIndicator1,
FreeDefinedIndicator2,
SetupOpActyNtwkInstance,
ProduceOpActyNtwkInstance,
TeardownOpActyNtwkInstance
FROM I_OrderOperation
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA