FINCS_REPRULE_RUNTIME

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 FINCS_REPRULE_RUNTIME.
-- 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 FINCS_REPRULE_RUNTIME AS
SELECT
  _Source.itclg AS ConsolidationChartOfAccounts,
  _Source.rihry AS ConsolidationReportingItemHier,
  _Source.rptid AS ConsolidationReportingRuleID,
  _Source.repitem AS ConsolidationReportingItem,
  _Source.posnr AS SequenceNumber,
  _Source.iatvs AS CnsldtnFSItemAttributeVersion,
  _Source.cuavs AS CnsldtnUnitAttributeVersion,
  _Source.fromyearper AS FromFiscalYearPeriod,
  _Source.sityp AS SubItemCategory,
  _Source.toyearper AS ToFiscalYearPeriod,
  _Source.docty AS ConsolidationDocumentType,
  _Source.ritem AS FinancialStatementItem,
  _Source.rbunit AS ConsolidationUnit,
  _Source.revsign AS ConsolidationReverseSign,
  _Source.rbuptr AS PartnerConsolidationUnit,
  _Source.rcomp AS Company,
  _Source.ritem AS CnsldtnFinancialStatementItem,
  _Source.rcongr AS ConsolidationGroup,
  _Source.sityp AS CnsldtnSubitemCategory,
  _Source.subit AS CnsldtnSubitem,
  _Source.plevl AS ConsolidationPostingLevel,
  _Source.adhocitem AS CnsldtnAdhocItem,
  _Source.adhocset AS CnsldtnAdhocSet,
  _Source.adhocsetitem AS CnsldtnAdhocSetItem,
  _Source.ktopl AS ChartOfAccounts,
  _Source.racct AS GLAccount,
  _Source.rcntr AS CostCenter,
  _Source.prctr AS ProfitCenter,
  _Source.rfarea AS FunctionalArea,
  _Source.rbusa AS BusinessArea,
  _Source.kokrs AS ControllingArea,
  _Source.segment AS Segment,
  _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.konzs AS CustomerSupplierCorporateGroup,
  _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
FROM fincs_rr_rt AS _Source
;