I_CnsldtnTaskLogItemDataInput

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_CnsldtnTaskLogItemDataInput.
-- 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_CnsldtnTaskLogItemDataInput AS
SELECT
  cnsldtnlognumber AS CnsldtnTaskLogUUID,
  cnsldtnlogitemnumber AS CnsldtnTaskLogItemUUID,
  cnsldtnlineitemtype AS CnsldtnTaskLogItemType,
  AssignmentReference,
  fiscalyear AS PostingFiscalYear,
  cast(cnsldtndocumentnumber as fincs_docnr preserving type) AS ConsolidationDocumentNumber,
  cnsldtnversion AS ConsolidationVersion,
  cast(cnsldtnlocalcurrency as fincs_lcurr_doc preserving type) AS CnsldtnJrnlEntryAmtLoclCrcy,
  cast(amountincnsldtnlocalcrcy as fincs_lc_doc preserving type) AS CnsldtnJrnlEntryAmtInLoclCrcy,
  cast(cnsldtngroupcurrency as fincs_gcurr_doc preserving type) AS CnsldtnJrnlEntryAmtGrpCrcy,
  cast(amountincnsldtngroupcrcy as fincs_gc_doc preserving type) AS CnsldtnJrnlEntryAmtInGrpCrcy,
  cast(transactioncurrency as fincs_tcurr_doc preserving type) AS CnsldtnJrnlEntryAmtTransCrcy,
  cast(amountintransactioncurrency 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(amountincnsldtnlocalcrcy as fincs_lc_tri preserving type) AS CnsldtnTriggeringAmtInLoclCrcy,
  cast(cnsldtngroupcurrency as fincs_gcurr_tri preserving type) AS CnsldtnTriggeringAmtGrpCrcy,
  cast(amountincnsldtngroupcrcy as fincs_gc_tri preserving type) AS CnsldtnTriggeringAmtInGrpCrcy,
  cast(transactioncurrency as fincs_tcurr_tri preserving type) AS CnsldtnTriggeringAmtTransCrcy,
  cast(amountintransactioncurrency 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(cnsldtnunit as fincs_consolidationunit preserving type) AS ConsolidationUnit,
  cast(cnsldtnchartofaccounts as fincs_conschartofaccounts preserving type) AS ConsolidationChartOfAccounts,
  cast(cnsldtnfinstmntitm as fincs_md_finstatementitem preserving type) AS CnsldtnFinancialStatementItem,
  cast(cnsldtnpartnerunit as fincs_consolidationunit preserving type) AS PartnerConsolidationUnit,
  cast(cnsldtngroup as fincs_md_congr preserving type) AS ConsolidationGroup,
  CompanyCode,
  cast(cnsldtnfinstmntsubitmcat as fincs_subitemcategory preserving type) AS SubItemCategory,
  cast(cnsldtnfinstmntsubitm as fincs_subitem preserving type) AS SubItem,
  cast(cnsldtnpostinglevel as fincs_postinglevel preserving type) AS PostingLevel,
  cast(cnsldtnapportionment as fincs_apportionment preserving type) AS ConsolidationApportionment,
  cast(cnsldtncrcycnvrsndifftype as fincs_currencycnvrsnsdifftype preserving type) AS CurrencyConversionsDiffType,
  cast(cnsldtndocumenttype as fincs_documenttype preserving type) AS ConsolidationDocumentType,
  cast(cnsldtninvesteeunit as fincs_consolidationunit preserving type) AS InvesteeConsolidationUnit,
  cast(cnsldtninvmtactivitytype as fincs_coiac preserving type) AS InvestmentActivityType,
  cast(cnsldtninvmtactivity as fincs_coinr preserving type) AS InvestmentActivity,
  PostingDate,
  cast(partnercostcenter as fincs_skost preserving type) AS PartnerCostCenter,
  cast(financialtransactiontype as fincs_financialtransactiontype preserving type) AS FinancialTransactionType,
  cast(customergroup as fincs_customergroup preserving type) AS CustomerGroup,
  raw_rowid AS CnsldtnTskLgItmRowNmbr,
  FiscalPeriod,
  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,
  CustomerSupplierCountry,
  datasource_id AS FinancialDataSource,
  logdate AS CnsldtnLogHeaderDateTime,
  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,
  SoldProduct,
  SoldProductGroup,
  cast(wbselement as ps_posid_edit preserving type) AS WBSElementExternalID,
  cnsldtnledger AS ConsolidationLedger,
  cast(entryid as fincs_group_jrnl_entry) AS CnsldtnGroupJrnlEntry,
  cnsldtnpostingitem AS ConsolidationPostingItem
FROM fincs_log_item01
LEFT OUTER JOIN I_CnsldtnVersion AS _CnsldtnVersion ON ConsolidationVersion = _CnsldtnVersion.ConsolidationVersion  -- 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_CnsldtnUnit_4 AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _CnsldtnChartOfAccounts ON ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItem_2 AS _CnsldtnFSItem ON ConsolidationChartOfAccounts = _CnsldtnFSItem.ConsolidationChartOfAccounts AND CnsldtnFinancialStatementItem = _CnsldtnFSItem.CnsldtnFinancialStatementItem  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnitPartner ON PartnerConsolidationUnit = _CnsldtnUnitPartner.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnGroup_3 AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- 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_CnsldtnPostingLevel AS _CnsldtnPostingLevel ON PostingLevel = _CnsldtnPostingLevel.PostingLevel  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnApportionment AS _CnsldtnApportionment ON ConsolidationApportionment = _CnsldtnApportionment.ConsolidationApportionment  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCrcyCnvrsnDiffType AS _CnsldtnCrcyCnvrsnDiffType ON CurrencyConversionsDiffType = _CnsldtnCrcyCnvrsnDiffType.CurrencyConversionsDiffType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentType_2 AS _CnsldtnDocumentType ON ConsolidationDocumentType = _CnsldtnDocumentType.ConsolidationDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnit_4 AS _CnsldtnUnitInvestee ON InvesteeConsolidationUnit = _CnsldtnUnitInvestee.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnInvmtActy AS _CnsldtnInvmtActy ON InvestmentActivityType = _CnsldtnInvmtActy.InvestmentActivityType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinTransType AS _CnsldtnFinTransType ON FinancialTransactionType = _CnsldtnFinTransType.FinancialTransactionType  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnCustomerGroup AS _CnsldtnCustomerGroup ON CustomerGroup = _CnsldtnCustomerGroup.CustomerGroup  -- 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_CnsldtnCountry AS _CnsldtnCountry ON CustomerSupplierCountry = _CnsldtnCountry.Country  -- 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_CnsldtnProduct AS _CnsldtnProduct ON SoldProduct = _CnsldtnProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnProductGroup AS _CnsldtnProductGroup ON SoldProductGroup = _CnsldtnProductGroup.ProductGroup  -- association [0..1]
;