P_IJE_LOG_DETAIL

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_IJE_LOG_DETAIL.
-- 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: PIJELOG

CREATE VIEW P_IJE_LOG_DETAIL AS
SELECT
  item.raw_rowid AS raw_rowid,
  item.entryid AS entryid,
  item.node AS node,
  item.parentnode AS parentnode,
  _CnsldtnPUnitText[1:Language = $session.system_language].ConsolidationUnitMdmText AS CNSLDTNPUNITMDMTEXT,
  _CnsldtnUnitT[1: Language = $session.system_language].ConsolidationUnitMdmText AS CNSLDTNUNITMDMTEXT,
  _CnsldtnSubItemCategoryText[1: Language = $session.system_language].SubItemCategoryText AS CNSLDTNSUBITEMCATTEXT,
  _CnsldtnSubItemText[1: Language = $session.system_language].SubItemMediumText AS CNSLDTNSUBITEMTEXT,
  _CnsldtnFinStmntItemText[1: Language = $session.system_language].FinancialStatementItemMdmText AS CNSLDTNFSITMMTEXT,
  _CnsldtnGroupT[1:Language = $session.system_language].ConsolidationGroupMediumText AS CNSLDTNGROUPTEXT,
  item.fiscalyear AS fiscalyear,
  item.glrecordtype AS glrecordtype,
  item.baseunit AS baseunit,
  item.fiscalperiod AS fiscalperiod,
  item.company AS company,
  item.cnsldtnunit AS cnsldtnunit,
  item.cnsldtngroup AS cnsldtngroup,
  item.companycode AS companycode,
  item.postingdate AS postingdate,
  item.glaccount AS glaccount,
  item.costcenter AS costcenter,
  item.profitcenter AS profitcenter,
  item.businessarea AS businessarea,
  item.segment AS segment,
  item.orderid AS orderid,
  item.material AS material,
  item.plant AS plant,
  item.project AS project
FROM fincs_log_item01 AS item
LEFT OUTER JOIN I_CnsldtnGroupT AS _CnsldtnGroupT ON cnsldtngroup = _CnsldtnGroupT.ConsolidationGroup AND cnsldtndimension = _CnsldtnGroupT.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitT AS _CnsldtnUnitT ON cnsldtnunit = _CnsldtnUnitT.ConsolidationUnit AND cnsldtndimension = _CnsldtnUnitT.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _CnsldtnFinStmntItemText ON cnsldtnfinstmntitm = _CnsldtnFinStmntItemText.FinancialStatementItem AND cnsldtnchartofaccounts = _CnsldtnFinStmntItemText.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategoryText AS _CnsldtnSubItemCategoryText ON cnsldtnfinstmntsubitmcat = _CnsldtnSubItemCategoryText.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemText AS _CnsldtnSubItemText ON cnsldtnfinstmntsubitm = _CnsldtnSubItemText.SubItem AND cnsldtnfinstmntsubitmcat = _CnsldtnSubItemText.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitT AS _CnsldtnPUnitText ON cnsldtnpartnerunit = _CnsldtnPUnitText.ConsolidationUnit AND cnsldtndimension = _CnsldtnPUnitText.ConsolidationDimension  -- association [0..1]
;