I_FundAcctgBalanceItemC

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_FundAcctgBalanceItemC.
-- 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: IFABALANCEITEMC
-- Parameters: P_FinancialStatementVersion : hryid, P_CompanyCode : bukrs, P_Ledger : fins_ledger, P_FiscalYear : fis_gjahr_no_conv, P_ToFiscalPeriod : fis_period_to, P_ComparisonFiscalYear : fis_gjahr_cmp_no_conv, P_ToComparisonFiscalPeriod : fis_period_to_cmp

CREATE VIEW I_FundAcctgBalanceItemC AS
SELECT
  BalItm.Ledger AS Ledger,
  BalItm.SourceLedger AS SourceLedger,
  BalItm.CompanyCode AS CompanyCode,
  BalItm.FiscalYear AS FiscalYear,
  BalItm.AccountingDocument AS AccountingDocument,
  BalItm.LedgerGLLineItem AS LedgerGLLineItem,
  BalItm.GLAccountHierarchy AS GLAccountHierarchy,
  case when BalItm.FiscalYear = $parameters.P_ComparisonFiscalYear then case BalItm.SemanticTag when 'PL_RESULT' then cast ( 'C_CMP_PL' as fins_sem_tag ) when 'FUND_BAL' then cast ( 'C_CMP_FB' as fins_sem_tag ) when 'CSH_CSHEQV' then cast ( 'C_CMP_CEQV' as fins_sem_tag ) else BalItm.SemanticTag end else case BalItm.SemanticTag when 'PL_RESULT' then cast ( 'C_PL' as fins_sem_tag ) else BalItm.SemanticTag end end as SemanticTag AS SemanticTagendendasSemanticTag,
  BalItm.ValidityStartDate AS ValidityStartDate,
  BalItm.ValidityEndDate AS ValidityEndDate,
  I_FiscalYearPeriod.FiscalPeriod AS FiscalPeriod,
  BalItm.FiscalYearVariant AS FiscalYearVariant,
  PostingDate,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  case when ( I_FiscalYearPeriod.FiscalPeriod = $parameters.P_ToFiscalPeriod and I_FiscalYearPeriod.FiscalYear = $parameters.P_FiscalYear ) then AmountInCompanyCodeCurrency else cast( 0 as abap.dec(23,2)) end as AmtInCoCodeCrcyPerFiscalYear AS dec232endasAmtInCoCodeCrcyPerFiscalYear,
  FinancialManagementArea,
  FunctionalArea,
  Fund,
  _Fund.FundType AS FundType,
  GrantID,
  _Grant._GrantType.GrantType AS GrantType,
  BalItm.AccountAssignmentType AS AccountAssignmentType,
  WBSElementExternalID,
  CostCenter,
  GLAccount,
  ProfitCenter,
  BusinessArea,
  Segment,
  ControllingArea,
  ValuationArea,
  FinancialAccountType,
  _Grant.GrantIsNotRelevantGrant AS GrantIsNotRelevantGrant,
  _Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  _Grant._Sponsor AS _Sponsor,
  AssetClass,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Supplier,
  ServiceDocument,
  ServiceDocumentType,
  SalesDocument,
  OrderID,
  Customer,
  AccountingDocumentType
FROM I_GLAccountLineItemSemTag AS BalItm
INNER JOIN I_FiscalYearPeriod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FundType AS _FundType ON FinancialManagementArea = _FundType.FinancialManagementArea AND fundtype = _FundType.FundType  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GrantType AS _GrantType ON granttype = _GrantType.GrantType  -- association [0..1]
-- UNION ALL with additional select branch(es): I_GLAccountLineItemSemTag
;