I_CnsldtnTskLogItemDataProcess

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_CnsldtnTskLogItemDataProcess.
-- 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.

CREATE VIEW I_CnsldtnTskLogItemDataProcess AS
SELECT
  cnsldtnlognumber AS CnsldtnTaskLogUUID,
  cnsldtnlogitemnumber AS CnsldtnTaskLogItemUUID,
  cnsldtnlineitemtype AS CnsldtnTaskLogItemType,
  cast(cnsldtngroup as fincs_md_congr preserving type) AS ConsolidationGroup,
  cast(cnsldtnunit as fincs_consolidationunit preserving type) AS ConsolidationUnit,
  cast(cnsldtnfinstmntitm as fincs_md_finstatementitem preserving type) AS CnsldtnFinancialStatementItem,
  cast(cnsldtnfinstmntsubitmcat as fincs_subitemcategory preserving type) AS SubItemCategory,
  cast(cnsldtnfinstmntsubitm as fincs_subitem preserving type) AS SubItem,
  cast(cnsldtnlocalcurrency as fincs_lcurr_doc preserving type) AS CnsldtnJrnlEntryAmtLoclCrcy,
  cast(amountinlocalcrcy as fincs_lc_doc preserving type) AS CnsldtnJrnlEntryAmtInLoclCrcy,
  cast(cnsldtngroupcurrency as fincs_gcurr_doc preserving type) AS CnsldtnJrnlEntryAmtGrpCrcy,
  cast(amountingroupcrcy as fincs_gc_doc preserving type) AS CnsldtnJrnlEntryAmtInGrpCrcy,
  cast(transactioncurrency as fincs_tcurr_doc preserving type) AS CnsldtnJrnlEntryAmtTransCrcy,
  cast(amountintransactioncrcy as fincs_tc_doc preserving type) AS CnsldtnJrnlEntryAmtInTransCrcy,
  cast(baseunit as fincs_base_unit_doc preserving type) AS CnsldtnJrnlEntryQtyBaseUnit,
  cast(quantityinbaseunit as fincs_quan_doc preserving type) AS CnsldtnJrnlEntryQtyInBsUnt,
  cast(cnsldtnlocalcurrency as fincs_lcurr_tri preserving type) AS CnsldtnTriggeringAmtLoclCrcy,
  cast(amountinlocalcrcy as fincs_lc_tri preserving type) AS CnsldtnTriggeringAmtInLoclCrcy,
  cast(cnsldtngroupcurrency as fincs_gcurr_tri preserving type) AS CnsldtnTriggeringAmtGrpCrcy,
  cast(amountingroupcrcy as fincs_gc_tri preserving type) AS CnsldtnTriggeringAmtInGrpCrcy,
  cast(transactioncurrency as fincs_tcurr_tri preserving type) AS CnsldtnTriggeringAmtTransCrcy,
  cast(amountintransactioncrcy as fincs_tc_tri preserving type) AS CnsldtnTriggeringAmtInTC,
  cast(baseunit as fincs_base_unit_tri preserving type) AS CnsldtnTriggeringQtyBaseUnit,
  cast(quantityinbaseunit as fincs_quan_tri preserving type) AS CnsldtnTriggeringQtyInBsUnt,
  cast(seqno as fincs_seqno) AS SequenceNumber,
  cast(cnsldtnmethod as fincs_method preserving type) AS ConsolidationMethod,
  cast(recordindicator as fincs_stindicator preserving type) AS CnsldtnRclassfctnRecdType,
  cast(reexchangerateindicator as fincs_rerin preserving type) AS CnsldtnRefExchangeRateType,
  cast(reexchagerate as fincs_rrate preserving type) AS CnsldtnRefExchangeRateValue,
  cast(exchangerateindicator as fincs_exrind preserving type) AS CnsldtnExchangeRateType,
  cast(exchangerate as fincs_erate preserving type) AS CnsldtnExchangeRateValue,
  cast(currencytranskey as fincs_ctkey preserving type) AS CnsldtnCrcyTranslationKey,
  cast(cnsldtnfinstmntitmr as fincs_md_finstatementitem preserving type) AS CnsldtnCrcyTrnsltnDiffFSItem,
  cast(cnsldtnfinstmntsubitmr as fincs_subitem preserving type) AS CnsldtnCrcyTrnsltnDiffSubitem,
  cast(diffamount as fincs_diffamount preserving type) AS CalculatedDiffAmount,
  cast(reffamount as fincs_refamount preserving type) AS CalculatedRefAmount,
  cast(selection_id as fincs_sel_id preserving type) AS ConsolidationSelection,
  branch_id AS FinancialServicesBranch,
  cast(ghgscp2calcmeth as fincs_ghgscp2calculationmethod preserving type) AS GHGScope2CalculationMethod,
  re_account AS CashLedgerAccount,
  cast(re_ktopl as fincs_re_ktopl preserving type) AS CnsldtnCashLedgerChartOfAccts,
  cast(ghgscp2contrinstr as fincs_ghgscp2cntrctlinstrument preserving type) AS GHGScope2ContractualInstrument,
  datasource_id AS FinancialDataSource,
  fikrs AS FinancialManagementArea,
  rfund AS Fund,
  cast(ghgcategory as fincs_ghgcategory preserving type) AS GHGCategory,
  cast(ghgscope as fincs_ghgscope preserving type) AS GHGScope,
  rgrant_nbr AS GrantID,
  cast(susmodeoftransport as fincs_sustmodeoftransport preserving type) AS SustainabilityModeOfTransport,
  fs_product_group AS FinancialServicesProductGroup,
  cast(cnsldtndocumentnumber as fincs_docnr preserving type) AS ConsolidationDocumentNumber,
  cnsldtnpostingitem AS ConsolidationPostingItem,
  cast(cnsldtncrcycnvrsndifftype as fincs_currencycnvrsnsdifftype preserving type) AS CurrencyConversionsDiffType,
  cast(cnsldtnapportionment as fincs_apportionment preserving type) AS ConsolidationApportionment,
  cast(cnsldtnisautoposting as fincs_autom preserving type) AS ConsolidationPostgItemAutoFlag,
  cast(cnsldtnpartnerunit as fincs_consolidationunit preserving type) AS PartnerConsolidationUnit,
  cast(cnsldtnsetidentification as fincs_selid preserving type) AS ConsolidationCurrencySetIdn,
  cast(percentage as fincs_taxrate preserving type) AS CnsldtnPercent,
  cast(partnercostcenter as fincs_skost preserving type) AS PartnerCostCenter,
  cast(financialtransactiontype as fincs_financialtransactiontype preserving type) AS FinancialTransactionType,
  SoldMaterial,
  cast(customergroup as fincs_customergroup preserving type) AS CustomerGroup,
  cast(customersuppliercountry as fincs_country preserving type) AS CustomerSupplierCountry,
  SoldProductGroup,
  AssignmentReference,
  node AS CnsldtnTskLgNode,
  parentnode AS CnsldtnTskLgParNode,
  ChartOfAccounts
FROM fincs_log_item
LEFT OUTER JOIN I_CnsldtnGroup_3 AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubitemCategory_2 AS _CnsldtnSubitemCategory ON SubItemCategory = _CnsldtnSubitemCategory.CnsldtnSubitemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubitem_2 AS _CnsldtnSubItem ON SubItemCategory = _CnsldtnSubItem.CnsldtnSubitemCategory AND SubItem = _CnsldtnSubItem.CnsldtnSubitem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CnsldtnJrnlEntryAmtLoclCrcy ON CnsldtnJrnlEntryAmtLoclCrcy = _CnsldtnJrnlEntryAmtLoclCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CnsldtnJrnlEntryAmtGrpCrcy ON CnsldtnJrnlEntryAmtGrpCrcy = _CnsldtnJrnlEntryAmtGrpCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CnsldtnJrnlEntryAmtTransCrcy ON CnsldtnJrnlEntryAmtTransCrcy = _CnsldtnJrnlEntryAmtTransCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CnsldtnJrnlEntryQtyBaseUnit ON CnsldtnJrnlEntryQtyBaseUnit = _CnsldtnJrnlEntryQtyBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CnsldtnTriggeringAmtLoclCrcy ON CnsldtnTriggeringAmtLoclCrcy = _CnsldtnTriggeringAmtLoclCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CnsldtnTriggeringAmtGrpCrcy ON CnsldtnTriggeringAmtGrpCrcy = _CnsldtnTriggeringAmtGrpCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CnsldtnTriggeringAmtTransCrcy ON CnsldtnTriggeringAmtTransCrcy = _CnsldtnTriggeringAmtTransCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CnsldtnTriggeringQtyBaseUnit ON CnsldtnTriggeringQtyBaseUnit = _CnsldtnTriggeringQtyBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMethod AS _CnsldtnMethod ON ConsolidationMethod = _CnsldtnMethod.ConsolidationMethod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubitem_2 AS _CnsldtnItemDiff ON SubItemCategory = _CnsldtnItemDiff.CnsldtnSubitemCategory AND CnsldtnCrcyTrnsltnDiffSubitem = _CnsldtnItemDiff.CnsldtnSubitem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScp2CalcMethod AS _CnsldtnGHGScp2CalcMethod ON GHGScope2CalculationMethod = _CnsldtnGHGScp2CalcMethod.GHGScope2CalculationMethod  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLAccount_2 AS _CnsldtnCashLedgerAccount ON CnsldtnCashLedgerChartOfAccts = _CnsldtnCashLedgerAccount.ChartOfAccounts AND CashLedgerAccount = _CnsldtnCashLedgerAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLChartOfAccounts AS _CnsldtnCashLedgerChartOfAccts ON CnsldtnCashLedgerChartOfAccts = _CnsldtnCashLedgerChartOfAccts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScp2CntrctlInstr AS _CnsldtnGHGScp2CntrctlInstr ON GHGScope2ContractualInstrument = _CnsldtnGHGScp2CntrctlInstr.GHGScope2ContractualInstrument  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGCategory AS _CnsldtnGHGCategory ON GHGCategory = _CnsldtnGHGCategory.GHGCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGHGScope AS _CnsldtnGHGScope ON GHGScope = _CnsldtnGHGScope.GHGScope  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSustModeOfTransport AS _CnsldtnSustModeOfTransport ON SustainabilityModeOfTransport = _CnsldtnSustModeOfTransport.SustainabilityModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCrcyCnvrsnDiffType AS _CnsldtnCrcyCnvrsnDiffType ON CurrencyConversionsDiffType = _CnsldtnCrcyCnvrsnDiffType.CurrencyConversionsDiffType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnApportionment AS _CnsldtnApportionment ON ConsolidationApportionment = _CnsldtnApportionment.ConsolidationApportionment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnitPartner ON PartnerConsolidationUnit = _CnsldtnUnitPartner.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinTransType AS _CnsldtnFinTransType ON FinancialTransactionType = _CnsldtnFinTransType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnMaterial AS _CnsldtnMaterial ON SoldMaterial = _CnsldtnMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomerGroup AS _CnsldtnCustomerGroup ON CustomerGroup = _CnsldtnCustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCountry AS _CnsldtnCountry ON CustomerSupplierCountry = _CnsldtnCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProductGroup AS _CnsldtnProductGroup ON SoldProductGroup = _CnsldtnProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGLChartOfAccounts AS _CnsldtnGLChartOfAccounts ON ChartOfAccounts = _CnsldtnGLChartOfAccounts.ChartOfAccounts  -- association [0..1]
;