P_GEN_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_GEN_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: PGLOGDETAIL

CREATE VIEW P_GEN_LOG_DETAIL AS
SELECT
  CnsldtnTskLgNode AS node,
  CnsldtnTskLgParNode AS parentnode,
  ConsolidationGroup AS cnsldtngroup,
  ConsolidationUnit AS cnsldtnunit,
  _cnsldtnmethodT.txt AS CNSLDTNMETHODTEXT,
  _CnsldtnPUnitText.ConsolidationUnitMdmText AS CNSLDTNPUNITMDMTEXT,
  _CnsldtnUnitT.ConsolidationUnitMdmText AS CNSLDTNUNITMDMTEXT,
  _CnsldtnSubItemCategoryText.SubItemCategoryText AS CNSLDTNSUBITEMCATTEXT,
  _CnsldtnSubItemText.SubItemMediumText AS CNSLDTNSUBITEMTEXT,
  _CnsldtnFinStmntItemText.FinancialStatementItemMdmText AS CNSLDTNFSITMMTEXT,
  _CnsldtnGroupT.ConsolidationGroupMediumText AS CNSLDTNGROUPTEXT,
  _CnsldtnSelection._Text[1: Language = $session.system_language].ConsolidationSelectionText AS SLCTNTXT,
  pre.CnsldtnPercent AS percentage,
  CnsldtnTriggeringQtyBaseUnit AS baseunit,
  SequenceNumber AS seqno,
  CnsldtnTaskLogItemType AS DOCINDICATOR,
  pre.AMOUNT_GC_TRI AS AMOUNT_GC_TRI,
  pre.AMOUNT_GC_DOC AS AMOUNT_GC_DOC,
  pre.AMOUNT_LC_TRI AS AMOUNT_LC_TRI,
  pre.AMOUNT_LC_DOC AS AMOUNT_LC_DOC,
  pre.AMOUNT_TC_TRI AS AMOUNT_TC_TRI,
  pre.AMOUNT_TC_DOC AS AMOUNT_TC_DOC,
  CnsldtnGroupJrnlEntry AS SortOrder,
  _header.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _header.CnsldtnDimension AS ConsolidationDimension,
  _header.CnsldtnVersion AS ConsolidationVersion,
  _header.CnsldtnTaskType AS CnsldtnTaskType,
  _header.UpdateMode AS UpdateMode,
  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.partnerwbselement AS wbselement,
  item.project AS project,
  item.soldmaterial AS soldmaterial,
  item.productgroup AS productgroup,
  item.customer AS customer,
  item.supplier AS supplier,
  item.soldproduct AS soldproduct,
  item.billtoparty AS billtoparty,
  item.shiptoparty AS shiptoparty
FROM fincs_log_item AS item
INNER JOIN P_GEN_LOG_HEADER AS _header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GEN_LOG_DETAIL_Pre AS pre ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tf551 AS _cnsldtnmethodT ON cnsldtnmethod = _cnsldtnmethodT.cmeth AND _cnsldtnmethodT.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGroupT AS _CnsldtnGroupT ON cnsldtngroup = _CnsldtnGroupT.ConsolidationGroup AND _CnsldtnGroupT.Language = $session.system_language AND ConsolidationDimension = _CnsldtnGroupT.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitT AS _CnsldtnUnitT ON cnsldtnunit = _CnsldtnUnitT.ConsolidationUnit AND _CnsldtnUnitT.Language = $session.system_language AND ConsolidationDimension = _CnsldtnUnitT.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _CnsldtnFinStmntItemText ON cnsldtnfinstmntitm = _CnsldtnFinStmntItemText.FinancialStatementItem AND _CnsldtnFinStmntItemText.Language = $session.system_language AND chartofaccounts = _CnsldtnFinStmntItemText.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategoryText AS _CnsldtnSubItemCategoryText ON cnsldtnfinstmntsubitmcat = _CnsldtnSubItemCategoryText.SubItemCategory AND _CnsldtnSubItemCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemText AS _CnsldtnSubItemText ON cnsldtnfinstmntsubitm = _CnsldtnSubItemText.SubItem AND cnsldtnfinstmntsubitmcat = _CnsldtnSubItemText.SubItemCategory AND _CnsldtnSubItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitT AS _CnsldtnPUnitText ON cnsldtnpartnerunit = _CnsldtnPUnitText.ConsolidationUnit AND _CnsldtnPUnitText.Language = $session.system_language AND ConsolidationDimension = _CnsldtnPUnitText.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSelection AS _CnsldtnSelection ON item.cnsldtnsetidentification = _CnsldtnSelection.ConsolidationSelection  -- association [1..1]
;