P_OpActyComponentAssignment

DDL: P_OPACTYCOMPONENTASSIGNMENT SQL: PMPEOACOMPASS Type: view CONSUMPTION

P_OpActyComponentAssignment is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_OpActyComponentAssignment, I_OpActyInstceNtwkElmntBasic) and exposes 14 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_OpActyComponentAssignment oaca from
I_OpActyInstceNtwkElmntBasic OpActyInstceNtwkElmntBasic inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOACOMPASS 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 #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (14)

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
MfgOrderComponentUsageQuantity I_OpActyComponentAssignment MfgOrderComponentUsageQuantity
MfgOrderComponentUsageNetQty I_OpActyComponentAssignment MfgOrderComponentUsageNetQty
AssemblySequenceNumber I_OpActyComponentAssignment AssemblySequenceNumber
BOOOpBOMItemInternalID I_OpActyComponentAssignment BOOOpBOMItemInternalID
OperationActivity I_OpActyInstceNtwkElmntBasic OperationActivity
OperationActyVersionCounter I_OpActyInstceNtwkElmntBasic OperationActyVersionCounter
_OpActyNtwkInstance I_OpActyComponentAssignment _OpActyNtwkInstance
_OperationActivityInstance I_OpActyComponentAssignment _OperationActivityInstance
_ReservationHeader I_OpActyComponentAssignment _ReservationHeader 
@AbapCatalog.sqlViewName: 'PMPEOACOMPASS'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #CUSTOMIZING}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_OpActyComponentAssignment
  as select from I_OpActyComponentAssignment  as oaca
    inner join   I_OpActyInstceNtwkElmntBasic as OpActyInstceNtwkElmntBasic on  oaca.OpActyNtwkInstance = OpActyInstceNtwkElmntBasic.OpActyNtwkInstance
                                                                            and oaca.OpActyNtwkElement  = OpActyInstceNtwkElmntBasic.OpActyNtwkElement
{
  key oaca.OpActyNtwkInstance,
  key oaca.OpActyNtwkElement,
  key oaca.Reservation,
  key oaca.ReservationItem,
  key oaca.RecordType,
      oaca.MfgOrderComponentUsageQuantity,
      oaca.MfgOrderComponentUsageNetQty,
      oaca.AssemblySequenceNumber,
      oaca.BOOOpBOMItemInternalID,
      OpActyInstceNtwkElmntBasic.OperationActivity,
      OpActyInstceNtwkElmntBasic.OperationActyVersionCounter,

      cast( OpActyInstceNtwkElmntBasic._OrderOperation.OpPlannedTotalQuantity * OpActyInstceNtwkElmntBasic._OrderOperation.OpQtyToBaseQtyNmrtr as esmng ) /
        cast( OpActyInstceNtwkElmntBasic._OrderOperation.OpQtyToBaseQtyDnmntr as esmng ) *
        oaca.MfgOrderComponentUsageNetQty as RequiredQuantity,

      oaca._OpActyNtwkInstance,
      oaca._OperationActivityInstance,
      oaca._ReservationHeader

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPACTYCOMPONENTASSIGNMENT",
"I_OPACTYINSTCENTWKELMNTBASIC",
"I_ORDEROPERATION"
],
"ASSOCIATED":
[
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_RESERVATIONDOCUMENTHEADER"
],
"BASE":
[
"I_OPACTYCOMPONENTASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More