P_ProcOrdMgmtOperationBasic

DDL: P_PROCORDMGMTOPERATIONBASIC SQL: PPROCORDOPBASIC Type: view COMPOSITE

P_ProcOrdMgmtOperationBasic is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OrderOperationBasic, I_MfgOrderBasic) and exposes 29 fields with key fields OrderInternalID, OrderOperationInternalID. It has 1 association to related views.

2 data source(s) 29 fields

Data Sources (2)

SourceAliasJoin Type
I_OrderOperationBasic afvc from
I_MfgOrderBasic aufv inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkCenter _WorkCenter $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPROCORDOPBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderOperationBasic OrderInternalID
KEY OrderOperationInternalID OrderOperationInternalID
ProcessOrder I_MfgOrderBasic ManufacturingOrder
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory
ProductionPlant I_MfgOrderBasic ProductionPlant
ProductionSupervisor I_MfgOrderBasic ProductionSupervisor
Sequence Sequence
Operation Operation
StandardTextInternalID StandardTextInternalID
OperationText OperationText
Language Language
BillOfOperationsSequence BillOfOperationsSequence
BillOfOperationsType I_OrderOperationBasic BillOfOperationsType
BillOfOperationsGroup I_OrderOperationBasic BillOfOperationsGroup
BillOfOperationsVariant I_OrderOperationBasic BillOfOperationsVariant
BOOOperationInternalID BOOOperationInternalID
BillOfOperationsVersion I_OrderOperationBasic BillOfOperationsVersion
SuperiorOperationInternalID SuperiorOperationInternalID
OperationControlProfile OperationControlProfile
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
WorkCenter _WorkCenter WorkCenter
WorkCenterText
Plant Plant
ObjectInternalID I_OrderOperationBasic ObjectInternalID
MfgOrderOperationIsPhase MfgOrderOperationIsPhase
_OrderInternalID _OrderInternalID
OrderIntBillOfOpItemOfPhase OrderIntBillOfOpItemOfPhase
_WorkCenter _WorkCenter 
@AbapCatalog.sqlViewName: 'PPROCORDOPBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Process Order operations basic view'

@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_ProcOrdMgmtOperationBasic
  as select from I_OrderOperationBasic as afvc
    inner join   I_MfgOrderBasic       as aufv on  afvc.OrderInternalID            = aufv.OrderInternalID
                                               and aufv.ManufacturingOrderCategory = '40'
  association [0..1] to I_WorkCenter as _WorkCenter on  $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                    and _WorkCenter.WorkCenterTypeCode   = 'A'
{
  key afvc.OrderInternalID,
  key OrderOperationInternalID,
      aufv.ManufacturingOrder as ProcessOrder,
      aufv.ManufacturingOrderCategory,
      aufv.ProductionPlant,
      aufv.ProductionSupervisor,
      Sequence,
      Operation,
      StandardTextInternalID,
      OperationText,
      Language,
      BillOfOperationsSequence,
      afvc.BillOfOperationsType,
      afvc.BillOfOperationsGroup,
      afvc.BillOfOperationsVariant,
      BOOOperationInternalID,
      afvc.BillOfOperationsVersion,
      SuperiorOperationInternalID,
      OperationControlProfile,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      _WorkCenter.WorkCenter,
      _WorkCenter._Text[1: Language=$session.system_language].WorkCenterText,
      Plant,
      afvc.ObjectInternalID,
      MfgOrderOperationIsPhase,
      _OrderInternalID,
      OrderIntBillOfOpItemOfPhase,
      _WorkCenter
}
where
      aufv.ManufacturingOrderCategory  = '40'
  and afvc.SuperiorOperationInternalID is initial //SuperiorOperationInternalID

  and afvc.Sequence                    = '000000'; //Sequence

Learn More