I_CashPositionProfile

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 I_CashPositionProfile.
-- 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.

CREATE VIEW I_CashPositionProfile AS
SELECT
  Main.profile_name AS CashPositionProfile,
  Main.prof_description AS CashPositionProfileDescription,
  Main.hierarchy_source AS CashPositionHierSource,
  Main.hierarchy_level1 AS CashPositionHierLevel1,
  Main.hierarchy_level2 AS CashPositionHierLevel2,
  Main.hierarchy_level3 AS CashPositionHierLevel3,
  Main.bank_acc_hierarchy_id AS BankAccountHierarchyName,
  Main.balance_type AS CashBalanceType,
  Main.balance_category AS CashPositionBalanceCategory,
  Main.view_category AS CashPositionViewCategory,
  Main.step_rhythm AS CashPositionPrdfndIncrement,
  Main.step_unit AS CashPositionPrdfndInterimStep,
  Main.period_end AS CashPositionPeriodEndIsNatural,
  Main.show_overdue AS CashPositionOverdueIsVisible,
  Main.include_overdue_in_closing AS CashPositionOvrdIsIncldInClsg,
  Main.shift_option AS CashPositionShiftOption,
  Main.factory_calendar AS FactoryCalendar,
  Main.display_currency AS DisplayCurrency,
  Main.exchange_rate_type AS ExchangeRateType,
  Main.need_root_node AS CashPositionRootNodeIsNeeded,
  Main.root_node AS CashPositionRootNode,
  Main.show_future AS CashPositionFutureIsVisible,
  Main.enable_smart_currency AS CashPositionSmartCrcyIsEnabled,
  Main.display_embed_csh_pos_det_view AS EmbeddedCshPosDetViewIsVisible,
  Main.consider_intraday_recncln_rslt AS IntradayRecnclnRsltIsConsdrd,
  Main.consider_endofday_recncln_rslt AS EndOfDayRecnclnRsltIsConsdrd,
  Main.created_by AS CreatedByUser,
  Main.created_at AS CreationDateTime,
  Main.last_changed_by AS LastChangedByUser,
  Main.last_changed_at AS LastChangeDateTime,
  Main.allow_key_date_in_the_past AS CshPosKeyDteInThePastIsAllowed
FROM fclm_cp_prof AS Main
CROSS JOIN fclm_config2 AS _config
LEFT OUTER JOIN I_CurrencyStdVH AS _Currency ON DisplayCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BankFeeExchRateTypeVH AS _BankFeeExchRateTypeVH ON ExchangeRateType = _BankFeeExchRateTypeVH.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_CshPosHierSourceText AS _CshPosHierSourceText ON CashPositionHierSource = _CshPosHierSourceText.CashPositionHierSource  -- association [0..*]
LEFT OUTER JOIN I_CshPosHierText AS _CshPosHierText ON CashPositionHierLevel1 = _CshPosHierText.CashPositionHierLevel1  -- association [0..*]
LEFT OUTER JOIN I_CshPosHierText AS _CshPosHierTwoText ON CashPositionHierLevel2 = _CshPosHierTwoText.CashPositionHierLevel1  -- association [0..*]
LEFT OUTER JOIN I_CshPosHierText AS _CshPosHierThreeText ON CashPositionHierLevel3 = _CshPosHierThreeText.CashPositionHierLevel1  -- association [0..*]
LEFT OUTER JOIN I_FactoryCalendarText AS _FactoryCalendarText ON FactoryCalendar = _FactoryCalendarText.FactoryCalendar  -- association [0..*]
LEFT OUTER JOIN I_CshPosShiftOptionText AS _CshPosShiftOptionText ON CashPositionShiftOption = _CshPosShiftOptionText.CashPositionShiftOption  -- association [0..*]
LEFT OUTER JOIN I_CshPosUnitText AS _CshPosUnitText ON CashPositionPrdfndInterimStep = _CshPosUnitText.CashPositionPrdfndInterimStep  -- association [0..*]
LEFT OUTER JOIN I_CshPosBalTypeText AS _CshPosBalTypeText ON CashPositionBalanceCategory = _CshPosBalTypeText.CashPositionBalanceCategory  -- association [0..*]
LEFT OUTER JOIN I_CshPosViewTypeText AS _CshPosViewTypeText ON CashPositionViewCategory = _CshPosViewTypeText.CashPositionViewCategory  -- association [0..*]
LEFT OUTER JOIN I_CashBalanceTypeText AS _CashBalanceTypeText ON CashBalanceType = _CashBalanceTypeText.CashBalanceType  -- association [0..*]
;