I_GLAccountFlowSemTag

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_GLAccountFlowSemTag.
-- 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_GLAccountFlowSemTag AS
SELECT
  P_ActualPlanGLAcctBalance.SourceLedger AS SourceLedger,
  P_ActualPlanGLAcctBalance.CompanyCode AS CompanyCode,
  P_ActualPlanGLAcctBalance.FiscalYear AS FiscalYear,
  P_ActualPlanGLAcctBalance.AccountingDocument AS AccountingDocument,
  P_ActualPlanGLAcctBalance.LedgerGLLineItem AS LedgerGLLineItem,
  P_ActualPlanGLAcctBalance.Ledger AS Ledger,
  P_ActualPlanGLAcctBalance.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActualPlanGLAcctBalance.ActualPlanCode AS ActualPlanCode,
  P_ActualPlanGLAcctBalance.PlanningCategory AS PlanningCategory,
  P_ActualPlanGLAcctBalance.ChartOfAccounts AS ChartOfAccounts,
  P_ActualPlanGLAcctBalance.ControllingArea AS ControllingArea,
  P_ActualPlanGLAcctBalance.GLAccount AS GLAccount,
  P_ActualPlanGLAcctBalance.CostCenter AS CostCenter,
  P_ActualPlanGLAcctBalance.ProfitCenter AS ProfitCenter,
  P_ActualPlanGLAcctBalance.FunctionalArea AS FunctionalArea,
  P_ActualPlanGLAcctBalance.BusinessArea AS BusinessArea,
  P_ActualPlanGLAcctBalance.Segment AS Segment,
  P_ActualPlanGLAcctBalance.Product AS Product,
  P_ActualPlanGLAcctBalance.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_ActualPlanGLAcctBalance.OrderType AS OrderType,
  P_ActualPlanGLAcctBalance.AssetClass AS AssetClass,
  P_ActualPlanGLAcctBalance.FinancialAccountType AS FinancialAccountType,
  P_ActualPlanGLAcctBalance.SalesOrganization AS SalesOrganization,
  P_ActualPlanGLAcctBalance.DistributionChannel AS DistributionChannel,
  P_ActualPlanGLAcctBalance.OrganizationDivision AS OrganizationDivision,
  P_ActualPlanGLAcctBalance.ServiceDocumentType AS ServiceDocumentType,
  P_ActualPlanGLAcctBalance.Plant AS Plant,
  P_ActualPlanGLAcctBalance.ValuationArea AS ValuationArea,
  P_ActualPlanGLAcctBalance.ServiceDocument AS ServiceDocument,
  P_ActualPlanGLAcctBalance.SalesDocument AS SalesDocument,
  P_ActualPlanGLAcctBalance.MasterFixedAsset AS MasterFixedAsset,
  P_ActualPlanGLAcctBalance.FixedAsset AS FixedAsset,
  P_ActualPlanGLAcctBalance.AccountingDocumentType AS AccountingDocumentType,
  P_ActualPlanGLAcctBalance.Customer AS Customer,
  P_ActualPlanGLAcctBalance.Supplier AS Supplier,
  P_ActualPlanGLAcctBalance.DebitCreditCode AS DebitCreditCode,
  P_ActualPlanGLAcctBalance.GLAccountType AS GLAccountType,
  P_ActualPlanGLAcctBalance.OrderID AS OrderID,
  P_ActualPlanGLAcctBalance.GLAccountFlowType AS GLAccountFlowType,
  P_ActualPlanGLAcctBalance.GLAccountTypeFlowType AS GLAccountTypeFlowType,
  P_ActualPlanGLAcctBalance.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_ActualPlanGLAcctBalance.GLAccountHierarchy AS GLAccountHierarchy,
  P_ActualPlanGLAcctBalance.HierarchyNode AS HierarchyNode,
  P_ActualPlanGLAcctBalance.SemanticTag AS SemanticTag,
  P_ActualPlanGLAcctBalance.ValidityEndDate AS ValidityEndDate,
  P_ActualPlanGLAcctBalance.ValidityStartDate AS ValidityStartDate,
  P_ActualPlanGLAcctBalance.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_ActualPlanGLAcctBalance.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_ActualPlanGLAcctBalance.GlobalCurrency AS GlobalCurrency,
  P_ActualPlanGLAcctBalance.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_ActualPlanGLAcctBalance.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  cast(( P_ActualPlanGLAcctBalance.AmountInGlobalCurrency * -1 ) as fis_ksl_inverted ) AS InvertedAmountInGlobalCurrency,
  P_ActualPlanGLAcctBalance.CostSourceUnit AS CostSourceUnit,
  P_ActualPlanGLAcctBalance.ValuationQuantity AS ValuationQuantity,
  P_ActualPlanGLAcctBalance.FiscalPeriod AS FiscalPeriod,
  P_ActualPlanGLAcctBalance.FiscalYearVariant AS FiscalYearVariant,
  P_ActualPlanGLAcctBalance.FiscalYearPeriod AS FiscalYearPeriod,
  P_ActualPlanGLAcctBalance.PostingDate AS PostingDate,
  P_ActualPlanGLAcctBalance.CalendarYear AS CalendarYear,
  P_ActualPlanGLAcctBalance.CalendarQuarter AS CalendarQuarter,
  P_ActualPlanGLAcctBalance.CalendarYearQuarter AS CalendarYearQuarter,
  P_ActualPlanGLAcctBalance.CalendarMonth AS CalendarMonth,
  P_ActualPlanGLAcctBalance.CalendarYearMonth AS CalendarYearMonth,
  P_ActualPlanGLAcctBalance.CalendarWeek AS CalendarWeek,
  P_ActualPlanGLAcctBalance.CalendarYearWeek AS CalendarYearWeek,
  P_ActualPlanGLAcctBalance._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  P_ActualPlanGLAcctBalance._FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  P_ActualPlanGLAcctBalance._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  P_ActualPlanGLAcctBalance._FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  cast ('0' as fis_revenue_hsl) AS RevenueAmountInCompanyCodeCrcy,
  cast ('0' as fis_revenue_ksl) AS RevenueInGlobalCurrency,
  cast ('0' as fins_sem_tag_grsrevn) AS GrossRevenueAmtInCCCrcy,
  cast ('0' as fins_trr_recrevn) AS RecognizedRevnAmtInCCCrcy,
  cast ('0' as fins_trr_revnadjust) AS RevenueAdjustmentAmtInCCCrcy,
  cast ('0' as fins_trr_revnadjust) AS RevenueAdjustAmtInGlobCrcy,
  cast ('0' as fins_trr_defrevn) AS DeferredRevenueAmtInCCCrcy,
  cast ('0' as fins_trr_accrevn) AS AccruedRevenueAmtInCCCrcy,
  cast ('0' as fins_trr_actrevn) AS RecognizableRevenueAmtInCCCrcy,
  cast ('0' as fins_trr_actrevn) AS RecognizableRevnAmtInGlobCrcy,
  cast ('0' as fins_trr_actrevn) AS BilledRevenueAmtInCoCodeCrcy,
  cast ('0' as fins_trr_actrevn) AS BilledRevenueAmtInGlobCrcy,
  cast ('0' as fins_trr_unbilledrevenue) AS UnbilledRevnInCoCodeCrcy,
  cast ('0' as fins_trr_recmargin) AS RecognizedMarginAmtInCCCrcy,
  cast ('0' as fins_trr_cntraccrpul_cccrcy) AS MnlContrAccrPnLItmAmtInCCCrcy,
  cast ('0' as fis_cost_hsl) AS CostAmountInCompanyCodeCrcy,
  cast ('0' as fins_trr_reccogs) AS RecognizedCOGSAmtInCCCrcy,
  cast ('0' as fins_trr_cogsadj) AS COGSAdjustmentAmtInCCCrcy,
  cast ('0' as fins_trr_defcogs) AS DeferredCOGSAmtInCCCrcy,
  cast ('0' as fins_trr_acccogs) AS AccruedCOGSAmtInCCCrcy,
  cast ('0' as fins_trr_actcost) AS RecognizableCostAmtInCCCrcy,
  cast ('0' as fins_cogs_fixed) AS FxdCOGSAmtInGlobCrcy,
  cast ('0' as fins_trr_resimmloss) AS ImminentLossRsrvAmtInCCCrcy,
  cast ('0' as fins_trr_ressalesded) AS SalesDeductReserveAmtInCCCrcy,
  cast ('0' as fins_trr_unrealcosts) AS UnrlzdCostsReserveAmtInCCCrcy,
  cast ('0' as fins_trr_cntraccrbalsht_cccrcy) AS MnlContrAccrBalShtAmtInCCCrcy,
  cast ('0' as fins_sales_deduction) AS SalesDeductionAmountInGlobCrcy,
  cast ('0' as fins_sales_deduction) AS SalesDeductionAmtInCoCodeCrcy,
  cast ('0' as fins_price_differences) AS PriceDifferenceAmtInGlobCrcy,
  cast ('0' as fins_administration_overhead) AS AdminOverheadAmtInGlobCrcy,
  cast ('0' as fins_sales_overhead) AS SalesOverheadAmtInGlobCrcy,
  cast ('0' as fins_marketing_overhead) AS MarketingOverheadAmtInGlobCrcy,
  cast ('0' as fins_research_and_dev_overhead) AS RnDOverheadAmtInGlobCrcy,
  cast ('0' as fis_asset_hsl) AS AssetAmtInCCCrcy,
  cast ('0' as fis_liab_equity_hsl) AS LiabilityEquityAmtInCCCrcy,
  cast ('0' as fis_unassigned_hsl) AS NotAssignedAmtInCCCrcy,
  cast ('0' as fis_netresult_hsl) AS NetResultAmtInCCCrcy,
  cast ('0' as fins_cfs_pl_result) AS PnLResultAmtInCCCrcy,
  cast ('0' as fis_ntinc_alac_hsl) AS GLAcctNetIncomeAmtInCCCrcy,
  cast ('0' as fins_cfs_chgltinv) AS LongTermInvmtAmtInCCCrcy,
  cast ('0' as fins_cfs_accrec) AS AcctsRblAmtInCCCrcy,
  cast ('0' as fins_cfs_accrec_oth) AS AcctsOthRblAmtInCCCrcy,
  cast ('0' as fins_cfs_accpay) AS AcctsPyblAmtInCCCrcy,
  cast ('0' as fins_cfs_accpay_oth) AS AcctsOthPyblAmtInCCCrcy,
  cast ('0' as fins_cfs_provisions) AS ProvisionAmtInCCCrcy,
  cast ('0' as fins_cfs_notereceiv) AS NotesReceivableAmtInCCCrcy,
  cast ('0' as fins_cfs_dprtasset) AS TangibleAstDeprAmtInCCCrcy,
  cast ('0' as fins_cfs_amorinasst) AS IntngblAssetAmtznAmtInCCCrcy,
  cast ('0' as fins_cfs_tangassets) AS TangibleAstAmtInCCCrcy,
  cast ('0' as fins_cfs_itangasset) AS IntangibleAstAmtInCCCrcy,
  cast ('0' as fins_cfs_chgfaret) AS FixedAssetRtrmtAmtInCCCrcy,
  cast ('0' as fins_cfs_inventory) AS InventoryAmtInCCCrcy,
  cast ('0' as fins_cfs_comnstock) AS CommonStockAmtInCCCrcy,
  cast ('0' as fins_cfs_cashneqv) AS CashAndCashEqvlntAmtInCCCrcy,
  cast( '0' as fis_asset_lblty ) AS AssetLiabilityAmtInCCCrcy,
  cast ( '0' as fins_cogs_variable) AS VarblCOGSAmtInGlobCrcy,
  cast ( '0' as fins_contribution_margin_i) AS ContrbnMargin1AmtInGlobCrcy,
  cast ( '0' as fins_contribution_margin_ii) AS ContrbnMargin2AmtInGlobCrcy,
  cast ( '0' as fins_contribution_margin_iii) AS ContrbnMargin3AmtInGlobCrcy,
  cast ( '0' as fins_cfs_cashopg) AS OperatingActyCashAmtInCCCrcy,
  cast ( '0' as fins_cfs_cashinvtg) AS InvestingActyCashAmtInCCCrcy,
  cast ( '0' as fins_cfs_cashfin) AS FinancingActyCashAmtInCCCrcy,
  cast ( '0' as fins_cfs_netcash) AS NetCashAmtInCCCrcy,
  cast ( '0' as fis_curast_ksl ) AS CurrentAssetAmtInGlobCrcy,
  cast ( '0' as fis_curlbty_ksl ) AS CurrentLiabilityAmtInGlobCrcy,
  cast ( '0' as fis_asset_ksl ) AS AssetAmtInGlobCrcy,
  cast ( '0' as fis_liab_equity_ksl ) AS LiabilityEquityAmtInGlobCrcy,
  cast ( '0' as fis_cogs_ksl ) AS CostOfGoodsSoldAmtInGlobCrcy,
  cast ( '0' as fis_gross_rev_ksl ) AS GrossRevenueAmtInGlobCrcy,
  cast ( '0' as fis_recrevn ) AS RecognizedRevnAmtInGlobCrcy,
  cast ( '0' as fis_netincome_ksl ) AS NetIncomeAmtInGlobCrcy,
  cast ( '0' as fis_operexp_ksl ) AS OpgExpnInGlobCrcy,
  cast ( '0' as fis_ooperexp_ksl ) AS OthOpgExpnInGlobCrcy,
  cast ( '0' as fis_strtginventory_ksl ) AS StrtgInventoryAmtInGlobCrcy,
  cast ( '0' as fis_chgsinventory_ksl ) AS ChgsInventoryAmtInGlobCrcy,
  cast ( '0' as fis_inventory_ksl ) AS InventoryAmtInGlobCrcy,
  cast ( '0' as fis_incometax_ksl ) AS IncomeTaxAmtInGlobCrcy,
  cast ( '0' as fis_interest_ksl ) AS InterestAmtInGlobCrcy,
  cast ( '0' as fis_tangassets_ksl ) AS TngblAstDeprAmtInGlobCrcy,
  cast ( '0' as fis_itangasset_ksl ) AS IntngblAssetAmtznAmtInGlobCrcy,
  cast ( '0' as fis_chgfaret_ksl ) AS FxdAssetRtrmtAmtInGlobCrcy,
  cast ( '0' as fis_chgsprovision_ksl ) AS ChgsProvisionAmtInGlobCrcy,
  cast ( '0' as fis_provision_ksl ) AS ProvisionAmtInGlobCrcy,
  cast ( '0' as fis_chgsaccrec_ksl ) AS ChgsAcctsRblAmtInGlobCrcy,
  cast ( '0' as fis_accrec_ksl ) AS AcctsRblAmtInGlobCrcy,
  cast ( '0' as fis_chgsaccrec_oth_ksl ) AS ChgsAcctsOthRblAmtInGlobCrcy,
  cast ( '0' as fis_accrec_oth_ksl ) AS AcctsOthRblAmtInGlobCrcy,
  cast ( '0' as fis_chgsaccpay_ksl ) AS ChgsAcctsPyblAmtInGlobCrcy,
  cast ( '0' as fis_accpay_ksl ) AS AcctsPyblAmtInGlobCrcy,
  cast ( '0' as fis_chgsaccpay_oth_ksl ) AS ChgsAcctsOthPyblAmtInGlobCrcy,
  cast ( '0' as fis_accpay_oth_ksl ) AS AcctsOthPyblAmtInGlobCrcy,
  P_ActualPlanGLAcctBalance._AccountingDocumentType AS _AccountingDocumentType,
  P_ActualPlanGLAcctBalance._BusinessArea AS _BusinessArea,
  P_ActualPlanGLAcctBalance._ChartOfAccounts AS _ChartOfAccounts,
  P_ActualPlanGLAcctBalance._CompanyCode AS _CompanyCode,
  P_ActualPlanGLAcctBalance._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_ActualPlanGLAcctBalance._ControllingArea AS _ControllingArea,
  P_ActualPlanGLAcctBalance._CostCenter AS _CostCenter,
  P_ActualPlanGLAcctBalance._CostSourceUnit AS _CostSourceUnit,
  P_ActualPlanGLAcctBalance._CurrentCostCenter AS _CurrentCostCenter,
  P_ActualPlanGLAcctBalance._CurrentProfitCenter AS _CurrentProfitCenter,
  P_ActualPlanGLAcctBalance._Customer AS _Customer,
  P_ActualPlanGLAcctBalance._FiscalCalendarDate AS _FiscalCalendarDate,
  P_ActualPlanGLAcctBalance._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  P_ActualPlanGLAcctBalance._FiscalYear AS _FiscalYear,
  P_ActualPlanGLAcctBalance._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  P_ActualPlanGLAcctBalance._FiscalYearVariant AS _FiscalYearVariant,
  P_ActualPlanGLAcctBalance._FixedAsset AS _FixedAsset,
  P_ActualPlanGLAcctBalance._FunctionalArea AS _FunctionalArea,
  P_ActualPlanGLAcctBalance._GLAccountFlowType AS _GLAccountFlowType,
  P_ActualPlanGLAcctBalance._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_ActualPlanGLAcctBalance._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  P_ActualPlanGLAcctBalance._GLAccountTypeFlowType AS _GLAccountTypeFlowType,
  P_ActualPlanGLAcctBalance._GlobalCurrency AS _GlobalCurrency,
  P_ActualPlanGLAcctBalance._Hierarchy AS _Hierarchy,
  P_ActualPlanGLAcctBalance._JournalEntry AS _JournalEntry,
  P_ActualPlanGLAcctBalance._Ledger AS _Ledger,
  P_ActualPlanGLAcctBalance._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  P_ActualPlanGLAcctBalance._Order AS _Order,
  P_ActualPlanGLAcctBalance._PlanningCategory AS _PlanningCategory,
  P_ActualPlanGLAcctBalance._ProfitCenter AS _ProfitCenter,
  P_ActualPlanGLAcctBalance._SalesDocument AS _SalesDocument,
  P_ActualPlanGLAcctBalance._Segment AS _Segment,
  P_ActualPlanGLAcctBalance._SemanticTag AS _SemanticTag,
  P_ActualPlanGLAcctBalance._ServiceDocument AS _ServiceDocument,
  P_ActualPlanGLAcctBalance._SourceLedger AS _SourceLedger,
  P_ActualPlanGLAcctBalance._Supplier AS _Supplier
FROM P_ActualPlanGLAcctBalance
;