I_ProcOrdMgmtOpBasic

DDL: I_PROCORDMGMTOPBASIC SQL: IPROORMGMTOPBSC Type: view BASIC
44 Fields 1 Data Sources 2 Associations

Process order operation afvg

I_ProcOrdMgmtOpBasic is a Basic CDS View that provides data about "Process order operation afvg" in SAP S/4HANA. It reads from 1 data source (P_ProcOrdMgmtOpBasic) and exposes 44 fields with key fields OrderInternalID, OrderOperationInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProcOrdMgmtOpBasic afvg from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_OrderInternalID _OrderInternalID $projection.OrderInternalID = _OrderInternalID.OrderInternalID
[1..1] I_UnitOfMeasure _OperationUnit $projection.OperationUnit = _OperationUnit.UnitOfMeasure

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPROORMGMTOPBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Process order operation afvg view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID P_ProcOrdMgmtOpBasic aufpl TaskList No.Ops
KEY OrderOperationInternalID P_ProcOrdMgmtOpBasic aplzl Plan No.f.Oper.
ProcessOrder ProcessOrder Order
ManufacturingOrderCategory ManufacturingOrderCategory Order Category
ProductionPlant ProductionPlant Prod plnt
ProductionSupervisor ProductionSupervisor Prodn Supervisor
Sequence P_ProcOrdMgmtOpBasic aplfl Sequence
Operation P_ProcOrdMgmtOpBasic vornr Operation
BillOfOperationsSequence P_ProcOrdMgmtOpBasic plnfl Sequence
BillOfOperationsType P_ProcOrdMgmtOpBasic plnty Task List Type
BillOfOperationsGroup P_ProcOrdMgmtOpBasic plnnr Task List Group
BillOfOperationsVariant P_ProcOrdMgmtOpBasic plnal Referenced BOO Variant
BOOOperationInternalID P_ProcOrdMgmtOpBasic plnkn Task list node
BillOfOperationsVersion P_ProcOrdMgmtOpBasic tl_versn Routing Version
BillOfMaterialCategory P_ProcOrdMgmtOpBasic istty BOM category
BillOfMaterialInternalID P_ProcOrdMgmtOpBasic istnr BOM
BillOfMaterialItemNodeNumber P_ProcOrdMgmtOpBasic istkn Item node
BOMItemNodeCount P_ProcOrdMgmtOpBasic istpo Counter
SuperiorOperationInternalID P_ProcOrdMgmtOpBasic sumnr Sup. Op. Node
WorkCenterInternalID P_ProcOrdMgmtOpBasic arbid WorkCtrGp plan.
Plant P_ProcOrdMgmtOpBasic werks Receiving Plant
ObjectInternalID P_ProcOrdMgmtOpBasic objnr Val. Obj. No.
OperationText P_ProcOrdMgmtOpBasic ltxa1 Short Text
Language P_ProcOrdMgmtOpBasic txtsp Language
OrderIntBillOfOpItemOfPhase P_ProcOrdMgmtOpBasic pvzkn Node
MfgOrderOperationIsPhase P_ProcOrdMgmtOpBasic phflg Ind.: Phase
OperationUnit P_ProcOrdMgmtOpBasic meinh Unit of Measure
OpPlannedTotalQuantity P_ProcOrdMgmtOpBasic mgvrg Operation Qty
OpPlannedScrapQuantity P_ProcOrdMgmtOpBasic asvrg Planned Scrap
OpTotalConfirmedYieldQty P_ProcOrdMgmtOpBasic lmnga Yield Quantity
OpTotalConfirmedScrapQty P_ProcOrdMgmtOpBasic xmnga Scrap Quantity
OpPlannedYieldQuantity OpPlannedYieldQuantity
OpErlstSchedldExecEndDte P_ProcOrdMgmtOpBasic fsedd EarliestEndDate
OpErlstSchedldExecEndTme P_ProcOrdMgmtOpBasic fsedz Earliest finish
OpLtstSchedldExecStrtDte P_ProcOrdMgmtOpBasic ssavd Latest start
OpLtstSchedldExecStrtTme P_ProcOrdMgmtOpBasic ssavz Lat. start time
OpLtstSchedldExecEndDte P_ProcOrdMgmtOpBasic ssedd Lat.finish date
OpLtstSchedldExecEndTme P_ProcOrdMgmtOpBasic ssedz Latest fin.time
OpActualExecutionStartDate P_ProcOrdMgmtOpBasic isdd Start Execution
OpActualExecutionStartTime P_ProcOrdMgmtOpBasic isdz Execution Start Time
OpActualExecutionEndDate P_ProcOrdMgmtOpBasic iedd Finish Execut.
OpActualExecutionEndTime P_ProcOrdMgmtOpBasic iedz Execution End Time
_OrderInternalID _OrderInternalID
_OperationUnit _OperationUnit

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 I_ProcOrdMgmtOpBasic.
-- 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: IPROORMGMTOPBSC

CREATE VIEW I_ProcOrdMgmtOpBasic AS
SELECT
  afvg.aufpl AS OrderInternalID,
  afvg.aplzl AS OrderOperationInternalID,
  ProcessOrder,
  ManufacturingOrderCategory,
  ProductionPlant,
  ProductionSupervisor,
  afvg.aplfl AS Sequence,
  afvg.vornr AS Operation,
  afvg.plnfl AS BillOfOperationsSequence,
  afvg.plnty AS BillOfOperationsType,
  afvg.plnnr AS BillOfOperationsGroup,
  afvg.plnal AS BillOfOperationsVariant,
  afvg.plnkn AS BOOOperationInternalID,
  afvg.tl_versn AS BillOfOperationsVersion,
  afvg.istty AS BillOfMaterialCategory,
  afvg.istnr AS BillOfMaterialInternalID,
  afvg.istkn AS BillOfMaterialItemNodeNumber,
  afvg.istpo AS BOMItemNodeCount,
  afvg.sumnr AS SuperiorOperationInternalID,
  afvg.arbid AS WorkCenterInternalID,
  afvg.werks AS Plant,
  afvg.objnr AS ObjectInternalID,
  afvg.ltxa1 AS OperationText,
  afvg.txtsp AS Language,
  afvg.pvzkn AS OrderIntBillOfOpItemOfPhase,
  afvg.phflg AS MfgOrderOperationIsPhase,
  afvg.meinh AS OperationUnit,
  afvg.mgvrg AS OpPlannedTotalQuantity,
  afvg.asvrg AS OpPlannedScrapQuantity,
  afvg.lmnga AS OpTotalConfirmedYieldQty,
  afvg.xmnga AS OpTotalConfirmedScrapQty,
  OpPlannedYieldQuantity,
  afvg.fsedd AS OpErlstSchedldExecEndDte,
  afvg.fsedz AS OpErlstSchedldExecEndTme,
  afvg.ssavd AS OpLtstSchedldExecStrtDte,
  afvg.ssavz AS OpLtstSchedldExecStrtTme,
  afvg.ssedd AS OpLtstSchedldExecEndDte,
  afvg.ssedz AS OpLtstSchedldExecEndTme,
  afvg.isdd AS OpActualExecutionStartDate,
  afvg.isdz AS OpActualExecutionStartTime,
  afvg.iedd AS OpActualExecutionEndDate,
  afvg.iedz AS OpActualExecutionEndTime
FROM P_ProcOrdMgmtOpBasic AS afvg
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationUnit ON OperationUnit = _OperationUnit.UnitOfMeasure  -- association [1..1]
;

Learn More