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
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]
;