C_CnsldtnRpt30Q

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 C_CnsldtnRpt30Q.
-- 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: CSRPT30Q
-- Parameters: P_FiscalYear : ryear, P_FiscalPeriod : poper, P_FiscalYearVariant : fis_periv, P_ConsolidationUnitHierarchy : fincs_hryid_consunit, P_ConsolidationPrftCtrHier : fincs_hryid_profitcenter, P_ConsolidationSegmentHier : fincs_hryid_segment, P_KeyDate : vdm_v_key_date

CREATE VIEW C_CnsldtnRpt30Q AS
SELECT
  lookupEntity: 'I_CnsldtnGlobalParameter' AS lookupEntityI_CnsldtnGlobalParameter,
  resultElement: 'FiscalYear' AS resultElementFiscalYearP_FiscalYearryear,
  resultElement: 'FiscalYearVariant' AS resultElementFiscalYearVariant,
  resultElement: 'FiscalPeriodEndDate' AS resultElementFiscalPeriodEndDate,
  binding: [ { targetElement: 'FiscalYear', type : #PARAMETER, value: 'P_FiscalYear' AS P_ConsolidationUnitHierarchy,
  P_ConsolidationPrftCtrHier : $parameters.P_ConsolidationPrftCtrHier AS P_ConsolidationPrftCtrHier,
  P_ConsolidationSegmentHier : $parameters.P_ConsolidationSegmentHier AS P_ConsolidationSegmentHier,
  ConsolidationVersion,
  ConsolidationVersionElement,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  PeriodMode,
  ConsolidationDimension,
  ConsolidationGroup,
  InvestmentActivityType,
  ConsolidationUnitForElim,
  ConsolidationUnit,
  FinancialStatementItem,
  SubItemCategory,
  SubItem,
  PartnerConsolidationUnit,
  PostingLevel,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  InvesteeConsolidationUnit,
  PostingDate,
  InvestmentActivity,
  InvestorConsolidationUnit,
  AmountInTransactionCurrency,
  cast ( 1 as fincs_sign_adjd_amt_trans_crcy ) AS CnsldtnSignAdjdAmtInTransCrcy,
  AmountInLocalCurrency,
  cast ( 1 as fincs_sign_adjd_amt_local_crcy ) AS CnsldtnSignAdjdAmtInLocalCrcy,
  AmountInGroupCurrency,
  cast ( 1 as fincs_sign_adjd_amt_group_crcy ) AS CnsldtnSignAdjdAmtInGroupCrcy,
  CnsldtnQuantityInBaseUnit,
  cast ( 1 as fincs_sign_adjd_qty_base_unit ) AS CnsldtnSignAdjdQtyInBaseUnit,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  ConsolidationPrftCtrForElim,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  ConsolidationSegmentForElim,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  Plant,
  FinancialTransactionType,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  MaterialGroup,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginType,
  OriginReference,
  GLRecordType,
  CnsldtnGroupJrnlEntry,
  CnsldtnGroupJrnlEntryBundle,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  CreationDateTime,
  GHGCategory,
  GHGScope,
  GHGScope2CalculationMethod,
  GHGScope2ContractualInstrument,
  GHGDataQualityCharacteristic,
  GHGEnergyClassification,
  GHGEnergyMix,
  GHGEnergySourcingType,
  SustainabilityModeOfTransport,
  FinancialManagementArea,
  Fund,
  GrantID,
  CnsldtnCashLedgerChartOfAccts,
  CashLedgerAccount,
  PartnerFund,
  :P_ConsolidationUnitHierarchy AS ConsolidationUnitHierarchy,
  :P_ConsolidationSegmentHier AS ConsolidationSegmentHierarchy,
  :P_ConsolidationPrftCtrHier AS ConsolidationPrftCtrHierarchy,
  :P_KeyDate AS KeyDate
FROM I_MatrixCnsldtnFndnCube
;