I_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 I_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 I_CnsldtnReportedAnswer AS
SELECT
  _Source.reported_answer AS ConsolidationReportedAnswer,
  _Source.ryear AS FiscalYear,
  _Source.poper AS FiscalPeriod,
  _Source.fiscyearper AS FiscalYearPeriod,
  _Source.rvers AS ConsolidationVersion,
  _Source.rbunit AS ConsolidationUnit,
  _Source.plevl AS ConsolidationPostingLevel,
  _Source.docty AS ConsolidationDocumentType,
  _Source.ritclg AS ConsolidationChartOfAccounts,
  _Source.ritem AS CnsldtnFinancialStatementItem,
  _Source.sityp AS CnsldtnSubitemCategory,
  _Source.subit AS CnsldtnSubitem,
  _Source.rcomp AS Company,
  _Source.adhocitem AS CnsldtnAdhocItem,
  _Source.adhocset AS CnsldtnAdhocSet,
  _Source.adhocsetitem AS CnsldtnAdhocSetItem,
  _Source.segment AS Segment,
  _Source.kokrs AS ControllingArea,
  _Source.rcntr AS CostCenter,
  _Source.prctr AS ProfitCenter,
  _Source.rfarea AS FunctionalArea,
  _Source.rbusa AS BusinessArea,
  _Source.ktopl AS ChartOfAccounts,
  _Source.racct AS GLAccount,
  _Source.aufnr AS OrderID,
  _Source.kunnr AS Customer,
  _Source.lifnr AS Supplier,
  _Source.matnr AS Material,
  _Source.matnr_copa AS Product,
  _Source.matkl_mm AS MaterialGroup,
  _Source.matkl AS ProductGroup,
  _Source.werks AS Plant,
  _Source.rmvct AS FinancialTransactionType,
  _Source.fkart AS BillingDocumentType,
  _Source.vkorg AS SalesOrganization,
  _Source.vtweg AS DistributionChannel,
  _Source.spart AS OrganizationDivision,
  _Source.kdgrp AS CustomerGroup,
  _Source.land1 AS CustomerSupplierCountry,
  _Source.brsch AS CustomerSupplierIndustry,
  _Source.bzirk AS SalesDistrict,
  _Source.kunre AS BillToParty,
  _Source.kunwe AS ShipToParty,
  _Source.fs_product_group AS FinancialServicesProductGroup,
  _Source.branch_id AS FinancialServicesBranch,
  _Source.datasource_id AS FinancialDataSource,
  _Source.fikrs AS FinancialManagementArea,
  _Source.rfund AS Fund,
  _Source.sfund AS PartnerFund,
  _Source.rgrant_nbr AS GrantID,
  _Source.re_ktopl AS CnsldtnCashLedgerChartOfAccts,
  _Source.re_account AS CashLedgerAccount,
  _Source.ghgscope AS GHGScope,
  _Source.ghgcategory AS GHGCategory,
  _Source.ghgscp2calcmeth AS GHGScope2CalculationMethod,
  _Source.ghgscp2contrinstr AS GHGScope2ContractualInstrument,
  _Source.susmodeoftransport AS SustainabilityModeOfTransport,
  _Source.ghgdtaqltycharc AS GHGDataQualityCharacteristic,
  _Source.ghgenergyclass AS GHGEnergyClassification,
  _Source.ghgenergymix AS GHGEnergyMix,
  _Source.ghgengysrcgtype AS GHGEnergySourcingType,
  _Source.rbuptr AS PartnerConsolidationUnit,
  _Source.scntr AS PartnerCostCenter,
  _Source.pprctr AS PartnerProfitCenter,
  _Source.sfarea AS PartnerFunctionalArea,
  _Source.sbusa AS PartnerBusinessArea,
  _Source.rassc AS PartnerCompany,
  _Source.psegment AS PartnerSegment,
  _Source.question AS ConsolidationQuestion,
  _Source.predefined_answer AS ConsolidationPredefinedAnswer,
  _Source.free_text_answer AS ConsolidationFreeTextAnswer,
  _Source.created_by AS CreatedByUser,
  _Source.created_at_date AS CreatedAtDate,
  _Source.created_at_time AS CreatedAtTime,
  _Source.created_at_date_time AS CreatedAtDateTime,
  _Source.last_changed_by AS LastChangedByUser,
  _Source.last_changed_at_date AS LastChangedAtDate,
  _Source.last_changed_at_time AS LastChangedAtTime,
  _Source.last_changed_at_date_time AS LastChangedAtDateTime
FROM fincs_rptdansw AS _Source
LEFT OUTER JOIN E_CnsldtnReportedAnswer AS _Extension ON ConsolidationReportedAnswer = _Extension.ConsolidationReportedAnswer  -- association [1..1]
;