P_MfgOrderCompInstceAssyQty

DDL: P_MFGORDERCOMPINSTCEASSYQTY SQL: PMPECOMPASSINSTQ Type: view COMPOSITE

P_MfgOrderCompInstceAssyQty is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_MfgOrderComponentAssembly, I_OpActyCompInstceAssignment, I_OpActyComponentAssignment, I_ReservationItem) and exposes 19 fields with key fields AssemblyDocument, AssemblyDocumentItem. It has 1 association to related views.

4 data source(s) 19 fields

Data Sources (4)

SourceAliasJoin Type
I_MfgOrderComponentAssembly MfgOrderComponentAssembly inner
I_OpActyCompInstceAssignment OpActyCompInstceAssignment inner
I_OpActyComponentAssignment OpActyComponentAssignment inner
I_ReservationItem ReservationItem inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MfgOrder _MfgOrder $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPASSINSTQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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 (19)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument MfgOrderCompInstceAssembly AssemblyDocument
KEY AssemblyDocumentItem MfgOrderCompInstceAssembly AssemblyDocumentItem
ManufacturingOrder I_ReservationItem ReferenceOrder
Reservation I_MfgOrderComponentAssembly Reservation
ReservationItem I_MfgOrderComponentAssembly ReservationItem
RecordType I_MfgOrderComponentAssembly RecordType
AssemblyShopFloorItem I_MfgOrderComponentAssembly AssemblyShopFloorItem
OpActyNtwkInstance I_MfgOrderComponentAssembly OpActyNtwkInstance
OpActyNtwkElement I_MfgOrderComponentAssembly OpActyNtwkElement
OriglDgtlMockUpCharcsUUID MfgOrderCompInstceAssembly OriglDgtlMockUpCharcsUUID
DgtlMockUpCharcsUUID I_OpActyCompInstceAssignment DgtlMockUpCharcsUUID
DebitCreditCode I_ReservationItem DebitCreditCode
_MfgOrder _MfgOrder
_Reservation I_MfgOrderComponentAssembly _Reservation
_ParentShopFloorItem I_MfgOrderComponentAssembly _ParentShopFloorItem
_OpActyNtwkInstance I_MfgOrderComponentAssembly _OpActyNtwkInstance
_OperationActivityInstance I_MfgOrderComponentAssembly _OperationActivityInstance
_DigitalMockUpCharcs I_OpActyCompInstceAssignment _DigitalMockUpCharcs
_DebitCreditCode I_ReservationItem _DebitCreditCode 
@AbapCatalog.sqlViewName: 'PMPECOMPASSINSTQ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@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_MfgOrderCompInstceAssyQty
  as select distinct from I_MfgOrderCompInstceAssembly as MfgOrderCompInstceAssembly
    inner join            I_MfgOrderComponentAssembly  as MfgOrderComponentAssembly  on  MfgOrderComponentAssembly.AssemblyDocument     = MfgOrderCompInstceAssembly.AssemblyDocument
                                                                                     and MfgOrderComponentAssembly.AssemblyDocumentItem = MfgOrderCompInstceAssembly.AssemblyDocumentItem
    inner join            I_OpActyComponentAssignment  as OpActyComponentAssignment  on  OpActyComponentAssignment.Reservation        = MfgOrderComponentAssembly.Reservation
                                                                                     and OpActyComponentAssignment.ReservationItem    = MfgOrderComponentAssembly.ReservationItem
                                                                                     and OpActyComponentAssignment.RecordType         = MfgOrderComponentAssembly.RecordType
                                                                                     and OpActyComponentAssignment.OpActyNtwkInstance = MfgOrderComponentAssembly.OpActyNtwkInstance
                                                                                     and OpActyComponentAssignment.OpActyNtwkElement  = MfgOrderComponentAssembly.OpActyNtwkElement
    inner join            I_OpActyCompInstceAssignment as OpActyCompInstceAssignment on  OpActyCompInstceAssignment.Reservation               = MfgOrderComponentAssembly.Reservation
                                                                                     and OpActyCompInstceAssignment.ReservationItem           = MfgOrderComponentAssembly.ReservationItem
                                                                                     and OpActyCompInstceAssignment.RecordType                = MfgOrderComponentAssembly.RecordType
                                                                                     and OpActyCompInstceAssignment.OpActyNtwkInstance        = MfgOrderComponentAssembly.OpActyNtwkInstance
                                                                                     and OpActyCompInstceAssignment.OpActyNtwkElement         = MfgOrderComponentAssembly.OpActyNtwkElement
                                                                                     and OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID = MfgOrderCompInstceAssembly.OriglDgtlMockUpCharcsUUID
    inner join            I_ReservationItem            as ReservationItem            on  ReservationItem.Reservation     = MfgOrderComponentAssembly.Reservation
                                                                                     and ReservationItem.ReservationItem = MfgOrderComponentAssembly.ReservationItem
                                                                                     and ReservationItem.RecordType      = MfgOrderComponentAssembly.RecordType

  association [1..1] to I_MfgOrder as _MfgOrder on $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
{
  key MfgOrderCompInstceAssembly.AssemblyDocument,
  key MfgOrderCompInstceAssembly.AssemblyDocumentItem,
      ReservationItem.ReferenceOrder as ManufacturingOrder,
      MfgOrderComponentAssembly.Reservation,
      MfgOrderComponentAssembly.ReservationItem,
      MfgOrderComponentAssembly.RecordType,
      MfgOrderComponentAssembly.AssemblyShopFloorItem,
      MfgOrderComponentAssembly.OpActyNtwkInstance,
      MfgOrderComponentAssembly.OpActyNtwkElement,
      MfgOrderCompInstceAssembly.OriglDgtlMockUpCharcsUUID,
      OpActyCompInstceAssignment.DgtlMockUpCharcsUUID,
      case ReservationItem.DebitCreditCode
        when 'S' then -1
        else 1
      end                            as MaterialComponentQuantity,
      ReservationItem.DebitCreditCode,

      _MfgOrder,
      MfgOrderComponentAssembly._Reservation,
      MfgOrderComponentAssembly._ParentShopFloorItem,
      MfgOrderComponentAssembly._OpActyNtwkInstance,
      MfgOrderComponentAssembly._OperationActivityInstance,
      OpActyCompInstceAssignment._DigitalMockUpCharcs,
      ReservationItem._DebitCreditCode
}
where
      ReservationItem.MatlCompIsMarkedForBackflush           = ''
  and OpActyComponentAssignment.MatlCompInstceAssyIsRequired = 'X'
  and MfgOrderCompInstceAssembly.IsReversal                  = ''
  and MfgOrderCompInstceAssembly.IsReversed                  = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERCOMPINSTCEASSEMBLY",
"I_MFGORDERCOMPONENTASSEMBLY",
"I_OPACTYCOMPINSTCEASSIGNMENT",
"I_OPACTYCOMPONENTASSIGNMENT",
"I_RESERVATIONITEM"
],
"ASSOCIATED":
[
"I_DEBITCREDITCODE",
"I_DIGITALMOCKUPCHARCS",
"I_MFGORDER",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_RESERVATIONDOCUMENTHEADER",
"I_SHOPFLOORITEM"
],
"BASE":
[
"I_MFGORDERCOMPONENTASSEMBLY",
"I_OPACTYCOMPINSTCEASSIGNMENT",
"I_RESERVATIONITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More