I_ProductionOrdOpBasic

DDL: I_PRODUCTIONORDOPBASIC Type: view_entity BASIC
43 Fields 1 Data Sources 1 Associations

Production Order Operation afvg

I_ProductionOrdOpBasic is a Basic CDS View that provides data about "Production Order Operation afvg" in SAP S/4HANA. It reads from 1 data source (P_ProdOrdMgmtOpBasic) and exposes 43 fields with key fields OrderInternalID, OrderOperationInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProdOrdMgmtOpBasic afvg from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OrderInternalID _OrderInternalID $projection.OrderInternalID = _OrderInternalID.OrderInternalID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Production Order Operation afvg 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 (43)

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

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_ProductionOrdOpBasic.
-- 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.

CREATE VIEW I_ProductionOrdOpBasic AS
SELECT
  afvg.aufpl AS OrderInternalID,
  afvg.aplzl AS OrderOperationInternalID,
  afvg.ManufacturingOrder AS ManufacturingOrder,
  afvg.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  afvg.ProductionPlant AS ProductionPlant,
  afvg.ProductionSupervisor AS 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,
  cast((afvg.mgvrg - afvg.asvrg) as vdm_gmeng) AS 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_ProdOrdMgmtOpBasic AS afvg
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
;

Learn More