I_MfgOrderOperationPickList

DDL: I_MFGORDEROPERATIONPICKLIST SQL: IPPMOROPPICKLIST Type: view COMPOSITE
9 Fields 2 Data Sources 2 Associations

Mfg Order Operation (Pick List)

I_MfgOrderOperationPickList is a Composite CDS View that provides data about "Mfg Order Operation (Pick List)" in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperationBasic, I_OrderOperationStatus) and exposes 9 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationBasic MfgOrderOperation from
I_OrderOperationStatus OperationStatus inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ManufacturingOrderOperation _ManufacturingOrderOperation $projection.OrderInternalBillOfOperations = _ManufacturingOrderOperation.MfgOrderInternalID and $projection.OrderIntBillOfOperationsItem = _ManufacturingOrderOperation.OrderOperationInternalID
[1..1] E_OrderOperation _Extension $projection.OrderInternalBillOfOperations = _Extension.OrderInternalID and $projection.OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMOROPPICKLIST view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Mfg Order Operation (Pick List) view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_MfgOrderOperationBasic OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationBasic OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ManufacturingOrderOperation I_MfgOrderOperationBasic ManufacturingOrderOperation Activity
ManufacturingOrder I_MfgOrderOperationBasic ManufacturingOrder Order
ManufacturingOrderSequence I_MfgOrderOperationBasic ManufacturingOrderSequence Visit Sequence
ManufacturingOrderCategory I_MfgOrderOperationBasic ManufacturingOrderCategory
MfgOrderOperationIsPhase I_MfgOrderOperationBasic MfgOrderOperationIsPhase
MfgOrderOperationText I_MfgOrderOperationBasic MfgOrderOperationText Description
_ManufacturingOrderOperation _ManufacturingOrderOperation

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_MfgOrderOperationPickList.
-- 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: IPPMOROPPICKLIST

CREATE VIEW I_MfgOrderOperationPickList AS
SELECT
  MfgOrderOperation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderOperation.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  MfgOrderOperation.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  MfgOrderOperation.ManufacturingOrder AS ManufacturingOrder,
  MfgOrderOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  MfgOrderOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrderOperation.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  MfgOrderOperation.MfgOrderOperationText AS MfgOrderOperationText
FROM I_MfgOrderOperationBasic AS MfgOrderOperation
INNER JOIN I_OrderOperationStatus AS OperationStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _ManufacturingOrderOperation ON OrderInternalBillOfOperations = _ManufacturingOrderOperation.MfgOrderInternalID AND OrderIntBillOfOperationsItem = _ManufacturingOrderOperation.OrderOperationInternalID  -- association [1..1]
LEFT OUTER JOIN E_OrderOperation AS _Extension ON OrderInternalBillOfOperations = _Extension.OrderInternalID AND OrderIntBillOfOperationsItem = _Extension.OrderOperationInternalID  -- association [1..1]
;

Learn More