I_JrnlPeriodEndClosingRunLog

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 I_JrnlPeriodEndClosingRunLog.
-- 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: IFICLSRUNLOG

CREATE VIEW I_JrnlPeriodEndClosingRunLog AS
SELECT
  JrnlPeriodEndClosingRunLogUUID,
  JrnlPeriodEndClosingRunLogID,
  BusinessTransactionCategory,
  BusinessTransactionType,
  FinancialClosingRunType,
  FinancialClosingStep,
  JrnlPerdEndClsgRunCrtnDteTime,
  JrnlPerdEndClsgRunChgdDateTime,
  JrnlPerdEndClsgRunCrtedByUser,
  JrnlPerdEndClsgRunChgdByUser,
  FinClsgRunConfignJSONString,
  FinClsgRunInputParamJSONStr,
  FinancialClosingRunProgram,
  FinClosingRunExecutionStatus,
  FinClosingRunBatchJobName,
  FinancialClosingRunBatchJob,
  CompanyCode,
  Ledger,
  FiscalYear,
  FiscalPeriod,
  cast( concat( fiscalyear, fiscalperiod ) as fins_fyearperiod ) AS FiscalYearPeriod,
  KeyDate,
  duration AS FinancialClosingRunDuration,
  number_obj_ok AS NmbrOfSuccssflObjectsInClsgRun,
  number_obj_fail AS NmbrOfFailedObjectsInClsgRun,
  msg_cnt_e AS NumberOfErrorMessages,
  msg_cnt_w AS NumberOfWarningMessages,
  log_handle AS ApplicationLogHandle
FROM fins_cls_run
LEFT OUTER JOIN I_BusinessTransactionCategory AS _BusinessTransactionCategory ON BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory  -- association [1..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_FinClsgRunExecStatusText AS _FinClsgRunExecStatusText ON FinClosingRunExecutionStatus = _FinClsgRunExecStatusText.FinClosingRunExecutionStatus  -- association [0..*]
LEFT OUTER JOIN I_FinClsgProcessingOptionText AS _FinClsgProcessingOptionText ON FinClosingRunIsTestExecution = _FinClsgProcessingOptionText.FinClosingRunIsTestExecution  -- association [0..*]
LEFT OUTER JOIN I_BusTransactionCategoryText AS _BusTransactionCategoryText ON BusinessTransactionCategory = _BusTransactionCategoryText.BusinessTransactionCategory  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
;