I_CnsldtnMnlJrnlEntrTaskLog

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_CnsldtnMnlJrnlEntrTaskLog.
-- 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: ICNSLDTNJRTSKLG

CREATE VIEW I_CnsldtnMnlJrnlEntrTaskLog AS
SELECT
  CnsldtnTaskLogUUID,
  CnsldtnTaskLogItemUUID,
  CnsldtnTskLgItmRowNmbr,
  CnsldtnTaskLogItemType,
  CnsldtnTaskLogItemTypeTxt,
  CnsldtnGroupJrnlEntry,
  cast ( lpad( CnsldtnTskLgNode, 32, '0' ) as sysuuid_c32 preserving type) AS CnsldtnTskLgNode,
  cast ( lpad( CnsldtnTskLgParNode, 32, '0' ) as sysuuid_c32 preserving type) AS CnsldtnTskLgParNode,
  ConsolidationLedger,
  PostingFiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  ConsolidationDimension,
  GLRecordType,
  ConsolidationVersion,
  PostingFiscalPeriod,
  OriginalCompanyCode,
  ConsolidationUnit,
  ConsolidationUnitMdmText,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  _CnsldtnUnitText[1: Language = $session.system_language].ConsolidationUnitMdmText AS ConsolidationUnitText,
  _CnsldtnPUnitText[1:Language = $session.system_language].ConsolidationUnitMdmText AS PartnerConsolidationUnitText,
  _CnsldtnSubItemCategoryText[1: Language = $session.system_language].SubItemCategoryText AS SubItemCategoryText,
  _CnsldtnSubItemText[1: Language = $session.system_language].SubItemMediumText AS SubItemText,
  _CnsldtnFinStmntItemText[1: Language = $session.system_language].FinancialStatementItemMdmText AS FinancialStatementItemText,
  _CnsldtnGroupT[1:Language = $session.system_language].ConsolidationGroupMediumText AS ConsolidationGroupMediumText,
  ChartOfAccountsText,
  CnsldtnTriggeringAmtLoclCrcy,
  CnsldtnTriggeringAmtInLoclCrcy,
  CnsldtnTriggeringAmtGrpCrcy,
  CnsldtnTriggeringAmtInGrpCrcy,
  CnsldtnTriggeringAmtTransCrcy,
  CnsldtnTriggeringAmtInTC,
  CnsldtnTriggeringQtyBaseUnit,
  CnsldtnTriggeringQtyInBsUnt,
  CnsldtnJrnlEntryAmtLoclCrcy,
  CnsldtnJrnlEntryAmtInLoclCrcy,
  CnsldtnJrnlEntryAmtGrpCrcy,
  CnsldtnJrnlEntryAmtInGrpCrcy,
  CnsldtnJrnlEntryAmtTransCrcy,
  CnsldtnJrnlEntryAmtInTransCrcy,
  CnsldtnJrnlEntryQtyBaseUnit,
  CnsldtnJrnlEntryQtyInBsUnt,
  ConsolidationReportingItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CnsldtnLogHeaderDateTime,
  CurrencyTranslationDate,
  RefAccountingDocument,
  ReferenceFiscalYear,
  RefAccountingDocumentItem,
  ReferenceAcctgDocumentType,
  RefBusinessTransactionType,
  RvsdReferenceDocumentType,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  GLAccountText,
  AssignmentReference,
  CostCenterText,
  ProfitCenterText,
  FunctionalAreaText,
  BusinessAreaText,
  ControllingAreaText,
  CnsldtnSegmentText,
  PartnerCostCenter,
  PartnerProfitCenterText,
  PartnerFunctionalAreaText,
  PartnerBusinessAreaText,
  PartnerCompanyText,
  PartnerSegmentText,
  OrderID,
  CnsldtnMaterialText,
  MaterialGroupName,
  CnsldtnPlantText,
  FinancialTransactionType,
  WBSElementInternalID,
  PartnerWBSElementDescription,
  CnsldtnProjectText,
  BillingDocumentTypeText,
  SalesOrganizationText,
  DistributionChannelText,
  OrganizationDivisionText,
  SoldMaterial,
  ProductGroupText,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrictText,
  CustomerSupplierCorporateGroup,
  CnsldtnTaskLogItemIsLatest,
  CnsldtnCustomerText,
  SupplierName,
  SoldProduct,
  SoldProductGroup,
  BillToParty,
  ShipToParty,
  CnsldtnGroupJrnlEntryBundle,
  GHGCategory,
  GHGScope,
  GHGScope2CalculationMethod,
  GHGScope2ContractualInstrument,
  SustainabilityModeOfTransport,
  FinancialManagementArea,
  Fund,
  GrantID,
  CnsldtnCashLedgerChartOfAccts,
  CashLedgerAccount,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  GHGDataQualityCharacteristic,
  GHGEnergyClassification,
  GHGEnergyMix,
  GHGEnergySourcingType,
  PartnerFund,
  _GHGScopeText.GHGScopeName AS GHGScopeName,
  _GHGCategoryText.GHGCategoryName AS GHGCategoryName,
  _GHGScp2CalcMethodText.GHGScope2CalculationMethodName AS GHGScope2CalculationMethodName,
  _GHGScp2CntrctlInstrText.GHGScp2CntrctlInstrName AS GHGScp2CntrctlInstrName,
  _SustModeOfTransportText.SustModeOfTransportName AS SustModeOfTransportName,
  _FinancialManagementAreaText.FinancialManagementAreaName AS FinancialManagementAreaName,
  _FundText.FundName AS FundName,
  _GrantText.GrantName AS GrantName,
  _FinancialServicesBranchT.FinancialServicesBranchName AS FinancialServicesBranchName,
  _FinancialDataSourceT.FinancialDataSourceName AS FinancialDataSourceName,
  _GHGDtaQltyCharcText.GHGDtaQltyCharacteristicName AS GHGDtaQltyCharacteristicName,
  _GHGEngyClassificationText.GHGEnergyClassificationName AS GHGEnergyClassificationName,
  _GHGEnergyMixText.GHGEnergyMixName AS GHGEnergyMixName,
  _GHGEnergySourcingTypeText.GHGEnergySourcingTypeName AS GHGEnergySourcingTypeName
FROM I_CnsldtnTaskLogItem01 AS item
LEFT OUTER JOIN I_CnsldtnGroupT AS _CnsldtnGroupT ON ConsolidationGroup = _CnsldtnGroupT.ConsolidationGroup AND ConsolidationDimension = _CnsldtnGroupT.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitText_2 AS _CnsldtnUnitText ON ConsolidationUnit = _CnsldtnUnitText.ConsolidationUnit AND ConsolidationDimension = _CnsldtnUnitText.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _CnsldtnFinStmntItemText ON CnsldtnFinancialStatementItem = _CnsldtnFinStmntItemText.FinancialStatementItem AND ConsolidationChartOfAccounts = _CnsldtnFinStmntItemText.ConsolidationChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemCategoryText AS _CnsldtnSubItemCategoryText ON SubItemCategory = _CnsldtnSubItemCategoryText.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnSubItemText AS _CnsldtnSubItemText ON SubItemCategory = _CnsldtnSubItemText.SubItem AND SubItemCategory = _CnsldtnSubItemText.SubItemCategory  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnUnitText_2 AS _CnsldtnPUnitText ON PartnerConsolidationUnit = _CnsldtnPUnitText.ConsolidationUnit AND ConsolidationDimension = _CnsldtnPUnitText.ConsolidationDimension  -- association [0..1]
LEFT OUTER JOIN I_GHGScopeText AS _GHGScopeText ON GHGScope = _GHGScopeText.GHGScope AND _GHGScopeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGCategoryText AS _GHGCategoryText ON GHGCategory = _GHGCategoryText.GHGCategory AND _GHGCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGScp2CalcMethodText AS _GHGScp2CalcMethodText ON GHGScope2CalculationMethod = _GHGScp2CalcMethodText.GHGScope2CalculationMethod AND _GHGScp2CalcMethodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGScp2CntrctlInstrText AS _GHGScp2CntrctlInstrText ON GHGScope2ContractualInstrument = _GHGScp2CntrctlInstrText.GHGScope2ContractualInstrument AND _GHGScp2CntrctlInstrText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SustModeOfTransportText AS _SustModeOfTransportText ON SustainabilityModeOfTransport = _SustModeOfTransportText.SustainabilityModeOfTransport AND _SustModeOfTransportText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea AND _FinancialManagementAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND FinancialManagementArea = _FundText.FinancialManagementArea AND _FundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID AND _GrantText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialServicesBranchT AS _FinancialServicesBranchT ON FinancialServicesBranch = _FinancialServicesBranchT.FinancialServicesBranch AND _FinancialServicesBranchT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialDataSourceT AS _FinancialDataSourceT ON FinancialDataSource = _FinancialDataSourceT.FinancialDataSource AND _FinancialDataSourceT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGDtaQltyCharcText AS _GHGDtaQltyCharcText ON GHGDataQualityCharacteristic = _GHGDtaQltyCharcText.GHGDataQualityCharacteristic AND _GHGDtaQltyCharcText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGEngyClassificationText AS _GHGEngyClassificationText ON GHGEnergyClassification = _GHGEngyClassificationText.GHGEnergyClassification AND _GHGEngyClassificationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGEnergyMixText AS _GHGEnergyMixText ON GHGEnergyMix = _GHGEnergyMixText.GHGEnergyMix AND _GHGEnergyMixText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHGEnergySourcingTypeText AS _GHGEnergySourcingTypeText ON GHGEnergySourcingType = _GHGEnergySourcingTypeText.GHGEnergySourcingType AND _GHGEnergySourcingTypeText.Language = $session.system_language  -- association [0..1]
;