P_ConfignTraceEntryHeadParams

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_ConfignTraceEntryHeadParams.
-- 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: PVCHTRENTHEADPAR
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_ConfignTraceEntryHeadParams AS
SELECT
  TraceEntryRefParams.trace_guid AS trace_guid,
  TraceEntryRefParams.roundtrip_no AS roundtrip_no,
  TraceEntryRefParams.entry_no AS entry_no,
  TraceEntryRefParams.text_no AS text_no,
  TraceEntryRefParams.parameter_no AS parameter_no,
  TraceEntryRefParams.io_type AS io_type,
  CharacteristicsValues.cstic_id AS cstic_id,
  CharacteristicsValues.cstic_name AS cstic_name,
  ClassNodes.class_number AS class_number,
  ClassNodes.class_type AS class_type,
  RoutingOperations.suboperation AS suboperation,
  Routing.routing_text AS routing_text,
  cast('' as vch_hl_trace_text) AS free_text,
  cast('' as symsgty) AS message_type,
  BAdi.badi_name AS badi_name,
  TraceEntryRefParams.cstic_view AS cstic_view,
  cast( 0 as vch_hl_cfg_instance_id) AS instance_id
FROM P_ConfignTraceEntryRefParams AS TraceEntryRefParams
LEFT OUTER JOIN P_ConfignTraceRefParamCharc AS CharacteristicsValues ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamInstance AS Instance ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamObjDep AS ObjectDependencies ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamClsNode AS ClassNodes ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamBOMNode AS BOMComponents ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamRtgOp AS RoutingOperations ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamRtgSeq AS RoutingSequences ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamRtgPRT AS RoutingPRTs ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamBAdI AS BAdi ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamSetBy AS ValueSetBy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamRouting AS Routing ON /* join condition not captured in parsed metadata */
INNER JOIN P_ConfignTraceParameter AS Parameters ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamFreeText AS FreeText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ConfignTraceParamSystemMsg AS T100 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ConfignTraceEntry
;