I_ProductionOrderOperation

DDL: I_PRODUCTIONORDEROPERATION SQL: IFIPRODNORDOPER Type: view BASIC
9 Fields 2 Data Sources 1 Associations

Interface View for Production Order Operation

I_ProductionOrderOperation is a Basic CDS View (Dimension) that provides data about "Interface View for Production Order Operation" in SAP S/4HANA. It reads from 2 data sources (afko, afvc) and exposes 9 fields with key fields OrderID, OrderOperation. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
afko afko inner
afvc afvc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductCostCtrlgOrder _CtrlgOrder $projection.OrderID = _CtrlgOrder.OrderID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIPRODNORDOPER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey OrderOperation view
EndUserText.label Interface View for Production Order Operation view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderID afko aufnr SettlementOrder
KEY OrderOperation afvc vornr Operation
Sequence afvc aplfl Sequence
OrderType _CtrlgOrder OrderType Order Type
OrderCategory _CtrlgOrder OrderCategory Order Category
Plant _CtrlgOrder Plant Valuation Area
OperationDescription afvc ltxa1 Short Text
Language
_CtrlgOrder _CtrlgOrder

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_ProductionOrderOperation.
-- 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: IFIPRODNORDOPER

CREATE VIEW I_ProductionOrderOperation AS
SELECT
  afko.aufnr AS OrderID,
  afvc.vornr AS OrderOperation,
  afvc.aplfl AS Sequence,
  _CtrlgOrder.OrderType AS OrderType,
  _CtrlgOrder.OrderCategory AS OrderCategory,
  _CtrlgOrder.Plant AS Plant,
  afvc.ltxa1 AS OperationDescription,
  cast(afvc.txtsp as spras) AS Language
FROM afvc
INNER JOIN afko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS _CtrlgOrder ON OrderID = _CtrlgOrder.OrderID  -- association [0..1]
;

Learn More