A_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 A_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 A_CnsldtnTaskLogItemDataEntry AS
SELECT
  CnsldtnTaskLogUUID,
  CnsldtnTaskLogItemUUID,
  CnsldtnTaskLogItemType,
  AssignmentReference,
  PostingFiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationVersion,
  CnsldtnJrnlEntryAmtLoclCrcy,
  CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtGrpCrcy,
  CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryAmtTransCrcy,
  CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryQtyBaseUnit,
  CnsldtnJrnlEntryQtyInBsUnt,
  CnsldtnTriggeringAmtLoclCrcy,
  CnsldtnTriggeringAmtInLoclCrcy,
  CnsldtnTriggeringAmtGrpCrcy,
  CnsldtnTriggeringAmtInGrpCrcy,
  CnsldtnTriggeringAmtTransCrcy,
  CnsldtnTriggeringAmtInTC,
  CnsldtnTriggeringQtyBaseUnit,
  CnsldtnTriggeringQtyInBsUnt,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  InvesteeConsolidationUnit,
  InvestmentActivityType,
  InvestmentActivity,
  PostingDate,
  PartnerCostCenter,
  FinancialTransactionType,
  CustomerGroup,
  CnsldtnTskLgItmRowNmbr,
  FiscalPeriod,
  FinancialServicesBranch,
  GHGScope2CalculationMethod,
  CashLedgerAccount,
  CnsldtnCashLedgerChartOfAccts,
  GHGScope2ContractualInstrument,
  CustomerSupplierCountry,
  FinancialDataSource,
  CnsldtnLogHeaderDateTime,
  Fund,
  GHGCategory,
  GHGScope,
  GrantID,
  SustainabilityModeOfTransport,
  FinancialServicesProductGroup,
  SoldProduct,
  SoldProductGroup,
  WBSElementExternalID,
  ConsolidationLedger,
  BillingDocumentType,
  BillToParty,
  BusinessArea,
  ChartOfAccounts,
  Customer,
  Material,
  Plant,
  Segment,
  CnsldtnTaskLogItemLatestRecord,
  CnsldtnTskLgNode,
  CnsldtnTskLgParNode,
  ConsolidationAcquisitionPeriod,
  ConsolidationAcquisitionYear,
  ConsolidationDimension,
  ControllingArea,
  CostCenter,
  CustomerSupplierCorporateGroup,
  CustomerSupplierIndustry,
  DistributionChannel,
  FinancialManagementArea,
  FunctionalArea,
  GLAccount,
  MaterialGroup,
  OrderID,
  Division,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerFunctionalArea,
  PartnerProfitCenter,
  PartnerSegment,
  PartnerWBSElementExternalID,
  ProfitCenter,
  SalesDistrict,
  SalesOrganization,
  ShipToParty,
  Supplier,
  _CnsldtnTaskLogItemType._Text.CnsldtnTaskLogItemTypeText : localized AS CnsldtnTaskLogItemTypeTextlocalized,
  _CnsldtnUnit._Text.ConsolidationUnitMdmText : localized AS ConsolidationUnitMdmTextlocalized,
  _CnsldtnFinancialDataSource._Text.FinancialDataSourceName : localized AS FinancialDataSourceNamelocalized,
  _CnsldtnFinManagementArea._Text.FinancialManagementAreaName : localized AS FinancialManagementAreaNamelocalized,
  _CnsldtnFinServicesBranch._Text.FinancialServicesBranchName : localized AS FinancialServicesBranchNamelocalized,
  _CnsldtnFSItem._Text.CnsldtnFSItemMediumText : localized AS CnsldtnFSItemMediumTextlocalized,
  _CnsldtnFund._Text.FundName : localized AS FundNamelocalized,
  _CnsldtnGHGCategory._Text.GHGCategoryName : localized AS GHGCategoryNamelocalized,
  _CnsldtnGHGScp2CalcMethod._Text.GHGScope2CalculationMethodName : localized AS GHGScope2CalculationMethodNamelocalized,
  _CnsldtnGHGScope._Text.GHGScopeName : localized AS GHGScopeNamelocalized,
  _CnsldtnGHGScp2CntrctlInstr._Text.GHGScp2CntrctlInstrName : localized AS GHGScp2CntrctlInstrNamelocalized,
  _CnsldtnGrant._Text.GrantName : localized AS GrantNamelocalized,
  _CnsldtnSubitemCategory._Text.CnsldtnSubitemCategoryText : localized AS CnsldtnSubitemCategoryTextlocalized,
  _CnsldtnSubItem._Text.CnsldtnSubitemMediumText : localized AS CnsldtnSubitemMediumTextlocalized,
  _CnsldtnSustModeOfTransport._Text.SustModeOfTransportName : localized AS SustModeOfTransportNamelocalized,
  GHGDataQualityCharacteristic,
  GHGEnergyClassification,
  GHGEnergyMix,
  GHGEnergySourcingType,
  WBSElementInternalID,
  ProjectExternalID,
  _CnsldtnGHGDtaQltyCharc._Text.GHGDtaQltyCharacteristicName : localized AS GHGDtaQltyCharacteristicNamelocalized,
  _CnsldtnGHGEngyClassification._Text.GHGEnergyClassificationName : localized AS GHGEnergyClassificationNamelocalized,
  _CnsldtnGHGEnergyMix._Text.GHGEnergyMixName : localized AS GHGEnergyMixNamelocalized,
  _CnsldtnGHGEnergySourcingType._Text.GHGEnergySourcingTypeName : localized AS GHGEnergySourcingTypeNamelocalized,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem
FROM I_CnsldtnTaskLogItemDataEntry
;