P_Fclm_Flow_Analyzer_Bkhview

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_Fclm_Flow_Analyzer_Bkhview.
-- 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: PFABKHCDS
-- Parameters: P_BankAccountHierarchy : hryid, P_Filter_BAL : abap.char(1000), P_GroupingFilter : fclm_groupingfilter, P_PlanningLevelFilter : abap.char(100), P_OverduePlanningLevelFilter : abap.char(100), P_Filter_BankAccount : abap.char(1000), P_FilterBal_type : fclm_filterbaltype, P_BankGroup : fclm_bank_group, P_KeyDate : vdm_v_key_date, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_Cycle : syst_tabix, P_CyclePattern : fclm_cyclepattern, P_ActualDate : datum, P_Language : sylangu, P_BamCur : abap.char(1), P_CalenderId : abap.char(10), P_htstp : timestampl, P_ExchangeRateDate : datum, P_PreviousFlag : abap.char(2), P_Export : abap.char(10), P_EndofPeriod : abap.char(2)

CREATE VIEW P_Fclm_Flow_Analyzer_Bkhview AS
SELECT
  $parameters.P_KeyDate AS KeyDate,
  companycode,
  n_text AS nodeid,
  parentid,
  nodelevel,
  node_ref_key,
  sort_order,
  is_data,
  FiDocumentType,
  glaccount,
  housebank,
  currency,
  CashPlanninggroup,
  CertaintyLevel,
  Direction,
  _BankAccount.BankCountry AS bankcountry,
  _BankAccount.BankAccountNumber AS bankaccount,
  _BankAccount.Bank AS Bank,
  _BankGroup.BankHeadquarter AS BankGroupID,
  _BankGroup.BankHeadquarterName AS BankGroupIDName,
  _BankGroup.CreditRating AS bankrating,
  bal_type,
  cast('' as prctr) AS ProfitCenter,
  cast('' as fb_segment ) AS Segment,
  cast('' as gsber ) AS BusinessArea,
  cast('' as rassc) AS TradingPartner,
  7 AS max_cycle,
  '' AS ExRateType,
  s_text,
  hierarchyname AS BankAccountGroup,
  $parameters.P_ActualDate AS ActualDate,
  '' AS BankName,
  '' AS CountryKey,
  '' AS LiquidityItemName,
  _BankAccount._Text[1:Language=$parameters.P_Language].BankAccountDescription AS BankAccountName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PlanningGroup._Text[1:Language=$parameters.P_Language].CashPlanningGroupName AS CashPlanningGroupName,
  $parameters.P_DisplayCurrency AS Display_Currency,
  $parameters.P_CyclePattern AS Cycle_Pattern,
  '' AS CalendarEnd,
  $parameters.P_Export AS Export,
  bal_type AS bal_type_ext,
  rel_status,
  fund,
  grantid,
  costcenter,
  TextData1,
  TextData2,
  TextData3,
  TextData4,
  TextData5,
  TextData6,
  TextData7,
  TextData8,
  TextData9,
  TextData10,
  TextData11,
  TextData12,
  TextData13,
  TextData14,
  TextData15,
  TextData16,
  TextData17,
  TextData18,
  TextData19,
  TextData20,
  TextData21,
  TextData22,
  TextData23,
  TextData24,
  TextData25,
  TextData26,
  TextData27,
  TextData28,
  TextData29,
  TextData30,
  TextData31,
  TextData32,
  day0 AS overdue,
  day1 AS data1,
  day2 AS data2,
  day3 AS data3,
  day4 AS data4,
  day5 AS data5,
  day6 AS data6,
  day7 AS data7,
  day8 AS data8,
  day9 AS data9,
  day10 AS data10,
  day11 AS data11,
  day12 AS data12,
  day13 AS data13,
  day14 AS data14,
  day15 AS data15,
  day16 AS data16,
  day17 AS data17,
  day18 AS data18,
  day19 AS data19,
  day20 AS data20,
  day21 AS data21,
  day22 AS data22,
  day23 AS data23,
  day24 AS data24,
  day25 AS data25,
  day26 AS data26,
  day27 AS data27,
  day28 AS data28,
  day29 AS data29,
  day30 AS data30,
  day31 AS data31,
  day32 AS data32,
  convert_day0 AS Convert_overdue,
  convert_day1 AS Convert_data1,
  convert_day2 AS Convert_data2,
  convert_day3 AS Convert_data3,
  convert_day4 AS Convert_data4,
  convert_day5 AS Convert_data5,
  convert_day6 AS Convert_data6,
  convert_day7 AS Convert_data7,
  convert_day8 AS Convert_data8,
  convert_day9 AS Convert_data9,
  convert_day10 AS Convert_data10,
  convert_day11 AS Convert_data11,
  convert_day12 AS Convert_data12,
  convert_day13 AS Convert_data13,
  convert_day14 AS Convert_data14,
  convert_day15 AS Convert_data15,
  convert_day16 AS Convert_data16,
  convert_day17 AS Convert_data17,
  convert_day18 AS Convert_data18,
  convert_day19 AS Convert_data19,
  convert_day20 AS Convert_data20,
  convert_day21 AS Convert_data21,
  convert_day22 AS Convert_data22,
  convert_day23 AS Convert_data23,
  convert_day24 AS Convert_data24,
  convert_day25 AS Convert_data25,
  convert_day26 AS Convert_data26,
  convert_day27 AS Convert_data27,
  convert_day28 AS Convert_data28,
  convert_day29 AS Convert_data29,
  convert_day30 AS Convert_data30,
  convert_day31 AS Convert_data31,
  convert_day32 AS Convert_data32
FROM P_Fclm_Flow_Analyzer_BKH_Tb
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON bankaccountid = _BankAccount.BankAccountInternalID  -- association [1..1]
LEFT OUTER JOIN I_BankAccountWithBGN AS _BankGroup ON bankaccountid = _BankGroup.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_PlanningGroup AS _PlanningGroup ON CashPlanninggroup = _PlanningGroup.CashPlanningGroup  -- association [0..1]
;