I_ConsolidationGroupRptEnhcdC

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_ConsolidationGroupRptEnhcdC.
-- 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: ICCGRPRPTENHANC
-- Parameters: P_ConsolidationRptgItemHier : fincs_rihry, P_ConsolidationRptgRuleID : fincs_rptid

CREATE VIEW I_ConsolidationGroupRptEnhcdC AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  DebitCreditCode,
  Company,
  cast ( ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  cast ( PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  cast ( InvesteeConsolidationUnit as fincs_investeeconsunit preserving type ) AS InvesteeConsolidationUnit,
  cast ( QuantityInBaseUnit as quan1_12 ) AS YTDQtyInCnsldtnBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  Plant,
  FinancialTransactionType,
  WBSElement,
  Project,
  ConsolidationRecordNumber,
  cast ( ConsolidationReportingItem as fincs_ritem ) AS ConsolidationReportingItem,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup
FROM P_CnsldtnFndnWithRptRules
LEFT OUTER JOIN I_CnsldtnRptgItem AS _RptgItm ON ConsolidationChartOfAccounts = _RptgItm.ConsolidationChartOfAccounts AND ConsolidationReportingItem = _RptgItm.ConsolidationReportingItem  -- association [0..1]
;