I_FinSGLCnsldtnADB

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_FinSGLCnsldtnADB.
-- 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_FinSGLCnsldtnADB AS
SELECT
  runid AS FinSGLRunUUID,
  id AS FinSGLItemID,
  rldnr AS Ledger,
  rbukrs AS CompanyCode,
  ryear AS FiscalYear,
  poper AS FiscalPeriod,
  usnam AS AccountingDocCreatedByUser,
  timestamp AS CreationDateTime,
  rtcur AS BalanceTransactionCurrency,
  rwcur AS TransactionCurrency,
  rhcur AS CompanyCodeCurrency,
  rkcur AS GlobalCurrency,
  rfccur AS FunctionalCurrency,
  rocur AS FreeDefinedCurrency1,
  rvcur AS FreeDefinedCurrency2,
  rbcur AS FreeDefinedCurrency3,
  rccur AS FreeDefinedCurrency4,
  rdcur AS FreeDefinedCurrency5,
  recur AS FreeDefinedCurrency6,
  rfcur AS FreeDefinedCurrency7,
  rgcur AS FreeDefinedCurrency8,
  m2davgbal_t AS MTDAvgDailyBalInBalTransCrcy,
  q2davgbal_t AS QTDAvgDailyBalInBalTransCrcy,
  y2davgbal_t AS YTDAvgDailyBalInBalTransCrcy,
  m2davgbal_h AS MTDAvgDailyBalInCCCrcy,
  q2davgbal_h AS QTDAvgDailyBalInCCCrcy,
  y2davgbal_h AS YTDAvgDailyBalInCCCrcy,
  m2davgbal_k AS MTDAvgDailyBalInGlobCrcy,
  q2davgbal_k AS QTDAvgDailyBalInGlobCrcy,
  y2davgbal_k AS YTDAvgDailyBalInGlobCrcy,
  m2davgbal_fc AS MTDAvgDailyBalInFuncnlCrcy,
  q2davgbal_fc AS QTDAvgDailyBalInFuncnlCrcy,
  y2davgbal_fc AS YTDAvgDailyBalInFuncnlCrcy,
  m2davgbal_o AS MTDAvgDailyBalInFDCrcy1,
  q2davgbal_o AS QTDAvgDailyBalInFDCrcy1,
  y2davgbal_o AS YTDAvgDailyBalInFDCrcy1,
  m2davgbal_v AS MTDAvgDailyBalInFDCrcy2,
  q2davgbal_v AS QTDAvgDailyBalInFDCrcy2,
  y2davgbal_v AS YTDAvgDailyBalInFDCrcy2,
  m2davgbal_b AS MTDAvgDailyBalInFDCrcy3,
  q2davgbal_b AS QTDAvgDailyBalInFDCrcy3,
  y2davgbal_b AS YTDAvgDailyBalInFDCrcy3,
  m2davgbal_c AS MTDAvgDailyBalInFDCrcy4,
  q2davgbal_c AS QTDAvgDailyBalInFDCrcy4,
  y2davgbal_c AS YTDAvgDailyBalInFDCrcy4,
  m2davgbal_d AS MTDAvgDailyBalInFDCrcy5,
  q2davgbal_d AS QTDAvgDailyBalInFDCrcy5,
  y2davgbal_d AS YTDAvgDailyBalInFDCrcy5,
  m2davgbal_e AS MTDAvgDailyBalInFDCrcy6,
  q2davgbal_e AS QTDAvgDailyBalInFDCrcy6,
  y2davgbal_e AS YTDAvgDailyBalInFDCrcy6,
  m2davgbal_f AS MTDAvgDailyBalInFDCrcy7,
  q2davgbal_f AS QTDAvgDailyBalInFDCrcy7,
  y2davgbal_f AS YTDAvgDailyBalInFDCrcy7,
  m2davgbal_g AS MTDAvgDailyBalInFDCrcy8,
  q2davgbal_g AS QTDAvgDailyBalInFDCrcy8,
  y2davgbal_g AS YTDAvgDailyBalInFDCrcy8,
  ktopl AS ChartOfAccounts,
  racct AS GLAccount,
  xblnr AS ReferenceDocumentNumber,
  zuonr AS AssignmentReference,
  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,
  aufnr AS OrderID,
  kunnr AS Customer,
  lifnr AS Supplier,
  matnr AS Material,
  matkl_mm AS MaterialGroup,
  werks AS Plant,
  rmvct AS FinancialTransactionType,
  cast( ps_psp_pnr as fis_wbsint_no_conv ) AS WBSElementInternalID,
  cast( ps_posid as fis_wbs_no_conv preserving type ) AS WBSElementExternalID,
  cast( ps_pspid as fis_project_no_conv preserving type ) AS Project,
  fkart AS BillingDocumentType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS OrganizationDivision,
  matnr_copa AS SoldProduct,
  matkl AS SoldProductGroup,
  kdgrp AS CustomerGroup,
  land1 AS CustomerSupplierCountry,
  brsch AS CustomerSupplierIndustry,
  bzirk AS SalesDistrict,
  kunre AS BillToParty,
  kunwe AS ShipToParty,
  konzs AS CustomerSupplierCorporateGroup,
  rbunit AS ConsolidationUnit,
  rbuptr AS PartnerConsolidationUnit,
  rcomp AS Company,
  ritclg AS ConsolidationChartOfAccounts,
  ritem AS FinancialStatementItem,
  sityp AS SubItemCategory,
  subit AS SubItem
FROM gle_adb_gr_kfc
;