P_OpActyComponentAssignmentDMU

DDL: P_OPACTYCOMPONENTASSIGNMENTDMU SQL: PMPECOMPDMUA Type: view COMPOSITE Package: MPE_EXEC_COMMON

Operation Activity Instance Component Assignment for DMU

P_OpActyComponentAssignmentDMU is a Composite CDS View that provides data about "Operation Activity Instance Component Assignment for DMU" in SAP S/4HANA. It reads from 2 data sources (I_OpActyComponentAssignment, I_MfgOrderOperationComponent) and exposes 20 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType. Part of development package MPE_EXEC_COMMON.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_OpActyComponentAssignment comp from
I_MfgOrderOperationComponent resb inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPDMUA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyComponentAssignment OpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyComponentAssignment OpActyNtwkElement
KEY Reservation I_OpActyComponentAssignment Reservation
KEY ReservationItem I_OpActyComponentAssignment ReservationItem
KEY RecordType I_OpActyComponentAssignment RecordType
MaterialComponent I_MfgOrderOperationComponent Material
ProductionPlant I_MfgOrderOperationComponent Plant
StorageLocation I_MfgOrderOperationComponent StorageLocation
MfgOrderComponentUsageQuantity I_OpActyComponentAssignment MfgOrderComponentUsageQuantity
MfgOrderComponentUsageNetQty I_OpActyComponentAssignment MfgOrderComponentUsageNetQty
AssemblySequenceNumber I_OpActyComponentAssignment AssemblySequenceNumber
MatlCompIsMarkedForBackflush I_MfgOrderOperationComponent MatlCompIsMarkedForBackflush
BillOfMaterialItemUUID stpo BillOfMaterialItemUUID
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ReservationHeader _ReservationHeader
_Material _Material
_MaterialPlant
_Plant _Plant
_StorageLocation _StorageLocation 
@AbapCatalog.sqlViewName: 'PMPECOMPDMUA'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_OpActyComponentAssignmentDMU
  as select from           I_OpActyComponentAssignment  as comp
    inner join             I_MfgOrderOperationComponent as resb on  comp.Reservation     = resb.Reservation
                                                                and comp.ReservationItem = resb.ReservationItem
                                                                and comp.RecordType      = resb.RecordType
    left outer to one join I_BillOfMaterialItemBasic    as stpo on  resb.BillOfMaterialCategory     = stpo.BillOfMaterialCategory
                                                                and resb.BillOfMaterialInternalID   = stpo.BillOfMaterial
                                                                and resb.BOMItem                    = stpo.BillOfMaterialItemNodeNumber
                                                                and resb.BOMItemInternalChangeCount = stpo.BOMItemInternalChangeCount
{
  key comp.OpActyNtwkInstance             as  OpActyNtwkInstance,
  key comp.OpActyNtwkElement              as  OpActyNtwkElement,
  key comp.Reservation                    as  Reservation,
  key comp.ReservationItem                as  ReservationItem,
  key comp.RecordType                     as  RecordType,
      resb.Material                       as  MaterialComponent,
      resb.Plant                          as  ProductionPlant,
      resb.StorageLocation                as  StorageLocation,
      comp.MfgOrderComponentUsageQuantity as  MfgOrderComponentUsageQuantity,
      comp.MfgOrderComponentUsageNetQty   as  MfgOrderComponentUsageNetQty,
      comp.AssemblySequenceNumber         as  AssemblySequenceNumber,
      resb.MatlCompIsMarkedForBackflush   as  MatlCompIsMarkedForBackflush,
      stpo.BillOfMaterialItemUUID         as  BillOfMaterialItemUUID,

      _OpActyNtwkInstance,
      _OperationActivityInstance,
      _ReservationHeader,
      _Material,
      --    _MaterialPlant,
      _Plant,
      _StorageLocation

}

Learn More