P_SFONonTrcblCompLdngResv

DDL: P_SFONONTRCBLCOMPLDNGRESV Type: view_entity CONSUMPTION
42 Fields 1 Data Sources 1 Associations

P_SFONonTrcblCompLdngResv is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SFONonTraceableComponent2) and exposes 42 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SFONonTraceableComponent2 SFONonTraceableComponent from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OpActyInstceNtwkElmntBasic _LdngOpActyInstceNtwkElmntBsc $projection.LeadingOpActyNtwkInstance = _LdngOpActyInstceNtwkElmntBsc.OpActyNtwkInstance and $projection.LeadingOpActyNtwkElement = _LdngOpActyInstceNtwkElmntBsc.OpActyNtwkElement

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true 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 (42)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_SFONonTraceableComponent2 Reservation Reservation
KEY ReservationItem P_SFONonTraceableComponent2 ReservationItem Reservation Item
KEY RecordType P_SFONonTraceableComponent2 RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SFONonTraceableComponent2 OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFONonTraceableComponent2 OpActyNtwkElement Element Number
LeadingReservation P_SFONonTraceableComponent2 Reservation
LeadingReservationItem P_SFONonTraceableComponent2 ReservationItem
LeadingReservationRecordType P_SFONonTraceableComponent2 RecordType
LeadingOpActyNtwkInstance P_SFONonTraceableComponent2 OpActyNtwkInstance
LeadingOpActyNtwkElement P_SFONonTraceableComponent2 OpActyNtwkElement
MatlCompIsMarkedForBackflush P_SFONonTraceableComponent2 MatlCompIsMarkedForBackflush Backflush
IsBulkMaterialComponent P_SFONonTraceableComponent2 IsBulkMaterialComponent Bulk material
ComponentAssemblyType P_SFONonTraceableComponent2 ComponentAssemblyType
MaterialBaseUnit
ReservationasReservation
KEY ReservationItem P_SFONonTraceableComponent2 ReservationItem Reservation Item
KEY RecordType P_SFONonTraceableComponent2 RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SFONonTraceableComponent2 OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFONonTraceableComponent2 OpActyNtwkElement Element Number
LeadingReservation P_SFONonTraceableComponent2 LeadingReservation
LeadingReservationItem P_SFONonTraceableComponent2 LeadingReservationItem
LeadingReservationRecordType P_SFONonTraceableComponent2 LeadingReservationRecordType
LeadingOpActyNtwkInstance P_SFONonTraceableComponent2 LeadingOpActyNtwkInstance
LeadingOpActyNtwkElement P_SFONonTraceableComponent2 LeadingOpActyNtwkElement
MatlCompIsMarkedForBackflush P_SFONonTraceableComponent2 MatlCompIsMarkedForBackflush Backflush
IsBulkMaterialComponent P_SFONonTraceableComponent2 IsBulkMaterialComponent Bulk material
ComponentAssemblyType P_SFONonTraceableComponent2 ComponentAssemblyType
MaterialBaseUnit
ReservationasReservation
KEY ReservationItem P_SFONonTraceableComponent2 ReservationItem Reservation Item
KEY RecordType P_SFONonTraceableComponent2 RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SFONonTraceableComponent2 OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFONonTraceableComponent2 OpActyNtwkElement Element Number
LeadingReservation P_SFONonTraceableComponent2 LeadingReservation
LeadingReservationItem P_SFONonTraceableComponent2 LeadingReservationItem
LeadingReservationRecordType P_SFONonTraceableComponent2 LeadingReservationRecordType
LeadingOpActyNtwkInstance P_SFONonTraceableComponent2 LeadingOpActyNtwkInstance
LeadingOpActyNtwkElement P_SFONonTraceableComponent2 LeadingOpActyNtwkElement
MatlCompIsMarkedForBackflush P_SFONonTraceableComponent2 MatlCompIsMarkedForBackflush Backflush
IsBulkMaterialComponent P_SFONonTraceableComponent2 IsBulkMaterialComponent Bulk material
ComponentAssemblyType P_SFONonTraceableComponent2 ComponentAssemblyType
MaterialBaseUnit

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_SFONonTrcblCompLdngResv.
-- 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_SFONonTrcblCompLdngResv AS
SELECT
  SFONonTraceableComponent.Reservation AS Reservation,
  SFONonTraceableComponent.ReservationItem AS ReservationItem,
  SFONonTraceableComponent.RecordType AS RecordType,
  SFONonTraceableComponent.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFONonTraceableComponent.OpActyNtwkElement AS OpActyNtwkElement,
  SFONonTraceableComponent.Reservation AS LeadingReservation,
  SFONonTraceableComponent.ReservationItem AS LeadingReservationItem,
  SFONonTraceableComponent.RecordType AS LeadingReservationRecordType,
  SFONonTraceableComponent.OpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  SFONonTraceableComponent.OpActyNtwkElement AS LeadingOpActyNtwkElement,
  SFONonTraceableComponent.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  SFONonTraceableComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  SFONonTraceableComponent.ComponentAssemblyType AS ComponentAssemblyType,
  cast(SFONonTraceableComponent.MaterialBaseUnit as meins preserving type ) AS MaterialBaseUnit
FROM P_SFONonTraceableComponent2 AS SFONonTraceableComponent
LEFT OUTER JOIN I_OpActyInstceNtwkElmntBasic AS _LdngOpActyInstceNtwkElmntBsc ON LeadingOpActyNtwkInstance = _LdngOpActyInstceNtwkElmntBsc.OpActyNtwkInstance AND LeadingOpActyNtwkElement = _LdngOpActyInstceNtwkElmntBsc.OpActyNtwkElement  -- association [0..1]
;

Learn More