C_GLAccountFlow

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 C_GLAccountFlow.
-- 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: CFIGLACCTFLOW

CREATE VIEW C_GLAccountFlow AS
SELECT
  I_GLAccountBalance.SourceLedger AS SourceLedger,
  I_GLAccountBalance.CompanyCode AS CompanyCode,
  I_GLAccountBalance.GLAccount AS GLAccount,
  I_GLAccountBalance.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountBalance.FiscalYearPeriod AS FiscalYearPeriod,
  I_GLAccountBalance.PostingDate AS PostingDate,
  I_GLAccountBalance.GLAccountTypeFlowType AS GLAccountTypeFlowType,
  I_GLAccountBalance.GLAccountFlowType AS GLAccountFlowType,
  I_GLAccountBalance.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_GLAccountBalance.AccountingDocument AS AccountingDocument,
  I_GLAccountBalance.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountBalance.FiscalYear AS FiscalYear,
  I_GLAccountBalance.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountBalance.ControllingArea AS ControllingArea,
  I_GLAccountBalance.FinancialTransactionType AS FinancialTransactionType,
  I_GLAccountBalance.BusinessTransactionType AS BusinessTransactionType,
  I_GLAccountBalance.ReferenceDocumentType AS ReferenceDocumentType,
  I_GLAccountBalance.LogicalSystem AS LogicalSystem,
  I_GLAccountBalance.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
  I_GLAccountBalance.IsReversal AS IsReversal,
  I_GLAccountBalance.IsReversed AS IsReversed,
  I_GLAccountBalance.IsSettlement AS IsSettlement,
  I_GLAccountBalance.IsSettled AS IsSettled,
  I_GLAccountBalance.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  I_GLAccountBalance.CostCenter AS CostCenter,
  I_GLAccountBalance.ProfitCenter AS ProfitCenter,
  I_GLAccountBalance.FunctionalArea AS FunctionalArea,
  I_GLAccountBalance.BusinessArea AS BusinessArea,
  I_GLAccountBalance.Segment AS Segment,
  I_GLAccountBalance.PartnerCostCenter AS PartnerCostCenter,
  I_GLAccountBalance.PartnerProfitCenter AS PartnerProfitCenter,
  I_GLAccountBalance.PartnerFunctionalArea AS PartnerFunctionalArea,
  I_GLAccountBalance.PartnerBusinessArea AS PartnerBusinessArea,
  I_GLAccountBalance.PartnerCompany AS PartnerCompany,
  I_GLAccountBalance.PartnerSegment AS PartnerSegment,
  I_GLAccountBalance.DebitCreditCode AS DebitCreditCode,
  I_GLAccountBalance.FiscalPeriod AS FiscalPeriod,
  I_GLAccountBalance.FiscalYearVariant AS FiscalYearVariant,
  I_GLAccountBalance.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountBalance.AssignmentReference AS AssignmentReference,
  I_GLAccountBalance.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountBalance.PostingKey AS PostingKey,
  I_GLAccountBalance.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountBalance.FlowAmountInBalanceTransCrcy AS FlowAmountInBalanceTransCrcy,
  I_GLAccountBalance.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
  I_GLAccountBalance.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
  I_GLAccountBalance.TransactionCurrency AS TransactionCurrency,
  I_GLAccountBalance.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountBalance.FlowAmountInTransCrcy AS FlowAmountInTransCrcy,
  I_GLAccountBalance.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  I_GLAccountBalance.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  I_GLAccountBalance.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountBalance.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountBalance.FlowAmountInCoCodeCrcy AS FlowAmountInCoCodeCrcy,
  I_GLAccountBalance.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_GLAccountBalance.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_GLAccountBalance.GlobalCurrency AS GlobalCurrency,
  I_GLAccountBalance.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountBalance.FlowAmountInGlobalCrcy AS FlowAmountInGlobalCrcy,
  I_GLAccountBalance.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
  I_GLAccountBalance.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
  I_GLAccountBalance.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  I_GLAccountBalance.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy1 AS FlowAmountInFreeDfndCrcy1,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy1 AS DebitAmountInFreeDfndCrcy1,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy1 AS CreditAmountInFreeDfndCrcy1,
  I_GLAccountBalance.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  I_GLAccountBalance.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy2 AS FlowAmountInFreeDfndCrcy2,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy2 AS DebitAmountInFreeDfndCrcy2,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy2 AS CreditAmountInFreeDfndCrcy2,
  I_GLAccountBalance.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  I_GLAccountBalance.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy3 AS FlowAmountInFreeDfndCrcy3,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy3 AS DebitAmountInFreeDfndCrcy3,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy3 AS CreditAmountInFreeDfndCrcy3,
  I_GLAccountBalance.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  I_GLAccountBalance.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy4 AS FlowAmountInFreeDfndCrcy4,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy4 AS DebitAmountInFreeDfndCrcy4,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy4 AS CreditAmountInFreeDfndCrcy4,
  I_GLAccountBalance.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  I_GLAccountBalance.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy5 AS FlowAmountInFreeDfndCrcy5,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy5 AS DebitAmountInFreeDfndCrcy5,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy5 AS CreditAmountInFreeDfndCrcy5,
  I_GLAccountBalance.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  I_GLAccountBalance.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy6 AS FlowAmountInFreeDfndCrcy6,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy6 AS DebitAmountInFreeDfndCrcy6,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy6 AS CreditAmountInFreeDfndCrcy6,
  I_GLAccountBalance.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  I_GLAccountBalance.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy7 AS FlowAmountInFreeDfndCrcy7,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy7 AS DebitAmountInFreeDfndCrcy7,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy7 AS CreditAmountInFreeDfndCrcy7,
  I_GLAccountBalance.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  I_GLAccountBalance.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  I_GLAccountBalance.FlowAmountInFreeDfndCrcy8 AS FlowAmountInFreeDfndCrcy8,
  I_GLAccountBalance.DebitAmountInFreeDfndCrcy8 AS DebitAmountInFreeDfndCrcy8,
  I_GLAccountBalance.CreditAmountInFreeDfndCrcy8 AS CreditAmountInFreeDfndCrcy8,
  I_GLAccountBalance.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_GLAccountBalance.EliminationProfitCenter AS EliminationProfitCenter,
  I_GLAccountBalance.OriginObjectType AS OriginObjectType,
  I_GLAccountBalance.GLAccountType AS GLAccountType,
  I_GLAccountBalance.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountBalance.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_GLAccountBalance.PurchasingDocument AS PurchasingDocument,
  I_GLAccountBalance.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GLAccountBalance.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_GLAccountBalance.SalesOrder AS SalesOrder,
  I_GLAccountBalance.SalesOrderItem AS SalesOrderItem,
  I_GLAccountBalance.SalesDocument AS SalesDocument,
  I_GLAccountBalance.SalesDocumentItem AS SalesDocumentItem,
  cast( I_GLAccountBalance.Product as matnr preserving type ) AS Material,
  I_GLAccountBalance.Product AS Product,
  I_GLAccountBalance.Plant AS Plant,
  I_GLAccountBalance.Supplier AS Supplier,
  I_GLAccountBalance.Customer AS Customer,
  I_GLAccountBalance.FinancialAccountType AS FinancialAccountType,
  I_GLAccountBalance.SpecialGLCode AS SpecialGLCode,
  I_GLAccountBalance.TaxCode AS TaxCode,
  I_GLAccountBalance.HouseBank AS HouseBank,
  I_GLAccountBalance.HouseBankAccount AS HouseBankAccount,
  I_GLAccountBalance.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccountBalance.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAccountBalance.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  I_GLAccountBalance.ClearingJournalEntry AS ClearingJournalEntry,
  I_GLAccountBalance.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_GLAccountBalance.AssetDepreciationArea AS AssetDepreciationArea,
  I_GLAccountBalance.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountBalance.FixedAsset AS FixedAsset,
  I_GLAccountBalance.AssetValueDate AS AssetValueDate,
  I_GLAccountBalance.AssetTransactionType AS AssetTransactionType,
  I_GLAccountBalance.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  I_GLAccountBalance.GroupFixedAsset AS GroupFixedAsset,
  I_GLAccountBalance.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_GLAccountBalance.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
  I_GLAccountBalance.InventorySpecialStockType AS InventorySpecialStockType,
  I_GLAccountBalance.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
  I_GLAccountBalance.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
  I_GLAccountBalance.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAccountBalance._InvtrySpclStkWBSElmntBscData.WBSElement AS InventorySpclStockWBSElement,
  cast(I_GLAccountBalance._InvtrySpclStkWBSElmntBscData.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) AS InvtrySpclStockWBSElmntExtID,
  I_GLAccountBalance.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
  I_GLAccountBalance.InventoryValuationType AS InventoryValuationType,
  I_GLAccountBalance.ValuationArea AS ValuationArea,
  I_GLAccountBalance.SenderGLAccount AS SenderGLAccount,
  I_GLAccountBalance.SenderAccountAssignment AS SenderAccountAssignment,
  I_GLAccountBalance.SenderAccountAssignmentType AS SenderAccountAssignmentType,
  I_GLAccountBalance.ControllingObjectDebitType AS ControllingObjectDebitType,
  I_GLAccountBalance.QuantityIsIncomplete AS QuantityIsIncomplete,
  I_GLAccountBalance.OffsettingAccount AS OffsettingAccount,
  I_GLAccountBalance.OffsettingAccountType AS OffsettingAccountType,
  I_GLAccountBalance.LineItemIsCompleted AS LineItemIsCompleted,
  I_GLAccountBalance.PersonnelNumber AS PersonnelNumber,
  I_GLAccountBalance.ControllingObjectClass AS ControllingObjectClass,
  I_GLAccountBalance.PartnerCompanyCode AS PartnerCompanyCode,
  I_GLAccountBalance.PartnerControllingObjectClass AS PartnerControllingObjectClass,
  I_GLAccountBalance.OriginCostCenter AS OriginCostCenter,
  I_GLAccountBalance.OriginProfitCenter AS OriginProfitCenter,
  I_GLAccountBalance.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  I_GLAccountBalance.AccountAssignment AS AccountAssignment,
  I_GLAccountBalance.AccountAssignmentType AS AccountAssignmentType,
  I_GLAccountBalance.CostCtrActivityType AS CostCtrActivityType,
  I_GLAccountBalance.OrderID AS OrderID,
  I_GLAccountBalance.OrderCategory AS OrderCategory,
  I_GLAccountBalance.WBSElementInternalID AS WBSElementInternalID,
  cast( I_GLAccountBalance.WBSElement as fis_wbs preserving type ) AS WBSElement,
  cast( I_GLAccountBalance._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
  I_GLAccountBalance.ProjectInternalID AS ProjectInternalID,
  cast( I_GLAccountBalance.Project as fis_project preserving type ) AS Project,
  cast( I_GLAccountBalance._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
  I_GLAccountBalance.OperatingConcern AS OperatingConcern,
  I_GLAccountBalance.ProjectNetwork AS ProjectNetwork,
  I_GLAccountBalance.RelatedNetworkActivity AS RelatedNetworkActivity,
  I_GLAccountBalance.BusinessProcess AS BusinessProcess,
  I_GLAccountBalance.CostObject AS CostObject,
  I_GLAccountBalance.CustomerServiceNotification AS CustomerServiceNotification,
  I_GLAccountBalance.PartnerAccountAssignment AS PartnerAccountAssignment,
  I_GLAccountBalance.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  I_GLAccountBalance.WorkPackage AS WorkPackage,
  I_GLAccountBalance.WorkItem AS WorkItem,
  I_GLAccountBalance.ServiceDocumentType AS ServiceDocumentType,
  I_GLAccountBalance.ServiceDocument AS ServiceDocument,
  I_GLAccountBalance.ServiceDocumentItem AS ServiceDocumentItem,
  I_GLAccountBalance.ServiceContractType AS ServiceContractType,
  I_GLAccountBalance.ServiceContract AS ServiceContract,
  I_GLAccountBalance.ServiceContractItem AS ServiceContractItem,
  I_GLAccountBalance.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  I_GLAccountBalance.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  I_GLAccountBalance.PartnerOrder AS PartnerOrder,
  I_GLAccountBalance.PartnerOrder_2 AS PartnerOrder_2,
  I_GLAccountBalance.PartnerOrderCategory AS PartnerOrderCategory,
  cast( I_GLAccountBalance.PartnerWBSElement as fis_partner_wbs preserving type ) AS PartnerWBSElement,
  cast( I_GLAccountBalance._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
  cast( I_GLAccountBalance.PartnerProject as fis_part_project preserving type ) AS PartnerProject,
  cast( I_GLAccountBalance._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
  I_GLAccountBalance.PartnerSalesDocument AS PartnerSalesDocument,
  I_GLAccountBalance.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
  I_GLAccountBalance.PartnerProjectNetwork AS PartnerProjectNetwork,
  I_GLAccountBalance.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
  I_GLAccountBalance.PartnerBusinessProcess AS PartnerBusinessProcess,
  I_GLAccountBalance.PartnerCostObject AS PartnerCostObject,
  I_GLAccountBalance.BillingDocumentType AS BillingDocumentType,
  I_GLAccountBalance.SalesOrganization AS SalesOrganization,
  I_GLAccountBalance.DistributionChannel AS DistributionChannel,
  I_GLAccountBalance.OrganizationDivision AS OrganizationDivision,
  cast( I_GLAccountBalance.SoldProduct as fis_sold_material preserving type ) AS SoldMaterial,
  I_GLAccountBalance.SoldProduct AS SoldProduct,
  cast( I_GLAccountBalance.SoldProductGroup as fins_matkl_pa preserving type ) AS MaterialGroup,
  I_GLAccountBalance.ProductGroup AS ProductGroup,
  I_GLAccountBalance.SoldProductGroup AS SoldProductGroup,
  I_GLAccountBalance.CustomerGroup AS CustomerGroup,
  I_GLAccountBalance.FinancialManagementArea AS FinancialManagementArea,
  I_GLAccountBalance.Fund AS Fund,
  I_GLAccountBalance.GrantID AS GrantID,
  I_GLAccountBalance.BudgetPeriod AS BudgetPeriod,
  I_GLAccountBalance.PartnerFund AS PartnerFund,
  I_GLAccountBalance.PartnerGrant AS PartnerGrant,
  I_GLAccountBalance.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  I_GLAccountBalance.FundsCenter AS FundsCenter,
  I_GLAccountBalance.FundedProgram AS FundedProgram,
  I_GLAccountBalance.JointVenture AS JointVenture,
  I_GLAccountBalance.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountBalance.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  I_GLAccountBalance.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountBalance.SettlementReferenceDate AS SettlementReferenceDate,
  I_GLAccountBalance.CalendarYear AS CalendarYear,
  I_GLAccountBalance.CalendarQuarter AS CalendarQuarter,
  I_GLAccountBalance.CalendarYearQuarter AS CalendarYearQuarter,
  I_GLAccountBalance.CalendarMonth AS CalendarMonth,
  I_GLAccountBalance.CalendarYearMonth AS CalendarYearMonth,
  I_GLAccountBalance.CalendarWeek AS CalendarWeek,
  I_GLAccountBalance.CalendarYearWeek AS CalendarYearWeek,
  I_GLAccountBalance.FiscalQuarter AS FiscalQuarter,
  I_GLAccountBalance.FiscalWeek AS FiscalWeek,
  I_GLAccountBalance.FiscalYearQuarter AS FiscalYearQuarter,
  I_GLAccountBalance.FiscalYearWeek AS FiscalYearWeek,
  I_GLAccountBalance.AccrualObjectType AS AccrualObjectType,
  I_GLAccountBalance.AccrualObject AS AccrualObject,
  I_GLAccountBalance.AccrualSubobject AS AccrualSubobject,
  I_GLAccountBalance.AccrualItemType AS AccrualItemType,
  I_GLAccountBalance.AssetClass AS AssetClass
FROM I_GLAccountBalance
;