I_FinDataReleaseRequest

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_FinDataReleaseRequest.
-- 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: IFVDRR

CREATE VIEW I_FinDataReleaseRequest AS
SELECT
  drruuid AS DataReleaseRequestID,
  scen_id AS ValidationScenarioID,
  ryear AS FiscalYear,
  poper AS FiscalPeriod,
  periv AS FiscalYearVariant,
  dimen AS ConsolidationDimension,
  rvers AS ConsolidationVersion,
  rldnr AS ConsolidationLedger,
  cast ( rbunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  rcongr AS ConsolidationGroup,
  ritclg AS ConsolidationChartOfAccounts,
  method AS ValidationMethodID,
  task AS ValidationTaskID,
  cast(ustatus as int4) AS DataReleaseRequestUserStatus,
  createdby AS CreatedByUser,
  createdat AS CreationDateTime,
  changedby AS LastChangedByUser,
  changedat AS LastChangeDateTime,
  _Task.ValidationTaskType AS ValidationTaskType,
  _Task._Text.ValidationTaskText AS ValidationTaskText,
  _Task._TaskTypeText.TaskTypeDescription AS TaskTypeDescription
FROM vec_drr
LEFT OUTER JOIN I_FinValidationTask AS _Task ON ValidationScenarioID = _Task.ValidationScenarioID AND ValidationTaskID = _Task.ValidationTaskID  -- association [0..1]
;