P_CnsldtnRecnclnItemStrct

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