I_CnsldtnTaskLogItemDataEntry

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_CnsldtnTaskLogItemDataEntry.
-- 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_CnsldtnTaskLogItemDataEntry AS
SELECT
  item.CnsldtnTaskLogUUID AS CnsldtnTaskLogUUID,
  item.CnsldtnTaskLogItemUUID AS CnsldtnTaskLogItemUUID,
  item.CnsldtnTaskLogItemType AS CnsldtnTaskLogItemType,
  item.AssignmentReference AS AssignmentReference,
  item.PostingFiscalYear AS PostingFiscalYear,
  item.ConsolidationDocumentNumber AS ConsolidationDocumentNumber,
  item.ConsolidationVersion AS ConsolidationVersion,
  item.CnsldtnJrnlEntryAmtLoclCrcy AS CnsldtnJrnlEntryAmtLoclCrcy,
  item.CnsldtnJrnlEntryAmtInLoclCrcy AS CnsldtnJrnlEntryAmtInLoclCrcy,
  item.CnsldtnJrnlEntryAmtGrpCrcy AS CnsldtnJrnlEntryAmtGrpCrcy,
  item.CnsldtnJrnlEntryAmtInGrpCrcy AS CnsldtnJrnlEntryAmtInGrpCrcy,
  item.CnsldtnJrnlEntryAmtTransCrcy AS CnsldtnJrnlEntryAmtTransCrcy,
  item.CnsldtnJrnlEntryAmtInTransCrcy AS CnsldtnJrnlEntryAmtInTransCrcy,
  item.CnsldtnJrnlEntryQtyBaseUnit AS CnsldtnJrnlEntryQtyBaseUnit,
  item.CnsldtnJrnlEntryQtyInBsUnt AS CnsldtnJrnlEntryQtyInBsUnt,
  item.CnsldtnTriggeringAmtLoclCrcy AS CnsldtnTriggeringAmtLoclCrcy,
  item.CnsldtnTriggeringAmtInLoclCrcy AS CnsldtnTriggeringAmtInLoclCrcy,
  item.CnsldtnTriggeringAmtGrpCrcy AS CnsldtnTriggeringAmtGrpCrcy,
  item.CnsldtnTriggeringAmtInGrpCrcy AS CnsldtnTriggeringAmtInGrpCrcy,
  item.CnsldtnTriggeringAmtTransCrcy AS CnsldtnTriggeringAmtTransCrcy,
  item.CnsldtnTriggeringAmtInTC AS CnsldtnTriggeringAmtInTC,
  item.CnsldtnTriggeringQtyBaseUnit AS CnsldtnTriggeringQtyBaseUnit,
  item.CnsldtnTriggeringQtyInBsUnt AS CnsldtnTriggeringQtyInBsUnt,
  item.ConsolidationUnit AS ConsolidationUnit,
  item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  item.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  item.ConsolidationGroup AS ConsolidationGroup,
  item.CompanyCode AS CompanyCode,
  item.SubItemCategory AS SubItemCategory,
  item.SubItem AS SubItem,
  item.PostingLevel AS PostingLevel,
  item.ConsolidationApportionment AS ConsolidationApportionment,
  item.CurrencyConversionsDiffType AS CurrencyConversionsDiffType,
  item.ConsolidationDocumentType AS ConsolidationDocumentType,
  item.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  item.InvestmentActivityType AS InvestmentActivityType,
  item.InvestmentActivity AS InvestmentActivity,
  item.PostingDate AS PostingDate,
  item.PartnerCostCenter AS PartnerCostCenter,
  item.FinancialTransactionType AS FinancialTransactionType,
  item.CustomerGroup AS CustomerGroup,
  item.CnsldtnTskLgItmRowNmbr AS CnsldtnTskLgItmRowNmbr,
  item.FiscalPeriod AS FiscalPeriod,
  item.FinancialServicesBranch AS FinancialServicesBranch,
  item.GHGScope2CalculationMethod AS GHGScope2CalculationMethod,
  item.CashLedgerAccount AS CashLedgerAccount,
  item.CnsldtnCashLedgerChartOfAccts AS CnsldtnCashLedgerChartOfAccts,
  item.GHGScope2ContractualInstrument AS GHGScope2ContractualInstrument,
  item.CustomerSupplierCountry AS CustomerSupplierCountry,
  item.FinancialDataSource AS FinancialDataSource,
  item.CnsldtnLogHeaderDateTime AS CnsldtnLogHeaderDateTime,
  item.Fund AS Fund,
  item.GHGCategory AS GHGCategory,
  item.GHGScope AS GHGScope,
  item.GrantID AS GrantID,
  item.SustainabilityModeOfTransport AS SustainabilityModeOfTransport,
  item.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  item.SoldProduct AS SoldProduct,
  item.SoldProductGroup AS SoldProductGroup,
  item.WBSElementExternalID AS WBSElementExternalID
FROM I_CnsldtnTaskLogItemDataInput AS item
LEFT OUTER JOIN I_ConsolidationTaskLog AS _ConsolidationTaskLog ON CnsldtnTaskLogUUID = _ConsolidationTaskLog.CnsldtnTaskLogUUID  -- association [1..1]
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]
;