I_FinStmntBalShtIncStmntC

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_FinStmntBalShtIncStmntC.
-- 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.
-- Parameters: P_KeyDate : sydatum, P_GLAccountHierarchyKeyDate : fis_glaccthier_keydate, P_FinancialStatementHierarchy : hryid, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_LedgerFiscalYear : fis_gjahr_no_conv, P_FromComparisonFiscalPeriod : fis_period_from_cmp, P_ToComparisonFiscalPeriod : fis_period_to_cmp, P_ComparisonLedgerFiscalYear : fis_gjahr_cmp_no_conv, P_Ledger : fins_ledger, P_ComparisonLedger : fis_ledger_cmp, P_CurrencyRole : fis_curtp, P_PlanningCategory : fcom_category, P_FinancialStatementSection : bsis_section

CREATE VIEW I_FinStmntBalShtIncStmntC AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  cast( FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  ControllingArea,
  ChartOfAccounts,
  ChartOfAccounts AS BalShtIncStmntItmChtOfAccts,
  GLAccount,
  cast(concat(ChartOfAccounts,concat(GLAccount,'0A')) as fins_fsleafit) AS FinancialStatementLeafItem,
  cast( '0A' as bsis_item_suffix ) AS BalShtIncStatementItemSuffix,
  cast(GLAccount as bsis_item) AS BalSheetIncomeStatementItem,
  ProfitCenter,
  FunctionalArea,
  FiscalPeriod,
  FiscalYearVariant,
  _GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount,
  _CompanyCode.CountryChartOfAccounts AS CountryChartOfAccounts,
  _CompanyCode._CountryChartOfAccounts AS _CountryChartOfAccounts,
  Segment,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  AccountingDocumentType,
  ProductGroup,
  Product,
  CostCenter,
  AssetClass,
  MasterFixedAsset,
  SoldProduct,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  cast (CompanyCodeCurrency as fis_waers) AS Currency,
  AmountInCompanyCodeCurrency AS PeriodBalanceAmount,
  AmountInCompanyCodeCurrency AS ComparisonPeriodBalanceAmount,
  cast( ' ' as fis_zerobalance preserving type ) AS ZeroBalanceAccountIsDisplayed,
  cast( ' ' as fis_inclyearendpostings preserving type ) AS YrEndClsgPostingIsDisplayed,
  GLRecordType,
  BusinessTransactionCategory,
  cast( GLAccount as nodevalue ) AS HierarchyNodeVal,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  HouseBank,
  HouseBankAccount,
  cast( '' as bu_partner ) AS NettingPartnerNumber,
  DistributionChannel,
  FinancialAccountType,
  OrganizationDivision,
  SalesOrganization,
  ValuationArea,
  Customer,
  OrderID,
  SalesDocument,
  ServiceDocument,
  ServiceDocumentType,
  Supplier,
  PostingDate
FROM I_GLAccountLineItem
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_FinancialStatementLeafItem AS _FinancialStatementLeafItem ON FinancialStatementLeafItem = _FinancialStatementLeafItem.FinancialStatementLeafItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorpGroupChartOfAccounts ON CorporateGroupChartOfAccounts = _CorpGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ZeroBalAccountIsDisplayed ON ZeroBalanceAccountIsDisplayed = _ZeroBalAccountIsDisplayed.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _YrEndClsgPostingIsDisplayed ON YrEndClsgPostingIsDisplayed = _YrEndClsgPostingIsDisplayed.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON NettingPartnerNumber = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccountsFSItem ON BalShtIncStmntItmChtOfAccts = _ChartOfAccountsFSItem.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_BalShtIncStmntItemSuffix AS _Suffix ON BalShtIncStatementItemSuffix = _Suffix.BalShtIncStatementItemSuffix  -- association [0..1]
LEFT OUTER JOIN I_BalShtIncomeStatementItem AS _FSItem ON BalSheetIncomeStatementItem = _FSItem.BalSheetIncomeStatementItem AND BalShtIncStmntItmChtOfAccts = _FSItem.ChartOfAccounts AND BalShtIncStatementItemSuffix = _FSItem.BalShtIncStatementItemSuffix  -- association [0..1]
;