P_VECReportedFinancialData

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 P_VECReportedFinancialData.
-- 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: PVECREPFINDATA
-- Parameters: p_rdimen : fc_dimen, p_ritclg : fc_itclg, p_rvers : fc_rvers, p_rldnr : rldnr, p_ryear : gjahr, p_pyear : gjahr, p_poper : poper

CREATE VIEW P_VECReportedFinancialData AS
SELECT
  '01' AS TaskType,
  'LC' AS CurrencyType,
  docnr AS ConsolidationDocumentNumber,
  docln AS ConsolidationPostingItem,
  rhcur AS Currency,
  rtcur AS TransactionCurrency,
  rdimen AS ConsolidationDimension,
  rldnr AS ConsolidationLedger,
  docct AS DocumentCategory,
  rcomp AS Company,
  rbunit AS Entity,
  rbunit AS ConsolidationUnit,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  rbuptr AS PartnerConsolidationUnit,
  sityp AS SubItemCategory,
  subit AS SubItem,
  poper AS PostingFiscalPeriod,
  ryear AS FiscalYear,
  '' AS OpeningBalanceAmount,
  '' AS YearToDateAmount,
  '' AS YearToDateAmountInPriorPeriod,
  '' AS YearToDateAmountInPriorYear,
  hsl AS CurrentPeriodAmount,
  tsl AS PeriodAmountInTransacCrcy,
  '' AS PeriodAmountInPriorPeriod,
  '' AS PeriodAmountInPriorYear,
  rrcty AS RecordType,
  plevl AS PostingLevel,
  docty AS ConsolidationDocumentType,
  yracq AS ConsolidationAcquisitionYear,
  pracq AS ConsolidationAcquisitionPeriod,
  coicu AS InvesteeConsolidationUnit,
  autom AS ConsolidationPostgItemAutoFlag,
  refdocct AS RefConsolidationDocumentType,
  coiac AS InvestmentActivityType,
  coinr AS InvestmentActivity,
  ktopl AS ChartOfAccounts,
  racct AS GLAccount,
  runit AS BaseUnit,
  msl AS CurrentPeriodQuantity,
  rcntr AS CostCenter,
  prctr AS ProfitCenter,
  rfarea AS FunctionalArea,
  rbusa AS BusinessArea,
  kokrs AS ControllingArea,
  Segment,
  scntr AS PartnerCostCenter,
  pprctr AS PartnerProfitCenter,
  sfarea AS PartnerFunctionalArea,
  sbusa AS PartnerBusinessArea,
  rassc AS PartnerCompany,
  psegment AS PartnerSegment,
  matkl_mm AS MaterialGroup,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  ps_posid AS WBSElementExternalID,
  ps_pspid AS Project,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  konzs AS CustomerSupplierCorporateGroup,
  timestamp AS CreationDateTime,
  robukrs AS CompanyCode,
  kunwe AS ShipToParty,
  kunre AS BillToParty,
  matnr AS Material,
  matnr_copa AS SoldProduct,
  rtflg AS CurrencyConversionsDiffType,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet
FROM P_ReportedFinancialData
INNER JOIN I_CnsldtnGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
;