P_MfgOrderOperationDelayBasic

DDL: P_MFGORDEROPERATIONDELAYBASIC SQL: PMFGOROPDELYBSC Type: view COMPOSITE Package: VDM_PP_SFC
119 Fields 2 Data Sources

Manufacturing Order Operation Delay Basic Data

P_MfgOrderOperationDelayBasic is a Composite CDS View that provides data about "Manufacturing Order Operation Delay Basic Data" in SAP S/4HANA. It reads from 2 data sources (I_OrderOperationDateTime, I_MfgOrderBasic) and exposes 119 fields with key fields OrderInternalID, OrderOperationInternalID. Part of development package VDM_PP_SFC.

Data Sources (2)

SourceAliasJoin Type
I_OrderOperationDateTime afvg from
I_MfgOrderBasic aufv inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMFGOROPDELYBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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

Fields (119)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderOperationDateTime OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationDateTime OrderOperationInternalID
ManufacturingOrder I_MfgOrderBasic ManufacturingOrder Order
Sequence I_OrderOperationDateTime Sequence Visit Sequence
Operation I_OrderOperationDateTime Operation Transaction
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory Order Category
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType Order Type
ProductionSupervisor I_MfgOrderBasic ProductionSupervisor Prodn Supervisor
MRPController I_MfgOrderBasic MRPController MRP Controller
ResponsiblePlannerGroup I_MfgOrderBasic ResponsiblePlannerGroup
ProductConfiguration I_MfgOrderBasic ProductConfiguration
InspectionLot I_MfgOrderBasic InspectionLot Inspection Lot
Reservation I_MfgOrderBasic Reservation Reservation
ManufacturingOrderImportance I_MfgOrderBasic ManufacturingOrderImportance
ProdnProcgIsFlexible I_MfgOrderBasic ProdnProcgIsFlexible
MfgOrderIsToBeDeleted I_MfgOrderBasic MfgOrderIsToBeDeleted Purch.org. data
OperationText I_OrderOperationDateTime OperationText Description
Language I_OrderOperationDateTime Language Report Text Language
StandardTextInternalID I_OrderOperationDateTime StandardTextInternalID
OperationIsToBeDeleted I_OrderOperationDateTime OperationIsToBeDeleted
NumberOfCapacities
NumberOfConfirmationSlips I_OrderOperationDateTime NumberOfConfirmationSlips No. of Conf. Slips
OperationImportance I_OrderOperationDateTime OperationImportance
Plant I_OrderOperationDateTime Plant Valuation Area
WorkCenterInternalID I_OrderOperationDateTime WorkCenterInternalID Work Center
WorkCenterTypeCode I_OrderOperationDateTime WorkCenterTypeCode Object Type
OperationControlProfile I_OrderOperationDateTime OperationControlProfile Control Key
OperationConfirmation I_OrderOperationDateTime OperationConfirmation
NumberOfOperationConfirmations I_OrderOperationDateTime NumberOfOperationConfirmations
FactoryCalendar I_OrderOperationDateTime FactoryCalendar Factory Calendar
CapacityRequirement I_OrderOperationDateTime CapacityRequirement
CapacityRequirementItem I_OrderOperationDateTime CapacityRequirementItem
ChangeNumber I_OrderOperationDateTime ChangeNumber Change Number
ObjectInternalID I_OrderOperationDateTime ObjectInternalID Object number
BillOfOperationsType I_OrderOperationDateTime BillOfOperationsType Task List Type
BillOfOperationsGroup I_OrderOperationDateTime BillOfOperationsGroup Group
BillOfOperationsVariant I_OrderOperationDateTime BillOfOperationsVariant Group Counter
BillOfOperationsSequence I_OrderOperationDateTime BillOfOperationsSequence Sequence
BOOOperationInternalID I_OrderOperationDateTime BOOOperationInternalID Task list node
BillOfOperationsVersion I_OrderOperationDateTime BillOfOperationsVersion Routing Version
BillOfMaterialCategory I_OrderOperationDateTime BillOfMaterialCategory BOM category
BillOfMaterialInternalID I_OrderOperationDateTime BillOfMaterialInternalID
BillOfMaterialItemNodeNumber I_OrderOperationDateTime BillOfMaterialItemNodeNumber Item node
BOMItemNodeCount I_OrderOperationDateTime BOMItemNodeCount Counter
CompanyCode I_OrderOperationDateTime CompanyCode Receiver Company Code
BusinessArea I_OrderOperationDateTime BusinessArea Business Area
ControllingArea I_MfgOrderBasic ControllingArea Controlling Area
ProfitCenter I_OrderOperationDateTime ProfitCenter Profit Center
ControllingObjectClass I_OrderOperationDateTime ControllingObjectClass Object Class
FunctionalArea I_OrderOperationDateTime FunctionalArea Sendr Fctl Area
EmployeeWageType I_OrderOperationDateTime EmployeeWageType Wage type
EmployeeWageGroup I_OrderOperationDateTime EmployeeWageGroup Wage Group
EmployeeSuitability I_OrderOperationDateTime EmployeeSuitability
NumberOfTimeTickets I_OrderOperationDateTime NumberOfTimeTickets No.TimeTickets
Personnel I_OrderOperationDateTime Personnel Personnel No.
NumberOfEmployees I_OrderOperationDateTime NumberOfEmployees No. employees
PlantTimeZone I_OrderOperationDateTime PlantTimeZone Time Zone
OpErlstSchedldExecStrtDte I_OrderOperationDateTime OpErlstSchedldExecStrtDte Earl.start date
OpErlstSchedldExecStrtTme I_OrderOperationDateTime OpErlstSchedldExecStrtTme
OpErlstSchedldExecStrtDteTme I_OrderOperationDateTime OpErlstSchedldExecStrtDteTme Time Stamp
OpErlstSchedldProcgStrtDte I_OrderOperationDateTime OpErlstSchedldProcgStrtDte
OpErlstSchedldProcgStrtTme I_OrderOperationDateTime OpErlstSchedldProcgStrtTme
OpErlstSchedldProcgStrtDteTme I_OrderOperationDateTime OpErlstSchedldProcgStrtDteTme
OpErlstSchedldTrdwnStrtDte I_OrderOperationDateTime OpErlstSchedldTrdwnStrtDte
OpErlstSchedldTrdwnStrtTme I_OrderOperationDateTime OpErlstSchedldTrdwnStrtTme
OpErlstSchedldTrdwnStrtDteTme I_OrderOperationDateTime OpErlstSchedldTrdwnStrtDteTme
OpErlstSchedldExecEndDte I_OrderOperationDateTime OpErlstSchedldExecEndDte EarliestEndDate
OpErlstSchedldExecEndTme I_OrderOperationDateTime OpErlstSchedldExecEndTme
OpErlstSchedldExecEndDteTme I_OrderOperationDateTime OpErlstSchedldExecEndDteTme Time Stamp
OpLtstSchedldExecStrtDte I_OrderOperationDateTime OpLtstSchedldExecStrtDte Latest start
OpLtstSchedldExecStrtTme I_OrderOperationDateTime OpLtstSchedldExecStrtTme
OpLtstSchedldExecStrtDteTme I_OrderOperationDateTime OpLtstSchedldExecStrtDteTme Time Stamp
OpLtstSchedldProcgStrtDte I_OrderOperationDateTime OpLtstSchedldProcgStrtDte
OpLtstSchedldProcgStrtTme I_OrderOperationDateTime OpLtstSchedldProcgStrtTme
OpLtstSchedldProcgStrtDteTme I_OrderOperationDateTime OpLtstSchedldProcgStrtDteTme
OpLtstSchedldTrdwnStrtDte I_OrderOperationDateTime OpLtstSchedldTrdwnStrtDte
OpLtstSchedldTrdwnStrtTme I_OrderOperationDateTime OpLtstSchedldTrdwnStrtTme
OpLtstSchedldTrdwnStrtDteTme I_OrderOperationDateTime OpLtstSchedldTrdwnStrtDteTme
OpLtstSchedldExecEndDte I_OrderOperationDateTime OpLtstSchedldExecEndDte Lat.finish date
OpLtstSchedldExecEndTme I_OrderOperationDateTime OpLtstSchedldExecEndTme
OpLtstSchedldExecEndDteTme I_OrderOperationDateTime OpLtstSchedldExecEndDteTme Time Stamp
OperationConfirmedStartDate I_OrderOperationDateTime OperationConfirmedStartDate
OperationConfirmedEndDate I_OrderOperationDateTime OperationConfirmedEndDate
OpActualExecutionStartDate I_OrderOperationDateTime OpActualExecutionStartDate Execution Start Date
OpActualExecutionStartTime I_OrderOperationDateTime OpActualExecutionStartTime
OpActualExecutionStartDateTime I_OrderOperationDateTime OpActualExecutionStartDateTime Time Stamp
OpActualSetupEndDate I_OrderOperationDateTime OpActualSetupEndDate
OpActualSetupEndTime I_OrderOperationDateTime OpActualSetupEndTime
OpActualSetupEndDateTime I_OrderOperationDateTime OpActualSetupEndDateTime
OpActualProcessingStartDate I_OrderOperationDateTime OpActualProcessingStartDate
OpActualProcessingStartTime I_OrderOperationDateTime OpActualProcessingStartTime
OpActualProcessingStartDteTme I_OrderOperationDateTime OpActualProcessingStartDteTme
OpActualProcessingEndDate I_OrderOperationDateTime OpActualProcessingEndDate
OpActualProcessingEndTime I_OrderOperationDateTime OpActualProcessingEndTime
OpActualProcessingEndDateTime I_OrderOperationDateTime OpActualProcessingEndDateTime
OpActualTeardownStartDate I_OrderOperationDateTime OpActualTeardownStartDate
OpActualTeardownStartTme I_OrderOperationDateTime OpActualTeardownStartTme
OpActualTeardownStartDateTime I_OrderOperationDateTime OpActualTeardownStartDateTime
OpActualExecutionEndDate I_OrderOperationDateTime OpActualExecutionEndDate Execution End Date
OpActualExecutionEndTime I_OrderOperationDateTime OpActualExecutionEndTime
OpActualExecutionEndDateTime I_OrderOperationDateTime OpActualExecutionEndDateTime Time Stamp
StartDateOffsetReferenceCode I_OrderOperationDateTime StartDateOffsetReferenceCode
StartDateOffsetDurationUnit I_OrderOperationDateTime StartDateOffsetDurationUnit
StartDateOffsetDuration I_OrderOperationDateTime StartDateOffsetDuration
EndDateOffsetReferenceCode I_OrderOperationDateTime EndDateOffsetReferenceCode
EndDateOffsetDurationUnit I_OrderOperationDateTime EndDateOffsetDurationUnit
EndDateOffsetDuration I_OrderOperationDateTime EndDateOffsetDuration
OperationUnit I_OrderOperationDateTime OperationUnit Act/op UoM
OperationScrapPercent I_OrderOperationDateTime OperationScrapPercent Scrap
OperationReferenceQuantity I_OrderOperationDateTime OperationReferenceQuantity Base Quantity
OpPlannedTotalQuantity I_OrderOperationDateTime OpPlannedTotalQuantity
OpPlannedScrapQuantity I_OrderOperationDateTime OpPlannedScrapQuantity
OpPlannedYieldQuantity
OpTotalConfirmedYieldQty I_OrderOperationDateTime OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty I_OrderOperationDateTime OpTotalConfirmedScrapQty
OperationConfirmedReworkQty I_OrderOperationDateTime OperationConfirmedReworkQty
SetupOpActyNtwkInstance I_OrderOperationDateTime SetupOpActyNtwkInstance
ProduceOpActyNtwkInstance I_OrderOperationDateTime ProduceOpActyNtwkInstance
TeardownOpActyNtwkInstance I_OrderOperationDateTime TeardownOpActyNtwkInstance

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_MfgOrderOperationDelayBasic.
-- 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: PMFGOROPDELYBSC

CREATE VIEW P_MfgOrderOperationDelayBasic AS
SELECT
  afvg.OrderInternalID AS OrderInternalID,
  afvg.OrderOperationInternalID AS OrderOperationInternalID,
  aufv.ManufacturingOrder AS ManufacturingOrder,
  afvg.Sequence AS Sequence,
  afvg.Operation AS Operation,
  aufv.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  aufv.ManufacturingOrderType AS ManufacturingOrderType,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  aufv.MRPController AS MRPController,
  aufv.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  aufv.ProductConfiguration AS ProductConfiguration,
  aufv.InspectionLot AS InspectionLot,
  aufv.Reservation AS Reservation,
  aufv.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  aufv.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  aufv.MfgOrderIsToBeDeleted AS MfgOrderIsToBeDeleted,
  afvg.OperationText AS OperationText,
  afvg.Language AS Language,
  afvg.StandardTextInternalID AS StandardTextInternalID,
  afvg.OperationIsToBeDeleted AS OperationIsToBeDeleted,
  cast(afvg.NumberOfCapacities as pph_anzkap preserving type) AS NumberOfCapacities,
  afvg.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
  afvg.OperationImportance AS OperationImportance,
  afvg.Plant AS Plant,
  afvg.WorkCenterInternalID AS WorkCenterInternalID,
  afvg.WorkCenterTypeCode AS WorkCenterTypeCode,
  afvg.OperationControlProfile AS OperationControlProfile,
  afvg.OperationConfirmation AS OperationConfirmation,
  afvg.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
  afvg.FactoryCalendar AS FactoryCalendar,
  afvg.CapacityRequirement AS CapacityRequirement,
  afvg.CapacityRequirementItem AS CapacityRequirementItem,
  afvg.ChangeNumber AS ChangeNumber,
  afvg.ObjectInternalID AS ObjectInternalID,
  afvg.BillOfOperationsType AS BillOfOperationsType,
  afvg.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvg.BillOfOperationsVariant AS BillOfOperationsVariant,
  afvg.BillOfOperationsSequence AS BillOfOperationsSequence,
  afvg.BOOOperationInternalID AS BOOOperationInternalID,
  afvg.BillOfOperationsVersion AS BillOfOperationsVersion,
  afvg.BillOfMaterialCategory AS BillOfMaterialCategory,
  afvg.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  afvg.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  afvg.BOMItemNodeCount AS BOMItemNodeCount,
  afvg.CompanyCode AS CompanyCode,
  afvg.BusinessArea AS BusinessArea,
  aufv.ControllingArea AS ControllingArea,
  afvg.ProfitCenter AS ProfitCenter,
  afvg.ControllingObjectClass AS ControllingObjectClass,
  afvg.FunctionalArea AS FunctionalArea,
  afvg.EmployeeWageType AS EmployeeWageType,
  afvg.EmployeeWageGroup AS EmployeeWageGroup,
  afvg.EmployeeSuitability AS EmployeeSuitability,
  afvg.NumberOfTimeTickets AS NumberOfTimeTickets,
  afvg.Personnel AS Personnel,
  afvg.NumberOfEmployees AS NumberOfEmployees,
  afvg.PlantTimeZone AS PlantTimeZone,
  afvg.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  afvg.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  afvg.OpErlstSchedldExecStrtDteTme AS OpErlstSchedldExecStrtDteTme,
  afvg.OpErlstSchedldProcgStrtDte AS OpErlstSchedldProcgStrtDte,
  afvg.OpErlstSchedldProcgStrtTme AS OpErlstSchedldProcgStrtTme,
  afvg.OpErlstSchedldProcgStrtDteTme AS OpErlstSchedldProcgStrtDteTme,
  afvg.OpErlstSchedldTrdwnStrtDte AS OpErlstSchedldTrdwnStrtDte,
  afvg.OpErlstSchedldTrdwnStrtTme AS OpErlstSchedldTrdwnStrtTme,
  afvg.OpErlstSchedldTrdwnStrtDteTme AS OpErlstSchedldTrdwnStrtDteTme,
  afvg.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  afvg.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  afvg.OpErlstSchedldExecEndDteTme AS OpErlstSchedldExecEndDteTme,
  afvg.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  afvg.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  afvg.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  afvg.OpLtstSchedldProcgStrtDte AS OpLtstSchedldProcgStrtDte,
  afvg.OpLtstSchedldProcgStrtTme AS OpLtstSchedldProcgStrtTme,
  afvg.OpLtstSchedldProcgStrtDteTme AS OpLtstSchedldProcgStrtDteTme,
  afvg.OpLtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  afvg.OpLtstSchedldTrdwnStrtTme AS OpLtstSchedldTrdwnStrtTme,
  afvg.OpLtstSchedldTrdwnStrtDteTme AS OpLtstSchedldTrdwnStrtDteTme,
  afvg.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  afvg.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  afvg.OpLtstSchedldExecEndDteTme AS OpLtstSchedldExecEndDteTme,
  afvg.OperationConfirmedStartDate AS OperationConfirmedStartDate,
  afvg.OperationConfirmedEndDate AS OperationConfirmedEndDate,
  afvg.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  afvg.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  afvg.OpActualExecutionStartDateTime AS OpActualExecutionStartDateTime,
  afvg.OpActualSetupEndDate AS OpActualSetupEndDate,
  afvg.OpActualSetupEndTime AS OpActualSetupEndTime,
  afvg.OpActualSetupEndDateTime AS OpActualSetupEndDateTime,
  afvg.OpActualProcessingStartDate AS OpActualProcessingStartDate,
  afvg.OpActualProcessingStartTime AS OpActualProcessingStartTime,
  afvg.OpActualProcessingStartDteTme AS OpActualProcessingStartDteTme,
  afvg.OpActualProcessingEndDate AS OpActualProcessingEndDate,
  afvg.OpActualProcessingEndTime AS OpActualProcessingEndTime,
  afvg.OpActualProcessingEndDateTime AS OpActualProcessingEndDateTime,
  afvg.OpActualTeardownStartDate AS OpActualTeardownStartDate,
  afvg.OpActualTeardownStartTme AS OpActualTeardownStartTme,
  afvg.OpActualTeardownStartDateTime AS OpActualTeardownStartDateTime,
  afvg.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  afvg.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  afvg.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  afvg.StartDateOffsetReferenceCode AS StartDateOffsetReferenceCode,
  afvg.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  afvg.StartDateOffsetDuration AS StartDateOffsetDuration,
  afvg.EndDateOffsetReferenceCode AS EndDateOffsetReferenceCode,
  afvg.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  afvg.EndDateOffsetDuration AS EndDateOffsetDuration,
  afvg.OperationUnit AS OperationUnit,
  afvg.OperationScrapPercent AS OperationScrapPercent,
  afvg.OperationReferenceQuantity AS OperationReferenceQuantity,
  afvg.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  afvg.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  (afvg.OpPlannedTotalQuantity - afvg.OpPlannedScrapQuantity) AS OpPlannedYieldQuantity,
  afvg.OpTotalConfirmedYieldQty AS OpTotalConfirmedYieldQty,
  afvg.OpTotalConfirmedScrapQty AS OpTotalConfirmedScrapQty,
  afvg.OperationConfirmedReworkQty AS OperationConfirmedReworkQty,
  afvg.SetupOpActyNtwkInstance AS SetupOpActyNtwkInstance,
  afvg.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  afvg.TeardownOpActyNtwkInstance AS TeardownOpActyNtwkInstance
FROM I_OrderOperationDateTime AS afvg
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
;

Learn More