P_TraceQuickFilter

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_TraceQuickFilter.
-- 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.
-- SQL view name: PTRCQUICKFILTER

CREATE VIEW P_TraceQuickFilter AS
SELECT
  trace_guid,
  roundtrip_no,
  entry_no,
  parameter_no,
  coalesce( coalesce( _Instance.instance_id, _CsticResult.instance_id ), _CsVal.instance_id ) AS instance_id,
  _ClsNode.class_number AS class_number,
  _Routing.routing_text AS routing_text,
  _Routing.bill_of_operations_group AS routing_num,
  _RtgSeq.bill_of_operations_sequence AS sequence_num,
  _RtgPRT.production_resource_tool AS PRTnum,
  _CsticSearch.cstic_name AS cstic_name
FROM P_ConfignTraceParameter AS TraceParameter
LEFT OUTER JOIN P_ConfignTraceParamInstance AS _Instance ON _Instance.trace_guid = TraceParameter.trace_guid AND _Instance.roundtrip_no = TraceParameter.roundtrip_no AND _Instance.entry_no = TraceParameter.entry_no AND _Instance.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamBOMNode AS _BOMNode ON _BOMNode.trace_guid = TraceParameter.trace_guid AND _BOMNode.roundtrip_no = TraceParameter.roundtrip_no AND _BOMNode.entry_no = TraceParameter.entry_no AND _BOMNode.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamClsNode AS _ClsNode ON _ClsNode.trace_guid = TraceParameter.trace_guid AND _ClsNode.roundtrip_no = TraceParameter.roundtrip_no AND _ClsNode.entry_no = TraceParameter.entry_no AND _ClsNode.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamRouting AS _Routing ON _Routing.trace_guid = TraceParameter.trace_guid AND _Routing.roundtrip_no = TraceParameter.roundtrip_no AND _Routing.entry_no = TraceParameter.entry_no AND _Routing.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamRtgSeq AS _RtgSeq ON _RtgSeq.trace_guid = TraceParameter.trace_guid AND _RtgSeq.roundtrip_no = TraceParameter.roundtrip_no AND _RtgSeq.entry_no = TraceParameter.entry_no AND _RtgSeq.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamRtgOp AS _RtgOp ON _RtgOp.trace_guid = TraceParameter.trace_guid AND _RtgOp.roundtrip_no = TraceParameter.roundtrip_no AND _RtgOp.entry_no = TraceParameter.entry_no AND _RtgOp.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamRtgPRT AS _RtgPRT ON _RtgPRT.trace_guid = TraceParameter.trace_guid AND _RtgPRT.roundtrip_no = TraceParameter.roundtrip_no AND _RtgPRT.entry_no = TraceParameter.entry_no AND _RtgPRT.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamDepSearch AS _DepSearch ON _DepSearch.trace_guid = TraceParameter.trace_guid AND _DepSearch.roundtrip_no = TraceParameter.roundtrip_no AND _DepSearch.entry_no = TraceParameter.entry_no AND _DepSearch.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamCsticSearch AS _CsticSearch ON _CsticSearch.trace_guid = TraceParameter.trace_guid AND _CsticSearch.roundtrip_no = TraceParameter.roundtrip_no AND _CsticSearch.entry_no = TraceParameter.entry_no AND _CsticSearch.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamCsVal AS _CsVal ON _CsVal.trace_guid = TraceParameter.trace_guid AND _CsVal.roundtrip_no = TraceParameter.roundtrip_no AND _CsVal.entry_no = TraceParameter.entry_no AND _CsVal.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamCsticResult AS _CsticResult ON _CsticResult.trace_guid = TraceParameter.trace_guid AND _CsticResult.roundtrip_no = TraceParameter.roundtrip_no AND _CsticResult.entry_no = TraceParameter.entry_no AND _CsticResult.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamDepResult AS _DepResult ON _DepResult.trace_guid = TraceParameter.trace_guid AND _DepResult.roundtrip_no = TraceParameter.roundtrip_no AND _DepResult.entry_no = TraceParameter.entry_no AND _DepResult.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamPricingFact AS _PricingFact ON _PricingFact.trace_guid = TraceParameter.trace_guid AND _PricingFact.roundtrip_no = TraceParameter.roundtrip_no AND _PricingFact.entry_no = TraceParameter.entry_no AND _PricingFact.parameter_no = TraceParameter.parameter_no  -- association [0..1]
LEFT OUTER JOIN P_ConfignTraceParamVariantTab AS _VariantTab ON _VariantTab.trace_guid = TraceParameter.trace_guid AND _VariantTab.roundtrip_no = TraceParameter.roundtrip_no AND _VariantTab.entry_no = TraceParameter.entry_no AND _VariantTab.parameter_no = TraceParameter.parameter_no  -- association [0..1]
;