P_EvtBsdOverheadErrorLog

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_EvtBsdOverheadErrorLog.
-- 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: PEBOVHDERRLG

CREATE VIEW P_EvtBsdOverheadErrorLog AS
SELECT
  _EvtBsdOvhdErrLgCtrlgDoc.EvtBsdProdnCostErrorObject AS EvtBsdProdnCostErrorObject,
  _EvtBsdOvhdErrLgCtrlgDoc.LogNumber AS LogNumber,
  _EvtBsdOvhdErrLgCtrlgDoc.EventBasedProdnCostErrorUUID AS EventBasedProdnCostErrorUUID,
  _EvtBsdOvhdErrLgCtrlgDoc.Ledger AS Ledger,
  _EvtBsdOvhdErrLgCtrlgDoc.CompanyCode AS CompanyCode,
  cast( '' as fco_ebw_log_text) AS LogMessageText,
  _EvtBsdOvhdErrLgCtrlgDoc.EventBasedProdnCostWlLogType AS EventBasedProdnCostWlLogType,
  _EvtBsdOvhdErrLgCtrlgDoc.EventBasedProdnCostRefProcess AS EventBasedProdnCostRefProcess,
  cast( coalesce(_ReferenceProcessText.DomainText, _ReferenceDocumentTypeText.ReferenceDocumentTypeName) as val_text preserving type ) AS EvtBsdProdnCostRefProcessName,
  _EvtBsdOvhdErrLgCtrlgDoc.EvtBsdProdnCostErrObjectType AS EvtBsdProdnCostErrObjectType,
  _AccountAssignmentTypeT.AccountAssignmentTypeDesc AS EvtBsdProdnCostErrObjTypeName,
  _EvtBsdOvhdErrLgCtrlgDoc.BusinessTransactionCategory AS BusinessTransactionCategory,
  _BusTransactionCategoryText.BusTransactionCategoryName AS BusTransactionCategoryName,
  _EvtBsdOvhdErrLgCtrlgDoc.OrderID AS OrderID,
  _EvtBsdOvhdErrLgCtrlgDoc.OrderItem AS OrderItem,
  _Order.OrderType AS OrderType,
  _Order.OrderCategory AS OrderCategory,
  _Order.OrderIsEventBasedPosting AS OrderIsEventBasedPosting,
  _EvtBsdOvhdErrLgCtrlgDoc.Plant AS Plant,
  _EvtBsdOvhdErrLgCtrlgDoc.Product AS Product,
  _EvtBsdOvhdErrLgCtrlgDoc.ServiceDocID AS ServiceDocID,
  _EvtBsdOvhdErrLgCtrlgDoc.ServiceDocItemID AS ServiceDocItemID,
  _EvtBsdOvhdErrLgCtrlgDoc.ServiceDocumentType AS ServiceDocumentType,
  _EvtBsdOvhdErrLgCtrlgDoc.WBSElementExternalID AS WBSElementExternalID,
  _EvtBsdOvhdErrLgCtrlgDoc.ControllingObject AS ControllingObject,
  _EvtBsdOvhdErrLgCtrlgDoc.SimulationStatus AS SimulationStatus,
  _EvtBsdOvhdErrLgCtrlgDoc.CreatedByUser AS CreatedByUser,
  _EvtBsdOvhdErrLgCtrlgDoc.ControllingDocument AS ControllingDocument,
  _EvtBsdOvhdErrLgCtrlgDoc.ControllingArea AS ControllingArea,
  _EvtBsdOvhdErrLgCtrlgDoc.OriginalReferenceDocument AS OriginalReferenceDocument,
  _EvtBsdOvhdErrLgCtrlgDoc.ReferenceDocumentType AS ReferenceDocumentType,
  _EvtBsdOvhdErrLgCtrlgDoc.TaskTimeStampValue AS TaskTimeStampValue,
  _EvtBsdOvhdErrLgCtrlgDoc.PostingDate AS PostingDate
FROM P_EvtBsdOvhdErrLgCtrlgDoc AS _EvtBsdOvhdErrLgCtrlgDoc
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON _ReferenceDocumentTypeText.ReferenceDocumentType = _EvtBsdOvhdErrLgCtrlgDoc.EventBasedProdnCostRefProcess AND _ReferenceDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DomainFixedValueText AS _ReferenceProcessText ON _ReferenceProcessText.SAPDataDictionaryDomain = 'FCO_EB_REF_PROCESS' AND _ReferenceProcessText.DomainValue = _EvtBsdOvhdErrLgCtrlgDoc.EventBasedProdnCostRefProcess AND _ReferenceProcessText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _AccountAssignmentTypeT ON _AccountAssignmentTypeT.AccountAssignmentType = EvtBsdProdnCostErrObjectType AND _AccountAssignmentTypeT.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BusTransactionCategoryText AS _BusTransactionCategoryText ON _BusTransactionCategoryText.BusinessTransactionCategory = _EvtBsdOvhdErrLgCtrlgDoc.BusinessTransactionCategory AND _BusTransactionCategoryText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearPeriodForLedger AS _FiscalYearPeriodForLedger ON _FiscalYearPeriodForLedger.CompanyCode = CompanyCode AND _FiscalYearPeriodForLedger.Ledger = Ledger AND _FiscalYearPeriodForLedger.FiscalPeriodStartDate <= PostingDate AND _FiscalYearPeriodForLedger.FiscalPeriodEndDate >= PostingDate  -- association [1..1]
;