P_ProcOrdCurOp

DDL: P_PROCORDCUROP SQL: PPROCORDCUROP Type: view COMPOSITE Package: VDM_PP_PROC_ORD_MNG

Process order current operation details

P_ProcOrdCurOp is a Composite CDS View that provides data about "Process order current operation details" in SAP S/4HANA. It reads from 1 data source (I_LogisticsOrder) and exposes 12 fields with key field ProcessOrder. It has 2 associations to related views. Part of development package VDM_PP_PROC_ORD_MNG.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_LogisticsOrder _ProcOrd from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_ProcOrdLatestOpAggr _ProcOrdLatestOp $projection.OrderInternalBillOfOperations = _ProcOrdLatestOp.MfgOrderInternalID and $projection.ProcessOrder = _ProcOrdLatestOp.ProcessOrder and $projection.ProductionPlant = _ProcOrdLatestOp.ProductionPlant and $projection.ProductionSupervisor = _ProcOrdLatestOp.ProductionSupervisor
[0..1] P_ProcOrdFirstOpAggr _ProcOrdFirstOp $projection.OrderInternalBillOfOperations = _ProcOrdFirstOp.MfgOrderInternalID and $projection.ProcessOrder = _ProcOrdFirstOp.ProcessOrder and $projection.ProductionPlant = _ProcOrdFirstOp.ProductionPlant and $projection.ProductionSupervisor = _ProcOrdFirstOp.ProductionSupervisor

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPROCORDCUROP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProcessOrder OrderID
OrderInternalBillOfOperations OrderInternalBillOfOperations
ManufacturingOrderCategory I_LogisticsOrder OrderCategory
ProductionPlant I_LogisticsOrder Plant
ProductionSupervisor I_LogisticsOrder ProductionSupervisor
BillOfOperationsGroup I_LogisticsOrder BillOfOperations
BillOfOperationsType I_LogisticsOrder BillOfOperationsType
BillOfOperationsVariant I_LogisticsOrder BillOfOperationsVariant
LatestOperationendasCurOperation
_OrderCategory _OrderCategory
_Plant _Plant
_ProductionSupervisor _ProductionSupervisor 
@AbapCatalog.sqlViewName: 'PPROCORDCUROP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Process order current operation details'

define view P_ProcOrdCurOp
  as select from I_LogisticsOrder as _ProcOrd
  association [0..1] to P_ProcOrdLatestOpAggr as _ProcOrdLatestOp on  $projection.OrderInternalBillOfOperations = _ProcOrdLatestOp.MfgOrderInternalID
                                                                  and $projection.ProcessOrder                  = _ProcOrdLatestOp.ProcessOrder
                                                                  and $projection.ProductionPlant               = _ProcOrdLatestOp.ProductionPlant
                                                                  and $projection.ProductionSupervisor          = _ProcOrdLatestOp.ProductionSupervisor

  //  association [0..1] to P_ProcOrdCurOpBasedOnRelshp  as _ProcOrdCurOpRel  on  $projection.OrderInternalBillOfOperations = _ProcOrdCurOpRel.OrderInternalBillOfOperations

  //                                                                          and $projection.ProcessOrder                  = _ProcOrdCurOpRel.ProcessOrder

  //                                                                          and $projection.ProductionPlant               = _ProcOrdCurOpRel.ProductionPlant

  //                                                                          and $projection.ProductionSupervisor          = _ProcOrdCurOpRel.ProductionSupervisor

  //

  //  association [0..1] to P_ProcOrdConfdOpCurOpRelshnp as _ProcOrdConfCurOp on  $projection.OrderInternalBillOfOperations = _ProcOrdConfCurOp.OrderInternalBillOfOperations

  //                                                                          and $projection.ProcessOrder                  = _ProcOrdConfCurOp.ProcessOrder

  //                                                                          and $projection.ProductionPlant               = _ProcOrdConfCurOp.ProductionPlant

  //                                                                          and $projection.ProductionSupervisor          = _ProcOrdConfCurOp.ProductionSupervisor


  association [0..1] to P_ProcOrdFirstOpAggr  as _ProcOrdFirstOp  on  $projection.OrderInternalBillOfOperations = _ProcOrdFirstOp.MfgOrderInternalID
                                                                  and $projection.ProcessOrder                  = _ProcOrdFirstOp.ProcessOrder
                                                                  and $projection.ProductionPlant               = _ProcOrdFirstOp.ProductionPlant
                                                                  and $projection.ProductionSupervisor          = _ProcOrdFirstOp.ProductionSupervisor
{
  key OrderID                   as ProcessOrder,
      OrderInternalBillOfOperations,

      _ProcOrd.OrderCategory    as ManufacturingOrderCategory,
      _ProcOrd.Plant            as ProductionPlant,
      _ProcOrd.ProductionSupervisor,

      _ProcOrd.BillOfOperations as BillOfOperationsGroup,
      _ProcOrd.BillOfOperationsType,
      _ProcOrd.BillOfOperationsVariant,

      //      case when _ProcOrdLatestOp.LatestOperation is not null

      //        then _ProcOrdLatestOp.LatestOperation

      //        when _ProcOrdConfCurOp.CurOperation is not null

      //        then _ProcOrdConfCurOp.CurOperation

      //        when _ProcOrdCurOpRel.CurOperation is not null

      //        then _ProcOrdCurOpRel.CurOperation

      //        else _ProcOrdFirstOp.FirstOperation

      //      end                       as CurOperation,


      case when _ProcOrdLatestOp.LatestOperation is null
             then _ProcOrdFirstOp.FirstOperation
            else _ProcOrdLatestOp.LatestOperation
            end                 as CurOperation,


      _OrderCategory,
      _Plant,
      _ProductionSupervisor
}

where
  OrderCategory = '40';

Learn More