P_FlowAnalyzerOverview

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 P_FlowAnalyzerOverview.
-- 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: PFLOWANALYSISOV
-- Parameters: P_PeriodBalanceAmount : fclm_filter_conditions, P_CashPlanningGroup : fclm_groupingfilter, P_PlanningLevel : fclm_filter_condition, P_OverduePlanningLevel : fclm_filter_condition, P_LiquidityItem : fclm_filter_conditions, P_BankAccount : fclm_filter_conditions, P_BalanceSheetType : fclm_filterbaltype, P_BankGroup : fclm_bank_group, P_KeyDate : vdm_v_key_date, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_OrderCycle : syst_tabix, P_CyclePattern : fclm_cyclepattern, P_BankAccountHierarchy : hryid, P_ActualStartDate : datum, P_BankAccountCurrency : bkk_char1, P_Language : sylangu, P_CustomerFactoryCalenderCode : fclm_factory_cal, P_HistoryDateTime : timestampl, P_ExchangeRateDate : datum, P_CalendarWorkingDateSkipRule : fclm_flag2, P_EndOfPeriodDetermination : fclm_flag2, P_CountOnly : abap.char(1)

CREATE VIEW P_FlowAnalyzerOverview AS
SELECT
  KeyDate,
  CompanyCode,
  FiDocumentType AS DocumentType,
  GLAccount AS GLAccountName,
  HouseBank,
  HouseBankAccount,
  BankAccountInternalID,
  Currency,
  CashPlanningGroup,
  CertaintyLevel,
  SummarizationGroup AS CashSummarizationGroup,
  SummarizationTerm AS CashSummarizationLevel,
  PaymentMethod,
  PlanningLevel,
  OverduePlanningLevel,
  LiquidityItem,
  Direction AS NFDirection,
  ProfitCenter,
  Segment,
  BusinessArea,
  TradingPartner,
  BankAccountType,
  BankCountry,
  BankAccount,
  Bank,
  BankGroupID AS BankAccountGroupId,
  BankGroupIDName AS BankHeadquarterName,
  BankRating AS CreditRating,
  bal_type AS BalanceSheetType,
  max_cycle AS MaximumDuration,
  ExRateType AS ExchangeRateType,
  ActualDate AS ActualStartDate,
  BankRatingDescription AS CreditRatingName,
  BankAccountName,
  BankName,
  CompanyCodeName,
  PlanningLevelName,
  PlanningLevelDescription,
  LiquidityItemName,
  LiquidityItemdDesc AS LiquidityItemDescription,
  BankGroup,
  BankGroupName AS BusinessPartnerFullName,
  CashPlanningGroupName,
  CashPlanningGroupDescription,
  Display_Currency AS DisplayCurrency,
  Cycle_Pattern AS CyclePattern,
  CalendarEnd AS FinalSettlmtCalendar,
  Bal_Type_Ext AS BalanceSheetTypeName,
  rel_status AS CashReleaseStatus,
  reconcil_status AS CshRecnclnStatus,
  Fund,
  FundName,
  GrantID,
  GrantName,
  CostCenter,
  CostCenterName,
  data1 AS TimePeriod1AmtInTransCrcy,
  data2 AS TimePeriod2AmtInTransCrcy,
  data3 AS TimePeriod3AmtInTransCrcy,
  data4 AS TimePeriod4AmtInTransCrcy,
  data5 AS TimePeriod5AmtInTransCrcy,
  data6 AS TimePeriod6AmtInTransCrcy,
  data7 AS TimePeriod7AmtInTransCrcy,
  data8 AS TimePeriod8AmtInTransCrcy,
  data9 AS TimePeriod9AmtInTransCrcy,
  data10 AS TimePeriod10AmtInTransCrcy,
  data11 AS TimePeriod11AmtInTransCrcy,
  data12 AS TimePeriod12AmtInTransCrcy,
  data13 AS TimePeriod13AmtInTransCrcy,
  data14 AS TimePeriod14AmtInTransCrcy,
  data15 AS TimePeriod15AmtInTransCrcy,
  data16 AS TimePeriod16AmtInTransCrcy,
  data17 AS TimePeriod17AmtInTransCrcy,
  data18 AS TimePeriod18AmtInTransCrcy,
  data19 AS TimePeriod19AmtInTransCrcy,
  data20 AS TimePeriod20AmtInTransCrcy,
  data21 AS TimePeriod21AmtInTransCrcy,
  data22 AS TimePeriod22AmtInTransCrcy,
  data23 AS TimePeriod23AmtInTransCrcy,
  data24 AS TimePeriod24AmtInTransCrcy,
  data25 AS TimePeriod25AmtInTransCrcy,
  data26 AS TimePeriod26AmtInTransCrcy,
  data27 AS TimePeriod27AmtInTransCrcy,
  data28 AS TimePeriod28AmtInTransCrcy,
  data29 AS TimePeriod29AmtInTransCrcy,
  data30 AS TimePeriod30AmtInTransCrcy,
  data31 AS TimePeriod31AmtInTransCrcy,
  data32 AS TimePeriod32AmtInTransCrcy,
  Convert_overdue AS OverdueAmountInUserDspCrcy,
  Convert_data1 AS TimePeriod1AmtInDisplayCrcy,
  Convert_data2 AS TimePeriod2AmtInDisplayCrcy,
  Convert_data3 AS TimePeriod3AmtInDisplayCrcy,
  Convert_data4 AS TimePeriod4AmtInDisplayCrcy,
  Convert_data5 AS TimePeriod5AmtInDisplayCrcy,
  Convert_data6 AS TimePeriod6AmtInDisplayCrcy,
  Convert_data7 AS TimePeriod7AmtInDisplayCrcy,
  Convert_data8 AS TimePeriod8AmtInDisplayCrcy,
  Convert_data9 AS TimePeriod9AmtInDisplayCrcy,
  Convert_data10 AS TimePeriod10AmtInDisplayCrcy,
  Convert_data11 AS TimePeriod11AmtInDisplayCrcy,
  Convert_data12 AS TimePeriod12AmtInDisplayCrcy,
  Convert_data13 AS TimePeriod13AmtInDisplayCrcy,
  Convert_data14 AS TimePeriod14AmtInDisplayCrcy,
  Convert_data15 AS TimePeriod15AmtInDisplayCrcy,
  Convert_data16 AS TimePeriod16AmtInDisplayCrcy,
  Convert_data17 AS TimePeriod17AmtInDisplayCrcy,
  Convert_data18 AS TimePeriod18AmtInDisplayCrcy,
  Convert_data19 AS TimePeriod19AmtInDisplayCrcy,
  Convert_data20 AS TimePeriod20AmtInDisplayCrcy,
  Convert_data21 AS TimePeriod21AmtInDisplayCrcy,
  Convert_data22 AS TimePeriod22AmtInDisplayCrcy,
  Convert_data23 AS TimePeriod23AmtInDisplayCrcy,
  Convert_data24 AS TimePeriod24AmtInDisplayCrcy,
  Convert_data25 AS TimePeriod25AmtInDisplayCrcy,
  Convert_data26 AS TimePeriod26AmtInDisplayCrcy,
  Convert_data27 AS TimePeriod27AmtInDisplayCrcy,
  Convert_data28 AS TimePeriod28AmtInDisplayCrcy,
  Convert_data29 AS TimePeriod29AmtInDisplayCrcy,
  Convert_data30 AS TimePeriod30AmtInDisplayCrcy,
  Convert_data31 AS TimePeriod31AmtInDisplayCrcy,
  Convert_data32 AS TimePeriod32AmtInDisplayCrcy
FROM P_Fclm_Flow_Analyzer_Overview
;