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