A_OpeningBalance

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_OpeningBalance.
-- 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: AFIOPENBALANCE

CREATE VIEW A_OpeningBalance AS
SELECT
  Ledger,
  _Ledger._Text[1:Language = $session.system_language].LedgerName AS LedgerName,
  LedgerFiscalYear,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  GLAccount,
  CostCenter,
  _CostCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  Segment,
  _Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  _PartnerBusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS PartnerBusinessAreaName,
  PartnerCompany,
  PartnerSegment,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  CostSourceUnit,
  ValuationQuantity,
  '001' AS FiscalPeriod,
  FiscalYearVariant,
  cast( cast(concat(LedgerFiscalYear, '001') as abap.char(7)) as fis_jahrper_c preserving type ) AS FiscalYearPeriod,
  ChartOfAccounts,
  Plant,
  Customer,
  ControllingDebitCreditCode,
  Project,
  _ProjectBasicData.ProjectDescription AS ProjectDescription,
  WBSElement,
  _WBSElementBasicData.WBSDescription AS WBSElementDescription,
  PartnerCompanyCode,
  _PartnerCompanyCode.CompanyCodeName AS PartnerCompanyCodeName,
  CostCtrActivityType,
  _CostCtrActivityType[1:ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date]._Text[1:Language = $session.system_language].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  OrderID,
  PartnerOrder_2 AS PartnerOrder,
  PartnerCostCtrActivityType,
  PartnerProject,
  _PartnerProjectBasicData.ProjectDescription AS PartnerProjectDescription,
  PartnerWBSElement,
  _PartnerWBSElementBasicData.WBSDescription AS PartnerWBSElementDescription,
  SalesOrganization,
  _SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  OrganizationDivision,
  SoldMaterial,
  _SoldMaterial._Text[1:Language = $session.system_language].MaterialName AS SoldMaterialName,
  MaterialGroup,
  _MaterialGroup._Text[1:Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  CustomerGroup,
  _CustomerGroup._Text[1:Language = $session.system_language].CustomerGroupName AS CustomerGroupName,
  CustomerSupplierCountry,
  _CustomerSupplierCountry._Text[1:Language = $session.system_language].CountryName AS CustomerSupplierCountryName,
  CustomerSupplierIndustry,
  SalesDistrict,
  _SalesDistrict._Text[1:Language = $session.system_language].SalesDistrictName AS SalesDistrictName
FROM I_GLAccountLineItemCube
LEFT OUTER JOIN A_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN A_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN A_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN A_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
;