P_SFONonTraceableComponent

DDL: P_SFONONTRACEABLECOMPONENT Type: view_entity CONSUMPTION

P_SFONonTraceableComponent is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_OpActyComponentAssignment) and exposes 23 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_OpActyComponentAssignment OpActyComponentAssignment from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (23)

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
ComponentAssemblyType I_OpActyComponentAssignment ComponentAssemblyType
RelatedReservation I_OpActyComponentAssignment RelatedReservation
RelatedReservationItem I_OpActyComponentAssignment RelatedReservationItem
RelatedRecordType I_OpActyComponentAssignment RelatedRecordType
RelatedOpActyNtwkInstance I_OpActyComponentAssignment RelatedOpActyNtwkInstance
RelatedOpActyNtwkElement I_OpActyComponentAssignment RelatedOpActyNtwkElement
LeadingReservation I_OpActyComponentAssignment LeadingReservation
LeadingReservationItem I_OpActyComponentAssignment LeadingReservationItem
LeadingReservationRecordType I_OpActyComponentAssignment LeadingReservationRecordType
LeadingOpActyNtwkInstance I_OpActyComponentAssignment LeadingOpActyNtwkInstance
LeadingOpActyNtwkElement I_OpActyComponentAssignment LeadingOpActyNtwkElement
IsBulkMaterialComponent OrderComponentBasic IsBulkMaterialComponent
MatlCompIsMarkedForBackflush OrderComponentBasic MatlCompIsMarkedForBackflush
VariableSizeComponentQuantity OrderComponentBasic VariableSizeComponentQuantity
VariableSizeComponentUnit OrderComponentBasic VariableSizeComponentUnit
MaterialBaseUnit OrderComponentBasic BaseUnit
_OpActyNtwkInstance I_OpActyComponentAssignment _OpActyNtwkInstance
_OperationActivityInstance I_OpActyComponentAssignment _OperationActivityInstance 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_SFONonTraceableComponent
  as select from      I_OpActyComponentAssignment as OpActyComponentAssignment
    inner to one join P_OpActyConfirmationAgg     as OpActyConfirmationAgg on  OpActyConfirmationAgg.OpActyNtwkInstance = OpActyComponentAssignment.OpActyNtwkInstance
                                                                           and OpActyConfirmationAgg.OpActyNtwkElement  = OpActyComponentAssignment.OpActyNtwkElement
    inner to one join I_OrderComponentBasic       as OrderComponentBasic   on  OrderComponentBasic.Reservation     = OpActyComponentAssignment.Reservation
                                                                           and OrderComponentBasic.ReservationItem = OpActyComponentAssignment.ReservationItem
                                                                           and OrderComponentBasic.RecordType      = OpActyComponentAssignment.RecordType

{
  key OpActyComponentAssignment.OpActyNtwkInstance                                                      as OpActyNtwkInstance,
  key OpActyComponentAssignment.OpActyNtwkElement                                                       as OpActyNtwkElement,
  key OpActyComponentAssignment.Reservation                                                             as Reservation,
  key OpActyComponentAssignment.ReservationItem                                                         as ReservationItem,
  key OpActyComponentAssignment.RecordType                                                              as RecordType,

      OpActyComponentAssignment.ComponentAssemblyType                                                   as ComponentAssemblyType,
      OpActyComponentAssignment.RelatedReservation                                                      as RelatedReservation,
      OpActyComponentAssignment.RelatedReservationItem                                                  as RelatedReservationItem,
      OpActyComponentAssignment.RelatedRecordType                                                       as RelatedRecordType,
      OpActyComponentAssignment.RelatedOpActyNtwkInstance                                               as RelatedOpActyNtwkInstance,
      OpActyComponentAssignment.RelatedOpActyNtwkElement                                                as RelatedOpActyNtwkElement,
      OpActyComponentAssignment.LeadingReservation                                                      as LeadingReservation,
      OpActyComponentAssignment.LeadingReservationItem                                                  as LeadingReservationItem,
      OpActyComponentAssignment.LeadingReservationRecordType                                            as LeadingReservationRecordType,
      OpActyComponentAssignment.LeadingOpActyNtwkInstance                                               as LeadingOpActyNtwkInstance,
      OpActyComponentAssignment.LeadingOpActyNtwkElement                                                as LeadingOpActyNtwkElement,

      OrderComponentBasic.IsBulkMaterialComponent                                                       as IsBulkMaterialComponent,
      OrderComponentBasic.MatlCompIsMarkedForBackflush                                                  as MatlCompIsMarkedForBackflush,
      -- Variable-Size Item Fields
      OrderComponentBasic.MaterialCompIsVariableSized                                                   as MaterialCompIsVariableSized,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      OrderComponentBasic.VariableSizeComponentQuantity                                                 as VariableSizeComponentQuantity,
      OrderComponentBasic.VariableSizeComponentUnit                                                     as VariableSizeComponentUnit,

      -- Quantities
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      OpActyConfirmationAgg.ConfirmationYieldQuantity + OpActyConfirmationAgg.ConfirmationScrapQuantity as OpActyProcessedQuantity,
      -- Add any Unit just to prevent superfluous jons --> All Units must be recalculated in parent views
      cast('PU' as ru_vorme )                                                                           as ProductionUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(round(fltp_to_dec(OpActyComponentAssignment.MfgOrderComponentUsageNetQty   as abap.dec(13,4) ), 3)
        as mpe_usage_qty )                                                                              as MfgOrderComponentUsageNetQty,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(round(fltp_to_dec(OpActyComponentAssignment.MfgOrderComponentUsageQuantity   as abap.dec(13,4) ), 3)
        as mpe_usage_qty )                                                                              as MfgOrderComponentUsageQuantity,
      OrderComponentBasic.BaseUnit                                                                      as MaterialBaseUnit,

      OpActyComponentAssignment._OpActyNtwkInstance,
      OpActyComponentAssignment._OperationActivityInstance
}
where
     OrderComponentBasic.IsBulkMaterialComponent      = 'X'
  or OrderComponentBasic.MatlCompIsMarkedForBackflush = 'X'

Learn More