I_CnsldtnRecnclnTskLgSortedItm

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_CnsldtnRecnclnTskLgSortedItm.
-- 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_CnsldtnRecnclnTskLgSortedItm AS
SELECT
  item.CnsldtnTaskLogUUID AS CnsldtnTaskLogUUID,
  item.CnsldtnTaskLogItemUUID AS CnsldtnTaskLogItemUUID,
  item.HierarchyNode AS HierarchyNode,
  item.ConsolidationTask AS ConsolidationTask,
  item.MatchingMethodID AS MatchingMethodID,
  item.ReconciliationCaseID AS ReconciliationCaseID,
  item.CnsldtnMatchingRuleID AS CnsldtnMatchingRuleID,
  item.CnsldtnUnitReconciliation AS CnsldtnUnitReconciliation,
  item.CnsldtnPrtnUnitReconciliation AS CnsldtnPrtnUnitReconciliation,
  ConsolidationItemGroup,
  cast(item.ConsolidationItemGroup as fincs_item_group ) AS ConsolidationItemGroupText,
  item.ConsolidationDisplayGroup AS ConsolidationDisplayGroup,
  item.ConsolidationSelection AS ConsolidationSelection,
  item.ConsolidationDocumentNumber AS ConsolidationDocumentNumber,
  item.ConsolidationPostingItem AS ConsolidationPostingItem,
  item.SequenceNumber AS SequenceNumber,
  item.CnsldtnRefExchangeRateType AS CnsldtnRefExchangeRateType,
  item.CnsldtnRefExchangeRateValue AS CnsldtnRefExchangeRateValue,
  item.CnsldtnExchangeRateType AS CnsldtnExchangeRateType,
  item.CnsldtnExchangeRateValue AS CnsldtnExchangeRateValue,
  item.CnsldtnCrcyTranslationKey AS CnsldtnCrcyTranslationKey,
  item.CnsldtnTaskLogItemType AS CnsldtnTaskLogItemType,
  item.CnsldtnTskLgItmRowNmbr AS CnsldtnTskLgItmRowNmbr,
  item.CnsldtnGroupJrnlEntry AS CnsldtnGroupJrnlEntry,
  item.CnsldtnUntAmtInTransCrcy AS CnsldtnUntAmtInTransCrcy,
  item.CnsldtnPrtnUntAmtInTransCrcy AS CnsldtnPrtnUntAmtInTransCrcy,
  item.CnsldtnDiffAmtInTransCrcy AS CnsldtnDiffAmtInTransCrcy,
  item.CnsldtnUntAmtInGrpCrcy AS CnsldtnUntAmtInGrpCrcy,
  item.CnsldtnPrtnUntAmtInGrpCrcy AS CnsldtnPrtnUntAmtInGrpCrcy,
  item.CnsldtnDifferenceAmtInGrpCrcy AS CnsldtnDifferenceAmtInGrpCrcy,
  item.CnsldtnUntQtyInBsUnt AS CnsldtnUntQtyInBsUnt,
  item.CnsldtnPrtnUntQtyInBsUnt AS CnsldtnPrtnUntQtyInBsUnt,
  item.CnsldtnDiffQtyInBsUnt AS CnsldtnDiffQtyInBsUnt,
  item.GLRecordType AS GLRecordType,
  item.ConsolidationVersion AS ConsolidationVersion,
  item.TransactionCurrency AS TransactionCurrency,
  item.LocalCurrency AS LocalCurrency,
  item.GroupCurrency AS GroupCurrency,
  item.BaseUnit AS BaseUnit,
  item.FiscalPeriod AS FiscalPeriod,
  item.FiscalYearPeriod AS FiscalYearPeriod,
  item.DocumentCategory AS DocumentCategory,
  item.Company AS Company,
  item.ConsolidationUnit AS ConsolidationUnit,
  item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  item.ConsolidationDocumentType AS ConsolidationDocumentType,
  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.ConsolidationAcquisitionYear AS ConsolidationAcquisitionYear,
  item.ConsolidationAcquisitionPeriod AS ConsolidationAcquisitionPeriod,
  item.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  item.InvestorConsolidationUnit AS InvestorConsolidationUnit,
  item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  item.AmountInLocalCurrency AS AmountInLocalCurrency,
  item.AmountInGroupCurrency AS AmountInGroupCurrency,
  item.CnsldtnQuantityInBaseUnit AS CnsldtnQuantityInBaseUnit,
  item.DocumentItemText AS DocumentItemText,
  item.ConsolidationPostgItemAutoFlag AS ConsolidationPostgItemAutoFlag,
  item.BusinessTransactionType AS BusinessTransactionType,
  item.IntercompanyTransaction AS IntercompanyTransaction,
  item.PostingDate AS PostingDate,
  item.CurrencyTranslationDate AS CurrencyTranslationDate,
  item.RefConsolidationDocumentNumber AS RefConsolidationDocumentNumber,
  item.ReferenceFiscalYear AS ReferenceFiscalYear,
  item.RefConsolidationPostingItem AS RefConsolidationPostingItem,
  item.RefConsolidationDocumentType AS RefConsolidationDocumentType,
  item.RefBusinessTransactionType AS RefBusinessTransactionType,
  item.CreationDateTime AS CreationDateTime,
  item.CreationDate AS CreationDate,
  item.CreationTime AS CreationTime,
  item.CnsldtnGroupJrnlEntryBundle AS CnsldtnGroupJrnlEntryBundle,
  item.InvestmentActivityType AS InvestmentActivityType,
  item.InvestmentActivity AS InvestmentActivity,
  item.ReferenceDocumentType AS ReferenceDocumentType,
  item.ReferenceDocumentContext AS ReferenceDocumentContext,
  item.LogicalSystem AS LogicalSystem,
  item.ChartOfAccounts AS ChartOfAccounts,
  item.GLAccount AS GLAccount,
  item.DocumentReferenceID AS DocumentReferenceID,
  item.AssignmentReference AS AssignmentReference,
  item.CostCenter AS CostCenter,
  item.ProfitCenter AS ProfitCenter,
  item.FunctionalArea AS FunctionalArea,
  item.BusinessArea AS BusinessArea,
  item.ControllingArea AS ControllingArea,
  item.Segment AS Segment,
  item.PartnerCostCenter AS PartnerCostCenter,
  item.PartnerProfitCenter AS PartnerProfitCenter,
  item.PartnerFunctionalArea AS PartnerFunctionalArea,
  item.PartnerBusinessArea AS PartnerBusinessArea,
  item.PartnerCompany AS PartnerCompany,
  item.PartnerSegment AS PartnerSegment,
  item.OrderID AS OrderID,
  item.Customer AS Customer,
  item.Supplier AS Supplier,
  item.Material AS Material,
  item.Product AS Product,
  item.MaterialGroup AS MaterialGroup,
  item.ProductGroup AS ProductGroup,
  item.Plant AS Plant,
  item.FinancialTransactionType AS FinancialTransactionType,
  item.WBSElementInternalID AS WBSElementInternalID,
  item.WBSElementExternalID AS WBSElementExternalID,
  item.Project AS Project,
  item.BillingDocumentType AS BillingDocumentType,
  item.SalesOrganization AS SalesOrganization,
  item.DistributionChannel AS DistributionChannel,
  item.OrganizationDivision AS OrganizationDivision,
  item.SoldMaterial AS SoldMaterial,
  item.SoldProduct AS SoldProduct,
  item.SoldProductGroup AS SoldProductGroup,
  item.CustomerGroup AS CustomerGroup,
  item.CustomerSupplierCountry AS CustomerSupplierCountry,
  item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  item.SalesDistrict AS SalesDistrict,
  item.BillToParty AS BillToParty,
  item.ShipToParty AS ShipToParty,
  item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  item.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  item.FinancialServicesBranch AS FinancialServicesBranch,
  item.FinancialDataSource AS FinancialDataSource,
  item.Fund AS Fund,
  item.GrantID AS GrantID,
  item.CashLedgerAccount AS CashLedgerAccount,
  item.FinancialManagementArea AS FinancialManagementArea,
  item.CnsldtnCashLedgerChartOfAccts AS CnsldtnCashLedgerChartOfAccts,
  item.PartnerFund AS PartnerFund,
  item.GHGCategory AS GHGCategory,
  item.GHGScope AS GHGScope,
  item.GHGScope2CalculationMethod AS GHGScope2CalculationMethod,
  item.GHGScope2ContractualInstrument AS GHGScope2ContractualInstrument,
  item.SustainabilityModeOfTransport AS SustainabilityModeOfTransport,
  item.GHGDataQualityCharacteristic AS GHGDataQualityCharacteristic,
  item.GHGEnergyClassification AS GHGEnergyClassification,
  item.GHGEnergyMix AS GHGEnergyMix,
  item.GHGEnergySourcingType AS GHGEnergySourcingType,
  item.CnsldtnAdhocItem AS CnsldtnAdhocItem,
  item.CnsldtnAdhocSet AS CnsldtnAdhocSet,
  item.CnsldtnAdhocSetItem AS CnsldtnAdhocSetItem,
  item.MatchingReasonCode AS MatchingReasonCode,
  item.OriginType AS OriginType,
  item.OriginReference AS OriginReference,
  _CnsldtnRecnclnHdr.FiscalYear AS FiscalYear
FROM P_CnsldtnRecnclnItemStrct AS item
LEFT OUTER JOIN I_CnsldtnTaskLogHeader AS _CnsldtnRecnclnHdr ON CnsldtnTaskLogUUID = _CnsldtnRecnclnHdr.CnsldtnTaskLogUUID  -- association [1..1]
;