I_MfgOrderOperationPickList

DDL: I_MFGORDEROPERATIONPICKLIST SQL: IPPMOROPPICKLIST Type: view COMPOSITE

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.

2 data source(s) 9 fields

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
KEY OrderIntBillOfOperationsItem I_MfgOrderOperationBasic OrderIntBillOfOperationsItem
ManufacturingOrderOperation I_MfgOrderOperationBasic ManufacturingOrderOperation
ManufacturingOrder I_MfgOrderOperationBasic ManufacturingOrder
ManufacturingOrderSequence I_MfgOrderOperationBasic ManufacturingOrderSequence
ManufacturingOrderCategory I_MfgOrderOperationBasic ManufacturingOrderCategory
MfgOrderOperationIsPhase I_MfgOrderOperationBasic MfgOrderOperationIsPhase
MfgOrderOperationText I_MfgOrderOperationBasic MfgOrderOperationText
_ManufacturingOrderOperation _ManufacturingOrderOperation 
@AbapCatalog.sqlViewName: 'IPPMOROPPICKLIST'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Mfg Order Operation (Pick List)'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE

define view I_MfgOrderOperationPickList
  as select from I_MfgOrderOperationBasic as MfgOrderOperation
    inner join   I_OrderOperationStatus   as OperationStatus on  MfgOrderOperation.OrderInternalBillOfOperations = OperationStatus.OrderInternalID
                                                             and MfgOrderOperation.OrderIntBillOfOperationsItem  = OperationStatus.OrderOperationInternalID

  association [1..1] to I_ManufacturingOrderOperation as _ManufacturingOrderOperation on  $projection.OrderInternalBillOfOperations = _ManufacturingOrderOperation.MfgOrderInternalID
                                                                                      and $projection.OrderIntBillOfOperationsItem  = _ManufacturingOrderOperation.OrderOperationInternalID
  association [1..1] to E_OrderOperation              as _Extension                   on  $projection.OrderInternalBillOfOperations = _Extension.OrderInternalID // Extensibility

                                                                                      and $projection.OrderIntBillOfOperationsItem  = _Extension.OrderOperationInternalID

{

      // internal key

  key MfgOrderOperation.OrderInternalBillOfOperations as OrderInternalBillOfOperations,
  key MfgOrderOperation.OrderIntBillOfOperationsItem  as OrderIntBillOfOperationsItem,

      // external key

      MfgOrderOperation.ManufacturingOrderOperation   as ManufacturingOrderOperation,
      MfgOrderOperation.ManufacturingOrder            as ManufacturingOrder,
      MfgOrderOperation.ManufacturingOrderSequence    as ManufacturingOrderSequence,

      // Category 10 = Production Order 40 = Process Order

      MfgOrderOperation.ManufacturingOrderCategory    as ManufacturingOrderCategory,
      MfgOrderOperation.MfgOrderOperationIsPhase      as MfgOrderOperationIsPhase,

      // text

      MfgOrderOperation.MfgOrderOperationText         as MfgOrderOperationText,

      _ManufacturingOrderOperation
}

where
      MfgOrderOperation.SuperiorOperationInternalID = '00000000'
  and OperationStatus.OperationIsDeleted            = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDEROPERATIONBASIC",
"I_ORDEROPERATIONSTATUS"
],
"ASSOCIATED":
[
"E_ORDEROPERATION",
"I_MANUFACTURINGORDEROPERATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More