P_FlowAnalyzerLqdyItemView

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_FlowAnalyzerLqdyItemView.
-- 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: PFLOWANALYSISLV
-- Parameters: P_HierarchyID : hryid, 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_KeyDate : vdm_v_key_date, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_OrderCycle : syst_tabix, P_CyclePattern : fclm_cyclepattern, P_ActualStartDate : datum, P_Language : sylangu, P_BankAccountCurrency : bkk_char1, P_CustomerFactoryCalenderCode : fclm_factory_cal, P_CalendarWorkingDateSkipRule : fclm_flag2, P_HistoryDateTime : timestampl, P_ExchangeRateDate : datum, P_BankAccountHierarchy : hryid, P_BankGroup : fclm_bank_group, P_ExportType : fclm_factory_cal, P_EndOfPeriodDetermination : fclm_flag2

CREATE VIEW P_FlowAnalyzerLqdyItemView AS
SELECT
  KeyDate,
  CompanyCode,
  hierarchyname AS HierarchyID,
  nodeid AS SAPObjectNodeID,
  parentid AS ParentNode,
  nodelevel AS HierarchyNodeLevel,
  node_ref_key AS HierarchyNodeReference,
  sort_order AS SortSequence,
  FiDocumentType AS DocumentType,
  glaccount AS GLAccountName,
  HouseBank,
  HouseBankAccount,
  bankaccountid AS BankAccountInternalID,
  Currency,
  CashPlanningGroup,
  CertaintyLevel,
  summarizationgroup AS CashSummarizationGroup,
  summarizationterm AS CashSummarizationLevel,
  PlanningLevel,
  OverduePlanningLevel,
  LiquidityItem,
  Direction AS NFDirection,
  BankAccountType,
  BankCountry,
  BankAccount,
  Bank,
  BankGroupID AS BankAccountGroupId,
  BankGroupIDName AS BankHeadquarterName,
  bankrating AS CreditRating,
  BankAccountGroup AS AccountGroupName,
  bal_type AS BalanceSheetType,
  is_data AS MDChgProcActvtIsDataRplctnRqd,
  ProfitCenter,
  Segment,
  BusinessArea,
  TradingPartner,
  max_cycle AS MaximumDuration,
  Export AS ExportType,
  ExRateType AS ExchangeRateType,
  ActualDate AS ActualStartDate,
  bankratingdescription AS CreditRatingName,
  BankAccountName,
  BankName,
  CompanyCodeName,
  CountryKey AS BankCountryKey,
  PlanningLevelName,
  LiquidityItemName,
  l_text AS StandardTextDescription,
  CashPlanningGroupName,
  Display_Currency AS DisplayCurrency,
  Cycle_Pattern AS CyclePattern,
  CalendarEnd AS FinalSettlmtCalendar,
  s_text AS TextDescription,
  bal_type_ext AS BalanceSheetTypeName,
  rel_status AS CashReleaseStatus,
  reconcil_status AS CshRecnclnStatus,
  fund,
  grantid,
  costcenter,
  TextData1 AS TimePeriod1Name,
  TextData2 AS TimePeriod2Name,
  TextData3 AS TimePeriod3Name,
  TextData4 AS TimePeriod4Name,
  TextData5 AS TimePeriod5Name,
  TextData6 AS TimePeriod6Name,
  TextData7 AS TimePeriod7Name,
  TextData8 AS TimePeriod8Name,
  TextData9 AS TimePeriod9Name,
  TextData10 AS TimePeriod10Name,
  TextData11 AS TimePeriod11Name,
  TextData12 AS TimePeriod12Name,
  TextData13 AS TimePeriod13Name,
  TextData14 AS TimePeriod14Name,
  TextData15 AS TimePeriod15Name,
  TextData16 AS TimePeriod16Name,
  TextData17 AS TimePeriod17Name,
  TextData18 AS TimePeriod18Name,
  TextData19 AS TimePeriod19Name,
  TextData20 AS TimePeriod20Name,
  TextData21 AS TimePeriod21Name,
  TextData22 AS TimePeriod22Name,
  TextData23 AS TimePeriod23Name,
  TextData24 AS TimePeriod24Name,
  TextData25 AS TimePeriod25Name,
  TextData26 AS TimePeriod26Name,
  TextData27 AS TimePeriod27Name,
  TextData28 AS TimePeriod28Name,
  TextData29 AS TimePeriod29Name,
  TextData30 AS TimePeriod30Name,
  TextData31 AS TimePeriod31Name,
  TextData32 AS TimePeriod32Name,
  overdue AS OverdueDays,
  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_Lqhview
;