P_EventBasedWIPLogHeaderData

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_EventBasedWIPLogHeaderData.
-- 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: PEBWORDLOGHD

CREATE VIEW P_EventBasedWIPLogHeaderData AS
SELECT
  LogNumber,
  log_handle AS LogHandle,
  cast( '' as fco_ebw_log_text) AS LogMessageText,
  object AS ApplicationLogObject,
  subobject AS ApplicationLogSubobject,
  _DomainFixedValueText.DomainText AS EvtBsdOrdRefTransText,
  aluser AS CreatedByUser,
  aldate AS CreationDate,
  altime AS CreationTime,
  cast(SUBSTRING(altext,3, 12 ) as aufnr ) AS OrderID,
  cast(altext as j_objnr ) AS ControllingObject
FROM balhdr AS _log
LEFT OUTER JOIN I_DomainFixedValueText AS _DomainFixedValueText ON _DomainFixedValueText.SAPDataDictionaryDomain = 'FCO_EBW_REFERENCE_TRANSACTION' AND _DomainFixedValueText.Language = $session.system_language  -- association [1..1]
;