P_SFONonTraceableComponent

DDL: P_SFONONTRACEABLECOMPONENT Type: view_entity CONSUMPTION
23 Fields 1 Data Sources

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.

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 Instance ID
KEY OpActyNtwkElement I_OpActyComponentAssignment OpActyNtwkElement Element Number
KEY Reservation I_OpActyComponentAssignment Reservation Reservation
KEY ReservationItem I_OpActyComponentAssignment ReservationItem Reservation Item
KEY RecordType I_OpActyComponentAssignment RecordType Reservation Record Type
ComponentAssemblyType I_OpActyComponentAssignment ComponentAssemblyType Assembly Type
RelatedReservation I_OpActyComponentAssignment RelatedReservation Reservation
RelatedReservationItem I_OpActyComponentAssignment RelatedReservationItem Item no.
RelatedRecordType I_OpActyComponentAssignment RelatedRecordType Record type
RelatedOpActyNtwkInstance I_OpActyComponentAssignment RelatedOpActyNtwkInstance Instance ID
RelatedOpActyNtwkElement I_OpActyComponentAssignment RelatedOpActyNtwkElement Element Number
LeadingReservation I_OpActyComponentAssignment LeadingReservation Reservation
LeadingReservationItem I_OpActyComponentAssignment LeadingReservationItem Item no.
LeadingReservationRecordType I_OpActyComponentAssignment LeadingReservationRecordType Record type
LeadingOpActyNtwkInstance I_OpActyComponentAssignment LeadingOpActyNtwkInstance Instance ID
LeadingOpActyNtwkElement I_OpActyComponentAssignment LeadingOpActyNtwkElement Element Number
IsBulkMaterialComponent OrderComponentBasic IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush OrderComponentBasic MatlCompIsMarkedForBackflush Backflush
VariableSizeComponentQuantity OrderComponentBasic VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit OrderComponentBasic VariableSizeComponentUnit VSI UoM
MaterialBaseUnit OrderComponentBasic BaseUnit Unit of Measure
_OpActyNtwkInstance I_OpActyComponentAssignment _OpActyNtwkInstance
_OperationActivityInstance I_OpActyComponentAssignment _OperationActivityInstance

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SFONonTraceableComponent.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_SFONonTraceableComponent AS
SELECT
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyComponentAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyComponentAssignment.Reservation AS Reservation,
  OpActyComponentAssignment.ReservationItem AS ReservationItem,
  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,
  OrderComponentBasic.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OrderComponentBasic.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OrderComponentBasic.BaseUnit AS MaterialBaseUnit,
  OpActyComponentAssignment._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyComponentAssignment._OperationActivityInstance AS _OperationActivityInstance
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
;

Learn More