A_CnsldtnReportedAnswer

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 A_CnsldtnReportedAnswer.
-- 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 A_CnsldtnReportedAnswer AS
SELECT
  _Source.ConsolidationReportedAnswer AS ConsolidationReportedAnswer,
  _Source.FiscalYear AS FiscalYear,
  _Source.FiscalPeriod AS FiscalPeriod,
  _Source.FiscalYearPeriod AS FiscalYearPeriod,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  _Source.ConsolidationUnit AS ConsolidationUnit,
  _Source.ConsolidationPostingLevel AS ConsolidationPostingLevel,
  _Source.ConsolidationDocumentType AS ConsolidationDocumentType,
  _Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Source.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  _Source.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  _Source.CnsldtnSubitem AS CnsldtnSubitem,
  _Source.Company AS Company,
  _Source.CnsldtnAdhocItem AS CnsldtnAdhocItem,
  _Source.CnsldtnAdhocSet AS CnsldtnAdhocSet,
  _Source.CnsldtnAdhocSetItem AS CnsldtnAdhocSetItem,
  _Source.Segment AS Segment,
  _Source.ControllingArea AS ControllingArea,
  _Source.CostCenter AS CostCenter,
  _Source.ProfitCenter AS ProfitCenter,
  _Source.FunctionalArea AS FunctionalArea,
  _Source.BusinessArea AS BusinessArea,
  _Source.ChartOfAccounts AS ChartOfAccounts,
  _Source.GLAccount AS GLAccount,
  _Source.OrderID AS OrderID,
  _Source.Customer AS Customer,
  _Source.Supplier AS Supplier,
  _Source.Material AS Material,
  _Source.Product AS Product,
  _Source.MaterialGroup AS MaterialGroup,
  _Source.ProductGroup AS ProductGroup,
  _Source.Plant AS Plant,
  _Source.FinancialTransactionType AS FinancialTransactionType,
  _Source.BillingDocumentType AS BillingDocumentType,
  _Source.SalesOrganization AS SalesOrganization,
  _Source.DistributionChannel AS DistributionChannel,
  _Source.OrganizationDivision AS OrganizationDivision,
  _Source.CustomerGroup AS CustomerGroup,
  _Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  _Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  _Source.SalesDistrict AS SalesDistrict,
  _Source.BillToParty AS BillToParty,
  _Source.ShipToParty AS ShipToParty,
  _Source.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  _Source.FinancialServicesBranch AS FinancialServicesBranch,
  _Source.FinancialDataSource AS FinancialDataSource,
  _Source.FinancialManagementArea AS FinancialManagementArea,
  _Source.Fund AS Fund,
  _Source.PartnerFund AS PartnerFund,
  _Source.GrantID AS GrantID,
  _Source.CnsldtnCashLedgerChartOfAccts AS CnsldtnCashLedgerChartOfAccts,
  _Source.CashLedgerAccount AS CashLedgerAccount,
  _Source.GHGScope AS GHGScope,
  _Source.GHGCategory AS GHGCategory,
  _Source.GHGScope2CalculationMethod AS GHGScope2CalculationMethod,
  _Source.GHGScope2ContractualInstrument AS GHGScope2ContractualInstrument,
  _Source.SustainabilityModeOfTransport AS SustainabilityModeOfTransport,
  _Source.GHGDataQualityCharacteristic AS GHGDataQualityCharacteristic,
  _Source.GHGEnergyClassification AS GHGEnergyClassification,
  _Source.GHGEnergyMix AS GHGEnergyMix,
  _Source.GHGEnergySourcingType AS GHGEnergySourcingType,
  _Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  _Source.PartnerCostCenter AS PartnerCostCenter,
  _Source.PartnerProfitCenter AS PartnerProfitCenter,
  _Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  _Source.PartnerBusinessArea AS PartnerBusinessArea,
  _Source.PartnerCompany AS PartnerCompany,
  _Source.PartnerSegment AS PartnerSegment,
  _Source.ConsolidationQuestion AS ConsolidationQuestion,
  _Source.ConsolidationPredefinedAnswer AS ConsolidationPredefinedAnswer,
  _Source.ConsolidationFreeTextAnswer AS ConsolidationFreeTextAnswer,
  _Source.CreatedByUser AS CreatedByUser,
  _Source.CreatedAtDate AS CreatedAtDate,
  _Source.CreatedAtTime AS CreatedAtTime,
  _Source.CreatedAtDateTime AS CreatedAtDateTime,
  _Source.LastChangedByUser AS LastChangedByUser,
  _Source.LastChangedAtDate AS LastChangedAtDate,
  _Source.LastChangedAtTime AS LastChangedAtTime,
  _Source.LastChangedAtDateTime AS LastChangedAtDateTime
FROM R_CnsldtnReportedAnswerTP
;